Horizontal and vertical analysis of balance sheets

Assignment Help Financial Management

Reference no: EM131075716

Choose a publicly traded company and perform an expanded analysis on the financial statements. Use the most current 10K statements available on SEC or annual statements in Yahoo Finance. Complete the following for your chosen firm in an Excel spreadsheet: Compan Chosen: The Coca-Cola Company (KO)

Horizontal and vertical analysis of the income statements for the past three years (all yearly balances set as a percentage of total revenues for that year).

Horizontal and vertical analysis of the balance sheets for the past three years (all yearly balances set as a percentage of total assets for that year).

Ratio analysis (eight ratios of your choosing) for the past three years PLUS a measurement for the creditworthiness of your firm as measured by Altman’s Z-score. Note that if you used your chosen firm for our ratio-related discussion posts, then you MUST also present industry-average ratios or current year competitor ratios for your ratio analysis. Comparing your firm’s ratios to a close competitor or an industry-average ratio makes your analysis much more meaningful.

Reference no: EM131075716

Questions Cloud

What is after-tax cost of debt : After-tax Cost of Debt The Heuser Company's currently outstanding bonds have a 8% coupon and a 12% yield to maturity. Heuser believes it could issue new bonds at par that would provide a similar yield to maturity. If its marginal tax rate is 35%, wha..

Futures contracts on treasury bonds : We have futures contracts on Treasury bonds, but we do not have features contracts on individual corporate bonds. We have cattle and hog futures but no chicken futures. Explain why the market has developed in this manner. What do you think are the mo..

Briefly describe the hedging strategy : You are the chief financial officer of a large multinational company; and six months from now you will be receiving a settlement payment of $50 million, which you plan to invest in 10-year U.S. Treasury bonds. Briefly describe the hedging strategy us..

Cost of common equity-future earnings and dividends : The future earnings, dividends, and common stock price of Carpetto Technologies Inc. are expected to grow 6% per year. Carpetto's common stock currently sells for $23.50 per share; Using the DCF approach, what is its cost of common equity? If you hav..

Horizontal and vertical analysis of balance sheets : Choose a publicly traded company and perform an expanded analysis on the financial statements. Horizontal and vertical analysis of the income statements for the past three years (all yearly balances set as a percentage of total revenues for that year..

The sales forecasts and the abandonment option : A firm is considering a project with a 5-year life and an initial cost of $135,000. The discount rate for the project is 13%. The firm expects to sell 2,400 units a year for the first 3 years. The cash flow per unit is $20. What is the net present va..

Develop incremental cash flows for replacement decision : A small factory is considering replacing its existing coining press with a newer, more efficient one. The existing press was purchased three years ago at a cost of $210,000, and it is being depreciated according to a 7-year MACRs depreciation schedul..

Interest rate parity and spot exchange rate : suppose 90-day investments in Europe have a 5 percent annualized return and a 1.25 percent quarterly (90-day) return. In the United State, 90-day investments of similar risk have a 7 percent annualized return and a 1.75 percent quarterly return. In t..

What is his attitude toward risk : Stock A has an expected return of 13 percent and a 25 percent volatility. Stock B has an expected return of 9 percent and a 30 percent volatility. An investor can only purchase one of the two stocks. The investor bought stock A. What is her attitude ..

User Account

All Pages