[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

[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

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter11: The Statement Of Cash Flows

Section: Chapter Questions

Problem 66.5C: Comparative Analysis: Under Armour, Inc., versus Columbia Sportswear Refer to the 10-K reports of...

See similar textbooks

Similar questions

Give typing answer with explanation and conclusion If the company were to borrow more (or less), how would that impact the cost of debt and the WACC? Provide a specific assumed example. Weight of Equity 76.10% Weight of Debt 23.90% Cost of Equity 6.98% Cost of Debt 2.55% Tax Rate WACC 5.92%
Consider a simple firm that has the following market-value balance sheet: Assets Liabilities end equity $1 040 Debt Equity $400 640 Next year, there are two possible values for its assets, each equally likely: $1 180 and $960. Its debt will be due with 4.9% interest. Because all of the cash flows from the assets must go to either the debt or the equity, if you hold a portfolio of the debt and equity in the same proportions as the firm's capital structure, your portfolio should earn exactly the expected return on the firm's assets. Show that a portfolio invested 38% in the firm's debt and 62% in its equity will have the same expected return as the assets of the firm. That is, show that the firm's pre-tax WACC is the same as the expected return on its assets. If the assets will be worth $1 180 in one year, the expected return on assets will be %. (Round to one decimal place.)
Suppose that Backwoods Chemical's book balance sheet is: Backwoods Chemical Company (Book Values) Debit Net working capital Net fixed assets $ 400 1,600 Total assets $ 2,000 $ 1,000 1,000 $ 2,000 Credit Debt Equity (net worth) Total value The debt has a one-year maturity and a promised interest payment of 9%. Thus, the promised payment to Backwoods's creditors is $1,090. The market value of the assets is $1,200, and the standard deviation of asset value is 45% per year. The risk-free interest rate is 9%. Calculate the value of Backwoods's debt and equity. Note: Do not round intermediate calculations. Round your answers to the nearest whole number. Value of equity Value of debt
A firm has 4000m in balance sheet debt (book value is equal to market value in this case) and 1000m in capitalized leases. Market value of equity is 10000m. You can use book value of debt to approximate its market value. If you were to use this information in the calculation of WACC, what is Wd? O 40.00% O 28.57% O 33.33% O 50.00%
A financial analyst is in the process of estimating the cost of capital of Gewicht GmbH. The following informnation is obtained from the company web pages. Market value of debt: $50 million • Market value of equity: $600 million Table 1. Primary competitors and capital structures (in millions) Market value of Market value of Competitor debt equity A $25 $50 B $101 $190 C $40 $60 QUESTIONS: What are Gewicht GmbH target capital structure (DV and E/V) if the analyst uses current capital structure? und numberto four decimalpla to report the results Options: 0.4213 0.4921 0,4545 0,5454 D/V v EN
Consider a simple firm that has the following market-value balance sheet: Assets Liabilities & Equity $1,000 Debt $400 Equity 600 Next year, there are two possible values for its assets, each equally likely: $1,190 and $960. Its debt will be due with 5.1% interest. Because all of the cash flows from the assets must go either to the debt or the equity, if you hold a portfolio of the debt and equity in the same proportions as the firm's capital structure, your portfolio should earn exactly the expected return on the firm's assets. Show that a portfolio invested 40% in the firm's debt and 60% in its equity will have the same expected return as the assets of the firm. That is, show that the firm's WACC is the same as the expected return on its assets. If the assets will be worth $1,190 in one year, the expected return on assets will be 19 %. (Round to one decimal place.) If the assets will be worth $960 in one year, the expected return on assets will be 4%. (Round to one decimal place.) -…
a. What percentage of the firm's assets does the firm finance using debt (liabilities)? b. If Campbell were to purchase a new warehouse for $1.1 million and finance it entirely with long-term debt, what would be the firm's new debt ratio? Question content area bottom Part 1 a. What percentage of the firm's assets does the firm finance using debt (liabilities)? The fraction of the firm's assets that the firm finances using debt is 27.827.8%. (Round to one decimal place.) Part 2 b. If Campbell were to purchase a new warehouse for $1.1 million and finance it entirely with long-term debt, what would be the firm's new debt ratio? The new debt ratio will be enter your response here%. (Round to one decimal place.)
Consider a simple firm that has the following market-value balance sheet: Assets Liabilities & Equity $1,000 Debt $400 Equity 600 Next year, there are two possible values for its assets, each equally likely: $1,200 and $960. Its debt will be due with 5.0% interest. Because all of the cash flows from the assets must go either to the debt or the equity, if you hold a portfolio of the debt and equity in the same proportions as the firm's capital structure, your portfolio should earn exactly the expected return on the firm's assets. Show that a portfolio invested 40% in the firm's debt and 60% in its equity will have the same expected return as the assets of the firm. That is, show that the firm's WACC is the same as the expected return on its assets. If the assets will be worth $1,200 in one year, the expected return on assets will be %. (Round to one decimal place.) If the assets will be worth $960 in one year, the expected return on assets will be %. (Round to one decimal place.) The…
Which of the following has the highest interest rate? Select one: a. Corporate Bond O b. Government Bond c. Treasury Bills d. Callable Corporate Bond The ratio that is used to compare the market value between companies is Select one: a. Equity Muitiplier b. EPS c. P/E d. Profit margin You have 50,000BD which you can use to either buy cars or to deposit in a bank account for 1 year. Inflation for the year is estimated to be 7%, and the bank deposit rate is 4.5%. if you had a goal of purchasing as many cars as possible, when should you buy them? Select one: a. Now b. After a year c. After 2 years d. Not enough information to decide
Suppose that LilyMac Photography expects EBIT to be approximately $94,000 per year for the foreseeable future, and that it has 400 10-year, 4 percent annual coupon bonds outstanding. (Use Table 11.1) What would the appropriate tax rate be for use in the calculation of the debt component of LilyMac's WACC? Tax rate Mc. Type here to search 7730
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*4. Maximum loan amount that ABC can borrow*Answer in percent rounded off to two decimal places, e.g. 125.33 for 125.33%.
You've collected the following information about Caccamisse, Incorporated: Sales Net income Dividends Total debt Total equity = a. Sustainable growth rate b. Additional borrowing c. Growth rate = = = = $ 330,000 $ 18,700 $ 7,500 $ 70,000 $ 101,000 a. What is the sustainable growth rate for the company? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. b. Assuming it grows at this rate, how much new borrowing will take place in the coming year, assuming a constant debt-equity ratio? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. c. What growth rate could be supported with no outside financing at all? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. % %