A Project has a cost of $11,455,074 and it's NOI $494,299 per year for 15 years. The Gross Income is 579,673. The Loan is 6,600,564 with a 5.5% interest rate. 

The required equity is 3,136,248. The reversion is 11,955,773. What is the project's levered IRR, unlevered IRR and MIRR? 

What is the unlevered MOIC and levered MOIC? Provide the formulas with the necessary numbers:

 

Transcribed Image Text:

Primary Loan Loan by LTV Interest Rate Amortization Loan Constant Loan per LTV Ratio Concluded Loan Selected Loan Annual Payment Land Lease Long Term Ground Lease Annual Payment Required Equity Incentives Cash Flow After Debt Service Investor Equity Cash-on-Cash Return Pro Forma Duplex Units 1-31 Duplex Units 32-62 Sub-Total Vacancy Loss Effective Gross Income Non Recoverable Expenses-Total Reserves Net Operating Income Debt Service Cash Flow After Debt Service Reversion Value Leveraged IRR Terminal Cap Rate NOI Reversion Less Cost of Sale Net Reversion Less Debt Balance EOY 10 Net Proceeds 65.00% LTV Ratio $ 6,600,564 5.50% 30.00 years 6.81% 2.00% increase per yr 1.00% increase per yr $ $ 6,600,564 $ 6,600,564 4.00% $ $ $ $ $ 3,136,248 $ 1,718,261 $ 44,572 '$ $ $ $ $ (3,136,248) S $ -17.29% $6,600,564 449,727 10,000 10,000 1.42% Year 6 Year 1 Year 2 Year 3 Year 4 Year 5 Year 7 Year 8 Year 9 Year 10 292,764 $ 292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $ 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 585,528 $ 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $ 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 579,673 $ 579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $ 79,577 81,169 82,792 84,448 86,137 87,860 89,617 91,409 93,237 95,102 5,797 5.855 5.913 5,972 6,032 6,092 6,153 6,215 6,277 6,340 494,299 $492,649 $490,967 $489,253 $487,504 $485,721 $483,903 $482,049 $480,158 $478,231 $ 459.727 $459.727 $459.727 $459.727 $459.727 $459.727 $449.727 $449,727 $449.727 $449,727 S 34,572 $32,922 $ 31,240 $ 29,525 $ 27,777 $25,993 $34,175 $ 32,321 $ 30,431 $ 28,504 $ 34,572 $ 32,922 $ 31,240 $ 29,525 $ 27,777 $25,993 $34,175 $ 32,321 $ 30,431 $ 28,504 $ $ 478,231 $ 11,955,773 6,00% $ 717,346 $ 11,238,427 s 6.526.809 $ 4,711,618. Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 292,764 $292,764 $292,764 $292,764 $292,764 $292,764 292,764 292,764 292,764 292,764 292,764 292,764 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 0 Q 2 Q 2 0 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 97,004 98,944 100,923 102,941 105,000 107,100 6,403 6,467 6.532 6,597 6.663 6,730 482,121 $480,117 $478,073 $475,989 $473,865 $471,698 449.727 $449.727 $449.727 $449.727 $449.727 $449.727 32,393 $30,389 $28,346 $26,262 $24,137 $ 21,971 32,393 $30,389 $28,346 $26,262 $24,137 $ 21,971 Primary Loan Loan by LTV Interest Rate Amortization Loan Constant Loan per LTV Ratio Concluded Loan Selected Loan Annual Payment Land Lease Long Term Ground Lease Annual Payment Required Equity Incentives Cash Flow After Debt Service Investor Equity Cash-on-Cash Return Pro Forma Duplex Units 1-31 Duplex Units 32-62 Sub-Total Vacancy Loss Effective Gross Income Non Recoverable Expenses-Total Reserves Net Operating Income Debt Service Cash Flow After Debt Service Reversion Value Leveraged IRR Terminal Cap Rate NOI Reversion Less Cost of Sale Net Reversion Less Debt Balance EOY 10 Net Proceeds 65.00% LTV Ratio $ 6,600,564 5.50% 30.00 years 6.81% 2.00% increase per yr 1.00% increase per yr $ $ 6,600,564 $ 6,600,564 4.00% $ $ $ $ $ 3,136,248 $ 1,718,261 $ 44,572 '$ $ $ $ $ (3,136,248) S $ -17.29% $6,600,564 449,727 10,000 10,000 1.42% Year 6 Year 1 Year 2 Year 3 Year 4 Year 5 Year 7 Year 8 Year 9 Year 10 292,764 $ 292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $292,764 $ 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 292,764 585,528 $ 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $585,528 $ 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 5.855 579,673 $ 579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $579,673 $ 79,577 81,169 82,792 84,448 86,137 87,860 89,617 91,409 93,237 95,102 5,797 5.855 5.913 5,972 6,032 6,092 6,153 6,215 6,277 6,340 494,299 $492,649 $490,967 $489,253 $487,504 $485,721 $483,903 $482,049 $480,158 $478,231 $ 459.727 $459.727 $459.727 $459.727 $459.727 $459.727 $449.727 $449,727 $449.727 $449,727 S 34,572 $32,922 $ 31,240 $ 29,525 $ 27,777 $25,993 $34,175 $ 32,321 $ 30,431 $ 28,504 $ 34,572 $ 32,922 $ 31,240 $ 29,525 $ 27,777 $25,993 $34,175 $ 32,321 $ 30,431 $ 28,504 $ $ 478,231 $ 11,955,773 6,00% $ 717,346 $ 11,238,427 s 6.526.809 $ 4,711,618. Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 292,764 $292,764 $292,764 $292,764 $292,764 $292,764 292,764 292,764 292,764 292,764 292,764 292,764 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 0 Q 2 Q 2 0 585,528 $585,528 $585,528 $585,528 $585,528 $585,528 97,004 98,944 100,923 102,941 105,000 107,100 6,403 6,467 6.532 6,597 6.663 6,730 482,121 $480,117 $478,073 $475,989 $473,865 $471,698 449.727 $449.727 $449.727 $449.727 $449.727 $449.727 32,393 $30,389 $28,346 $26,262 $24,137 $ 21,971 32,393 $30,389 $28,346 $26,262 $24,137 $ 21,971

Answer rating: 100% (QA)

Project Cost 11455074 Loan Amount 6600564 Interest Rate 55 Loan Term 15 years Required Equity 114550... View the full answer