Prepare the following analysis using Ford’s interactive financial statements (ht
ID: 2709699 • Letter: P
Question
Prepare the following analysis using Ford’s interactive financial statements (http://www.sec.gov/cgi-bin/viewer?action=view&cik=37996&accession_number=0000037996-14-000010&xbrl_type=v#) for end of the Fiscal year 2013, 2012, and 2011. Submit an Excel worksheet that develops the following: (((PLEASE SUBMIT THE EXCEL SHEET)))
Prepare horizontal analysis by developing a comparative balance sheet for the current and previous year of the balance sheet included in the 10-K.
Prepare vertical analysis by developing a comparative income statement for the current and previous year of the income statement included in the 10-K.
Explanation / Answer
Answer:
CONSOLIDATED AND SECTOR BALANCE SHEET (USD $) Dec. 31, 2013 Dec. 31, 2012 Amount ($) Inc or dec % In Millions, unless otherwise specified ASSETS Cash and cash equivalents $14,468 $15,659 ($1,191) -7.60584967 Marketable securities 22,100 20,284 $1,816 8.95286926 Finance receivables, net 77,481 70,991 $6,490 9.14200392 Other receivables, net 9,828 10,878 ($1,050) -9.65250965 Net investment in operating leases 19,984 15,303 $4,681 30.5887734 Inventories 7,708 7,362 $346 4.69980983 Equity in net assets of affiliated companies 3,679 3,246 $433 13.3394948 Net property 27,616 24,942 $2,674 10.7208724 Deferred income taxes 13,315 15,185 ($1,870) -12.3147843 Other assets 5,847 5,556 $291 5.23758099 Total assets 202,026 189,406 $12,620 6.6629357 LIABILITIES Payables 19,531 19,308 $223 1.15496167 Other liabilities and deferred revenue 40,462 48,259 ($7,797) -16.1565718 Debt 114,688 105,058 $9,630 9.16636525 Deferred income taxes 598 470 $128 27.2340426 Total liabilities 175,279 173,095 $2,184 1.26173489 Redeemable noncontrolling interest 331 322 $9 2.79503106 EQUITY Capital in excess of par value of stock 21,422 20,976 $446 2.12623951 Retained earnings 23,658 18,077 $5,581 30.8734856 Accumulated other comprehensive income/(loss) -18,231 -22,854 $4,623 -20.2284064 Treasury stock -506 -292 ($214) 73.2876712 Total equity attributable to Ford Motor Company 26,383 15,947 $10,436 65.4417759 Equity attributable to noncontrolling interests 33 42 ($9) -21.4285714 Total equity 26,416 15,989 $10,427 65.2135843 Total liabilities and equity 202,026 189,406 $12,620 6.6629357