Hello,

I very much need assistance with answering these five excel problems by around 5PM today. I greatly appreciate all of your help!

13.1 Finance balance sheet: KneeMan Markup Company has total debt obligations with value equal to $30 million and $28 million, respectively. It also has total equity with a equal to $20 million and $70 million, respectively. If you were going to buy all of the a Markup today, how much should you be willing to pay? Capital component Book value Market value Debt Equity Total tal 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 commo Whitewall is expected to increase its annual dividend by 2 percent per year into the future and the current price of Whitewall's common shares is $11.66, what is the cos equity for Whitewall? Dividend just paid (Do) Dividend growth rate (perpetual) Current stock price Cost of common equity dividend on its common shares. If ent per year into the foreseeable 11.66, what is the cost of common 13.8 Cost of preferred stock: Fjord Luxury Liners has preferred shares outstanding tha dividend equal to $15 per year. If the current price of Fjord preferred shares is $107 tax cost of preferred shares for Fjord? Annual preferred dividend Current preferred stock price After-tax cost of preferred stock ed shares outstanding that pay an annual d preferred shares is $107.14, what is the after- 13.11 WACC for a firm: Capital Co. has a capital structure that is financed, based on curr values, with 50 percent debt, 10 percent preferred shares, and 40 percent common returns required by investors are 8 percent, 10 percent, and 15 percent for debt, pre and common equity, respectively, what is Capital's after-tax WACC? Assume that the tax rate is 40 percent. Capital component Debt Preferred stock Common stock Marginal tax rate After-tax WACC Weight Return offered to investors anced, based on current market 40 percent common shares. If the 5 percent for debt, preferred shares, ACC? Assume that the firm's marginal 13.15 Current cost of a bond: You know that the after-tax cost of debt capital for Bubbles percent. If the firm has only one issue of five-year maturity bonds outstanding, what the bonds if the coupon rate on those bonds is 10 percent? Assume the bonds make payments and the marginal tax rate is 30 percent. After-tax cost of debt Maturity of bonds (years) Coupon rate Face value Tax rate Coupon frequency per year Before-tax cost of debt Bond Price of debt capital for Bubbles Champagne is 7 bonds outstanding, what is the current price of ? Assume the bonds make semiannual coupon