Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cases In Healthcare Finance

Authors: Louis Gapenski

5th Edition

1567936113, 978-1567936117

More Books

Students also viewed these Finance questions

Question

What is a debt service?

Answered: 1 week ago

Question

12.6 Analyze the emerging emphasis on employee recognition.

Answered: 1 week ago