Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I'm required to calculate the financial ratios of these two companies using these two financial statements. this is the only information i am given. FORD

image text in transcribed

image text in transcribed

image text in transcribed

I'm required to calculate the financial ratios of these two companies using these two financial statements. this is the only information i am given.

FORD CO Balance Sheet Fiscal year is Jan - Dec 2018 2012 2018 2017 16.720 18 498 156,776 20.448 17.23B 11.21 160,338 2.27% 145.732 145,732 10.6B 3.28% 132,892 124,439 11.228 10.283 . 4.43 . 8,453 9,122 -669 3.24% 6.788 52 21B 53.291 9.66% 3.930 23,884 113.5911 3.51% 3.890 115.98 65.198 29 861 14,606 38.85% 9.11% 11,403 - 19,527 36.188 8,000 35.338 31.325 31.83B 11.403 -41 60% 11,527 0.10% 56.188 56.61B 10.418 10.07B 3,203 4,357 7.93B 8.1B 204 3,685 256.54 257.81B 2,247 Income Statement Fiscal year is January-December. All values USD Millions Sales/Revenue Sales Growth Cost of Goods Sold (COGS) incl. DBA COGS excluding DBA Depreciation & Amortization Expenso Depreciation Amortization of Intangibles COGS Growth Gross Income Gross Income Growth Gross Profit Margin SGBA Expense Research & Development Other SG&A SGA Growth Other Operating Expense EBIT Unusual Expense Non Operating Income Expense Non-Operating Interest Income Equity in Affiliates (Prelax) Interest Expense Interest Expense Growth Gross Interest Expense Interest Capitalized Prelax 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 Cash Marketable Securities Receivables Inventory Raw Materials Work In Progress Finished Goods Notes Receivable Other Current Assels Total Current Assets Property Plant & liquipment Accumulated Depreciation Net Property Plant & Equipment Investment & Advances Other Not-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 Total Current Liabilities Mortgages Deferred Taxes/Income Convertible Debt Long-Term Debt Non-Current Capital Leases Other Long-Term Liabilities Total Liabilities Minority Interest Preferred Stock Comnton Stock Net Capital Surplus Retained Earnings Treasury Stock 459 21.328 23.28B 123 1,228 1,201 1.350 53.491 51.62B -9.04% 7.06% 1,228 1,385 35 20.56B 19.7B 4,345 -46.67% 8,148 19.89% 95.578 94.6B . 2.71% 597M 815M 650 520 -40 100.728 102.678 868 - -901 23.59 593 24.718 222.89B 3,695 7,628 220.57B 100M 98M 18 26 . - 7,602 3,677 -51.63% 41M 41M 65.40% 22.018 21.840 2.29% 3,677 21.22B 7,602 22.678 1.42B 1.258 3,677 7,602 -6936 0.92 1.9 Other Liabilities -7.338 Shureholders Equity 35.978 Total Liabilities & Sharchalders Equity 256.548 34.92 -51.58% 65.22% 257.81B 3.075 0.00% EPS (Basic) EPS (Basic) Growth Basic Shares Outstanding EPS (Diluted) EPS (Diluted) Growth ) Diluted Shares Outstanding EBITDA EBITDA Growth EBITDA Margin EBIT 1.9 65.45% 3.998 12,810 4.18% 11,511 -10.14% 7.18% - 3.203 4,357 Balance Sheet HONDA CO Income Statement Fiscal year is April-March. All values 2018 JPY Millions Sales Revenue 15,361,146 Fiscal year is Apr - Mar 2018 2017 2017 20.31B 19.59B 13,999,200 Cash Marketable Securities Receivables - Sales Growth 9.73% -4.12% 23.77B 24.58B Inventory 13.711 12.691 4.7B Cost of Goods Sold (COGS) incl. ( 12,154,503 11,018,396 DRA COGS excluding DSA 10,700,387 9,681,986 Depreciation & Amortization Expense 1.454 116 1,335,410 Depreciation 1,258,172 Amortization of Intangibles 195,944 62731M 717.5M 8.398 7.545 4.540 4.115 60.976 COGS Growth 10.31% -3.85% 62.333 122278 Gross Income 3.206.643 125 326 37.38B 2,980,004 57.91B Gross Income Growth 7.58% -5.10% 64.36R 67.948 Raw Materials Work In Progress Finished Goods Notes Receivable Other Current Assets Total Current Assets Property Plant & Equipment Accumulated Depreciation Net Property Plant & Equipment Investment & Advances Other Non-Current Assets Deferred Charges Intangibles Deposits & Other Assets Totul Assets Notes Payable Accounts Payable Current Portion Long-Term Debt Current Portion Capital leases Accrued Expenses Income Taxes Payable Other Current Liabilities Total Current Liabilities 6.12B 28.0GB 1.16 3.558 28.56B 1.133 Gross Profit Margin SG&A Exponse Research & Development Other SG&A 20.88% 2,373,085 897,934 1,775,151 2,140,093 638,881 1,601,212 7.248 6,678 5453 174.148 4.938 176.31B SGA Growth 10.89% -18.00% EBIT 833,658 840,711 11.022 26.261 11.013 25.9213 Unusual Expense -67,132 51,416 Non Operating Income/Expense -61,581 32,980 3.643 482.35M 9.220 3.8KB 423 21M 32,389 9.268 50.00 Non-Operating Interest Income Equity in Affiliates (Pretax) Interest Expense 41,191 247,843 12,970 50.62B 12,471 Mortgages Interest Expense Growth 4.00% -31.27% 5.673 8.378 Deferred Taxes Income Convertible Debt 12,970 1,114,973 12,471 842,193 Long-Term Dett Gross Interest Expense Pretax Income Pretax Income Growth 34.943 37.413 32.39% 32.53% 8.823 9.615 105913 100.048 Pretax Margin 7.26% - Non-Current Capital Leases Other Long-Term Liabilities Total Liabilities Minority Interest Preferred Stock Common Stock Net Capital Surplus Retained Earnings Income Tax -13,686 327,502 774.6M 300 42M Income Tax - Current Domestic - -2.956 196,149 1543 1.593 685B 62.43B Income Tax - Current Foreign 280,316 243.5SM Income Tax Deferred Domestic - 25,149 131.443 5.821 Treasury Stock 1.02B Other Llabilities 431B Sharcholders Equity Total Liabilities & Shareholders Equity 194.14B 74,118 70.48 17631B Income Tax . Deferred Foreign -316,175 1,128,639 69,302 1,059,337 104.703 679,394 62,825 616,569 Equity in Affiliates Consolidated Not Incomo Minority Interest Expense Net Income Net Income Growth Net Margin Net Income After Extraordinaries Net Income Available to Common EPS (Basic) 71.81% 78.06% 6.90% 1,059,337 1,059,337 590.79 616,569 616,569 342.1 EPS (Basic) Growth 72.70% 78.98% 1.793 1.802 Basic Shares Outstanding EPS (luted) 590.79 3421 Assignment Questions i. Using financial statement ratio analysis to determine the following for each of the two companies you selected for the latest of the two years you have to financial statements for you can use multiple ratios for each element): ii. Profitability Efficiency Liquidity Investment Financial gearing Analyse and discuss the differences observed between the two companies, based on your results from (1), ii. Perform a direct analysis by looking at aspects like turnover, gross profit, net profit etc., between the selected companies. iv. Evaluate the two companies and discuss the differences between the results obtained in (ii) and (iii). Identify and explain difficulties when analysing two different companies in terms of the two methods used for your analysis ii and ii above). vi. Analyse the companies' financial reports and describe any positive, uplifting stories about activities and accomplishments done in the past year in their financial reporting. vii. Which of these two companies would you rather work for? Explain your V

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management And Cost Accounting

Authors: Charles T. Horngren, George Foster, Srikant M. Datar

3rd Edition

0273687514, 978-0273687511

More Books

Students also viewed these Accounting questions

Question

Contrast Adlers and Freuds approaches to motivation.

Answered: 1 week ago

Question

What is the cause of this situation?

Answered: 1 week ago

Question

What is the significance or importance of the situation?

Answered: 1 week ago