Campbel Gabrnel MEAT Ford FY16-17adx Saved Gabe Campbel File Home Insert Page Laycut Data Formulas Review View Add-ins Help Team O Tel me what you want to do- X Cut Calibri A A Wap Text AutoS 11 Number Copy Paste Fill Clear .A. 00 Merge & Center BIU- Conditional Format as Cell Formatting Table Styles $-% Insert Delete Format Format Painter Clipboard Fent Alignment Number Styles Celt AutoSave H C CS0 4607 A C C E G H 1 Ford Motor Company CONSOUDATED BALANCE SHEET-USD ($)$ in Millions Dec. 31, 2017 Dec. 31, 2016 3 ASSETS 4 Cash and cash equivalents 5 Marketable securities (Note 9) Accounts receivables, (less allowances of S392 for 2017 and $412 for 6 2016) 7 Inventories (Note 12) 8 0ther assets $18,492 $15,905 Calculate Gross Recievables 20,435 22,922 62,809 57,368 63.201 37,784 2016 10,277 3,889 8,898 2017 3,368 "Review A Exhibit 6-3 9 Total current assets 10 Financial Services finance receivables, net (Note 10) 11 Net investment in operating leases 12 Net property (Note 14) 13 Equity in net assets of affiliated companies (Note 15) 14 Deferred income taxes (Note 7) 15 Other assets 16 Total assets 17 IABILITIES 18 Payables 19 Other liabilities and deferred revenue (Note 16) 20 ITotal current liabilities 115,902 108,461 56,182 49,924 28.235 28.829 35,127 32,072 3,085 3,304 10,973 9,70 5,656 8,104 237,951 257,808 21,296 23,282 71,318 68,985 94.600 90.281 Sheet avag 50 7 dour 1 Su 401399s Type here to search Clipboard Font Alignment Number Styles AutoSave Off fe C50 4607 A E D 1 Costs and expenses 2 Cost of Goods Sold 131,332 126,183 3 Selling, administrative, and other expenses 4 Financial Services interest, operating, and other expenses 11,527 10,972 9,104 8,904 5 Total costs and expenses 151,963 146,059 6 Interest expense on Automotive debt 894 1,133 7 Equity in net income of affiliated companies 8 Income before income taxes 9 Provision for/(Benefit from) income taxes (Note 7) 0 Net income 1,201 1,780 8.148 6,796 520 2,189 4,607 7,628 367.28 Exhbit 6-3 2 Calculate Days Sales Receivables 2017 3 Calculate Average Receivables 2017) Exhibit 6-4 part B 4 5 Exhibit 6-4 Calculate Accounts Receivable Turnover 2017 6 7 Exhibit 6-5 Calculate Accounts Receivable Turnover in Days 2017 58 59 Calculate Day Sales Inventory 2017 Exhibit 6-8 50 51 Sheet1 Average 50,17S Type here to search hp