Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete Sales Revenue Forecast in Forecast Development Tab using the raw data above If there is any data missing could you please include how

image text in transcribed

image text in transcribedimage text in transcribed

Please complete "Sales Revenue Forecast" in Forecast Development Tab using the raw data above

image text in transcribed

image text in transcribed

If there is any data missing could you please include how to find what is missing in the comment?

Coca-Cola Year (Most recent in far right column BALANCE SHEET DATA Assets: Cash and cash equivalents Marketable securities Accounts and notes receivable-net Inventories Prepaid expenses and other current assets Deferred tax assets-current Other current assets (1 Other current assets (2 10:399 11761 5,4982185016,902 0 105.610 125.726 103.524 29.770 396.022 15,521 15.136 14.53189,464143.553 183.618 63.834 100.646 12.876 65.92426.872 44.168 28.564 65.996 Current Assets Investments in noncontrolled affiliates Property, plant, and equipment-at cost CAccumulated depreciation> Amortizable intangible assets (net 241,312239,215 287,001 282,694593,811794,538 998 358.232 40,145 812.989 29,837 54.150 48,981 42.971525,820 33,552 1,031,388 307.467 302. 53,801 58,560 60.832 725,819 86,091 520.672 520.672 520.672 144,447 533.040 Other nonamortizable intangible assets Other noncurrent assets (1 Other noncurrent assets (2 102.049 102.049106.220 117.954 144586 169.316 57.148 133.109 245.415 913.352 0 116,209 18.320 1,283,474 1,276,1561,433,0762,048,2132,449,484 3,072,960 Total Assets Liabilities and Equities: Accounts pavable Current accrued expenses Notes pavable and short-term debt Current maturities of long-term debt Deferred tax liabilities-current Income taxes payable Other current liabilities (1 Other current liabilities (2 20,000 20.000 644682,937 7.527197.049 7,063 116.821 43.579 51.227 79.065 35.155 171.042 27,830 25,86968.775 104,168 133,885 185,530 5,113 77,622 38,677 32,428 31.753 Current Liabilities Long-term debt obligations Long-term accrued liabilities Deferred tax liabilities-noncurrent Other noncurrent liabilities (1 Other noncurrent liabilities 216,312 208,816 227,420 326,553457,907 639,452 140,965 153,408 140,000 146,944174,854 1,088,018 90.599 134.100 115.197 126.679 25,791 59.050 177.250 267.090378.572 112.364 41.194 118,392 403,386 378,566 444,759 623,879 907,254620,579 1,084,036 1,016,230 1,176,133 1,528,384 2,086,460 2,614,053 118.303125.791 52.604 Total Liabilities 10 204 10,20410 204 756 Preferred stock 10.204 120.417 ommon stock Additional paid in capital Retained earnings Accum. other comprehensive income Amortizable intangible assets (net 241,312239,215 287,001 282,694593,811794,538 998 358.232 40,145 812.989 29,837 54.150 48,981 42.971525,820 33,552 1,031,388 307.467 302. 53,801 58,560 60.832 725,819 86,091 520.672 520.672 520.672 144,447 533.040 Other nonamortizable intangible assets Other noncurrent assets (1 Other noncurrent assets (2 102.049 102.049106.220 117.954 144586 169.316 57.148 133.109 245.415 913.352 0 116,209 18.320 1,283,474 1,276,1561,433,0762,048,2132,449,484 3,072,960 Total Assets Liabilities and Equities: Accounts pavable Current accrued expenses Notes pavable and short-term debt Current maturities of long-term debt Deferred tax liabilities-current Income taxes payable Other current liabilities (1 Other current liabilities (2 20,000 20.000 644682,937 7.527197.049 7,063 116.821 43.579 51.227 79.065 35.155 171.042 27,830 25,86968.775 104,168 133,885 185,530 5,113 77,622 38,677 32,428 31.753 Current Liabilities Long-term debt obligations Long-term accrued liabilities Deferred tax liabilities-noncurrent Other noncurrent liabilities (1 Other noncurrent liabilities 216,312 208,816 227,420 326,553457,907 639,452 140,965 153,408 140,000 146,944174,854 1,088,018 90.599 134.100 115.197 126.679 25,791 59.050 177.250 267.090378.572 112.364 41.194 118,392 403,386 378,566 444,759 623,879 907,254620,579 1,084,036 1,016,230 1,176,133 1,528,384 2,086,460 2,614,053 118.303125.791 52.604 Total Liabilities 10 204 10,20410 204 756 Preferred stock 10.204 120.417 ommon stock Additional paid in capital Retained earnings Accum. other comprehensive income

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_2

Step: 3

blur-text-image_3

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 A Global Approach

Authors: Sidney J. Gray, Belverd E. Needles

1st Edition

9780395839867

More Books

Students also viewed these Accounting questions

Question

What do you like to do in your spare time?

Answered: 1 week ago