Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete the following seven Financial Ratios as described for the years 2019, 2014. (2017 is optional) Please show the formula and all the work! 2019
Complete the following seven Financial Ratios as described for the years 2019, 2014. (2017 is optional) Please show the formula and all the work!
2019 Ratio 2014 Ratio (2017 Optional) Profitability Ratios: Basic Earnings per Share EPS Return on Equity Return on Sales Liquidity Ratios: 2019 Ratio 2014 Ratio (2017 Optional) Current Ratio Acid Test Ratio 2019 Ratio 2014 Ratio (2017 Optional) Activity Ratios: (a.k.a. Efficiency Ratio) Inventory Turnover 2019 Ratio 2014 Ratio (2017 Optional) Leverage Ratios: (a.k.a. Solvency Ratio) Debt-Equity Ratio Ford Motor Company (F) Balance Sheet Period Ending (All numbers in thousands) 12/31/2019 12/31/2018 12/31/2017 12/31/2016 12/31/2015 12/31/2014 Assets Current Assets Cash and Cash Equivalents Short-term Investments Accounts Receivables Inventory Other Current Assets Total Current Assets 17,500,000 17,150,000 63,140,000 10,790,000 5,470,000 114,050,000 16,720,000 17,230,000 65,810,000 11,220,000 3,670,000 114,650,000 18,492,000 20,435,000 62,809,000 10,277,000 3,889,000 115,902,000 15,905,000 22,922.000 57,368,000 8,898,000 3.368.000 108,461,000 14,272,000 20,904,000 56,179,000 8,319,000 2.913.000 102,587,000 10,757,000 20,393,000 90,584,000 7,870,000 2.235,000 131,839,000 53,700,000 67,110,000 278,000 55,540,000 65,300.000 59,267,000 63,562,000 53,228,000 60,901.000 48,778,000 57,256,000 3,357,000 53,343,000 Long Term Investments Property, Plant, and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets 11,462,000 11,940,000 258,540,000 10,850,000 10,200,000 256,540,000 8,104,000 10,973,000 257,808,000 5,656,000 9,705,000 237,951,000 4,795,000 11,509,000 224,925,000 6,052,000 14,024,000 208,615,000 Liabilities Current Liabilities Accounts Payable Short / Current Long Term Debt Other Current Liabilites Total Current Liabilties 20,670,000 53,310,000 24,150,000 98,130,000 21,520,000 53,490,000 20,560,000 95,570,000 23,282,000 51,621,000 19,697,000 94,600,000 21,296,000 49,669,000 19,316,000 90.281,000 20,272,000 42,975,000 19,089,000 82.336.000 20,035,000 42,975,000 19,089.000 82,099,000 Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilties 102,410,000 23,590,000 1,152,000 28,000 100,720.000 23,590,000 562,000 28,000 102,666,000 24,711,000 815,000 28,000 93,301,000 24,395,000 691,000 17,000 89,879,000 23,457,000 502,000 15,000 119,171,000 44,032,000 570,000 27,000 225,310,000 220,470,000 222,820,000 208,685,000 196, 189,000 183,835,000 96,000 96.000 98,000 96,000 94,000 342,000 Stockholders' Equity Misc Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholders' Equity 41,000 20,320,000 (1,610,000) 21,640,000 (7.167,000) 33,320,000 41,000 22,670,000 (1,420,000) 21,800,000 (7,021.000) 36,070,000 41,000 21,218,000 (1,253,000) 21,843,000 (6,959,000) 34,890,000 41,000 15,634,000 (1,122,000) 21,630,000 (7.013,000) 29,170,000 41,000 14,414,000 (977,000) 21,421,000 (6,257,000) 28,642,000 40,000 9,422,000 (848,000) 21,089,000 (5,265,000 24,438,000 Ford Motor Company (F) Income Statement Period Ending (All numbers in thousands) 12/31/2019 12/31/2018 12/31/2017 12/31/2016 12/31/2015 12/31/2014 Revenue Total Revenue (a.k.a. net sales, annual sales, "top line") Cost of Revenue Gross Profit 155,900,000 136,790,000 19,110,000 160,340,000 137,580,000 22,760,000 156,776,000 140,436,000 16,340,000 151,800,000 135,488,000 16,312,000 149,558,000 131,409,000 18.149,000 144,077,000 131,903,000 12,174,000 11,527,000 12,196,000 10,502,000 11,842,000 Operating Expenses Research and Development Selling, General, and Administrative Non Recurring Others Total Operating Expenses 18,561,000 181,000 19,600,000 (24,000) 18,742,000 19,576,000 11,527,000 12,196,000 10,502,000 11,842,000 Operating Income (Loss) 368,000 3,184,000 4,813,000 4,116,000 7,647,000 332,000 Income from Continuing Operations Total Other Income / Expenses Net Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income from Continuing Operations 12,000 368,000 1,020,000 (666,000) (724,000) 37,000 47,000 2,406,000 5,590,000 1,240,000 4,350,000 650,000 18,000 3,682,000 3,267,000 9,281,000 1,133,000 8,148,000 520,000 28,000 8.803,000 1,794,000 7,690,000 894,000 6,796,000 2,189,000 17,000 6,376,000 1,560,000 11,025,000 773,000 10,252,000 2,881,000 15,000 9,191,000 424,000 2,031,000 797,000 1,234,000 4,000 27,000 2,506,000 Non-recurring Events Discontinued Operations Extraordinary Items Effect of Accounting Changes Other Items Net Income (a.k.a. net profit, the "bottom line") 47,000 3,682,000 7,602,000 4,596,000 7,373,000 1,231,000 2019 Ratio 2014 Ratio (2017 Optional) Profitability Ratios: Basic Earnings per Share EPS Return on Equity Return on Sales Liquidity Ratios: 2019 Ratio 2014 Ratio (2017 Optional) Current Ratio Acid Test Ratio 2019 Ratio 2014 Ratio (2017 Optional) Activity Ratios: (a.k.a. Efficiency Ratio) Inventory Turnover 2019 Ratio 2014 Ratio (2017 Optional) Leverage Ratios: (a.k.a. Solvency Ratio) Debt-Equity Ratio Ford Motor Company (F) Balance Sheet Period Ending (All numbers in thousands) 12/31/2019 12/31/2018 12/31/2017 12/31/2016 12/31/2015 12/31/2014 Assets Current Assets Cash and Cash Equivalents Short-term Investments Accounts Receivables Inventory Other Current Assets Total Current Assets 17,500,000 17,150,000 63,140,000 10,790,000 5,470,000 114,050,000 16,720,000 17,230,000 65,810,000 11,220,000 3,670,000 114,650,000 18,492,000 20,435,000 62,809,000 10,277,000 3,889,000 115,902,000 15,905,000 22,922.000 57,368,000 8,898,000 3.368.000 108,461,000 14,272,000 20,904,000 56,179,000 8,319,000 2.913.000 102,587,000 10,757,000 20,393,000 90,584,000 7,870,000 2.235,000 131,839,000 53,700,000 67,110,000 278,000 55,540,000 65,300.000 59,267,000 63,562,000 53,228,000 60,901.000 48,778,000 57,256,000 3,357,000 53,343,000 Long Term Investments Property, Plant, and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets 11,462,000 11,940,000 258,540,000 10,850,000 10,200,000 256,540,000 8,104,000 10,973,000 257,808,000 5,656,000 9,705,000 237,951,000 4,795,000 11,509,000 224,925,000 6,052,000 14,024,000 208,615,000 Liabilities Current Liabilities Accounts Payable Short / Current Long Term Debt Other Current Liabilites Total Current Liabilties 20,670,000 53,310,000 24,150,000 98,130,000 21,520,000 53,490,000 20,560,000 95,570,000 23,282,000 51,621,000 19,697,000 94,600,000 21,296,000 49,669,000 19,316,000 90.281,000 20,272,000 42,975,000 19,089,000 82.336.000 20,035,000 42,975,000 19,089.000 82,099,000 Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilties 102,410,000 23,590,000 1,152,000 28,000 100,720.000 23,590,000 562,000 28,000 102,666,000 24,711,000 815,000 28,000 93,301,000 24,395,000 691,000 17,000 89,879,000 23,457,000 502,000 15,000 119,171,000 44,032,000 570,000 27,000 225,310,000 220,470,000 222,820,000 208,685,000 196, 189,000 183,835,000 96,000 96.000 98,000 96,000 94,000 342,000 Stockholders' Equity Misc Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholders' Equity 41,000 20,320,000 (1,610,000) 21,640,000 (7.167,000) 33,320,000 41,000 22,670,000 (1,420,000) 21,800,000 (7,021.000) 36,070,000 41,000 21,218,000 (1,253,000) 21,843,000 (6,959,000) 34,890,000 41,000 15,634,000 (1,122,000) 21,630,000 (7.013,000) 29,170,000 41,000 14,414,000 (977,000) 21,421,000 (6,257,000) 28,642,000 40,000 9,422,000 (848,000) 21,089,000 (5,265,000 24,438,000 Ford Motor Company (F) Income Statement Period Ending (All numbers in thousands) 12/31/2019 12/31/2018 12/31/2017 12/31/2016 12/31/2015 12/31/2014 Revenue Total Revenue (a.k.a. net sales, annual sales, "top line") Cost of Revenue Gross Profit 155,900,000 136,790,000 19,110,000 160,340,000 137,580,000 22,760,000 156,776,000 140,436,000 16,340,000 151,800,000 135,488,000 16,312,000 149,558,000 131,409,000 18.149,000 144,077,000 131,903,000 12,174,000 11,527,000 12,196,000 10,502,000 11,842,000 Operating Expenses Research and Development Selling, General, and Administrative Non Recurring Others Total Operating Expenses 18,561,000 181,000 19,600,000 (24,000) 18,742,000 19,576,000 11,527,000 12,196,000 10,502,000 11,842,000 Operating Income (Loss) 368,000 3,184,000 4,813,000 4,116,000 7,647,000 332,000 Income from Continuing Operations Total Other Income / Expenses Net Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income from Continuing Operations 12,000 368,000 1,020,000 (666,000) (724,000) 37,000 47,000 2,406,000 5,590,000 1,240,000 4,350,000 650,000 18,000 3,682,000 3,267,000 9,281,000 1,133,000 8,148,000 520,000 28,000 8.803,000 1,794,000 7,690,000 894,000 6,796,000 2,189,000 17,000 6,376,000 1,560,000 11,025,000 773,000 10,252,000 2,881,000 15,000 9,191,000 424,000 2,031,000 797,000 1,234,000 4,000 27,000 2,506,000 Non-recurring Events Discontinued Operations Extraordinary Items Effect of Accounting Changes Other Items Net Income (a.k.a. net profit, the "bottom line") 47,000 3,682,000 7,602,000 4,596,000 7,373,000 1,231,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started