Question
1.) Calculate the following ratios for your company using the financial statements for the current year and prior year: - Current Ratio - Amount of
1.) Calculate the following ratios for your company using the financial statements for the current year and prior year:
- Current Ratio
- Amount of Working Capital (Current Assets Current Liabilities)
- Net Profit Margin
- Debt-to-Assets Ratio
Show all work and include a statement for each calculation. (Example: Current Ratio is 2:1. This indicates the company has enough current assets to cover its current liabilities)
2.) For each of the ratios calculated in Part 2, calculate the percentage change from prior year. Have they improved or declined?
3.) Calculate the following ratios for your company using the financial statements for the current year only:
- Fixed Asset Turnover
- Return on Equity
SHOW ALL WORK and include a statement for each calculation
4.) Are net cash flows from operating activities considered healthy or unhealthy in the current year? Why?
MAGNA INTERNATIONAL INC. CONSOLIDATED STATEMENTS OF INCOME [U.S. dollars in millions, except per share figures] Years ended December 31, , Note 2019 2018 Sales $ 39,431 $ 40,827 Costs and expenses Cost of goods sold Depreciation and amortization Selling, general and administrative Interest expense, net Equity income Other expense, net 34,022 1,345 1,697 82 (178) 240 35,055 1,278 1,664 93 (277) 63 17 4 2,223 2,951 12 591 619 Income from operations before income taxes Income taxes Net income Loss (income) attributable to non-controlling interests Net income attributable to Magna International Inc. 1,632 133 2,332 (36) 4 $ 1,765 $ 2,296 5 Earnings per Common Share: Basic Diluted $ 5.61 $ 5.59 $ $ 6.65 6.61 5 Weighted average number of Common Shares outstanding during the year [in millions): Basic Diluted 345.4 314.7 315.8 347.5 MAGNA INTERNATIONAL INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME [U.S. dollars in millions) Years ended December 31, Note 2019 2018 $ 1,632 $ 2,332 22 (25) 102 4 Net income Other comprehensive income (loss), net of tax: Net unrealized loss on translation of net investment in foreign operations Net unrealized gain (loss) on cash flow hedges Reclassification of net loss (gain) on cash flow hedges to net income Reclassification of net loss on pensions to net income Pension and post-retirement benefits Other comprehensive income (loss) Comprehensive income Comprehensive loss (income) attributable to non-controlling interests Comprehensive income attributable to Magna International Inc. 8 (47) (515) (106) (1) 6 (13) (629) 1,703 (11) $ 1,692 42 1,674 140 $ 1,814 Note 2019 2018 [U.S. dollars in millions, except shares issued] As at December 31, ASSETS Current assets Cash and cash equivalents Accounts receivable Inventories Prepaid expenses and other Income taxes receivable Assets held for sale 6 $ $ 1,276 5,927 3,304 238 8 6, 17 684 6,548 3,403 193 57 949 3 11,834 2,189 8,095 Investments Fixed assets, net Operating lease right-of-use assets Intangible assets, net Goodwill Deferred tax assets Other assets 9 10 18 13 7, 11 12 14, 19 10,745 1,210 8,260 1,811 484 1,976 308 996 $ 25,790 560 1,979 300 988 $ 25,945 17 $ LIABILITIES AND SHAREHOLDERS' EQUITY Current liabilities Short-term borrowings Accounts payable Accrued salaries and wages Other accrued liabilities Income taxes payable Long-term debt due within one year Current portion of operating lease liabilities Liabilities held for sale $ 1,098 6,094 769 1,734 15 16 5,628 753 1,800 17 106 225 201 17 18 3 408 10,304 3,084 Long-term debt Operating lease liabilities Long-term employee benefit liabilities Other long-term liabilities Deferred tax liabilities 17 18 19 20 12 8,529 3,062 1,601 677 371 419 597 400 401 14,659 14,786 21 Shareholders' equity Common Shares (Issued: 2019-303,250,415, 2018 - 327,339,095) Contributed surplus Retained earnings Accumulated other comprehensive loss 22 3,198 127 8,596 (1,090) 10,831 300 3,380 120 8,376 (1,175) 10,701 458 Non-controlling interests [U.S. dollars in millions] Years ended December 31, Note 2019 2018 OPERATING ACTIVITIES Net income Items not involving current cash flows $ 2,332 1,539 6 $ 1,632 1,976 3,608 352 3,960 6 Changes in operating assets and liabilities Cash provided from operating activities 3,871 (153) 3,718 INVESTMENT ACTIVITIES Fixed asset additions Proceeds from sale of investment in) Lyft, Inc. Increase in investments, other assets and intangible assets Proceeds from dispositions Acquisitions Proceeds on sale of business Cash used for investing activities (1,441) 231 (394) 185 (147) 1,132 (1,650) (220) (481) 223 (148) 7 3 (434) (2,276) 17 17 172 866 (171) 50 (16) (1,831) 21 FINANCING ACTIVITIES Issues of debt (Decrease) increase in short-term borrowings Repayments of debt Issue of Common Share on exercise of stock options Shares repurchased for tax withholdings on vesting of equity awards Repurchase of Common Shares Contributions to subsidiaries by non-controlling interests Dividends paid to non-controlling interests Dividends paid Cash used for financing activities Effect of exchange rate changes on cash, cash equivalents and restricted cash equivalents Net increase (decrease) in cash, cash equivalents and restricted cash equivalents during the year Cash, cash equivalents and restricted cash equivalents beginning of year Cash, cash equivalents and restricted cash equivalents, end of year 47 (1,124) (149) 44 (9) (1,289) 4 (22) (449) (2,947) (69) (448) (1,443) (36) (37) 839 11 590 802 6 $ 1,392 $ $ 802Step 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