Company Name: Ford Motors
Competitors: General Motors and Tesla
Your Report consists of three parts:
Part 1: Financial Analysis
Part 2: Managerial Actions
Part 3: Investors’ Decisions
1.1 Current and quick ratios:
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
Current |
1.23 |
1.20 |
1.16 |
0.86 |
0.83 |
1.13 |
0.89 |
0.92 |
0.88 |
Quick |
1.08 |
1.04 |
0.99 |
0.51 |
0.46 |
0.71 |
0.68 |
0.73 |
0.67 |
1.2 Turnover ratios:
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
Inventory Turnover |
12.78 |
12.15 |
12.49 |
4.21 |
5.59 |
5.77 |
11.82 |
13.54 |
11.85 |
Inventory Period |
28.56 |
30.05 |
29.23 |
86.64 |
65.24 |
63.22 |
30.89 |
26.95 |
30.79 |
A/R Turnover |
2.50 |
2.45 |
2.48 |
22.82 |
22.61 |
18.56 |
5.08 |
4.40 |
4.11 |
A/R Period |
146.23 |
149.22 |
147.24 |
16.00 |
16.14 |
19.66 |
71.92 |
82.90 |
88.83 |
A/P Turnover |
5.40 |
6.05 |
6.18 |
2.49 |
3.57 |
3.34 |
5.35 |
5.52 |
5.00 |
A/P Period |
67.64 |
60.29 |
59.08 |
146.72 |
102.15 |
109.35 |
68.20 |
66.11 |
72.96 |
1.3Cycle & DIR
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
Operating Cycle |
174.79 |
179.27 |
176.74 |
102.63 |
81.38 |
82.88 |
102.81 |
109.85 |
119.62 |
Cash Cycle |
107.15 |
118.98 |
117.39 |
44.08 |
20.77 |
26.47 |
34.60 |
43.74 |
46.65 |
DIR |
1168.45 |
1142.66 |
1362.60 |
1043.50 |
1128.16 |
8411.10 |
692.81 |
3687.13 |
1539.69 |
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
Debt to Asset Ratio |
86.5% |
86.0% |
87.1% |
81.7% |
80.6% |
78.2% |
83.0% |
81.2% |
79.8% |
Equity Multiplier |
7.38 |
7.13 |
7.78 |
5.47 |
5.17 |
4.59 |
5.87 |
5.31 |
4.96 |
Interest Coverage |
7.16 |
6.07 |
2.39 |
3.61 |
0.40 |
0.12 |
35.14 |
13.89 |
15.53 |
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
Total Asset Turnover |
0.61 |
0.63 |
0.60 |
0.41 |
0.72 |
0.72 |
0.61 |
0.63 |
0.60 |
WC Turnover |
7.36 |
8.40 |
9.80 |
-10.65 |
-12.73 |
-17.12 |
-17.87 |
-21.18 |
-13.84 |
Fixed Assets Turnover |
4.44 |
4.43 |
4.27 |
0.57 |
1.09 |
1.22 |
1.84 |
1.79 |
1.70 |
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
Gross Profit Margin |
16.2% |
15.0% |
13.6% |
18.9% |
18.8% |
16.6% |
13.5% |
9.6% |
10.2% |
O/P Margin |
3.1% |
2.0% |
0.4% |
-13.9% |
-1.2% |
0.3% |
6.9% |
3.0% |
4.0% |
Net Profit Margin |
4.9% |
2.3% |
0.1% |
-19.1% |
-5.0% |
-3.2% |
-0.2% |
6.02 % |
5.49% |
Effective Tax rate |
15.3% |
10.0% |
26.5% |
-1.4% |
-5.8% |
-16.5% |
97.2% |
5.5% |
10.3% |
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
ROA |
3.0% |
1.4% |
0.0% |
-7.8% |
-3.6% |
-2.3% |
0.2% |
3.6% |
2.9% |
ROE |
21.8% |
10.3% |
0.3% |
-42.8% |
-18.5% |
-10.4% |
0.9% |
18.9% |
14.5% |
5.3 Dividend Payout:
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
Earning per share |
1.88 |
0.91 |
0.02 |
-13.27 |
-6.16 |
-4.28 |
0.24 |
5.77 |
4.76 |
Dividend per share |
0.64 |
0.71 |
0.59 |
1.55 |
1.32 |
1.72 |
0.40 |
0.43 |
0.30 |
Dividend Payout ratio |
34% |
79% |
135% |
-12% |
-21% |
-40% |
170% |
7% |
6% |
Dividend yield |
6% |
10% |
6% |
0% |
0% |
0% |
1% |
1% |
1% |
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
P/E |
5.68 |
7.64 |
324.50 |
-23.46 |
-54.06 |
-97.73 |
160.28 |
5.57 |
7.69 |
Price/Sales |
0.28 |
0.18 |
0.24 |
4.47 |
2.68 |
3.08 |
0.36 |
0.31 |
0.37 |
Market to Book |
1.24 |
0.78 |
1.12 |
10.04 |
9.98 |
10.14 |
1.46 |
1.05 |
1.11 |
6.2 Growth Ratios:
|
Ford |
Tesla |
GM |
||||||
|
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
2017 |
2018 |
2019 |
EPS Growth Rate |
65.1% |
-51.7% |
-97.7% |
177.4% |
-53.6% |
-30.5% |
-96.2% |
2347% |
-17.4% |
PEG Ratio |
8.7% |
-14.8% |
-454.7% |
-13.2% |
-10.8% |
-7% |
-166.6% |
0.2% |
-44.1% |
Sustainable Growth Rate |
14% |
2% |
-7% |
-48% |
-22% |
-15% |
-1% |
17% |
-14% |
1.4 Cash Cycle: Discuss at least 5 ways through which your company could reduce its cash cycle. Please note that we discussed a complete list of ways to reduce cash cycle in class, but not all items would be applied to your company—choose the ones that will work for your company and discuss in details how each way could be achieved.
1.5 Cash position: Discuss the company’s cash position in general –is the company holding too much, right just, or not enough cash?). Your answer should be based on the ratios you calculated above and consider the company’s balance sheet, income statement, cash flow statement, and its business strategy. (Cash = cash & equivalent + ST investments)
2.2 Based on Higgins 5-Factor Model of Financing Decisions, analyze your company against each of the 5 factors, and weigh the relative importance of these five factors. Should the company use high or low level of debt? (read Chapter 6)
2.3 Give advice to the company in terms of its debt policy—should the company reduce its debt, issue more debt, or stay in the current situation, explain your answers in details.
4.2 Are the company’s margins changing? Why and what are the underlying business cause—changes in competition, changes in input costs, or poor overhead cost management?
4.3 Now look at the company’s SG&A: is the company managing its overhead and administrative costs well? What are the business activities driving these costs? Are these activities necessary?
4.4 Discuss the company’s tax planning strategies and whether it strategically locates certain operations in tax havens, (hint: you can find the information on the company’s annual report). Is the company’s effective tax rate affected by the US tax cut?
4.5 Suggest two ways through which the company could improve its net profit margin, if necessary; or if you think the company’s current net profit margin is fine, you can also suggest two ways specifically to keep it or even further increase it.
5.2 Suggest two ways through which the company could improve its ROE, if necessary; or if you think the company’s current ROE is fine, you can also suggest two ways specifically to keep it or even further increase it.
7.1 Calculate the following for your company and its two competitors in the most recent year AND comment on the numbers:
7.2 Calculate the following for your company and its two competitors in the most recent year AND comment on the numbers:
7.3 Where do you see the company’s WACC going, increasing, decreasing, or remaining at the same level? Why? Type your answers starting from here:
7.4 Discuss two ways to improve the company’s WACC, your answers should relay to the general market condition, as well as the company’s debt structure & policy.
Type your answers starting from here:
Others
Discuss one more thing that’s not discussed above but you find worth noticing from the company’s income statement, balance sheet, or cash flow statement.
If you work for a bank and the company approaches you for debt financing:
Type your answers starting from here:
Equity Investors’ decision:
If you are considering whether or not to invest on the company’s publically traded stocks:
which ratios are important considerations? Will you purchase the stock? Why?