Can someone please show how to manually get Question 4's IRR without excel? Thank you. I don't need any other answers.

Y, Inc. has no debt right now. You project that this company can generate EBIT of 8 million per year for the next few years. There is no depreciation. You plan to attempt a leveraged buyout of this company. Your plan is to operate the company for three years and sell the company then. You think the company can be sold at price to EBIT ratio of 9.5 three years from now. You plan to borrow 60 million in three-year interest only loan and putting 10 millions of your own equity to buy the company. (Note that the loan is interest only and you do not plan to retire any debt before you sell the company. Your interest payment will remain the same for the three years.) The interest rate on the loan is 10% and the tax rate is 40%. 1. What will be the selling price of the company in three years (in millions)? 89.5=76 2. What is the cash flow to the equity investor in the first year (in millions)? Interestexpense=6010%=6CF=(86)(10.4)=1.2 3. What is the cash flow to the equity investor in the third year in millions (the final year of the project, including sale proceeds and loan repayment)? CF from operation =1.2 CF from selling and loan repayment =7660=16 Total CF=1.2+16=17.2 4. What is the rate of return to you as the equity investor (in percentage)? All cash flows for the equity investor 0123101.21.217.2 IRR=27.4% Y, Inc. has no debt right now. You project that this company can generate EBIT of 8 million per year for the next few years. There is no depreciation. You plan to attempt a leveraged buyout of this company. Your plan is to operate the company for three years and sell the company then. You think the company can be sold at price to EBIT ratio of 9.5 three years from now. You plan to borrow 60 million in three-year interest only loan and putting 10 millions of your own equity to buy the company. (Note that the loan is interest only and you do not plan to retire any debt before you sell the company. Your interest payment will remain the same for the three years.) The interest rate on the loan is 10% and the tax rate is 40%. 1. What will be the selling price of the company in three years (in millions)? 89.5=76 2. What is the cash flow to the equity investor in the first year (in millions)? Interestexpense=6010%=6CF=(86)(10.4)=1.2 3. What is the cash flow to the equity investor in the third year in millions (the final year of the project, including sale proceeds and loan repayment)? CF from operation =1.2 CF from selling and loan repayment =7660=16 Total CF=1.2+16=17.2 4. What is the rate of return to you as the equity investor (in percentage)? All cash flows for the equity investor 0123101.21.217.2 IRR=27.4%