Question

In: Accounting

Analytical case-comparative analysis of profitability and financial lever-age measures The annual reports of the Coca-Cola Co....

Analytical case-comparative analysis of profitability and financial lever-age measures The annual reports of the Coca-Cola Co. and PepsiCo. INC., indicate the following for the year ended December 31, 2014 (amounts in millions):

   Coca-Cola Co. PepsiCo. INC.
Net revenues $45,998 $66,683
Net income 7,124 6,558
Total assets, January 1, 2014 90,055 77,478
Total liabilities, January 1, 2014 56,615 53,089
Total liabilities, December 31, 2014 61,462 52,961
Total stockholders' equity, December 31, 2014 30,561 17,548

Required:

a. Calculate ROI and ROE for each company for 2014. (Hint: You will need to calculate some of the numbers used in the denominator of these ratios.)

b. Based on the results of your ROI and ROE analysis in part a, do you believe that either firm uses financial leverage more effectively than the other?

Explain your answer. (Hint: Compare the percentage differences between ROl and ROE for each firm. Is there a significant difference that would suggest that one firm uses leverage more effectively than the other?).

c. Calculate the debt ratio and debt/equity ratio for each firm at the end of 2014.

d. Compare the results of your analysis in part e to your expectations concerning the relative use of financial leverage in part b. Do the debt and debt/equity ratios calculated in part c make sense relative to your expectations? Explain your answer.

Solutions

Expert Solution

Coca Cola Pepsi Co
ans a 7.82

8.86 %

ROI=Net Income/Avg Tota lassets 7123/((90055+92023)/2)*100 6558/((77478+70509)/2)*100
Total assets for 2014 92023.00 70509.00
61462+30561 52961+17548
2) ROE
Net Income/Avg equity *100 22.26 31.28
7123/((30561+33440)/2)*100 6558/((17548+24389)/2)*100
Equity as on Jan 1 2014 33440.00 24389.00
90055-56615 77478-53089
ans b Yes Pepsi Co uses financial leverage better than Coc cola company :
1) ROI of Pepsi co is 8.86% as compare to ROI of coca cola 7.82%
2) ROE of Pepsi co is 31.28% as compare to ROE of coca cola 22.26%
In ROE there is significant difference of approximately 9%, which is due to financial leverage
ans c
Debt ratio 0.67 0.75
Total liabilities/Total assets 61462/92023 52961/70509
Debt/equity ratio 2.01 3.02
Total Debts/Total Equity 61462/30561 52961/17548
ans d
Yes, the effect of financial leverage can be proved by analyzing Debt ratio and Debt to equity ratio
Pepsi co debt ratio is .75 that means 75% of total assets are financed by debts which is higher than Debt ratio of Coca cola
Also Debt to equity ratio of Pepsi co is 3.02 is higher than of Coca cola company whose ratio is 2.01
So, Pepsi co ROI and ROE is higher due to financial leverage.
But at the same time it is more riskier to invest in Pepsi co as it is more dependent on debts rather than equity, Coca cola
is less riskier
If any doubt please comment

Related Solutions

For annual report for coca cola 2016 Complete a financial statement analysis of your focus coca...
For annual report for coca cola 2016 Complete a financial statement analysis of your focus coca cola company. Essay - analysis the annual report of coca cola applying the approaches and quantitative tools in the topic functional interpretation made from financial statement data and ( Financial statement analyses) as you deem important, and also please provide an interpretation, perspective, and assessment of your analysis as far as how well the coca cola company is doing.
View the 2015 Annual Reports for the Coca-Cola Company and PepsiCo, Inc. (Download the PDFs of...
View the 2015 Annual Reports for the Coca-Cola Company and PepsiCo, Inc. (Download the PDFs of the Annual Form 10-K reports). Using these reports, answer the following questions: What amounts for intangible assets did Coca-Cola and PepsiCo report in their respective balance sheets? What percentage of total assets is each of these reported amounts? On what basis and over what periods of time did Coca-Cola and PepsiCo amortize their intangible assets? What were Coca-Cola’s and PepsiCo’s net revenues (sales) for...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 69 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1     20Y2     20Y1 Retained earnings, January 1 $3,577,150 $3,023,350 Net income 851,200 619,300 Total $4,428,350 $3,642,650 Dividends: On preferred stock $13,300 $13,300 On common stock 52,200 52,200 Total dividends $65,500 $65,500 Retained earnings, December 31 $4,362,850...
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall Inc. common stock was $ 66 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $ 1,413,000 $ 1,202,700 Net income 330,000 246,300 Total $ 1,671,000 $ 1,449,000 Dividends On preferred stock $ 10,500 $ 10,500 On common stock 25,500 25,500 Total dividends...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 65 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1     20Y2     20Y1 Retained earnings, January 1 $3,356,900 $2,820,900 Net income 728,000 577,800 Total $4,084,900 $3,398,700 Dividends: On preferred stock $9,800 $9,800 On common stock 32,000 32,000 Total dividends $41,800 $41,800 Retained earnings, December 31 $4,043,100...
1. Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as...
1. Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 56 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $4,770,100 $4,018,100 Net income 1,050,800 823,000 Total $5,820,900 $4,841,100 Dividends: On preferred stock $14,000 $14,000 On common stock 57,000 57,000 Total dividends $71,000 $71,000 Retained earnings, December 31...
Nineteen Measures of Solvency and Profitability The comparative financial statements of Blige Inc. are as follows....
Nineteen Measures of Solvency and Profitability The comparative financial statements of Blige Inc. are as follows. The market price of Blige Inc. common stock was $54 on December 31, 2016. Blige Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2016 and 2015     2016     2015 Retained earnings, January 1 $3,212,400 $2,711,800 Add net income for year 710,000 555,400 Total $3,922,400 $3,267,200 Deduct dividends On preferred stock $11,900 $11,900 On common stock 42,900 42,900 Total $54,800 $54,800 Retained earnings,...
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall Inc. common stock was $ 61 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $ 920,575 $ 780,625 Net income 198,800 159,900 Total $ 1,119,375 $ 940,525 Dividends On preferred stock $ 6,300 $ 6,300 On common stock 13,650 13,650 Total dividends...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 56 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $2,541,175 $2,144,325 Net income 600,000 439,200 Total $3,141,175 $2,583,525 Dividends: On preferred stock $7,700 $7,700 On common stock 34,650 34,650 Total dividends $42,350 $42,350 Retained earnings, December 31 $3,098,825...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 67 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $3,346,500 $2,812,300 Net income 748,800 576,000 Total $4,095,300 $3,388,300 Dividends: On preferred stock $9,800 $9,800 On common stock 32,000 32,000 Total dividends $41,800 $41,800 Retained earnings, December 31 $4,053,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT