Hemp Airlines (HA, "we" fly high") is about to buy five CFA3000 commuter jets. each airplane costs $50 million. a friendly bank has put together a consortium to finance the deal. the consortium includes a 20% equity investment and an 80% debt component. the debt has an interest rate of 8% annually and is a term loan over 10 years. at the end of each of the next to years, HA will pay a lease payment of $35 million. at the end of the 10-year lease term, Hemp has the option to buy the aircraft for $10 million each; it is anticipated that it will exercise this option in which the planes are priced at their anticipated fair market value. the airplanes will be depreciated on a straight line basis over five years to zero salvage value.

If the equity partner in the lease has a tax rate of 35%, what is its expected compound rate of return?

please answer in excel format. (preferably also with formulas)