Question: Use your proforma for FSG Gardens and create a sensitivity table examining the Unlevered IRR. We want to know the impact of changes to Utility

Use your proforma for FSG Gardens and create a sensitivity table examining the Unlevered IRR. We want to know the impact of changes to Utility Escalation by .5% and changes to utility cost per month by $10. Please submit the highlighted squares.

NOTE: The IRR is 7.73%

I am having trouble using a Data Table to get these answers. What Row and Column input do I use? Not sure if info from the main problem is beneficial or not. Utility Escalation is 2%. Utility Cost per month is $144,00 (100 units x $120 x 12)

Unlevered IRR
Utility Escalation
Utility Cost per Month 7.73% 1.0% 1.5% 2.0% 2.5% 3.0%
$ 100.00 7.86% 7.80% 7.74% 7.67% 7.61%
$ 110.00 7.87% 7.81% 7.74% 7.66% 7.59%
$ 120.00 7.89% 7.81% 7.73% 7.65% 7.57%
$ 130.00 7.90% 7.82% 7.73% 7.64% 7.55%
$ 140.00 7.91% 7.82% 7.73% 7.63% 7.53%

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!