Question: 8a. Use your proforma for FSG Gardens and create a sensitivity table examining the IRR. We want to know the impact of changes to Annual
8a. Use your proforma for FSG Gardens and create a sensitivity table examining the IRR. We want to know the impact of changes to Annual Rental Appreciation Rate by 1.5% and changes to maintenance by + $50. Please submit the highlighted squares. Please put your answer in percentage with two decimal places for instance put 7.63 for 7.63%. Please put dollar amounts with two decimal places as well. Please enter a positive value. All questions should be completed in excel. Rounding will result in an incorrect answer. IRR 7.73% Annual Rental Appreciation Rate 1.50% 2.00% 2.50% (a) 200 Maintenance 250 300 (b) What is the value in cell (a)? 8a. Use your proforma for FSG Gardens and create a sensitivity table examining the IRR. We want to know the impact of changes to Annual Rental Appreciation Rate by 1.5% and changes to maintenance by + $50. Please submit the highlighted squares. Please put your answer in percentage with two decimal places for instance put 7.63 for 7.63%. Please put dollar amounts with two decimal places as well. Please enter a positive value. All questions should be completed in excel. Rounding will result in an incorrect answer. IRR 7.73% Annual Rental Appreciation Rate 1.50% 2.00% 2.50% (a) 200 Maintenance 250 300 (b) What is the value in cell (a)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
