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

See Answer