Question

Gemini, Inc., an all-equity firm, is considering an investment of $1.75 million that will be depreciated according to the straight-line method over its four-year life. The project is expected to generate earnings before taxes and depreciation of $609,000 per year for four years. The investment will not change the risk level of the firm. The company can obtain a four-year, 9 percent loan to finance the project from a local bank. All principal will be repaid in one balloon payment at the end of the fourth year. The bank will charge the firm $59,000 in flotation fees, which will be amortized over the four-year life of the loan. If the company financed the project entirely with equity, the firm’s cost of capital would be 13 percent. The corporate tax rate is 34 percent.

   

Using the adjusted present value method, calculate the APV of the project. (Enter your answer in dollars, not millions of dollars, e.g., 1,234,567. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

  

APV

$ ???

Answer 1

In this question, we have to calculate Adjusted Present Value of the project

Calculation of Adjusted Present Value of the project

Excel formula for After Tax Earnings : =C4*(1-C3)

Excel formula for Depreciation tax Shield : =C2/4*C3

Excel formula for All Equity NPV : =PV(C8,C7,-C5,,0)+PV(C16,C7,-C6,,0)-C2

Excel formula for Annual amortization of Floating Cost: =C12/4

Excel formula for PV of Floating Cost : =C12-PV(C16,C14,-C13*C15,,0)

Excel formula for Loan Financing : =C19-PV(C16,C14,-C19*C16*(1-C15),-C19,0)

Excel formula for APV of the project: =C10+C20-C17

Thank you..

I hope I was able to help you.