Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer 3,4,5,6,and 7 for a good review and rating. it needs to be paragraphs writing about this information that is calculated. read the questions

image text in transcribed

please answer 3,4,5,6,and 7 for a good review and rating.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

it needs to be paragraphs writing about this information that is calculated. read the questions and use the balance statements and income statements to help with answering the questions

image text in transcribed

image text in transcribed

image text in transcribed

Pepsi above coke below

image text in transcribed

image text in transcribed

image text in transcribed

3. Calculate the inventory turnover and the average sales period for both companies for 2020 and 2021. Write a paragraph comparing 2021 with 2020 and Coke with Pepsi using these two ratios to indicate how they manage their inventory. Which one of the two companies has a better approach to inventory management? Why? What are the problems that come with poor inventory management? 4. Calculate the gross margin percentage, net profit margin percentage, and return on assets for both companies for 2020 and 2021. Explain in a paragraph what these ratios show about each company's profitability compared to the year before and compared to each other. Indicate which company shows the best prospects for future profits and explain in detail why you think the ratios support your observations. 5. Prepare a vertical analysis on the income statement and the balance sheet for Pepsi and Coca Cola for 2020 and 2021 . Write a paragraph highlighting what you have learned from the percentages of sales or total assets calculated from the financial statements. Write also about the comparison between 2020 and 2021 and between Coke and Pepsi. 6. Prepare a horizontal analysis on the income statement and the balance sheet for Pepsi and Coca Cola for 2020 and 2021. Be sure to calculate the change in dollars and percentages for all of the revenues and expenses. What do the changes indicate about Pepsi's success in 2021 relative to 2020? Do the same comparison for Coke's income statement. What do the changes indicate about Coke's improvement or lack thereof between 2021 and 2020? With this comparison of both companies over time now compare Coke vs. Pepsi and explain why one company seems to do better than the other, financially speaking. 7. Based on all of your calculations and observations described above. make a recommendation as to which company would be a better investment. Give the reasons for your conclusion. EBEA-EBA As of the end of doNcoubiteo BuANE SHE2 S -USO (S) in Willons 207129702019 CURRENT ASSETS enshand owh cqulvalonts Shoit tem inkestments Nowi Cash, Cash Equivateits and short Term investment: 19inde securtics \begin{tabular}{rrr} $9,684 & $6,795 & 56,490 \\ 1,247 & 1,771 & 1,457 \\ \hline 10,926 & 8,565 & 7,947 \\ 1,699 & 2,348 & 3,278 \\ 3,512 & 3,144 & 3,971 \end{tabular} lorichirment Acsers OTh wertments beceredincame thix axpixts 2.1214 (2) loti furrent Labince Total Lapianci 12 Months Ended Consolidated Statement of Income - USD (\$) shares in Millions, $ in Millions Income Strtement [Abstract] Net Revenue $79,474$70,372567,161 cost of sales Gross profit 42,307=38,575 3 3,029 Selling general and administrative expenses 31,23728,49525,738 Operating Profit 11,16210,080.10,291 Other pension and retiree medical benefits income/lexpense) Net interest expense and other income before income taxes Provision for income taXES Net income Less: Net income attributable to noncontrolling interests Net income Attributable to PepsiCo Net income Attributable to Pepsico per common Share \begin{tabular}{rrr} \hline 522 & 117 & \\ \hline 1,883 & 1,178 &, 335 \\ \hline 9,821 & 9,069 & 9,312 \\ \hline 2,142 & 1,894 & 1,959 \\ \hline 7,679 & 7,175 & 7,353 \\ \hline 57,618 & 57,120 & 5,7,314 \\ \hline \hline \end{tabular} Basic Diluted Weighted-zverage common shares outstanding \begin{tabular}{c|c|c|} 35.51 & 5.4 .12 & 52.12 \end{tabular} Basic 1,2821.3820+238 PEPSICO As of the end of Consolidited Balance sheet - $ in Millions Nssats Earthand esh equivalents shoit iem investments Accountsand notes recelvabie, net inveritirias Prepild expenses and other current asscts Dispena Goup, Including Dircontinued Operation, Asscts Assets Current Pprperty, Paint and Equpment, net Amortiabic intangible Aspers, net gocdwill Indetinite Iived lntangibic Assects (Ixcluding Goodwili) Eaguity Merhed lnvertmonts betarred ine The Tax Aurect, Ne Orher Asects Total Assets UABIUTIES AND EQUITY shon term ecbt oblikations Aecount: paynibic and other current isbilites uabilimes, current Leng Term Debt Obligutioni eteried income fix Liabilincs, Net Other tablintios, Nankurtent Lablines Gominitimente aing cantingereiks Uabilthes: Common stock ailhoriper Common stock issued Fepsico Common Shareholders' Equity Common stock, par value 12/36 per share lathorized 3 , fle0 sharez, Bsund, net of repurchased common stock at par valuc. Adcitonal Paid in Capitat Earn Earnings (Accumulated Deficit) Acoumulated Other Comprehensive income (Lose), Net of Tax Fcourchased common stock, shares Tressury stcek, Valuc Stodinoiders' Equity Attributable to Parrent Stooknokers EQuity Atrnbutable to Noncontroling intwrert total Equity Lablites and Equity PEPSICO As of the end of Consolidated Balance Sheet - $ in Millions ASSETS Cash and cash equivalents Short-term Investments Accounts and notes receivable, net Inventories Prepaid expenses and other current assets Disposal Group, Including Discontinued Operation, Assets Assets, Current Property, Plant and Equipment, net Amortizable Intangible Assets, net Goodwill Indefinite-lived Intangible Assets (Excluding Goodwill) Equity Method Investments Deferred Income Tax Assets, Net Other Assets Total Assets LIABILITIES AND EQUITY Short-term debt obligations Accounts payable and other current liabilities Disposal Group, Including Discontinued Operation, Liabilities Liabilities, Current Long-Term Debt Obligations Deferred Income Tax Liabilities, Net Other Liabilities, Noncurrent Liabilities Assets, Currenl Property, Mant and L civieiment, nei Amoitizable intaneible Acceitsinei Goodwill Indefinite lived Intarimiblo Aveis (Inclioding Goodwill) Iauily Methad Investimeits. Deferred Income tak Avsets, Neit Other Assels Total Aseth LAIIIITIES AND IQUIT Short-terim debt obiligations Accouits payable and other cuichi liabilities Disposal Gromp, Indudin Bisciailinued bopration, Labijitios Llabillties, Current Lone Leit Debi obligations Deterted lncame lax Liabilitiel, Net Othe Llabilities, Noncuicim! Liabilities Commitments and rontilyencies Common stock, autlicited Common stock, istued Pepsico Common Shareholders' Lquity Additionat Pind in Capilal. Common Stock Retained Latrimh (Accumatated beficic) Repurchased commonstork, Ghales Treasury Stock, Value Stockhoider' Equity Allibutabie to Parmit Stockhoiders' Equity Auritustable tu Noncomlyotline Imterest Total Equity Liabilities and fquity PEPSICO Consolidated Statement of Income - USD (\$) shares in Millions, $ in Millions 12 Months Ended 202120202019 Income Statement [Abstract] Net Revenue $79,474$70,372$57,161 Cost of sales Gross profit Selling, general and administrative expenses Operating Profit Other pension and retiree me Net interest expense and oth Income before income taxes provision for income taxes Net income Less: Net income attributable to noncontrolling interests Net income Attributable to Pepsico Net income Attributable to Pepsico per Common Share Basic Diluted Weighted-average common shares outstanding Basic Diluted 1,3821,3891,3851,3921,3991,407 COCA COLA As of the and of CONSOLIDATED BALANCE SHEETS - USD (\$) \$ In MIIIIONS \begin{tabular}{l} 202120202019 \\ \hline \end{tabular} CURRENT ASSETS Cash and cash equivalents Short-term investments Total Cash, Cash Equivalents and Short.Term Investments Marketable securities Tradeaccountsreceivable,lessallowancesof$516and$526,3,5123,1445,97 respectively Inventories Prepaid expenses and other current astets Total Current Assets Equity method investments Other investments Other noncurrent assets Deferred income tax assets Property, plant and equipment - net Trademarks with indelinte lives Goodwill Other intangble assets Total Assets CURRENI HIABILIIIS Accounts payable and acciued expenses loans and notes payable Current maturities of long term debt Accrued income takes Total Current Liabilities \begin{tabular}{rrr} 14,619 & 11.145 & 11.112 \\ 1.107 & 2.181 & 10,994 \\ 1,338 & 185 & 4.253 \\ 686 & 788 & 414 \\ \hline 19,950 & 14,601 & 26,973 \end{tabular} IIIIIIINI IIAGiIIIIII Total Cunemi Liabilites Othe cument liabiticiet Defered inceme tak llabilities Total Liabilities Compon stoec, 80 25 par value authareed 11,200 shares) 1. 7601,7601,760 issued 7,0a0 thares Capital surplue Aeinvested earning Lquity Altributable to Shareowners of the Coca-Cola Company 22,99919,29918,981 Equity atributabie to noncontrolling interests Total fquity Total Liabilities and t quity \begin{tabular}{rrr} 1,861 & 1,985 & 2,117 \\ \hline 24,860 & 21,284 & 21,098 \\ \hline$94,354 & $87,296 & $86,381 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Water Audits And Loss Control Programs

Authors: American Water Works Association

4th Edition

1625761007, 978-1625761002

More Books

Students also viewed these Accounting questions