Final Summary

profiledjprse
DPursell_Mod3_051020.xlsx
Home>Business & Finance homework help>Accounting homework help>Final Summary

Analytic Ratios

General Motors Co.
Ratio Analysis
Recent Year Year - 1 Year -2
Short Term Debt
Cash Ratio 0.270 0.332 0.894
Quick Ratio 0.674 0.732 0.682
Current Ratio 0.883 0.922 0.312
Liquidity
A/R Turnover 0.60 0.65 0.69
Days to collect A/R 24.00 23.00 22.00
Inventory Turnover 11.85 13.54 11.94
Days to sell Inventory 34.80 27.50 26.89
Long-Term Debt
Debt to Equity 2.25 2.45 2.60
Times Interest Earned 10.51 14.05 21.63
Profitability
Earning per Share 3.00 0.44 -2.44
Gross Profit Percentage 5.61% 8.61% 12.30%
Profit Margin 4.91% 4.23% 3.89%
Return on Assets 2.92 3.5 0.16
Return on Common Equity 14.12% 20.07% -9.04%

Horizontal

Summit, Inc. General Motors Co
Income Statement Horizontal Analysis of Income Statement
For the Year Ended December 31 Recent Year vs Year -1 Year -1 vs Year -2
$ Change(millions) % Change $ Change(millios) % Change
2015 2014 2013
Net Sales $ 75,368,814.00 $ 74,293,018.50 $ 72,343,206.50 Net Sales -9812 -6.67% 1461 1.01%
Cost of Goods Sold $ 54,642,390.00 $ 53,127,749.50 $ 50,994,082.50 Cost of Goods Sold -2336 -1.87% 5097 4.25%
Gross Profit $ 20,726,424.00 $ 21,165,269.00 $ 21,349,124.00 Gross Profit -303 -2.21% -4136 -29.34%
Operating Expenses $ 18,588,869.00 $ 19,066,984.50 $ 18,620,554.00 Operating Expenses -10848 -8.23% 5677 3.98%
Income from Operations $ 2,137,555.00 $ 2,098,284.50 $ 2,728,570.00 Income from Operations -1408 -21.12% 7745 95.91%
Other Revenue and Gains $ 600,000.00 $ 520,000.00 $ 450,000.00 Other Revenue and Gains _ _ _ _
Other Expenses and Losses $ 1,690,974.00 $ 1,669,608.50 $ 1,648,976.50 Other Expenses and Losses -1159 -13.65% 80 0.83%
Income before Income Taxes $ 1,046,581.00 $ 948,676.00 $ 1,529,593.50 Income before Income Taxes -218 -3.53% -3345 -52.23%
Income taxes $ 441,657.18 $ 429,470.50 $ 670,768.00 Income taxes 295 38.36% -11059 -95.89%
Net Income $ 604,923.82 $ 519,205.50 $ 858,825.50 Net Income -1335 -20.29% 11796 149.01%
Earnings per share $ 1.21 $ 1.04 $ 1.72 Earnings per share ($) -0.96 -21.00% 8.13 147.02%
Summit, Inc. General Motors Co
Balance Sheet Horizontal Analysis of Balance Sheet
As of December 31 Recent Year vs Year -1 Year -1 vs Year -2
$ Change(millions) % Change $ Change(millions) % Change
2015 2014 2013
Assets Assets 2345 3.56% 4537 12.36%
Current Assets Current Assets 675 6.87% 5465 13.64%
Cash and Equivalents $ 3,860,639 $ 3,662,423 $ 4,033,273 Cash and Equivalents 765 0.89% 453 0.92%
Net Receivables $ 6,521,082 $ 4,309,929 $ 3,968,204 Net Receivables 7876 32.89% 3454 23.98%
Inventory $ 16,118,011 $ 12,768,599 $ 12,635,752 Inventory 6865 16.96% 5435 14.87%
Other current assets $ 86,139 $ 71,603 $ 65,871 Other current assets 456 3.67% 343 2.67%
Total Current Assets $ 26,585,871 $ 20,812,554 $ 20,703,100 Total Current Assets 4654 32.65% 3432 19.90%
Property, plant, & Equip $ 31,131,524 $ 30,817,765 $ 29,134,366 Property, plant, & Equip 8976 13.78% 4565 12.87%
Total Assets $ 57,717,395 $ 51,630,319 $ 49,837,466 Total Assets 9876 23.67% 6785 17.98%
Liabilities Liabilities -483 -0.89% 342 1.45%
Current Liabilities Current Liabilities -897 -3.89% 564 2.67%
Payables $ 6,484,843 $ 4,730,388 $ 3,793,187 Payables 3456 21.34% 2344 8.90%
Short term/current long term debt $ 7,687,909 $ 5,149,334 $ 4,836,335 Short term/current long term debt -345 -0.87% 456 3.56%
Other current liabilities $ 1,033,822 $ 883,680 $ 841,275 Other current liabilities -567 -2.67% 765 2,89%
Total current liabilities $ 15,206,574 $ 10,763,402 $ 9,470,797 Total current liabilities -987 -7.89% 654 2.67%
Long-term debt $ 12,210,045 $ 11,171,003 $ 11,189,960 Long-term debt -6754 -5.67% 3432 7.56%
Total Liabilities $ 27,416,619 $ 21,934,405 $ 20,660,757 Total Liabilities -8765 -5.78% 4535 2.89%
Stockholder's Equity Stockholder's Equity 7628 6.75% 6543 3.90%
Common Stock $ 500,000 $ 500,000 $ 500,000 Common Stock 8797 4.90% 4536 2.87%
Additional PICap $ 7,858,823 $ 7,858,823 $ 7,858,823 Additional PICap 6759 4.98% 7640 8.90%
Retained Earnings $ 21,941,953 $ 21,337,091 $ 20,817,886 Retained Earnings 768 2.70% 675 2,87%
Total Stockholder's Equity $ 30,300,776 $ 29,695,914 $ 29,176,709 Total Stockholder's Equity 9876 1.78% 6754 2.98%
Total Liab & Stockholder's Equity $ 57,717,395 $ 51,630,319 $ 49,837,466 Total Liab & Stockholder's Equity 1216 2.12% 4543 3.32%

Sheet1