Question
Download the annual income statements, balance sheets, and cash flow statements for the last three fiscal years (2017, 2016 & 2015) for Ford Motor Company.
Download the annual income statements, balance sheets, and cash flow statements for the last three fiscal years (2017, 2016 & 2015) for Ford Motor Company. Compute three different valuation ratios, three different profitability ratios, and three financial strength ratios for each of the three years. Compare the ratios over time. What do they say about the profitability and strength of Ford Motor Company? Is Ford Motor Company a good investment? 750 - 1000 words - The Balance Sheet, Income Statements, and Cash Flow statements are provided.
Balance Sheet
The fiscal year is January-December. All values USD millions. | 2013 | 2014 | 2015 | 2016 | 2017 | 5-year trend |
---|---|---|---|---|---|---|
Cash & Short-Term Investments | 36.57B | 31.15B | 35.18B | 38.83B | 38.93B | |
Cash Only | 14.47B | 10.76B | 14.27B | 15.91B | 18.49B | |
Short-Term Investments | 22.1B | 20.39B | 20.9B | 22.92B | 20.44B | |
Cash & Short Term Investments Growth | - | -14.82% | 12.92% | 10.38% | 0.26% | |
Cash & ST Investments / Total Assets | 18.10% | 14.93% | 15.64% | 16.32% | 15.10% | |
Total Accounts Receivable | 87.31B | 92.82B | 101.98B | 57.59B | 63.05B | |
Accounts Receivables, Net | 87.31B | 92.82B | 101.98B | 57.37B | 62.81B | |
Accounts Receivables, Gross | 87.67B | 93.14B | 102.35B | 58.24B | 63.82B | |
Bad Debt/Doubtful Accounts | (357M) | (321M) | (373M) | (876M) | (1.01B) | |
Other Receivables | - | - | - | 223M | 240M | |
Accounts Receivable Growth | - | 6.31% | 9.86% | -43.52% | 9.48% | |
Accounts Receivable Turnover | 1.68 | 1.55 | 1.47 | 2.64 | 2.49 | |
Inventories | 7.71B | 7.87B | 8.32B | 8.9B | 10.28B | |
Finished Goods | 5.06B | 5.03B | 5.25B | 5.94B | 6.78B | |
Work in Progress | - | - | - | - | - | |
Raw Materials | 3.61B | 3.86B | 4.01B | 3.84B | 4.4B | |
Progress Payments & Other | (963M) | (1.02B) | (940M) | (888M) | (899M) | |
Other Current Assets | - | - | - | 3.15B | 3.65B | |
Miscellaneous Current Assets | - | - | - | 3.15B | 3.65B | |
Total Current Assets | 131.59B | 131.84B | 145.47B | 108.46B | 115.9B |
2013 | 2014 | 2015 | 2016 | 2017 | 5-year trend | |
---|---|---|---|---|---|---|
Net Property, Plant & Equipment | 47.6B | 53.34B | 57.26B | 60.9B | 63.56B | |
Property, Plant & Equipment - Gross | 82.21B | 85.91B | 89.32B | 94.32B | 99.42B | |
Buildings | 10.33B | 10.6B | 9.94B | 10.31B | 11.1B | |
Land & Improvements | 440M | 351M | 344M | 391M | 411M | |
Computer Software and Equipment | 2.07B | 2.12B | 2.24B | 2.8B | 3.12B | |
Other Property, Plant & Equipment | 9.32B | 11.09B | 10.19B | 11.68B | 12B | |
Accumulated Depreciation | 34.61B | 32.57B | 32.06B | 33.42B | 35.86B | |
Total Investments and Advances | 3.87B | 3.36B | 3.22B | 3.52B | 3.45B | |
Other Long-Term Investments | 186M | - | - | - | - | |
Long-Term Note Receivable | - | 191M | 209M | 49.92B | 56.18B | |
Intangible Assets | 85M | 133M | 124M | 248M | 288M | |
Net Goodwill | - | - | - | 50M | 75M | |
Net Other Intangibles | 85M | 133M | 124M | 198M | 213M | |
Other Assets | 5.58B | 5.73B | 7.13B | 5.19B | 7.45B | |
Tangible Other Assets | 5.58B | 5.73B | 7.13B | 5.19B | 7.45B | |
Total Assets | 202.03B | 208.62B | 224.93B | 237.95B | 257.81B | |
Assets - Total - Growth | - | 3.26% | 7.82% | 5.79% | 8.34% |
Liabilities & Shareholders' Equity
2013 2014 2015 2016 2017
Debt & CtrendPortion LT Debt | 38.06B | 39.17B | 43B | 49.67B | 51.62B | |
Short-Term Debt | 15.56B | 11.51B | 12.94B | 16.65B | 18.55B | |
Current Portion of Long-Term Debt | 22.51B | 27.66B | 30.06B | 33.02B | 33.07B | |
Accounts Payable | 19.53B | 20.04B | 20.27B | 21.3B | 23.28B | |
Accounts Payable Growth | - | 2.58% | 1.18% | 5.05% | 9.33% | |
Income Tax Payable | - | - | - | - | - | |
Other Current Liabilities | 16.54B | 17.91B | 17.99B | 19.32B | 19.7B | |
Dividends Payable | - | - | - | - | - | |
Accrued Payroll | 2.42B | 2.76B | 2.13B | 2.07B | 2.24B | |
Miscellaneous Current Liabilities | 14.12B | 15.16B | 15.86B | 17.25B | 17.46B | |
Total Current Liabilities | 74.13B | 77.12B | 81.26B | 90.28B | 94.6B | |
Long-Term Debt | 76.63B | 80B | 89.86B | 93.3B | 102.67B | |
Long-Term Debt excl. Capitalized Leases | 76.63B | 80B | 89.86B | 93.3B | 102.67B | |
Non-Convertible Debt | 76.63B | 80B | 89.86B | 93.3B | 102.67B | |
Convertible Debt | - | - | - | - | - | |
Capitalized Lease Obligations | - | - | - | - | - | |
Provision for Risks & Charges | 15.58B | 17.34B | 15.93B | 16.92B | 17.02B | |
Deferred Taxes | (12.72B) | (13.45B) | (11.01B) | (9.01B) | (10.16B) | |
Deferred Taxes - Credit | 598M | 570M | 502M | 691M | 815M | |
Deferred Taxes - Debit | 13.32B | 14.02B | 11.51B | 9.71B | 10.97B | |
Other Liabilities | 8.35B | 8.78B | 8.63B | 7.48B | 7.69B | |
Other Liabilities (excl. Deferred Income) | 5.81B | 6.1B | 5.79B | 3.79B | 3.86B | |
Deferred Income | 2.53B | 2.69B | 2.83B | 3.69B | 3.83B | |
Total Liabilities | 175.28B | 183.81B | 196.17B | 208.67B | 222.79B | |
Non-Equity Reserves | - | - | - | - | - | |
Total Liabilities / Total Assets | 86.76% | 88.11% | 87.22% | 87.69% | 86.42% | |
Preferred Stock (Carrying Value) | - | - | - | - | - | |
Redeemable Preferred Stock | - | - | - | - | - | |
Non-Redeemable Preferred Stock | - | - | - | - | - | |
Common Equity (Total) | 26.38B | 24.44B | 28.64B | 29.17B | 34.89B | |
Common Stock Par/Carry Value | 40M | 40M | 41M | 41M | 41M | |
Retained Earnings | 23.66B | 9.42B | 14.41B | 15.63B | 21.22B | |
ESOP Debt Guarantee | - | - | - | - | - | |
Cumulative Translation Adjustment/Unrealized For. Exch. Gain | (1.75B) | (2.44B) | (3.57B) | (4.59B) | (4.28B) | |
Unrealized Gain/Loss Marketable Securities | - | - | (6M) | (14M) | (48M) | |
Revaluation Reserves | - | - | - | - | - | |
Treasury Stock | (506M) | (848M) | (977M) | (1.12B) | (1.25B) | |
Common Equity / Total Assets | 13.06% | 11.71% | 12.73% | 12.26% | 13.53% | |
Total Shareholders' Equity | 26.38B | 24.44B | 28.64B | 29.17B | 34.89B | |
Total Shareholders' Equity / Total Assets | 13.06% | 11.71% | 12.73% | 12.26% | 13.53% | |
Accumulated Minority Interest | 364M | 369M | 109M | 113M | 126M | |
Total Equity | 26.75B | 24.81B | 28.75B | 29.28B | 35.02B | |
Liabilities & Shareholders' Equity | 202.03B | 208.62B | 224.93B | 237.95B | 257.81B | |
5-year trendST |
Annual Financials for Ford Motor Co.
View Ratios
Fiscal year is January-December. All values USD millions. | 2013 | 2014 | 2015 | 2016 | 2017 | 5-year trend |
---|---|---|---|---|---|---|
Sales/Revenue | 146.92B | 144.08B | 149.56B | 151.8B | 156.78B | |
Sales Growth | - | -1.93% | 3.80% | 1.50% | 3.28% | |
Cost of Goods Sold (COGS) incl. D&A | 121.5B | 121.25B | 120.33B | 128.73B | 132.89B | |
COGS excluding D&A | 114.99B | 113.83B | 112.36B | 120.01B | 124.44B | |
Depreciation & Amortization Expense | 6.52B | 7.42B | 7.97B | 8.72B | 8.45B | |
Depreciation | 6.5B | 7.39B | 7.99B | 9.02B | 9.12B | |
Amortization of Intangibles | 11M | 38M | (27M) | (306M) | (669M) | |
COGS Growth | - | -0.21% | -0.76% | 6.98% | 3.24% | |
Gross Income | 25.42B | 22.83B | 29.23B | 23.08B | 23.88B | |
Gross Income Growth | - | -10.18% | 28.03% | -21.05% | 3.51% | |
Gross Profit Margin | - | - | - | - | 15.23% | NA |
2013 | 2014 | 2015 | 2016 | 2017 | 5-year trend | |
---|---|---|---|---|---|---|
SG&A Expense | 18.54B | 21.74B | 21.7B | 19.5B | 19.53B | |
Research & Development | 6.4B | 6.7B | 6.7B | 7.3B | 8B | |
Other SG&A | 12.14B | 15.04B | 15B | 12.2B | 11.53B | |
SGA Growth | - | 17.23% | -0.17% | -10.15% | 0.16% | |
Other Operating Expense | 208M | 305M | 417M | - | - | |
Unusual Expense | 1.38B | 1.41B | (969M) | (1.16B) | 204M | |
EBIT after Unusual Expense | 5.29B | (1.41B) | 8.08B | 4.74B | 4.15B | |
Non Operating Income/Expense | 1.26B | 1.11B | 1.19B | 1.24B | 3.69B | |
Non-Operating Interest Income | 213M | 244M | 309M | 291M | 459M | |
Equity in Affiliates (Pretax) | 1.07B | 1.6B | 1.82B | 1.78B | 1.2B | |
Interest Expense | 829M | 1.1B | 1.14B | 1.26B | 1.35B | |
Interest Expense Growth | - | 32.81% | 3.81% | 10.32% | 7.06% | |
Gross Interest Expense | 847M | 1.12B | 1.16B | 1.29B | 1.39B | |
Interest Capitalized | 18M | 21M | 20M | 27M | 35M | |
Pretax Income | 7B | 1.23B | 10.25B | 6.8B | 8.15B | |
Pretax Income Growth | - | -82.37% | 730.79% | -33.71% | 19.89% | |
Pretax Margin | - | - | - | - | 5.20% | NA |
Income Tax | (147M) | 4M | 2.88B | 2.19B | 520M | |
Income Tax - Current Domestic | (59M) | (24M) | 92M | (110M) | (40M) | |
Income Tax - Current Foreign | 302M | 389M | 572M | 630M | 868M | |
Income Tax - Deferred Domestic | (711M) | (521M) | 1.75B | 1.55B | (901M) | |
Income Tax - Deferred Foreign | 321M | 160M | 472M | 121M | 593M | |
Income Tax Credits | - | - | - | - | - | |
Equity in Affiliates | - | - | - | - | - | |
Other After Tax Income (Expense) | - | - | - | - | - | |
Consolidated Net Income | 7.15B | 1.23B | 7.37B | 4.61B | 7.63B | |
Minority Interest Expense | (7M) | (1M) | (2M) | 11M | 26M | |
Net Income | 7.16B | 1.23B | 7.37B | 4.6B | 7.6B | |
Net Income Growth | - | -82.80% | 498.94% | -37.66% | 65.40% | |
Net Margin Growth | - | - | - | - | 4.85% | NA |
Extraordinaries & Discontinued Operations | - | - | - | - | - | |
Extra Items & Gain/Loss Sale Of Assets | - | - | - | - | - | |
Cumulative Effect - Accounting Chg | - | - | - | - | - | |
Discontinued Operations | - | - | - | - | - | |
Net Income After Extraordinaries | 7.16B | 1.23B | 7.37B | 4.6B | 7.6B | |
Preferred Dividends | - | - | - | - | - | |
Net Income Available to Common | 7.16B | 1.23B | 7.37B | 4.6B | 7.6B | |
EPS (Basic) | 1.82 | 0.31 | 1.86 | 1.16 | 1.91 | |
EPS (Basic) Growth | - | -82.97% | 500.00% | -37.63% | 64.66% | |
Basic Shares Outstanding | 3.94B | 3.91B | 3.97B | 3.97B | 3.98B | |
EPS (Diluted) | 1.76 | 0.31 | 1.84 | 1.15 | 1.90 | |
EPS (Diluted) Growth | - | -82.39% | 493.55% | -37.50% | 65.22% | |
Diluted Shares Outstanding | 4.09B | 3.96B | 4B | 4B | 4B | |
EBITDA | 13.18B | 8.21B | 15.08B | 12.3B | 12.81B | |
EBITDA Growth | - | -37.71% | 83.62% | -18.46% | 4.18% | |
EBITDA Margin | - | - | - | - | 8.17% | NA |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started