1
Дмитрий
no recommendations
no complaints
Closed
Project title: Solve financial and economic problems (test task after interview)
Type of cooperation: One-time project
Section: Other / Miscellaneous
Prepayment: without prepayment
Payment methods: Cash, Bank transfer
Acceptance of requests: closed
Type of cooperation: One-time project
Section: Other / Miscellaneous
Prepayment: without prepayment
Payment methods: Cash, Bank transfer
Acceptance of requests: closed
Project description:
Task 1. Using the following information, fill in the missing company balance sheet data
Task 2. Restore the formula(s) that allow calculating the IRR (% per annum) for the project on the basis of the data shown in the table.
You can use empty strings for intermediate calculations.
Task 3. Table 1 contains information that you can use to calculate net income. In Table 2, analyze the sensitivity of net income to EBITDA margin using Excel data tools.
Task 4. Determine the factors affecting the deviation of the actual amount of revenue for each group of tenants from the planned. Build a factor analysis (iterational or integral method) of income deviations between plan and fact in the table on the right. If necessary, you can add the table with the necessary graphs.
Task 1. Using the following information, fill in the missing company balance sheet data
Task 2. Restore the formula(s) that allow calculating the IRR (% per annum) for the project on the basis of the data shown in the table.
You can use empty strings for intermediate calculations.
Task 3. Table 1 contains information that you can use to calculate net income. In Table 2, analyze the sensitivity of net income to EBITDA margin using Excel data tools.
Task 4. Determine the factors affecting the deviation of the actual amount of revenue for each group of tenants from the planned. Build a factor analysis (iterational or integral method) of income deviations between plan and fact in the table on the right. If necessary, you can add the table with the necessary graphs.
