70.2K

Verified Solution

Link Copied!

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}

Answer & Explanation Solved by verified expert

See Answer