Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Following are summarized 2020 and 2019 encome statements and bulance sheets for The CocaCola Company Required Mate the following assumptions - 2021 sales revenue increases

image text in transcribed
image text in transcribed
image text in transcribed
Following are summarized 2020 and 2019 encome statements and bulance sheets for The CocaCola Company Required Mate the following assumptions - 2021 sales revenue increases 5% from 2020 to 535,358 mulion. - Operabiris expenses increase un 2021 in proportien to sales reverue - Dividend paryout is 60m of net income. - Income tax rate is 23% Prepare a forecast income statement and balance sheet for 2021. Note: Round your answers to the nearest whole dollar. \begin{tabular}{|c|c|c|c|c|c|} \hline & & & & Ferecant2021 & \\ \hline Net beprating rivenues & 133674 & 14,011 & 1 & & 9 \\ \hline Cost of soods sold & 18762 & 12911 & & & a \\ \hline Grnts proft & 1297 & & & & 9 \\ \hline Seline senerd, and admingtiance crierses & 2.920 & 1234 & & & 0 \\ \hline Dther pquerases tharges & 870 & 467 & & & 0 \\ \hline Operatury income & 3.176 & 102sin & & & 0 \\ \hline incereut inceme & 37 & 37 & & & 0 \\ \hline intertat experat & 1.465 & 95 & & & 0 \\ \hline & 994 & 1070 & & & 0 \\ \hline Oener income bawa-net & ass & 33 & & & 0 \\ \hline income betorr uent & & 11,002 & & & 9 \\ \hline Vecumecaset & 2,021 & & & & \\ \hline Comaldaned net incurine & & & 1 & & 9 \\ \hline \end{tabular} Consolidated net income \begin{tabular}{l|l|l|} \hline$7,922 & $9,165 & $ \end{tabular} 0 \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{THECOCA-COLACOMPANYANDSUBSIDIARIESConsolidatedBalanceSheets(5millions)} \\ \hline December 31 & \multirow{2}{*}{Actual2020} & Actual2019 & Forecast2021 \\ \hline \multicolumn{3}{|l|}{ Assets } & \\ \hline \multicolumn{4}{|l|}{ Current assets } \\ \hline Cash and cash equivalents & $6,934 & $6,608 & $ \\ \hline Short-term investments & 1,806 & 1,496 & 0 \\ \hline Marketable securities & 2,395 & 3,293 & 0 \\ \hline Trade accounts receivable, net & 3,207 & 4,050 & 0 \\ \hline Inventories & 3,331 & 3,447 & 0 \\ \hline Prepaid expenses and other assets & 1,954 & 1,924 & 0 \\ \hline Total current assets & 19,627 & 20,818 & 0 \\ \hline Equity method investments & 19,658 & 19,406 & 0 \\ \hline Other investments & 828 & 871 & 0 \\ \hline Other assets & 6,308 & 6,197 & 0 \\ \hline Deferred income tax assets & 2,509 & 2,460 & 0 \\ \hline Property, plant, and equipment, net & 10,993 & 11,055 & 0 \\ \hline Trademarks with indefinite lives & 10,603 & 9,451 & 0 \\ \hline Goodwill & 17,856 & 17,099 & 0 \\ \hline Other intangible assets & 662 & 751 & 0 \\ \hline Total assets & $89,044 & $88,108 & $ \\ \hline \multicolumn{4}{|l|}{ Liabilities and equity } \\ \hline \multicolumn{4}{|l|}{ Current liabilities } \\ \hline Accounts payable and accrued expenses & $11,368 & $11,538 & $ \\ \hline Loans and notes payable & 2,227 & 11,214 & 0 \\ \hline Current maturities of long-term debt & 495 & 4,338 & 0 \\ \hline Accrued income taxes & 804 & 422 & 0 \\ \hline Total current liabilities & 14,894 & 27,512 & 0 \\ \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

Financial Accounting Theory

Authors: Craig Deegan

2nd Edition

0077126734, 978-0077126735

More Books

Students also viewed these Accounting questions

Question

=+c) What do you conclude about the average value of the

Answered: 1 week ago