I'm trying to solve for a leasing upfront payment question in excel Does anyone have a Macro that would assist me?
Assumptions:
20 Year Lease
IRS 467 rules apply meaning 90%-110%
Quarterly (rent) payments: First (rent) payment starts August 24th
Lessor gets 100% depreciation benefit
Lessor will give lease $90 Million
Lessor requires 5% rate of return
AFT? (leasee interest on Upfront payment) 2.5%
Lessor receives quarterly (rent) payments based upon 1.30 of EBITDA
Question: How do you solve for the upfront payment

Thanks, Kelly