Question: Help me with theses sensitivity analysis charts Key Performance Indicators Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 2 0 2

Help me with theses sensitivity analysis charts Key Performance Indicators Column1 Column2 Column3 Column4 Column5 Column62024 CAP 3.23% Terminal Cash Flow $(147,458.63) Cash Flow $(2,451.14) Rent Growth 6% WACC 7.76% Equipty proportion 0.9 Debt proportion 0.1 Cost of Equity 7.85% Beta 1.0010 year treasury 4.62% Market Rate 3.23% Cost of Debt 6.37% Tax Rate 0.004 IRR -12.77% NPV $45,013.65 Cash on Cash Return 18.34% Cash Flow -55,000$(7,632.44)$(6,448.04)$(5,192.57)$(3,861.78)$(2,451.14)
Sensitivity Table 1
VACANCY RATE RENT GROWTH 4% RENT GROWTH 6% RENT GROWTH 8%5%10%15%
Sensitivity Table 2
Purchase Price Cap Rate terminal value -10% Base Terminal Value Terminal value +10%9%8%7%6%5% Purchase Price Increment 5%

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!