You have been provided with the financial statements for Ford Motor Company. Using the Excel template provided, you can input the financial statements and then use those to populate your ratio calculations. The pyramid tab will automatically populate. 

All ratio formulas are given, similar to what you had for this week's activity.

In addition to calculating the ratios, please answer the following questions. Note that these questions are to continue to help you with your critical thinking - as we discussed in class.

 

Question:

From an internal benchmark perspective, how has Ford been performing over the past 4 years? What influence has Ford Credit had on their performance?

 

Question:

Remove the Ford Credit numbers. Now what does Ford's performance look like? 

 

Question:

From an external benchmark perspective, with Ford Credit still removed, how does Ford's performance compare to the industry? What other companies can Ford be compared to? (Please provide your sources of information - for example, Google Finance, Bloomberg, Investopedia, ReadyRatios, any others?