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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!