60.1K

Verified Solution

Link Copied!

skip the EPS (Earnings per share) calculations as I does not include the stock information needed to make the calculation. This will also affect the Price/Earnings ratio so please skip it as well. On any formulas requiring preferred dividends assume the preferred dividends amount is zero. please zoom in on photos as needed chegg makes the photos a little blurry. Page 1 had the questions that need answering the rest is the info needed to solve. thank you

ACCOUNTING 220 FALL 2019 Ratio Analysis Assignment. Due on or before December 2, 2019, 8:00 a.m. Using the annual financial statement provided with this assignment prepare the answers to the ratios below. Your answers must be submitted to the assignment folder on D2L by the deadline. Profitability Ratios (1) Net Profit Margin-Net Income_X 100 Revenues (2) Gross Profit Percentage - Net Sales - Cost of Goods Sold X 100 Net sales Revenue (3) Fixed Asset Turnover - Net Revenue Average Net Fixed Assets (4) Return on Equity (ROE) - Net Income - Preferred Dividends__x 100 Average Common Stockholders' Equity (5) Earnings per Share (EPS) - Net Income - Preferred Dividends Average Number of Common Shares Outstanding (6) Price/Earnings Ratio - Stock Price* EPS Liquidity Ratios (7) Receivables Turnover Net Sales Revenue Average Net Receivables Days to Collect 365 Receivables Turnover Ratio (8) Inventory Turnover - Cost of Goods Sold Average Inventory Days to Sell = = 365 Inventory Turnover Ratio (9) Current Ratio = _Current Assets Current Liabilities Solvency Ratios (10) Debt-to-Assets - Total Liabilities Total Assets (11) Times Interest Earned = Net Income + Interest Expense Income Tax Expense Interest Expense CONSOLIDATED INCOME STATEMENTS (In millions, except per share amounts) Year Ended December 31, 2017 2018 2016 $ $ 133,0455 133,449 14004 12.119 1470491455 140,205 8,979 1 49.184 120,656 12.29 9.650 142604 116,229 11.12 9570 136.927 8,561 Net sales and revenue Automotive GM Financial Total net sales and revenue (Note 3)..... Costs and expenses Automotive and other cost of sales GM Financial interest, operating and other expenses.. Automotive and other selling, general and administrative expense Total costs and expenses Operating income...... Automotive interest expense Interest income and other non-operating income, net (Note 19) Equity income (Note 8). Income before income taxes. Income tax expense (Note 17). Income from continuing operations.. Loss from discontinued operations, net of tax (Note 22)... Net income (loss). Net loss attributable to noncontrolling interests.... Net income (loss) attributable to stockholders. 121.784 169 10.345 140.498 8.686 563 1,603 2.282 575 Net income (loss) attributable to common stockholders.... 7.916 S 3,880) S 9.427 Earnings per share (Note 21) Basic camings per common share - continuing operations .... Basic loss per common share-discontinued operations Basic camings (loss) per common share.. Weighted average common shares outstanding-basic .. Diluted earnings per common share - continuing operations Diluted loss per common share-discontinued operations Diluted earnings (los) per common share .. Weighted average common shares outstanding-diluted... CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (In millions) Years Faded December 31, 2018 2017 2016 8.005s (3.882) $ 9.268 715 (384) (969) Net income (loss)......... Other comprehensive income (loss), net of tax (Note 20) Foreign currency translation adjustments and other.... Defined benefit plans.. Other comprehensive income (loss), nct of tax... Comprehensive income (loss)... Comprehensive loss attributable to noncontrolling interests Comprehensive income (loss) attributable to stockholders. 2.545 8.133 Reference should be made to the notes to consolidated financial statements. 47 December 31, 2017 $ GENERAL MOTORS COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In millions, except per share amounts) December 31, 2018 ASSETS Current Assets Cash and cash equivalents..... 20,844 Marketable securities (Note 4)...... 5,966 Accounts and notes receivable (net of allowance of $211 and $278). 6,549 GM Financial receivables, nct (Note 5: Note 11 at VIE)... 26,850 Inventories (Note 6)...... 9.816 Equipment on operating leases, net (Note 7)..... 247 Other current assets (Note 4; Note 11 at VIEs). 5,021 Total current assets... 75,293 Non-current Assets GM Financial receivables, net (Note 5: Note 11 at VIEs). 25,083 Equity in net assets of nonconsolidated affiliates (Note 8)... 9,215 Property, net (Note 9)... 38,758 Goodwill and intangible assets, net (Note 10)..... 5,579 Equipment on operating leases, net (Note 7: Note 11 at VIES). 43.559 Deferred income taxes (Note 17) ..... 24,082 Other assets (Note 4: Note 11 at VIES). 5270 Total non-current assets........ 152.046 Total Assets 227,339 15,512 8313 8,164 20,521 10.663 1,106 4,465 68,744 21.208 9,073 36,253 5,849 42.82 23,544 4.929 143,738 212.482 $ 22,297 $ 23,929 935 30,956 23.049 82,237 2,515 24,450 25.996 76,190 LIABILITIES AND EQUITY Current Liabilities Accounts payable (principally trade).............. Short-term debt and current portion of long-term debt (Note 13) Automotive ..... GM Financial (Note 11 at VIE).... Accrued liabilities (Note 12). Total current liabilities... Non-current Liabilities Long-term debt (Note 13) Automotive ... GM Financial (Note 11 at VIES)....... Postretirement benefits other than pensions (Note 15).. Pensions (Note 15) ...... Other liabilities (Note 12)..... Total non-current liabilities.. Total Liabilities. ... Commitments and contingencies (Note 16) Equity (Note 20) Common stock, S0.01 par value.... Additional paid-in capital...... Retained earnings Accumulated other comprehensive loss. Total stockholders' equity ..... Noncontrolling interests.... Total Equity... Total Liabilities and Equity.... 13,028 60,032 5,370 11,538 12.357 102,325 184,562 10,987 56,267 5,998 13,746 12.394 99,392 176,282 14 25,563 22,322 (9,039) 38,860 3.917 42.777 227.339 S 25,371 17,627 (8,011) 35.001 1.199 36,200 212.482 60S 52 GENERAL MOTORS COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) Years Ended December 31, 2018 2017 2016 Cash flows from operating activities Income from continuing operations 0755 330 S 9.29 Depreciation and impairment of Equipment on operating lases, net 7,604 4804 Depreciation, amortization and impairment charges on Property, net 6,065 5,456 5,015 Foreign currency remeasurement and transaction losses Undistributed carings of nonconsolidated affiliates, net ... (141) 132 (15) Pension contributions and OPER payments.... 2.0 03.454) Pension and OPEB income, net (120) 1934) Provision benefit) for deferred taxes................... (112) 10. Change in other operating assets and liabilities (Note 26)...... (1176) (3015) 500 Other operating activities 167 (468) Net cash provided by operating activities - continuing operations 172338 16.993 Net cash used in operating activities - discontinued operations LO 5) Net cash provided by operating activities............. 17,328 16.007 Cash flows from investing activities Expenditures for property 8.761) (8.453) (8354) Available for sale marketable securities acquisitions...... (2.820) (5.503) (15.12) Trading marketable securities acquisitions...... (262) Available for sale marketae securities, liquidations 5.10 9.007 IONI Trading marketable securities, liquidations 872 Acquisition of companies investments, net of cash acquired (104) Purchases of finance receivables, net. 25.671) (19.325) (14.378) Principal collections and recoveries on finance receivables 17,048 12.578 Purchases of leased vehicles, net (1671) (191) (19.495) Proceeds from termination of leased vehicles... 10.864 6,667 2.554 Other investing activities 122 Net cach used in investing activities continuing operations.. (20.929) (24.072) 34.147 Net cash provided by used in investing activities - discontinued operations Note 3.500) Netcash used in investing activities 20,763) (27.5721 (35,643) Cash flows from financing activities Net increase (decrease in short-term debt......... 1.186 (140) (282) Proceeds from issuance of debt (original maturities greater than three months).. 43.801 52.187 42,036 Payments on debt (original maturities greater than three months)...... 31120 (33,592) (20,727) Payments to purchase common stock (190) (4.492) 2.500) Proceeds from issuance of subsidiary preferred and common stock (Note 20). 95 Dividends paid... (2.233) Other financing activities (305) (163) Net cash provided by financing activities continuing operations .... 12.410 15.996 Net cash provided by financing activities - discontinued operations ... 174 1,081 Net cash provided by financing activities 11.454 122514 17077 Effect of exchange rate changes on cash, cash equivalents and restricted cash (213) Net increase (decrease) in cash, cash equivalents and restricted cash 2.172) Cash, cash equivalents and restricted cash at beginning of period 17 15. 160 17 132 Cash, cash equivalents and restricted cash at end of period 17,84 1 60 14.457 23,4965 - $ Cash, cash equivalents and restricted cash - continuing operations at end of period (Note 4).... Cash, cash equivalents and restricted cash-discontinued operations at end of period Significant Non-cash Investing and Financing Activity Non-cash property additions - continuing operations ............. Non-cash property additions - discontinued operations.............. Non-cash business acquisition - continuing operations.. Non-cash proceeds on sale of discontinued operations (Note 22) 308135 3.9965 86 GENERAL MOTORS COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EQUITY (In millions) Commen Stockholders Accumulated Other Comprehensive Common Nencontrolling Additional Paid in Capital $ 27,607 Retained Earnings $20,285 5 $ (8,036) 452 (159) (59) Total Equity $ 40,323 9,268 (1.353) 290 (2,500) 290 (1,320) (1.180) 317 (271 (2,337) 290 (2,337) 16 15 26,0 26,168 (3.864) 44,075 (3.882) 1.317 (4,492) (1) (2,063) (2,428) 43 Balance at January 1, 2016. Net income.... Other comprehensive loss... Issuance of common stock .......... Purchase of common stock...... Exercise of common stock warrants... Stock based compensation Cash dividends paid on common stock..... Dividends to noncontrolling interests.... Other Balance at December 31, 2016........... Net loss. ********** Other comprehensive income... Purchase of common stock.......... Exercise of common stock warrants...... ... Issuance of subsidiary preferred stock (Note 20)... Stock based compensation ... . Cash dividends paid on common stock Dividends to noncontrolling interests Other Balance at December 31, 2017 Adoption of accounting standards (Note 2).... Net income Other comprehensive loss.... . ... Purchase of common stock Issuance of subsidiary preferred and common stock (Note 20) Stock based compensation ..... Cash dividends paid on common stock. .... Dividends to noncontrolling interests...... Other.... Balance at December 31, 2018 985 (2.215) 17,627 (1,046) (2.215) (18) (47) 36,200 (1.144) 1,005 (936) (190) 2.862 287 (2,144) (169) (99) (2,144) Imam

Answer & Explanation Solved by verified expert

See Answer