Part 1:
(in millions)
Year 1
Year 2
Year 3
Sales
34734
39304
42680
Cost of Goods Sold
33550
37852
40648
Net Income
1184
1452
2032
Assets
25654
27385
29903
Total Debt
11695
10498
13926
Equity
15654
15220
14727
Operating Cash Flow
1998
2378
3186
Investment Cash Flow
-2781
-3419
-4049
Financing Cash Flow
-692
-287
-244
Required: Given the information in the table above calculate the following:
Profit margin on sales
Return on assets
Return on equity
Total debt to total assets
Total asset turnover
Explain and evaluate y
Part 1:
(in millions)
Year 1
Year 2
Year 3
Sales
34734
39304
42680
Cost of Goods Sold
33550
37852
40648
Net Income
1184
1452
2032
Assets
25654
27385
29903
Total Debt
11695
10498
13926
Equity
15654
15220
14727
Operating Cash Flow
1998
2378
3186
Investment Cash Flow
-2781
-3419
-4049
Financing Cash Flow
-692
-287
-244
Required: Given the information in the table above calculate the following:
Profit margin on sales
Return on assets
Return on equity
Total debt to total assets
Total asset turnover
Explain and evaluate your results as they pertain to profitability debt and asset turnover for the company over a three-year period. Must be reported in excel and show all calculations.
Part 2: Report in a MS Excel document. Show all calculations and conclusions.
Identify two items or issues that cannot be derived from the financial statements of General Motors and Ford Motors. Explain why these items or issues would be of concern to investors and other stakeholders. In your rationale address the specific interests of the different users of financial statements.
Compare and contrast General Motors and Ford Motors in terms of how well or how poorly they are performing in the areas of profit debt and asset turnover. Use appropriate ratios in your analysis. Indicate strategies for possible improvement in each area.
Attachments: