#2 Calculate the Levered IRR of an investment with the following metrics - Show full cash flow (levered & unlevered) while coming to the IRR calculation Important note: Model should be fully parametric (should still work/calculate correctly when we change the parameters below) Entry price Hold period Exit yield (Net Initial) Opex Genex Capex Bank Loan - LTV Bank Loan - Interest Rate pa Bank Loan - Amortization Bank Loan - Maturity Corporate Income Tax Capital Gains Tax 87,500,000 5 years 5.75% (15.00%) of gross rental income (5.00%) of gross rental income (3.50%) of gross rental income 75.0% 3.0% per annum 5.0% per annum 20 years 21.0% 10.0% Rental Contracts for Revenue Estimates Tenant Annual Rent Zara 1,000,000 Apple 750,000 Kaufland 2,500,000 Coolblue 1,299,000 Claudia Stratter 66,000 Alphonso Dominguez 862,314 Contract Duration 3 years 2 years 5 years 6 years 1 years 4 years Rent Reversionary at Contract Renewal 12.9% (7.5%) 10.0% 3.5% (1.7%) 5.0%