Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For the financial statement ratio analyses please skip the EPS (Earnings per share) calculations as I does not include the stock information needed to make

For the financial statement ratio analyses please 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. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Using the annual financial statement provided with this assignment prepare the answers to the ratios
image text in transcribed
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 Not Re Average Net Fixed Assets (4) Return on Equity (ROE) - Net Income - Preferred Dividends_ X 100 Average Common Stockholders' Equity (5) Earings per Share (EPS) - Net Income - Preferred Dividends Average Number of Common Shares Outstanding (6) Price Earnings Ratio - Stock Priset EPS Liquidity Ratios (7) Receivables Turnover - Net Sales Revenue Average Net Receivables Days to Collect 365 Receivables Turnover Ratio (8) Inventory Tumover - 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 GENERAL MOTORS COMPANY AND SUBSIDIARIES Item 8. Financial Statements and Supplementary Data CONSOLIDATED INCOME STATEMENTS (In millions, except per share amounts) 140 205 133.0455 135 1211 12065 Net sales and A . GM Facial Total (Nate) Cast and expres Automotive and other cost of sales....... GM Financial interest operating and other expenses. Automotive and other welling a d ministrative expense Total costs and Operating income Automotive interest expense Interest income and other rating Note 19) Equity income (N ) Income before income ne........ Income taxe Note 17). Income from continuing operations Loss from discontinued operations et of tax (Note 22)... Net Income (less) Net loss attributable to no controlling interests Net income (ass) attributable to stockholders..... Net Income (los) attributable to common stockholders 16 S OS 9427 Earnings per share (Note 21) Basic camings per common share continuing operations Basic loss per common share-discontinued operations Basic caming close common da........... We have more anding-basic Diluted camnings per continuing operations Diluted loss pr e dicted operations Diluted coming do w Weighted average common shares outstanding diluted CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME In millions) Verbuch Net income ) Other comprehensive income on, et oftas (Note 20) Foreign currency translation austments and other Defined plans Other comprehensive income o ne of tax.... Comprehensive income (s) Comprehensive loss attributable to moncontrolling interests Comprehensive income foss) attributable to stockholders Reference should be made to the notes to consolidated financial statements GENERAL MOTORS COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In millions, except per share amounts) December 31, 2018 December , 2017 S 20.844 5.966 6549 26.850 9.816 15,512 8,313 8,164 20,521 10,663 1,106 4.465 68,744 247 5.021 75.293 ASSETS Current Assets Cash and cash equivalents Marketable securities (Note 4).......... ... Accounts and notes receivable (not of allowance of $211 and 5278 GM Financial receivables, net (Note 5: Note 11 at VIES). Inventories (Note 6)... Equipment on operating leases, net (Note 7). Other current assets (Note 4: Note Il at VIES) Total current assets. Non-current Assets GM Financial receivables, net (Note 5; Note 11 at VIES). Equity in net assets of nonconsolidated affiliates (Notes) Property, net (Note 9).... Goodwill and intangible assets, act (Note 10. Equipment on operating leases, net (Note 7Note 11 at VIES) Deferred income taxes (Note 17). Other assets (Note 4: Note 11 at VIES) Total non-current assets.. Total Assets.... 25.083 9.215 3.75 5.579 43.559 24,082 21.208 9,073 36,253 5.849 5.770 23.544 4.929 143.738 212.482 152.046 227,339 $ 22,297 $ 23,929 935 30,956 28.049 82237 2,515 24.450 76,890 LIABILITIES AND EQUITY Current Liabilities Accounts payablc (principally trade)....... Short-term debt and current portion of long-term dcbt (Note 13) Automotive GM Financial (Note 11 at VIES)... Accrued liabilities (Note 12).. Total current liabilities Non-current Liabilities Long-term debt (Note 13) Automotive GM Financial (Note Il a VIE)........ 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 camnings.... Accumulated other comprehensive loss.. Total stockholders' equity. Noncontrolling interests.... Total Equity-.. . Total abilities and Equity 13.028 60,032 5.370 11.538 122357 102.325 184,562 10.987 56,267 5.998 13.746 12294 99 392 176.282 14 25 563 22.322 19.039) 38.860 3917 42.777 223.339S 25.371 17,627 (2011) 35,001 36.200 212242 05 168 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.250 Depreciation and impairment of Equipment on operating leases, et 7,604 4804 Depreciation, amortization and impairment charges on Property, met... 6,065 5.456 5,015 Foreign currency remeasurement and transaction losses 52 219 Undistributed camnings of nonconsolidated affiliates, net ... (141) 1:32 Pension contributions and OPER payments..... (20) 1.636) 0.454) Pension and OPEB income, net (12) 1934) Provision benefit for deferred taxes................... (112) 10. 2.225 Change in other operating assets and liabilities (Note 26)..... (1.376) (3015) Other operating activities (465) Net cash provided by operating activities - continuing operations 15.236 172338 16,993 Net cash used in operating activities - discontinued operations (10) 15) Net cash provided by operating activities...... 17,328 16.007 Cash flows from investing activities Expenditures for property.... (761) (8.453) (8.354) Available for sale marketable securities acquisitions....... (5.503) (15.12 Trading marketable securities, acquisitions........ (262) Available for sale marketable 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.37) Principal collections and recoveries on finance receivables 17,048 12.578 Purchases of leased vehicles, net (167) (19.10) (19.495) Proceeds from termination of leased vehicles... 1054 6,667 2.554 Other investing activities 122 Net cash used in investing activities - continuing operations 20.929) 24.072 034147 Net cash provided by used in investing activities - discontinued operations Note 166 Net cash used in investing activities 20,763) 27,572) (35,643) Cash flows from financing activities Net increase (decrease in short-term debt..... 1.185 (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)........ 32120) (33,592) (20,727) Payments to purchase common stock (190) (2.500) Proceeds from issuance of subsidiary preferred and common stock (Note 20). 262 95 Dividends paid... 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 122524 17077 Effect of exchange rate changes on cash, cash equivalents and restricted cash (213) Net increase (decrease) in cash, cash equivalents and restricted cash SISES 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,848 15160 Cash, cash equivalents and restricted cash continuing operations at end of period (Note 4).... 23.4965 17,8485 1447 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 ............ 3.813 5 3 ,996 S Non-cash property additions - discontinued operations............. Non-cash business acquisition continuing operations Non-cash proceeds on sale of discontinued operations Note 22) 868 Common Stockholders Accumulated Common Nontrolling Additional Paid in Capital $ 27,607 Retained Earnings $20,285 9,427 Comprehensive Loss $ (8.036) 15 Total Equity S 40.323 452 (159) (59) (1.353) 290 290 (1,320) - (1.180) (2,500) 317 (27) 290 (2,337) (2.337) 36 1526,983 26,168 (3.864) 44,075 (3.882) 1.317 (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 interest 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........... (34) (2,215) 985 434 (2,215) (18) (47) 36,200 (60) 17.627 (1,046) 8,014 8.005 (936) (190) 2.862 287 (2,144) (169) 2.144) 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 Re Average Net Fixed Assets (4) Return on Equity (ROE) - Net Income - Preferred Dividends_ X 100 Average Common Stockholders' Equity (5) Earings 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 Tumover - 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 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 Not Re Average Net Fixed Assets (4) Return on Equity (ROE) - Net Income - Preferred Dividends_ X 100 Average Common Stockholders' Equity (5) Earings per Share (EPS) - Net Income - Preferred Dividends Average Number of Common Shares Outstanding (6) Price Earnings Ratio - Stock Priset EPS Liquidity Ratios (7) Receivables Turnover - Net Sales Revenue Average Net Receivables Days to Collect 365 Receivables Turnover Ratio (8) Inventory Tumover - 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 GENERAL MOTORS COMPANY AND SUBSIDIARIES Item 8. Financial Statements and Supplementary Data CONSOLIDATED INCOME STATEMENTS (In millions, except per share amounts) 140 205 133.0455 135 1211 12065 Net sales and A . GM Facial Total (Nate) Cast and expres Automotive and other cost of sales....... GM Financial interest operating and other expenses. Automotive and other welling a d ministrative expense Total costs and Operating income Automotive interest expense Interest income and other rating Note 19) Equity income (N ) Income before income ne........ Income taxe Note 17). Income from continuing operations Loss from discontinued operations et of tax (Note 22)... Net Income (less) Net loss attributable to no controlling interests Net income (ass) attributable to stockholders..... Net Income (los) attributable to common stockholders 16 S OS 9427 Earnings per share (Note 21) Basic camings per common share continuing operations Basic loss per common share-discontinued operations Basic caming close common da........... We have more anding-basic Diluted camnings per continuing operations Diluted loss pr e dicted operations Diluted coming do w Weighted average common shares outstanding diluted CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME In millions) Verbuch Net income ) Other comprehensive income on, et oftas (Note 20) Foreign currency translation austments and other Defined plans Other comprehensive income o ne of tax.... Comprehensive income (s) Comprehensive loss attributable to moncontrolling interests Comprehensive income foss) attributable to stockholders Reference should be made to the notes to consolidated financial statements GENERAL MOTORS COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In millions, except per share amounts) December 31, 2018 December , 2017 S 20.844 5.966 6549 26.850 9.816 15,512 8,313 8,164 20,521 10,663 1,106 4.465 68,744 247 5.021 75.293 ASSETS Current Assets Cash and cash equivalents Marketable securities (Note 4).......... ... Accounts and notes receivable (not of allowance of $211 and 5278 GM Financial receivables, net (Note 5: Note 11 at VIES). Inventories (Note 6)... Equipment on operating leases, net (Note 7). Other current assets (Note 4: Note Il at VIES) Total current assets. Non-current Assets GM Financial receivables, net (Note 5; Note 11 at VIES). Equity in net assets of nonconsolidated affiliates (Notes) Property, net (Note 9).... Goodwill and intangible assets, act (Note 10. Equipment on operating leases, net (Note 7Note 11 at VIES) Deferred income taxes (Note 17). Other assets (Note 4: Note 11 at VIES) Total non-current assets.. Total Assets.... 25.083 9.215 3.75 5.579 43.559 24,082 21.208 9,073 36,253 5.849 5.770 23.544 4.929 143.738 212.482 152.046 227,339 $ 22,297 $ 23,929 935 30,956 28.049 82237 2,515 24.450 76,890 LIABILITIES AND EQUITY Current Liabilities Accounts payablc (principally trade)....... Short-term debt and current portion of long-term dcbt (Note 13) Automotive GM Financial (Note 11 at VIES)... Accrued liabilities (Note 12).. Total current liabilities Non-current Liabilities Long-term debt (Note 13) Automotive GM Financial (Note Il a VIE)........ 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 camnings.... Accumulated other comprehensive loss.. Total stockholders' equity. Noncontrolling interests.... Total Equity-.. . Total abilities and Equity 13.028 60,032 5.370 11.538 122357 102.325 184,562 10.987 56,267 5.998 13.746 12294 99 392 176.282 14 25 563 22.322 19.039) 38.860 3917 42.777 223.339S 25.371 17,627 (2011) 35,001 36.200 212242 05 168 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.250 Depreciation and impairment of Equipment on operating leases, et 7,604 4804 Depreciation, amortization and impairment charges on Property, met... 6,065 5.456 5,015 Foreign currency remeasurement and transaction losses 52 219 Undistributed camnings of nonconsolidated affiliates, net ... (141) 1:32 Pension contributions and OPER payments..... (20) 1.636) 0.454) Pension and OPEB income, net (12) 1934) Provision benefit for deferred taxes................... (112) 10. 2.225 Change in other operating assets and liabilities (Note 26)..... (1.376) (3015) Other operating activities (465) Net cash provided by operating activities - continuing operations 15.236 172338 16,993 Net cash used in operating activities - discontinued operations (10) 15) Net cash provided by operating activities...... 17,328 16.007 Cash flows from investing activities Expenditures for property.... (761) (8.453) (8.354) Available for sale marketable securities acquisitions....... (5.503) (15.12 Trading marketable securities, acquisitions........ (262) Available for sale marketable 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.37) Principal collections and recoveries on finance receivables 17,048 12.578 Purchases of leased vehicles, net (167) (19.10) (19.495) Proceeds from termination of leased vehicles... 1054 6,667 2.554 Other investing activities 122 Net cash used in investing activities - continuing operations 20.929) 24.072 034147 Net cash provided by used in investing activities - discontinued operations Note 166 Net cash used in investing activities 20,763) 27,572) (35,643) Cash flows from financing activities Net increase (decrease in short-term debt..... 1.185 (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)........ 32120) (33,592) (20,727) Payments to purchase common stock (190) (2.500) Proceeds from issuance of subsidiary preferred and common stock (Note 20). 262 95 Dividends paid... 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 122524 17077 Effect of exchange rate changes on cash, cash equivalents and restricted cash (213) Net increase (decrease) in cash, cash equivalents and restricted cash SISES 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,848 15160 Cash, cash equivalents and restricted cash continuing operations at end of period (Note 4).... 23.4965 17,8485 1447 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 ............ 3.813 5 3 ,996 S Non-cash property additions - discontinued operations............. Non-cash business acquisition continuing operations Non-cash proceeds on sale of discontinued operations Note 22) 868 Common Stockholders Accumulated Common Nontrolling Additional Paid in Capital $ 27,607 Retained Earnings $20,285 9,427 Comprehensive Loss $ (8.036) 15 Total Equity S 40.323 452 (159) (59) (1.353) 290 290 (1,320) - (1.180) (2,500) 317 (27) 290 (2,337) (2.337) 36 1526,983 26,168 (3.864) 44,075 (3.882) 1.317 (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 interest 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........... (34) (2,215) 985 434 (2,215) (18) (47) 36,200 (60) 17.627 (1,046) 8,014 8.005 (936) (190) 2.862 287 (2,144) (169) 2.144) 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 Re Average Net Fixed Assets (4) Return on Equity (ROE) - Net Income - Preferred Dividends_ X 100 Average Common Stockholders' Equity (5) Earings 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 Tumover - 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

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

Cost Accounting With Integrated Data Analytics

Authors: Karen Congo Farmer, Amy Fredin

1st Edition

1119731860, 9781119731863

More Books

Students also viewed these Accounting questions

Question

What was the source of the opportunity for Command Audio?

Answered: 1 week ago

Question

What is your least favorite U.S. dialect? Why?

Answered: 1 week ago