#2 Calculate the Levered IRR of an investment with the following metrics - Show full cash...

 

Transcribed Image Text:

#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 Rental Contracts for Revenue Estimates Tenant Zara Apple Kaufland Coolblue Claudia Stratter Alphonso Dominguez 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% 5.0% 20 years 21.0% 10.0% Annual Rent 1,000,000 750,000 2,500,000 1,299,000 66,000 862,314 per annum per annum 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% #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 Rental Contracts for Revenue Estimates Tenant Zara Apple Kaufland Coolblue Claudia Stratter Alphonso Dominguez 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% 5.0% 20 years 21.0% 10.0% Annual Rent 1,000,000 750,000 2,500,000 1,299,000 66,000 862,314 per annum per annum 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%

Answer rating: 100% (QA)

You have provided an image with details required to calculate the Levered Internal Rate of ... View the full answer