50.1K
Verified Solution
Link Copied!
Finance Ford excel case study.
FORD MOTOR CO (F) INCOME STATEMENT
Dec-17. Dec-18. Dec-19 Dec-20
Revenue 156,776,000,000 160,338,000,000 155,900,000,000 127,144,000,000
Cost of revenue 131,332,000,000 136,269,000,000 134,693,000,000 112,752,000,000
Gross profit 25,444,000,000 24,069,000,000 21,207,000,000 14,392,000,000
Operating expenses
Sales, General and administrative 11,527,000,000 11,403,000,000 11,161,000,000 10,193,000,000
Total operating expenses 11,527,000,000 11,403,000,000 11,161,000,000 10,193,000,000
Operating income 13,917,000,000 12,666,000,000 10,046,000,000 4,199,000,000
Interest Expense 10,237,000,000 10,691,000,000 10,521,000,000 10,256,000,000
Other income (expense) 4,468,000,000 2,370,000,000 (165,000,000) 4,941,000,000
Income before taxes 8,148,000,000 4,345,000,000 (640,000,000) (1,116,000,000)
Provision for income taxes 520,000,000 650,000,000 (724,000,000) 160,000,000
Net income from continuing operations 7,628,000,000 3,695,000,000 84,000,000 (1,276,000,000)
Other (26,000,000) (18,000,000) (37,000,000) (3,000,000)
Net income 7,602,000,000 3,677,000,000 47,000,000 (1,279,000,000)
Net income available to common shareholders 7,602,000,000 3,677,000,000 47,000,000 (1,279,000,000)
Earnings per share
Basic 2 1 0 (0)
Diluted 2 1 0 (0)
Weighted average shares outstanding
Basic 3,975,000,000 3,974,000,000 3,972,000,000 3,973,000,000
Diluted 3,998,000,000 3,998,000,000 4,004,000,000 3,973,000,000
EBITDA 26,838,000,000 23,344,000,000 18,371,000,000 16,597,000,000
Please provide excel cell reference formulas. Thank you
| Ratios | | | | | | |
| | Dec-17 | Dec-18 | Dec-19 | Dec-20 | | |
| | | | | | | |
| Stock Price | 12.49 | 7.65 | 9.3 | 8.79 | | |
| Market Capitalization | 49,647,750,000 | 30,401,100,000 | 36,939,600,000 | 34,922,670,000 | | |
| | | | | | | |
| Valuation | | | | | | |
| Price-Earnings | | | | | | |
| | | | | | | |
| Market to Book | | | | | | Use Price to Book |
| | | | | | | |
| Enterprise / EBITDA | | | | | | |
| | | | | | | |
| Profitability | | | | | | |
| Operating Margin | | | | | | |
| | | | | | | |
| Net Profit Margin | | | | | | |
| | | | | | | |
| Return on Equity | | | | | | Based on Net Income from Continuing Operations |
| | | | | | | |
| Financial Strength | | | | | | |
| Current Ratio | | | | | | |
| | | | | | | |
| Book Debt-Equity | | | | | | |
| | | | | | | |
| Mkt Debt-Equity | | | | | | |
| | | | | | | |
| Interest Coverage | | | | | | |
| | | | | | | |
| Enterprise Value | | | | | | |
Answer & Explanation
Solved by verified expert
