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 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.
Other / Miscellaneous Cash, Bank transfer
