046 x fx 1 Ford Motor Company CONSOLIDATID NALANCES SI 492 22,922 Galerie 2015 171,201 115.902 28.235 32.072 10,973 3.104 257,808 207.951 Cash and cash equivalents Short term Marktbecurities (Note9) Accounts receiv e s allowance of $392 for 2017 and 1412 Inventories Note 12) Others Total current a s Financial Services finance receivables et Note 10) 11 Net investment in operating lease 12 Net property Note 14) 13 Equity in net of companies Note 15) 14 Deferred income taxes (Note?) 15 other assets 16 Total ILIABILMES 18 Payables 19 Other liabilities and deferred revenue Note 16) 20 Total current liabilities 21 Other liabilities and deferred revenue Note 16) 22 Debt 23 Deferred income taxes (Note 7) 24 Total liabilities 25 Redeemable noncontrolling interest (Note 201 26 EQUITY 27 Capital in excess of par value of stock 28 Retained earnings 29 Accumulated other comprehensive income/low Note 21) 30 Treasury stock 31 Totality to Ford Motor Compan 12 Equity tributable to controlling interest 3 Total equity 34 Total Babies and equity 21,296 19.316 90.281 24.195 142.970 154.287 205,668 21.630 15,634 (013) 28.110 257,80 237,951 12 Months Ended Dec 31, 2016 3 CONSOLIDATED INCOME STATEMENT-USO 185 in 33 Revenues Financial Services Revenues 10 Total Net Sales $10.253 151.800 BE ta 151,800 156,776 Marcar criceveres 40 Total Net Sales E 41 Costs and expenses Cost of Goods Sold Selling administrative, and other expenses 44 Financial Services Interest, operating and other expenses 45 Total costs and expenses 46 Interest expense on Automotive debt 47 Equity in net income of affiliated companies 48 Income before income taxes 49 Provision for/(Benefit from) income taxes (Note 7) 50 Net Income 131,332 11,527 9,104 151,963 1,133 1,201 8,148 520 7,628 126,183 10,972 8,904 146,059 894 1,780 6,796 2.189 4.607 Calculate Days Sales Receivables 2017 Exhbit 6-3 Calculate Average Receivables 2017 Exhibit 6-4 part Calculate Accounts Receivable Turnover 2017 Exhibit 6-4 Calculate Accounts Receivable Turnover in Days 2017| Exhibit 6-5 Calculate Day Sales Inventory 2017 Exhibit 6-8 Calculate Average Inventory 2017 Exhibit 6-9 B Calculate Inventory Turnover 2017 Exhibit 6-9 Calculate Inventory Turnover in Days 2017 Exhibit 6-10 calculate Inventory Turnover 2017 Working condition Current Ratio 2017 Working Capital 2017 Exhibit 6-12 Current Ratio 2017 Exhibit 6-13 Acid-Test Ratio 2017 (First Example in Bookp.244) Exhibit 6-14 I Cash Ratio 2017 Exhibit 6-17 Average Working Capital 2017 Exhibit 6-18 Part B Sales to Working Capital 2017 Exhibit 6-18 Sheet1 I need the excel formula for the calculation for the yellow boxes