Old MathJax webview

Old MathJax webview

Question: My Two Companies: Honda Motor Company And Ford Motor Company 2. (Financial Rati... My Two Companies: Honda Motor Company and Ford Motor Company 2. (Financial Ratio Analysis) Using 2017 & 2018 Balance sheet & Income statement for each company, compute the following financial ratios for each company: 1) Current ratio CR = CA/CL 2) Quick ratio = (CA Inventory) / CL 3) Debt-to-equity ratio = TD / TE 4) Times interest earned ratio (Interest coverage ratio) = EBIT / Interest 5) Inventory Turnover = COGS / Inventory 6) Receivable turnover - Sales / Accts. Rec. = = FORD CO Balance Sheet Fiscal year is Jan - Dee 2018 2012 2018 2017 18.491 16.728 17.23B 11.21 20.418 160,338 2.27% 145,732 156,776 3.28% 132,892 10.6B 11.228 10.280 145,732 124,439 8,453 44B 9,122 -6.89 53.2903 3.93B 113.5911 6.788 S2 211 3.89B 115.98 9.66% 14,606 3.24% 23,884 3.51% 65.198 38.85% 9.11% 11,403 29.860 Cash Marketable Securities Receivables Inventory Raw Materials Work In Progress Finished Goods Notes Receivable Other Current Assets Total Current Assets Property Plant & Fiquipment Accumulated Depreciation Net Property Phant & Equipment Investment & Advances Other Non-Current Assets - Deferred Charges Intangibles Deposits & Other Assets Total Assets Notes Payable Accounts Payable Current Portion Long-Term Debt Current Portion Capital Leases Accrued Expenses Income Taxes Payable Other Current Liabilities 36.188 31.83 35.338 31.325 56.181 19,527 8,000 11,527 0.16% 11,403 56.618 -41 60% 10.418 10.97B - 3,203 4,357 8.13 204 7.93B 256.548 257.81B 2,247 3,685 Income Statement Fiscal year is January-December. All values USD Milions Sales/Revenue Sales Growth Cost of Goods Sold (COGS) incl. D&A COGS excluding DBA Depreciation & Amortization Expense Depreciation Amortization of Intangibles COGS Growth Gross Income Gross Income Growth Gross Profit Margin SGBA Expense Research & Development Other SGSA SGA Growth Other Operating Expense EBIT Unusual Expense Non Operating Income/Expense Non-Operating Interest income Equity in Affiliates (Prolax) Interest Expense Interest Expense Growth Gross Interest Expense Interest Capitalized Pretax Income Prelax Income Growth Pretax Margin Income Tax Income Tax - Current Domestic Income Tax . Current Foreign Income Tax-Deferred Domestic Income Tax-Deferred Foreign Consolidated Net Income Minority Interest Expense Net Income Net Income Growth Net Morgin Net Income After Extraordinaries Net Income Available to common 459 23.28B 1,201 21.52B 53.491 123 1,228 51.628 1,350 -9.04% 7.06% 1,228 1,385 35 8,148 19.89% 19.7B 20.56B 95.578 4,345 -46.67% Total Current Liabilities 94.6B 2.71% 597M 815M 650 520 -40 100.728 102,678 868 -901 24,718 593 Mortgages Deferred Taxes/Income / Convertible Debt Long-Term Debt Non-Current Capital Leases Other Long-Term Liabilities Total Liabilities Minority Interest Preferred Stock Common Stock Net Capital Surplus Retained Earnings Treasury Stock 23.59B 220.578 100M 222.89B 98M 3,695 18 3,677 7,628 26 . 7,602 65.40% 41M 41M -51.63% 22.011 21.84 2.29% 3,677 21.228 7,602 22,678 1,428 1.258 3,677 7,602 0.92 1.9 Other Liabilities -7.33B Shareholders Equity 35.978 Total Liabilities & Shareholders Equity 256.548 -6.938 34.926 -51.58% 65.22% 257.81B 3,973 1.9 0.00% EPS (Basic) EPS (Basic) Growth Basle Shares Outstanding EPS (Dikuted) EPS (Dited) Growth Diluted Shares Outstanding EBITDA EBITDA Growth EBITDA Margin EBIT 65.45% 3,998 12,810 4.18% 11,511 -10.14% 7.18% - 3,203 4,357 Question: My Two Companies: Honda Motor Company And Ford Motor Company 2. (Financial Rati... My Two Companies: Honda Motor Company and Ford Motor Company 2. (Financial Ratio Analysis) Using 2017 & 2018 Balance sheet & Income statement for each company, compute the following financial ratios for each company: 1) Current ratio CR = CA/CL 2) Quick ratio = (CA Inventory) / CL 3) Debt-to-equity ratio = TD / TE 4) Times interest earned ratio (Interest coverage ratio) = EBIT / Interest 5) Inventory Turnover = COGS / Inventory 6) Receivable turnover - Sales / Accts. Rec. = = FORD CO Balance Sheet Fiscal year is Jan - Dee 2018 2012 2018 2017 18.491 16.728 17.23B 11.21 20.418 160,338 2.27% 145,732 156,776 3.28% 132,892 10.6B 11.228 10.280 145,732 124,439 8,453 44B 9,122 -6.89 53.2903 3.93B 113.5911 6.788 S2 211 3.89B 115.98 9.66% 14,606 3.24% 23,884 3.51% 65.198 38.85% 9.11% 11,403 29.860 Cash Marketable Securities Receivables Inventory Raw Materials Work In Progress Finished Goods Notes Receivable Other Current Assets Total Current Assets Property Plant & Fiquipment Accumulated Depreciation Net Property Phant & Equipment Investment & Advances Other Non-Current Assets - Deferred Charges Intangibles Deposits & Other Assets Total Assets Notes Payable Accounts Payable Current Portion Long-Term Debt Current Portion Capital Leases Accrued Expenses Income Taxes Payable Other Current Liabilities 36.188 31.83 35.338 31.325 56.181 19,527 8,000 11,527 0.16% 11,403 56.618 -41 60% 10.418 10.97B - 3,203 4,357 8.13 204 7.93B 256.548 257.81B 2,247 3,685 Income Statement Fiscal year is January-December. All values USD Milions Sales/Revenue Sales Growth Cost of Goods Sold (COGS) incl. D&A COGS excluding DBA Depreciation & Amortization Expense Depreciation Amortization of Intangibles COGS Growth Gross Income Gross Income Growth Gross Profit Margin SGBA Expense Research & Development Other SGSA SGA Growth Other Operating Expense EBIT Unusual Expense Non Operating Income/Expense Non-Operating Interest income Equity in Affiliates (Prolax) Interest Expense Interest Expense Growth Gross Interest Expense Interest Capitalized Pretax Income Prelax Income Growth Pretax Margin Income Tax Income Tax - Current Domestic Income Tax . Current Foreign Income Tax-Deferred Domestic Income Tax-Deferred Foreign Consolidated Net Income Minority Interest Expense Net Income Net Income Growth Net Morgin Net Income After Extraordinaries Net Income Available to common 459 23.28B 1,201 21.52B 53.491 123 1,228 51.628 1,350 -9.04% 7.06% 1,228 1,385 35 8,148 19.89% 19.7B 20.56B 95.578 4,345 -46.67% Total Current Liabilities 94.6B 2.71% 597M 815M 650 520 -40 100.728 102,678 868 -901 24,718 593 Mortgages Deferred Taxes/Income / Convertible Debt Long-Term Debt Non-Current Capital Leases Other Long-Term Liabilities Total Liabilities Minority Interest Preferred Stock Common Stock Net Capital Surplus Retained Earnings Treasury Stock 23.59B 220.578 100M 222.89B 98M 3,695 18 3,677 7,628 26 . 7,602 65.40% 41M 41M -51.63% 22.011 21.84 2.29% 3,677 21.228 7,602 22,678 1,428 1.258 3,677 7,602 0.92 1.9 Other Liabilities -7.33B Shareholders Equity 35.978 Total Liabilities & Shareholders Equity 256.548 -6.938 34.926 -51.58% 65.22% 257.81B 3,973 1.9 0.00% EPS (Basic) EPS (Basic) Growth Basle Shares Outstanding EPS (Dikuted) EPS (Dited) Growth Diluted Shares Outstanding EBITDA EBITDA Growth EBITDA Margin EBIT 65.45% 3,998 12,810 4.18% 11,511 -10.14% 7.18% - 3,203 4,357