Final Exam NPV and IRR-2.xlsx  Using the attached Excel Spre…

Final Exam NPV and IRR-2.xlsx  Using the attached Excel Spreadsheet, the discounted cash flow of period two is ***FOR THIS QUESTION, TO AVOID POSSIBLE ROUNDING ERROR, USE EXCEL AND DON’T ROUND ANY RATES IN YOUR EQUATIONS (link the rates in your formulas to avoid error).

Destin Company Information: Total Assets $940,000 Total Liab…

Destin Company Information: Total Assets $940,000 Total Liabilities $600,000 Cost of debt 5.8% Risk-free rate 1.97% Beta 0.89 Market Return 10%   Using CAPM, what is cost of equity? (so you are not confused, the opportunity cost of using equity is the return we were expecting to receive on the equity).   

ABC Corp is acquiring DEF Corp. The Fair Value of DEF’s net…

ABC Corp is acquiring DEF Corp. The Fair Value of DEF’s net assets (after subtracting the FV of the liabilities) is 1,239,000. ABC is granting DEF’s owners 1,300,000 in common stock with a contingent liability of 15,000 in exchange for DEF’s assets. Goodwill is equal to 

It is Jan 1 and Doheny Incorporated is acquiring Shay Indust…

It is Jan 1 and Doheny Incorporated is acquiring Shay Industries through a leveraged buyout. Doheny will borrow 1.2M at 7.5% cost of debt. Doheny’s cash is 4,875,000. After accounting for this additional interest expense and its tax shield (21% federal rate), Doheny’s cash is

Destin Company Information: Total Assets $940,000 Total Liab…

Destin Company Information: Total Assets $940,000 Total Liabilities $600,000 Cost of debt 5.8% Risk-free rate 1.97% Beta 0.89 Market Return 10%   Using CAPM, what is cost of equity? (so you are not confused, the opportunity cost of using equity is the return we were expecting to receive on the equity).