Calculate common size balance sheet. Please include excel reference formulas.

The requirement is to calculate a Common Size Balance Sheet. It is shown in green.

glcons Screenshot - JW ADO- Charts Charts - fi Dec 31, 2018 Paste Companies Financial Statements in Space proviced for each company: Make sure that you write if the info is in million COMPANY A: (Coca-Cola) Add most current fiscal year end date first last years Calculate Financial Info Common Size Balance Sheet Dec 31, 2018 Dec 31, 2017 Dec 31, 2018] Dec 31, 2017 Consolidated Balance Sheets (USD $) in Millions In Millions, unless otherwise specified $ 8,926 2,025 10,951 5,013 3,396 $6,006 9,352 15,358 5,317 3667 CURRENT ASSETS Cash and cash equivalents Short-term investments TOTAL CASH, CASH EQUIVALENTS AND SHORT-TERM INVESTMENTS Marketable securities Trade accounts receivable, less allowances of $489 and $477 respectively Inventories Prepaid expenses and other assets Assets held for sale Assets held for sale - discontinuing operations TOTAL CURRENT ASSETS EQUITY METHOD INVESTMENTS OTHER INVESTMENTS OTHER ASSETS Deferred Tax Assets, Net, Noncurrent 2,766 1,962 2,655 2,000 219 7,329 36,545 20,856 6,546 30,634 19,407 857 1,096 4,230 4,139 2,667 310 g Points Ratios and Comparison t ere to search BIO PIR VERTY TU Table Pictures Icons Screenshot My Add-ins & Charts Add-ins Ilustrations for Dec 31, 2018 2,667 8,232 6,682 330 8,203 6,729 138 9,401 368 87,896 10,263 274 83,216 Deferred Tax Assets, Net, Noncurrent PROPERTY, PLANT AND EQUIPMENT - net TRADEMARKS WITH INDEFINITE LIVES BOTTLERS' FRANCHISE RIGHTS WITH INDEFINITE LIVES GOODWILL OTHER INTANGIBLE ASSETS TOTAL ASSETS CURRENT LIABILITIES Accounts payable and accrued expenses Notes and Loans Payable, Current Current maturities of long-term debt Accrued income taxes Liabilities held for sale Liabilities Held for Sale, Discontinued Operations 8,748 13.205 8,932 13,194 4,997 378 3,298 410 1,722 1,496 TOTAL CURRENT LIABILITIES LONG-TERM DEBT OTHER LIABILITIES 29,223 25,364 7,638 27,194 31,182 8,021 1,933 2,522 DEFERRED INCOME TAXES THE COCA-COLA COMPANY SHAREOWNERS' EQUITY 1,760 1,760 Common stock, $0.25 par value; Authorized - 11,200 shares; Issued - 7,040 and 7,040 shares, respectively Capital surplus Reinvested earnings Tading Points Ratios and Comparisont 16,520 63,234 15,864 60,430 pe here to search 80- P IR - Y o Shapes le S Pictures Get Add-ins My Add-ins - SmartArt Screenshot Icons Maps PivotChart Recommended Charts 3D Map - Tours llustrations Add-ins fr 7638 CURRENT LIABILITIES Accounts payable and accrued expenses Notes and Loans Payable, Current Current maturities of long-term debt Accrued income taxes Liabilities held for sale Liabilities Held for Sale, Discontinued Operations 8,932 13,194 4,997 8,748 13,205 3,298 410 37 1,722 1,496 TOTAL CURRENT LIABILITIES LONG-TERM DEBT OTHER LIABILITIES 29.223 25,364 7,638 27,194 31,182 8,021 1,933 2,522 DEFERRED INCOME TAXES THE COCA-COLA COMPANY SHAREOWNERS' EQUITY 1,760 1,760 Common stock, $0.25 par value; Authorized - 11,200 shares; issued - 7,040 and 7,040 shares, respectively Capital surplus Reinvested earnings Accumulated other comprehensive income (loss) Treasury stock, at cost-2,772 and 2,781 shares, respectively EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS TOTAL EQUITY TOTAL LIABILITIES AND EQUITY 16.520 63,234 (12,814) (51,719) 16,981 15,864 60,430 (10,305) (50,677) 17,072 2,077 19,058 $ 83,216 1,905 18,977 $ 87,896 oints Ratios and Comparisont to search S PIRE