Answer all excel question in excel and all word in word PLEASE AND THANK

EXCEL ANSWERS AND FORMAT CLICK HERE ------>https://www.youtube.com/watch?v=oDjRPmp1EOA

ALL ANSWERS HIGHLIGHTED YELLOW

Chapter 13 HW Questions Note: For each non-excel question, you must provide your source in the proper APA format. Reminder: If you DO NOT have a formula within your answer cell, it will not be marked correct! You must show your work within the excel formula! 1. [EXCEL] Finance balance sheet: KneeMan Markup Company has total debt obligations with book and market values equal to $30 million and $28 million, respectively. It also has total equity with book and market values equal to $20 million and $70 million, respectively. If you were going to buy all of the assets of KneeMan Markup today, how much should you be willing to pay? 2. WACC: What is the weighted average cost of capital for a firm? 3. Taxes and the cost of debt: How are taxes accounted for when we calculate the cost of debt? 4. Cost of common stock: List and describe each of the three methods used to calculate the cost of common stock. 5. [EXCEL] Cost of common stock: Whitewall Tire Co. just paid an annual dividend of $1.60 on its common shares. If Whitewall is expected to increase its annual dividend by 2 percent per year into the foreseeable future and the current price of Whitewall's common shares is $11.66, what is the cost of common stock for Whitewall? 6. [EXCEL] Cost of common stock: Seerex Wok Co. is expected to pay a dividend of $1.10 one year from today on its common shares. That dividend is expected to increase by 5 percent every year thereafter. If the price of Seerex common stock is $13.75, what is the cost of its common equity capital? 7. [EXCEL] Cost of common stock: Two-Stage Rocket paid an annual dividend of $1.25 yesterday, and it is commonly known that the firm's management expects to increase its dividend by 8 percent for the next two years and by 2 percent thereafter. If the current price of Two-Stage's common stock is $17.80, what is the cost of common equity capital for the firm? 8. [EXCEL] Cost of preferred stock: Fjord Luxury Liners has preferred shares outstanding that pay an annual dividend equal to $15 per year. If the current price of Fjord preferred shares is $107.14, what is the after-tax cost of preferred stock for Fjord? 9. [EXCEL] Cost of preferred stock: Kresler Autos has preferred shares outstanding that pay annual dividends of $12, and the current price of the shares is $80. What is the after-tax cost of new preferred shares for Kresler if the flotation (issuance) costs for preferred shares are 5 percent? 10. WACC: Describe the alternatives to using a firm's WACC as a discount rate when evaluating a project. 11. [EXCEL] WACC: Capital Co. has a capital structure, based on current market values, that consists of 50 percent debt, 10 percent preferred stock, and 40 percent common stock. If the returns required by investors are 8 percent, 10 percent, and 15 percent for the debt, preferred stock, and common stock, respectively, what is Capital's after-tax WACC? Assume that the firm's marginal tax rate is 40 percent. 12. WACC: What are direct out-of-pocket costs? 13.1 Finance balance sheet: KneeMan Markup Company has total debt obligations with a value equal to $30 million and $28 million, respectively. It also has total equity with a bo equal to $20 million and $70 million, respectively. If you were going to buy all of the ass Markup today, how much should you be willing to pay? otal debt obligations with a book and market o has total equity with a book and market value going to buy all of the assets of KneeMan 13.5 Cost of common stock: Whitewall Tire Co. just paid a $1.60 dividend on its common expected to increase its annual dividend by 2 percent per year into the foreseeable futu Whitewall's common shares is $11.66, what is the cost of common equity for Whitewal dividend on its common shares. If Whitewall is r into the foreseeable future and the current price of mon equity for Whitewall? 13.6 Cost of common stock: Seerex Wok Co. is expected to pay a dividend of $1.10 on today on its common shares. That dividend is expected to increase by 5 percent eve thereafter. If the price of Seerex is $13.75, what is Seerex's cost of common equity? to pay a dividend of $1.10 one year from d to increase by 5 percent every year rex's cost of common equity? 13.7 Cost of common stock: Two-Stage Rocket's common stock is expected to pay an an equal of $1.25, and it is commonly known that the firm expects dividends paid to increa for the next two years and by 2 percent thereafter. If the current price of Two-Stage's co $17.80, what is the cost of common equity capital for the firm? ck is expected to pay an annual dividend ects dividends paid to increase by 8 percent rent price of Two-Stage's common shares is m? 13.8 Cost of preferred stock: Fjord Luxury Liners has preferred shares outstanding th dividend equal to $15 per year. If the current price of Fjord preferred shares is $107 after-tax cost of preferred shares for Fjord? eferred shares outstanding that pay an annual Fjord preferred shares is $107.14, what is the 13.9 Cost of preferred stock: Kresler Autos has preferred shares outstanding that pay the current price of the shares is $80.What is the after-tax cost of new preferred sha flotation (issuance) costs for a new issue of preferred are 5 percent? d shares outstanding that pay annual dividends of $12, and er-tax cost of new preferred shares for Kresler if the d are 5 percent? 13.11 WACC for a firm: Capital Co. has a capital structure that is financed, based on cur percent debt, 10 percent preferred shares, and 40 percent common shares. If the re percent, 10 percent, and 15 percent for debt, preferred shares, and common equity after-tax WACC? Assume that the firm's marginal tax rate is 40 percent. anced, based on current market values, with 50 mmon shares. If the returns required by investors are 8 , and common equity, respectively, what is Capital's 0 percent