212,482 Consolidated Balance Sheets - USD $ $ In Mill 2 Current Assets Cash and cash equivalents Martable securities Note 4) Accounts and notes receivable et of lowance of $278 for 2017 id $212 for 2016) Inventaries Note 6) Equipment on operating l o te 7) 8 Other current N ote 4 Note 12 at VE 9. Current held for sale Note 3) 10 Total currentes 11 Non-current Assets 12 Equity in news of nonconsolidated affiliates Note 8) 13 Property, Note) 14 Goodwill and intangi s , net (Note 11) 15 Equipment on operating net Note 7 Note 12 at VE 16 Deferred income tee 13 17 Others Note 4 Note 12 V 10 Non-current is held for sale Note 3) 19 Total non-current assets 20 Total Assets 21 Current Liabilities 22 Accounts payable principally tradel 23 Accrued a s Note 13) 24 Current liabilities held for sale Note 3) 25 Total current es 26 Non-currem Uwiities 27 Postretirement benefits other than pension Note 16 28 Pensions (Note 16) 29 Other Mote 13) 30 Non current liabilities held for sale Note 3 31 Total non curre tes 32 Total Liabilities 33 Commitments and contingencies Note 17) 34 Equity Nate 20 15 Commonwoch, 1 par value 1 Additional pa din capital 37 Retained rings 38 Accumulher com velo 39 Total eckholders' equity in Nocontrolling interests Sheet 23.333 12,415 177,615 2016 40 Noncontrolling interests 41 Total Equity 42 Total Llabilities and Equity 43 1,199 36,200 212,482 239 44,075 221,690 12 Months Ended Dec 31, 2017 Dec 31, 2016 $ 133,449 12,139 $ 140,205 8,979 149,184 1455 114,869 11,128 9,575 135,572 10,016 575 290 120,499 8,369 10,354 139,222 9,962 563 327 2,132 Consolidated Income Statements - USD ($) shares in Millons, S In Millions 46 Net sales and revenue 47 Automotive 48 GM Financial 49 Total net sales and revenue 50 costs and expenses 51 Cost of Goods Sold 52 GM Financial Interest, operating and other expenses 53 Automotive selling general and administrative exper 54 Total costs and expenses 55 Operating income 56 Automotive Interest expense 57 Interest income and other non-operating income 58 Gain on extinguishment of debt 59 Equity income (Note 8) 60 Income before income taxes 61 Income tax expense (benefit) (Note 18) 62 Income from continuing operations 63 Income (loss) from discontinued operations, net of tax (Note 3) 64 Net Income (loss) 65 Net loss attributable to noncontrolling interests 66 Net Income (los) attributable to stockholders 67 Net income (los) attributable to common stockholders 68 Earnings per share (Note 21) 69 Basic earnings per common share-continuing operations in dollars per share) 70 Basic earnings (los) per common share-discontinued operations (in dollars per share) 71 Basic earnings floss) per common share in dollars per share) 72 Weighted average common shares outstanding-basic in shares) 73 Diluted earnings per common share - continuing operations in dollars per share) 74 Diluted earnings (loss) per common share-discontinued operations in dollars per share) 75 Diluted earnings (loss) per common share in dollars per share) 76 Weighted average common shares outstanding-diluted in shares) 11.863 2,282 12,008 2,739 9,269 11.533 330 (1) (4,212) (3,882) 9,268 159 9.427 $ 9,427 (3.864) $ (3,880) $ 6.12 $ 0.23 (2.88) $12.65) 1,465 $0.22 (2.82) $ 2.60) 1.492 $6.12 1.540 $6 $6 1,570 Calculate Days Sales Receivables 2017 Sheet1 + 1,540 $6 72 Weighted average common shares outstanding-basic in shares) 73 Diluted earnings per common share-continuing operations in dollars per share) 74 Diluted earnings (los) per common share-discontinued operations (in dollars per share) 75 Diluted earnings (loss) per common share in dollars per share) 76 Weighted-average common shares outstanding-diluted in shares) 1,465 $ 0.22 (2.82) $ 12.60) 1,492 $6 1,570 Calculate Days Sales Receivables 2017 Exchbit 6-3 Calculate Average Receivables 2017 Exhibit 6-4 part B Calculate Accounts Receivable Turnover 2017 Exhibit 64 Calculate Accounts Receivable Turnover in Days 2017 Exhibit 6-5 Calculate Day Sales Inventory 2017 Exhibit 6-8 Calculate Average Inventory 2017 Calculate inventory Turnover 2017 Exhibit 6.9 Calculate Inventory Turnover in Days 2017 Exhibit 6-10 Working Capital Ratio 2017 Exhibit 6-12 Current Ratio 2017 Exhibit 6-13 Acid Test Ratio 2017(First Dample in Bookp.244) 100 Cash Ratio 2017 Exhibit 6-17 101 102 Average Working Capital 2017 Exhibit 6-18 Part 3 Sales to Working Capital 2017 Exhibit 6.18 104 105 106 108 109 I need the excel formula for the calculation for the yellow boxes