I NEED THE EXACT ANSWER ON EXCELL!!!! SHOW THE FORMULA

THIS IS THE ENOUGH AND THE ONLY INFO!

- Just do it with the given info. you can make a search on internet for any leverage calculations, or others.

D30 - fx A B D E F 1 #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) 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 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% 18 Contract Duration 19 20 21 22 23 24 25 26 27 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 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%