[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? please use excel

You are given the following information concerning a firm:Assets required for operation: $5,100,000Revenues: $8,400,000Operating expenses: $7,850,000Income tax rate: 40%. Management faces three possible combinations of financing: 100% equity financing 30% debt financing with a 8% interest rate 60% debt financing with a 8% interest rate   What is the net income for each combination of debt and equity financing? Round your answers to the nearest dollar.     1 2 3 Net income $     $     $       What is the return on equity for each combination of debt and equity financing? Round your answers to one decimal place.     1 2 3 Return on equity   %     %     %     If the interest rate had been 16 percent instead of 8 percent, what would be the return on equity for each combination of debt and equity financing? Round your answers to one decimal place.     1 2 3 Return on equity   %     %     %     What is the implication of the use of financial leverage…

Problem C: Liquidity RatiosABC has P400,000 cash, P200,000 short‐term investments, P500,000 receivables, and P900,000 inventories. It has trade payables ofP600,000 and short‐term loans of P900,000. It is planning to acquire another short‐term loan. However, the first loan requires ABCto maintain a minimum current ratio of 125%.Required:1. Current ratio before additional loan*2. Current ratio if ABC borrowed P300,000*3. Current ratio if ABC borrows P600,000*

Assume ABC Corporation is a multinational company with the following financial information: Market value of equity (E): $500 million Market value of debt (D): $300 million Market value of preferred stock (PS): $50 million Cost of equity (Re): 10% Cost of debt (BTrd): 5% Corporate tax rate (Tc): 25% Cost of preferred stock ( Rps): 8% a. Calculate the WACC for ABC Corporation. Needs to be done in Excel