4. Carry out a sensitivity analysis of the assumptions in this report. Using what-if scenarios, evaluate...

Transcribed Image Text:

4. Carry out a sensitivity analysis of the assumptions in this report. Using "what-if" scenarios, evaluate how changing the assumptions such as the selling price, capital costs, or rents may impact the report's conclusion. You may use the associated Excel spreadsheet for this. (a) Which assumptions would need to change and by how much in order to lead to a revised course of action in the report? (6 marks) (b) Sensitivity analysis (12 marks) (c) Based on your results, what is your opinion of the degree of risk presented by this report's conclusion? (5 marks) 8.1 Appendix A - Sensitivity Analysis Table 4 - Sensitivity Analysis Table Sensitivity Analysis to Change in Sales Price Sale Price % Chg Net Proceeds NR Sensitivity Analysis to Transaction Costs Change in $ 145,200 10% $ 81,090 19% Transaction % Change in N 138,600 5% $ 74,490 10% Costs % Chg Net Proceeds Proceeds 132,000 0% $ 67,890 0% (70,521) 10% $ 61,479 -9% $ 125,400 -5% $ 61,290 -10% (67,315) 5% $ 64,685 -5% $ 118,800 -10% $ 54,690 -19% (64,110) 0% $ 67,890 0% (60,904) -5% $ 71,096 5% Sensitivity Analysis to Timing (57,699) -10% $ 74,301 9% One Year Discounted Discount Current NR NR Change in NR 5.15% $ 132,000.00 $ 125,535 $ (6,465) 6.2 Capital Budget Table 3 - Capital Budget Summary Capital Budget Summary Expenses ESA 1 $1,800.00 Commission Appraisal $8,120.00 $350.00 Legal Fees $5,000.00 CMHC Profit Sharing $45,841.07 Contingency $2,998.49 Total Expenses $64,109.55 Table 1 - Project Budget Summary Project Budget Summary Revenue Sales Proceeds Expenses ESA 1 $132,000.00 $1,800.00 Commission $8,120.00 Appraisal $350.00 Legal Fees $5,000.00 CMHC Profit Sharing $45,841.07 Contingency $2,998.49 Total Expenses $64,109.55 Net Income (Loss) $67,890.45 Net Book Value $36,814.40 Net Gain to Office of Real $31,076.05 Estate A sensitivity analysis was completed for this project and the results are presented in Appendix A. 4. Carry out a sensitivity analysis of the assumptions in this report. Using "what-if" scenarios, evaluate how changing the assumptions such as the selling price, capital costs, or rents may impact the report's conclusion. You may use the associated Excel spreadsheet for this. (a) Which assumptions would need to change and by how much in order to lead to a revised course of action in the report? (6 marks) (b) Sensitivity analysis (12 marks) (c) Based on your results, what is your opinion of the degree of risk presented by this report's conclusion? (5 marks) 8.1 Appendix A - Sensitivity Analysis Table 4 - Sensitivity Analysis Table Sensitivity Analysis to Change in Sales Price Sale Price % Chg Net Proceeds NR Sensitivity Analysis to Transaction Costs Change in $ 145,200 10% $ 81,090 19% Transaction % Change in N 138,600 5% $ 74,490 10% Costs % Chg Net Proceeds Proceeds 132,000 0% $ 67,890 0% (70,521) 10% $ 61,479 -9% $ 125,400 -5% $ 61,290 -10% (67,315) 5% $ 64,685 -5% $ 118,800 -10% $ 54,690 -19% (64,110) 0% $ 67,890 0% (60,904) -5% $ 71,096 5% Sensitivity Analysis to Timing (57,699) -10% $ 74,301 9% One Year Discounted Discount Current NR NR Change in NR 5.15% $ 132,000.00 $ 125,535 $ (6,465) 6.2 Capital Budget Table 3 - Capital Budget Summary Capital Budget Summary Expenses ESA 1 $1,800.00 Commission Appraisal $8,120.00 $350.00 Legal Fees $5,000.00 CMHC Profit Sharing $45,841.07 Contingency $2,998.49 Total Expenses $64,109.55 Table 1 - Project Budget Summary Project Budget Summary Revenue Sales Proceeds Expenses ESA 1 $132,000.00 $1,800.00 Commission $8,120.00 Appraisal $350.00 Legal Fees $5,000.00 CMHC Profit Sharing $45,841.07 Contingency $2,998.49 Total Expenses $64,109.55 Net Income (Loss) $67,890.45 Net Book Value $36,814.40 Net Gain to Office of Real $31,076.05 Estate A sensitivity analysis was completed for this project and the results are presented in Appendix A.