Obtain the annual package (financial statements) for the General Motors Look up (or calculate) key financial ratios and perform a brief analysis of the organizations performance Be sure to include at least two ratios in each ratio category liquidity, profitability, and solvency Explain what each ratio means and what the ratio tells you about your organizations performance in the most recent period I am not too sure how I go about putting the attached information into wording to make it 3 5 pages or if i even have the right information honestly Growth Profitability and Financial Ratios for General Motors Co Financials 2008 12 2009 12 2010 12 2011 12 2012 12 2013 12 2014 12 2015 12 2016 12 2017 12 TTM Revenue USD Mil 148,979 104,589 135,592 150,276 152,256 155,427 155,929 135,725 149,184 145,588 144,421 Gross Margin 0 2 7 3 12 4 13 2 7 9 13 2 11 4 16 7 19 2 21 1 20 2 Operating Income USD Mil 20,620 21,023 5,108 6,942 3,218 5,672 1,650 5,538 9,962 10,016 7,962 Operating Margin 13 8 20 1 3 8 4 6 2 1 3 6 1 1 4 1 6 7 6 9 5 5 Net Income USD Mil 30,943 104,821 6,172 9,190 6,188 5,346 3,949 9,687 9,427 3,864 5,426 Earnings Per Share USD 53 47 113 18 2 89 4 58 2 92 2 38 1 65 5 91 6 2 65 3 65 Dividends USD 1 2 1 38 1 52 1 52 1 52 Payout Ratio 58 1 48 4 17 3 32 1 Shares Mil 579 925 1,624 1,668 1,675 1,676 1,687 1,640 1,570 1,492 1,467 Book Value Per Share USD 17 19 21 95 18 92 19 21 24 93 23 09 29 81 29 74 24 33 Operating Cash Flow USD Mil 12,065 17,239 6,780 8,166 10,605 12,630 10,058 11,978 16,545 17,328 15,735 Cap Spending USD Mil 7,530 5,379 4,200 7,078 9,118 9,819 11,867 23,032 29,166 27,633 27,944 Free Cash Flow USD Mil 19,595 22,618 2,580 1,088 1,487 2,811 1,809 11,054 12,621 10,305 12,209 Free Cash Flow Per Share USD 1 59 0 34 0 89 0 34 0 36 4 42 8 59 9 8 Working Capital USD Mil 31,341 6,812 5,896 11,315 16,004 19,089 17,969 6,541 8,978 8,146 Key Ratios Profitability Margins of Sales 2008 12 2009 12 2010 12 2011 12 2012 12 2013 12 2014 12 2015 12 2016 12 2017 12 TTM Revenue 100 100 100 100 100 100 100 100 100 100 100 COGS 100 19 107 27 87 59 86 76 92 11 86 81 88 55 83 25 80 77 78 9 79 83 Gross Margin 0 19 7 27 12 41 13 24 7 89 13 19 11 45 16 75 19 23 21 1 20 17 SG A 9 57 12 83 8 44 8 09 9 22 7 97 7 8 8 76 6 94 6 58 6 64 R D Other 4 09 0 2 0 52 0 79 1 58 2 59 3 91 5 61 7 64 8 02 Operating Margin 13 84 20 1 3 77 4 62 2 11 3 65 1 06 4 08 6 68 6 88 5 51 Net Int Inc Other 5 94 118 1 0 46 1 49 16 73 1 15 1 66 2 09 1 37 1 27 1 39 EBT Margin 19 78 98 4 23 6 11 18 85 4 8 2 72 6 17 8 05 8 15 6 9 Profitability 2008 12 2009 12 2010 12 2011 12 2012 12 2013 12 2014 12 2015 12 2016 12 2017 12 TTM Tax Rate 11 71 1 84 28 52 5 37 20 68 97 22 112 5 Net Margin 20 77 100 1 3 44 5 05 3 19 2 43 1 8 6 36 5 67 2 67 3 78 Asset Turnover (Average) 1 64 0 92 0 99 1 06 1 04 0 98 0 91 0 82 0 8 0 67 0 64 Return on Assets 33 99 92 1 3 39 5 35 3 31 2 39 1 63 5 21 4 53 1 79 2 43 Financial Leverage (Average) 6 41 5 39 5 21 5 78 4 21 5 01 4 88 5 06 6 07 6 38 Return on Equity 19 85 28 35 18 14 11 54 7 48 25 72 22 52 9 84 13 59 Return on Invested Capital 11 59 18 76 13 83 9 93 6 53 21 16 18 86 7 2 9 94 Interest Coverage 10 67 17 74 6 22 12 08 60 88 23 33 11 53 18 42 21 43 21 63 18 24 Key Ratios Growth 2008 12 2009 12 2010 12 2011 12 2012 12 2013 12 2014 12 2015 12 2016 12 2017 12 Latest Qtr Revenue Year over Year 29 8 29 64 10 83 1 32 2 08 0 32 2 29 9 2 12 5 12 38 3 Year Average 0 29 13 33 4 66 1 24 0 02 2 3 2 26 5 Year Average 0 85 8 31 2 36 2 06 0 89 10 Year Average Operating Income Year over Year 36 55 70 91 196 79 94 92 4 93 80 73 3 Year Average 3 72 38 06 18 95 82 42 5 Year Average 0 75 6 58 10 Year Average Net Income Year over Year 94 11 48 9 32 67 13 61 26 13 145 3 2 68 3 Year Average 61 06 4 68 24 54 16 11 20 81 5 Year Average 48 1 9 43 0 51 10 Year Average EPS Year over Year 97 45 58 48 36 24 18 49 30 67 258 18 1 52 57 65 3 Year Average 70 45 6 27 28 84 26 49 36 1 5 Year Average 57 07 15 38 5 55 10 Year Average Key Ratios Cash Flow Cash Flow Ratios 2008 12 2009 12 2010 12 2011 12 2012 12 2013 12 2014 12 2015 12 2016 12 2017 12 TTM Operating Cash Flow Growth YOY 20 44 29 87 19 09 20 36 19 09 38 13 4 73 Free Cash Flow Growth YOY 57 83 36 67 89 04 Cap Ex as a of Sales 5 05 5 14 3 1 4 71 5 99 6 32 7 61 16 97 19 55 18 98 19 35 Free Cash Flow Sales 13 15 21 63 1 9 0 72 0 98 1 81 1 16 8 14 8 46 7 08 8 45 Free Cash Flow Net Income 0 63 0 22 0 42 0 12 0 24 0 53 0 46 1 14 1 34 2 67 2 25 Key Ratios Financial Health Balance Sheet Items (in ) 2008 12 2009 12 2010 12 2011 12 2012 12 2013 12 2014 12 2015 12 2016 12 2017 12 Latest Qtr Cash Short Term Investments 15 59 16 74 19 16 21 89 18 34 17 43 15 86 12 03 11 19 11 21 9 77 Accounts Receivable 8 7 5 52 6 26 6 88 9 66 13 71 14 41 13 57 14 3 13 5 14 6 Inventory 14 49 7 42 8 73 9 91 9 85 8 44 7 68 7 08 6 22 5 02 5 24 Other Current Assets 9 84 13 8 4 04 2 99 8 99 9 41 9 14 7 43 2 67 2 62 3 05 Total Current Assets 48 62 43 47 38 2 41 66 46 84 49 47 09 40 1 34 37 32 35 32 66 Net PP E 43 57 13 71 13 85 15 88 17 3 17 58 19 59 26 42 31 73 37 24 36 93 Intangibles 0 29 33 18 31 43 26 99 5 88 4 35 3 61 3 06 2 82 2 75 2 65 Other Long Term Assets 7 52 9 64 16 52 15 47 29 98 29 08 29 71 30 42 31 07 27 65 27 77 Total Assets 100 100 100 100 100 100 100 100 100 100 100 Accounts Payable 24 58 13 81 15 59 17 04 16 93 14 25 12 72 12 4 12 17 11 33 11 97 Short Term Debt 18 68 7 54 1 17 1 17 0 74 0 34 0 28 0 42 0 53 1 19 2 Taxes Payable Accrued Liabilities 35 81 16 44 16 98 15 83 14 79 14 09 15 13 2 11 94 10 69 12 56 Other Short Term Liabilities 4 42 0 89 0 45 3 87 8 97 9 1 10 81 13 83 13 18 11 49 Total Current Liabilities 83 49 38 67 34 19 34 04 36 32 37 65 37 1 36 83 38 46 36 39 38 02 Long Term Debt 32 04 4 1 6 63 8 11 1 73 3 96 5 03 4 1 4 33 5 2 5 04 Other Long Term Liabilities 78 95 41 55 32 95 31 33 37 57 32 69 37 85 38 53 37 41 41 84 41 18 Total Liabilities 194 48 84 33 73 77 73 48 75 62 74 3 79 98 79 46 80 21 83 43 84 24 Total Stockholders' Equity 94 48 15 67 26 23 26 52 24 38 25 7 20 02 20 54 19 79 16 57 15 76 Total Liabilities Equity 100 100 100 100 100 100 100 100 100 100 100 Liquidity Financial Health 2008 12 2009 12 2010 12 2011 12 2012 12 2013 12 2014 12 2015 12 2016 12 2017 12 Latest Qtr Current Ratio 0 59 1 13 1 13 1 23 1 3 1 31 1 27 1 09 0 89 0 89 0 86 Quick Ratio 0 29 0 58 0 75 0 85 0 78 0 83 0 82 0 7 0 66 0 68 0 64 Financial Leverage 6 41 5 39 5 21 5 78 4 21 5 01 4 88 5 06 6 07 6 38 Debt Equity 0 26 0 35 0 42 0 13 0 17 0 25 0 2 0 22 0 31 0 32 Key Ratios Efficiency Ratios Efficiency 2008 12 2009 12 2010 12 2011 12 2012 12 2013 12 2014 12 2015 12 2016 12 2017 12 TTM Days Sales Outstanding 20 43 28 11 22 16 22 65 24 39 22 23 20 61 20 86 19 72 22 32 27 38 Days Inventory 32 27 37 9 34 16 36 8 37 79 38 89 36 59 38 98 36 88 38 85 41 39 Payables Period 54 43 66 67 61 79 63 99 64 63 65 99 61 66 26 68 3 80 85 86 69 Cash Conversion Cycle 1 73 0 65 5 47 4 54 2 45 4 87 3 8 6 42 11 7 19 69 17 92 Receivables Turnover 17 86 12 99 16 47 16 12 14 97 16 42 17 71 17 5 18 51 16 36 13 33 Inventory Turnover 11 31 9 63 10 69 9 92 9 66 9 39 9 98 9 36 9 9 9 4 8 82 Fixed Assets Turnover 3 76 3 58 7 15 7 12 6 24 5 64 4 87 3 53 2 73 1 95 1 86 Asset Turnover 1 64 0 92 0 99 1 06 1 04 0 98 0 91 0 82 0 8 0 67 0 64

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 04, 2024

Obtain the annual package (financial statements) for the General Motors. Look up (or calculate) key financial ratios and perform a brief analysis of the organizations

Obtain the annual package (financial statements) for the General Motors. Look up (or calculate) key financial ratios and perform a brief analysis of the organizations performance. Be sure to include at least two ratios in each ratio category: liquidity, profitability, and solvency. Explain what each ratio means and what the ratio tells you about your organizations performance in the most recent period.

I am not too sure how I go about putting the attached information into wording to make it 3-5 pages or if i even have the right information honestly.

Growth Profitability and Financial Ratios for General Motors Co
Financials
	2008-12	2009-12	2010-12	2011-12	2012-12	2013-12	2014-12	2015-12	2016-12	2017-12	TTM
Revenue USD Mil	148,979	104,589	135,592	150,276	152,256	155,427	155,929	135,725	149,184	145,588	144,421
Gross Margin %	-0.2	-7.3	12.4	13.2	7.9	13.2	11.4	16.7	19.2	21.1	20.2
Operating Income USD Mil	-20,620	-21,023	5,108	6,942	-3,218	5,672	1,650	5,538	9,962	10,016	7,962
Operating Margin %	-13.8	-20.1	3.8	4.6	-2.1	3.6	1.1	4.1	6.7	6.9	5.5
Net Income USD Mil	-30,943	104,821	6,172	9,190	6,188	5,346	3,949	9,687	9,427	-3,864	-5,426
Earnings Per Share USD	-53.47	113.18	2.89	4.58	2.92	2.38	1.65	5.91	6	-2.65	-3.65
Dividends USD							1.2	1.38	1.52	1.52	1.52
Payout Ratio % *							58.1	48.4	17.3	32.1
Shares Mil	579	925	1,624	1,668	1,675	1,676	1,687	1,640	1,570	1,492	1,467
Book Value Per Share * USD			17.19	21.95	18.92	19.21	24.93	23.09	29.81	29.74	24.33
Operating Cash Flow USD Mil	-12,065	-17,239	6,780	8,166	10,605	12,630	10,058	11,978	16,545	17,328	15,735
Cap Spending USD Mil	-7,530	-5,379	-4,200	-7,078	-9,118	-9,819	-11,867	-23,032	-29,166	-27,633	-27,944
Free Cash Flow USD Mil	-19,595	-22,618	2,580	1,088	1,487	2,811	-1,809	-11,054	-12,621	-10,305	-12,209
Free Cash Flow Per Share * USD			1.59	-0.34	0.89	0.34	-0.36	-4.42	-8.59	-9.8
Working Capital USD Mil	-31,341	6,812	5,896	11,315	16,004	19,089	17,969	6,541	-8,978	-8,146

Key Ratios -> Profitability
Margins % of Sales	2008-12	2009-12	2010-12	2011-12	2012-12	2013-12	2014-12	2015-12	2016-12	2017-12	TTM
Revenue	100	100	100	100	100	100	100	100	100	100	100
COGS	100.19	107.27	87.59	86.76	92.11	86.81	88.55	83.25	80.77	78.9	79.83
Gross Margin	-0.19	-7.27	12.41	13.24	7.89	13.19	11.45	16.75	19.23	21.1	20.17
SG&A	9.57	12.83	8.44	8.09	9.22	7.97	7.8	8.76	6.94	6.58	6.64
R&D
Other	4.09		0.2	0.52	0.79	1.58	2.59	3.91	5.61	7.64	8.02
Operating Margin	-13.84	-20.1	3.77	4.62	-2.11	3.65	1.06	4.08	6.68	6.88	5.51
Net Int Inc & Other	-5.94	118.1	0.46	1.49	-16.73	1.15	1.66	2.09	1.37	1.27	1.39
EBT Margin	-19.78	98	4.23	6.11	-18.85	4.8	2.72	6.17	8.05	8.15	6.9

Profitability	2008-12	2009-12	2010-12	2011-12	2012-12	2013-12	2014-12	2015-12	2016-12	2017-12	TTM
Tax Rate %			11.71	1.84		28.52	5.37		20.68	97.22	112.5
Net Margin %	-20.77	100.1	3.44	5.05	3.19	2.43	1.8	6.36	5.67	-2.67	-3.78
Asset Turnover (Average)	1.64	0.92	0.99	1.06	1.04	0.98	0.91	0.82	0.8	0.67	0.64
Return on Assets %	-33.99	92.1	3.39	5.35	3.31	2.39	1.63	5.21	4.53	-1.79	-2.43
Financial Leverage (Average)		6.41	5.39	5.21	5.78	4.21	5.01	4.88	5.06	6.07	6.38
Return on Equity %			19.85	28.35	18.14	11.54	7.48	25.72	22.52	-9.84	-13.59
Return on Invested Capital %			11.59	18.76	13.83	9.93	6.53	21.16	18.86	-7.2	-9.94
Interest Coverage	-10.67	17.74	6.22	12.08	-60.88	23.33	11.53	18.42	21.43	21.63	18.24

Key Ratios -> Growth
	2008-12	2009-12	2010-12	2011-12	2012-12	2013-12	2014-12	2015-12	2016-12	2017-12	Latest Qtr
Revenue %
Year over Year		-29.8	29.64	10.83	1.32	2.08	0.32	-2.29	9.2	-12.5	-12.38
3-Year Average				0.29	13.33	4.66	1.24	0.02	2.3	-2.26
5-Year Average						0.85	8.31	2.36	2.06	-0.89
10-Year Average
Operating Income %
Year over Year				36.55			-70.91	196.79	94.92	4.93	-80.73
3-Year Average						3.72	-38.06		18.95	82.42
5-Year Average								-0.75	6.58
10-Year Average
Net Income %
Year over Year			-94.11	48.9	-32.67	-13.61	-26.13	145.3	-2.68
3-Year Average					-61.06	-4.68	-24.54	16.11	20.81
5-Year Average							-48.1	9.43	0.51
10-Year Average
EPS %
Year over Year			-97.45	58.48	-36.24	-18.49	-30.67	258.18	1.52		-57.65
3-Year Average					-70.45	-6.27	-28.84	26.49	36.1
5-Year Average							-57.07	15.38	5.55
10-Year Average

Key Ratios -> Cash Flow
Cash Flow Ratios	2008-12	2009-12	2010-12	2011-12	2012-12	2013-12	2014-12	2015-12	2016-12	2017-12	TTM
Operating Cash Flow Growth % YOY				20.44	29.87	19.09	-20.36	19.09	38.13	4.73
Free Cash Flow Growth % YOY				-57.83	36.67	89.04
Cap Ex as a % of Sales	5.05	5.14	3.1	4.71	5.99	6.32	7.61	16.97	19.55	18.98	19.35
Free Cash Flow/Sales %	-13.15	-21.63	1.9	0.72	0.98	1.81	-1.16	-8.14	-8.46	-7.08	-8.45
Free Cash Flow/Net Income	0.63	-0.22	0.42	0.12	0.24	0.53	-0.46	-1.14	-1.34	2.67	2.25

Key Ratios -> Financial Health
Balance Sheet Items (in %)	2008-12	2009-12	2010-12	2011-12	2012-12	2013-12	2014-12	2015-12	2016-12	2017-12	Latest Qtr
Cash & Short-Term Investments	15.59	16.74	19.16	21.89	18.34	17.43	15.86	12.03	11.19	11.21	9.77
Accounts Receivable	8.7	5.52	6.26	6.88	9.66	13.71	14.41	13.57	14.3	13.5	14.6
Inventory	14.49	7.42	8.73	9.91	9.85	8.44	7.68	7.08	6.22	5.02	5.24
Other Current Assets	9.84	13.8	4.04	2.99	8.99	9.41	9.14	7.43	2.67	2.62	3.05
Total Current Assets	48.62	43.47	38.2	41.66	46.84	49	47.09	40.1	34.37	32.35	32.66
Net PP&E	43.57	13.71	13.85	15.88	17.3	17.58	19.59	26.42	31.73	37.24	36.93
Intangibles	0.29	33.18	31.43	26.99	5.88	4.35	3.61	3.06	2.82	2.75	2.65
Other Long-Term Assets	7.52	9.64	16.52	15.47	29.98	29.08	29.71	30.42	31.07	27.65	27.77
Total Assets	100	100	100	100	100	100	100	100	100	100	100
Accounts Payable	24.58	13.81	15.59	17.04	16.93	14.25	12.72	12.4	12.17	11.33	11.97
Short-Term Debt	18.68	7.54	1.17	1.17	0.74	0.34	0.28	0.42	0.53	1.19	2
Taxes Payable
Accrued Liabilities	35.81	16.44	16.98	15.83	14.79	14.09	15	13.2	11.94	10.69	12.56
Other Short-Term Liabilities	4.42	0.89	0.45		3.87	8.97	9.1	10.81	13.83	13.18	11.49
Total Current Liabilities	83.49	38.67	34.19	34.04	36.32	37.65	37.1	36.83	38.46	36.39	38.02
Long-Term Debt	32.04	4.1	6.63	8.11	1.73	3.96	5.03	4.1	4.33	5.2	5.04
Other Long-Term Liabilities	78.95	41.55	32.95	31.33	37.57	32.69	37.85	38.53	37.41	41.84	41.18
Total Liabilities	194.48	84.33	73.77	73.48	75.62	74.3	79.98	79.46	80.21	83.43	84.24
Total Stockholders' Equity	-94.48	15.67	26.23	26.52	24.38	25.7	20.02	20.54	19.79	16.57	15.76
Total Liabilities & Equity	100	100	100	100	100	100	100	100	100	100	100

Liquidity/Financial Health	2008-12	2009-12	2010-12	2011-12	2012-12	2013-12	2014-12	2015-12	2016-12	2017-12	Latest Qtr
Current Ratio	0.59	1.13	1.13	1.23	1.3	1.31	1.27	1.09	0.89	0.89	0.86
Quick Ratio	0.29	0.58	0.75	0.85	0.78	0.83	0.82	0.7	0.66	0.68	0.64
Financial Leverage		6.41	5.39	5.21	5.78	4.21	5.01	4.88	5.06	6.07	6.38
Debt/Equity		0.26	0.35	0.42	0.13	0.17	0.25	0.2	0.22	0.31	0.32

Key Ratios -> Efficiency Ratios
Efficiency	2008-12	2009-12	2010-12	2011-12	2012-12	2013-12	2014-12	2015-12	2016-12	2017-12	TTM
Days Sales Outstanding	20.43	28.11	22.16	22.65	24.39	22.23	20.61	20.86	19.72	22.32	27.38
Days Inventory	32.27	37.9	34.16	36.8	37.79	38.89	36.59	38.98	36.88	38.85	41.39
Payables Period	54.43	66.67	61.79	63.99	64.63	65.99	61	66.26	68.3	80.85	86.69
Cash Conversion Cycle	-1.73	-0.65	-5.47	-4.54	-2.45	-4.87	-3.8	-6.42	-11.7	-19.69	-17.92
Receivables Turnover	17.86	12.99	16.47	16.12	14.97	16.42	17.71	17.5	18.51	16.36	13.33
Inventory Turnover	11.31	9.63	10.69	9.92	9.66	9.39	9.98	9.36	9.9	9.4	8.82
Fixed Assets Turnover	3.76	3.58	7.15	7.12	6.24	5.64	4.87	3.53	2.73	1.95	1.86
Asset Turnover	1.64	0.92	0.99	1.06	1.04	0.98	0.91	0.82	0.8	0.67	0.64