60.1K

Verified Solution

Link Copied!

Following are summarized 2020 and 2019 income statements and balance sheets for The Coca-Cola Company. Required Make the following assumptions: - 2021 sales revenue increases 5% from 2020 to $35,358 million. - Operating expenses increase in 2021 in proportion to sales revenue. - Operating assets and liabilities increase based on their 2020 relation to sales revenue. Classify "deferred and accrued taxes," "Other assets," and "Other liabilities" as operating. - Nonoperating revenues, expenses, assets (including investments and intangible assets), and liabilities do not change from 2020 to 2021. Assume no change for equity income or equity method investments. - Dividend payout is 60% of net income. - Income tax rate is 25%. 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|} \hline \multirow[t]{2}{*}{ December 31} & \multirow[t]{2}{*}{millions)Actual2020} & \multicolumn{2}{|l|}{Actual2019} & Forecast2021 \\ \hline & & & & \\ \hline Current assets & & & & \\ \hline Cash and cash equivalents & $6,934 & $6,608 & $ & \\ \hline Short-term investments & 1,806 & 1,496 & & \\ \hline Marketable securities & 2,395 & 3,293 & & \\ \hline Trade accounts receivable, net & 3,207 & 4,050 & & \\ \hline Inventories & 3,331 & 3,447 & & \\ \hline Prepaid expenses and other assets & 1,954 & 1,924 & & \\ \hline Total current assets & 19,627 & 20,818 & & 0 \\ \hline Equity method investments & 19,658 & 19,406 & & \\ \hline Other investments & 828 & 871 & & \\ \hline Other assets & 6,308 & 6,197 & & \\ \hline Deferred income tax assets & 2,509 & 2,460 & & \\ \hline Property, plant, and equipment, net & 10,993 & 11,055 & & \\ \hline Trademarks with indefinite lives & 10,603 & 9,451 & & \\ \hline Goodwill & 17,856 & 17,099 & & \\ \hline Other intangible assets & 662 & 751 & & \\ \hline Total assets & $89,044 & $88,108 & $ & 0 \\ \hline Liabilities and equity & & & & \\ \hline Current liabilities & & & & \\ \hline Accounts payable and accrued expenses & $11,368 & $11,538 & $ & \\ \hline Loans and notes payable & 2,227 & 11,214 & & \\ \hline Current maturities of long-term debt & 495 & 4,338 & & \\ \hline Accrued income taxes & 804 & 422 & & \\ \hline Total current liabilities & 14,894 & 27,512 & & 0 \\ \hline Long-term debt & 40,928 & 28,066 & & \\ \hline Other liabilities & 9,642 & 8,680 & & \\ \hline Deferred income tax liabilities & 1,870 & 2,330 & & \\ \hline Total liabilities & 67,334 & 66,588 & & 0 \\ \hline Total equity & 21,710 & 21,520 & & \\ \hline Total liabilities and equity & $89,044 & $88,108 & $ & 0 \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer