Calculate the NPV and IRR Levered and Unlevered.

SHOW STEPS please

Calculate the unlevered and levered NPV and IRR. Purchase price 22,000,000 Anticipated NOI Year 1 Tear 2 Year 3 Year 4 Year 5 Year 6 (stabilized) 1,500,000 1,600,000 1,800,000 2,000,000 2,100,000 2,150,000 Financing LTV Payment frequency Mortgage rate Mortgage rate per month Term (years) Amortization (years) 70.0% Monthly 3.5% 0.2896% 5 25 Anticipated cap rate on sale Required Equity Return Required WACC 9.0% 15.0% 10.0% Calculate the unlevered and levered NPV and IRR. Purchase price 22,000,000 Anticipated NOI Year 1 Tear 2 Year 3 Year 4 Year 5 Year 6 (stabilized) 1,500,000 1,600,000 1,800,000 2,000,000 2,100,000 2,150,000 Financing LTV Payment frequency Mortgage rate Mortgage rate per month Term (years) Amortization (years) 70.0% Monthly 3.5% 0.2896% 5 25 Anticipated cap rate on sale Required Equity Return Required WACC 9.0% 15.0% 10.0%