I need a 10 page paper on financial analysis of General Electric. The report should include an analysis of the...

profileNrhnry
financials_analysis.xlsx
Home>Business & Finance homework help>Accounting homework help>I need a 10 page paper on financial analysis of General Electric. The report should include an analysis of the...

Common Size BS

Period Ending 31-Dec-12 Percent 31-Dec-11 Percent 31-Dec-10 Percent
Balance Sheet
Assets
Cash And Cash Equivalents 77,356 11.29% 84,501 11.77% 78,943 10.56%
Short Term Investment 48,510 7.08% 47,374 6.60% 43,938 5.88%
Net Receivables 287,489 41.95% 307,957 42.88% 329,204 44.02%
Inventory 15,374 2.24% 13,792 1.92% 11,526 1.54%
Total Current Assets 428,729 453,624 463,611
Long Term Investments
Property, Plant & Equipment 69,954 10.21% 66,450 9.25% 103,099 13.79%
Goodwill 73,447 10.72% 72,625 10.11% 64,388 8.61%
Intangible Assets 11,987 1.75% 12,068 1.68% 9,971 1.33%
Other Assets 101,211 14.77% 113,422 15.79% 106,724 14.27%
Total Assets 685,328 100.00% 718,189 100.00% 747,793 100.00%
Liabilities
Current Liabilities
Accounts Payable 28,532 5.07% 29,546 4.91% 56,943 9.05%
Short/Current Long Term Debt 131,515 23.39% 166,869 27.73% 147,977 23.53%
Other Current Liabilities 61,356 10.91% 57,911 9.62% 67,328 10.71%
Total Current Liabilites 221,403 254,326 272,248
Long Term Debt 236,084 41.99% 243,459 40.46% 293,323 46.64%
Other Liabilities 99,446 17.69% 102,401 17.02% 55,271 8.79%
Deferred Long Term Liability Charges (75) -0.01% (131) -0.02% 2,753 0.44%
Minority Interest 5,444 0.97% 1,696 0.28% 5,262 0.84%
Total Liabilites 562,302 100.00% 601,751 100.00% 628,857 100.00%
Stockholders' Equity
Common Stock 702 0.57% 702 1% 702 0.59%
Retained Earnings 144,055 117.09% 137,786 118.33% 131,137 110.26%
Treauary Stock (34,571) -28.10% (31,769) -27.28% (31,938) -26.85%
Other Stockholder Equity 12,840 10.44% 9,719 8.35% 19,035 16.00%
Total Stockholder Equity 123,026 100.00% 116,438 118,936 100.00%
Net Tangilble Assets 37,592 31,745 44,577

Common Size IS

Period Ending 31-Dec-12 Percent 31-Dec-11 Percent 31-Dec-10 Percent
Income Statement
Total Revenue 147,359 100.00% 147,288 100.00% 149,567 100.00%
Cost of Revenue 77,167 52.37% 71,190 48.33% 74,725 49.96%
Gross Profit 70,192 47.63% 76,098 51.67% 74,842 50.04%
Operating Expense
Research Development
Selling General and Administrative 36,387 24.69% 37,362 25.37% 38,033 25.43%
Non Recurring 3,891 2.64% 3,951 2.68% 7,085 4.74%
Others
Total Operating Expenses
Operating Income or Loss 29,914 34,785 29,724
Income from Continuting Operations
Total other Income/Expenses Net
Earnings Before Interest and Taxes 29,914 20.30% 34,785 23.62% 29,724 19.87%
Interest Expense 12,508 8.49% 14,528 9.86% 15,537 10.39%
Income before Tax 17,406 11.81% 20,257 13.75% 14,187 9.49%
Income Tax Expense 2,504 1.70% 5,738 3.90% 1,039 0.69%
Minority Interest (223) -0.15% (292) -0.20% (535) -0.36%
Net Income From Continuing Ops 14,902 10.11% 14,519 9.86% 13,148 8.79%
Non-recurring Events
Discontinued Operations (1,038) -0.70% (76) -0.05% (969) -0.65%
Extraordinary Items
Effect of Accounting Changes
Other Items
Net Income 13,641 9.26% 14,151 9.61% 11,644 7.79%
Preferred Stock and Other Adjustments (1,031) (300)
Net Income Applicable to Common Shares 13,641 13,120 11,344

Horizontal IS

Period Ending 31-Dec-12 Amt Change Percent Change 31-Dec-11 Amt Change Percent Change 31-Dec-10
Income Statement
Total Revenue 147,359 71 0.05% 147,288 (2,279) 1.52% 149,567
Cost of Revenue 77,167 5,977 8.40% 71,190 (3,535) 4.73% 74,725
Gross Profit 70,192 (5,906) 7.76% 76,098 1,256 1.68% 74,842
Operating Expense
Research Development
Selling General and Administrative 36,387 (975) 2.61% 37,362 (671) 1.76% 38,033
Non Recurring 3,891 (60) 1.52% 3,951 (3,134) 44.23% 7,085
Others
Total Operating Expenses
Operating Income or Loss 29,914 (4,871) 14.00% 34,785 5,061 17.03% 29,724
Income from Continuting Operations
Total other Income/Expenses Net
Earnings Before Interest and Taxes 29,914 (4,871) 14.00% 34,785 5,061 17.03% 29,724
Interest Expense 12,508 (2,020) 13.90% 14,528 (1,009) 6.49% 15,537
Income before Tax 17,406 (2,851) 14.07% 20,257 6,070 42.79% 14,187
Income Tax Expense 2,504 (3,234) 56.36% 5,738 4,699 452.26% 1,039
Minority Interest (223) 69 23.63% (292) 243 45.42% (535)
Net Income From Continuing Ops 14,902 383 2.64% 14,519 1,371 10.43% 13,148
Non-recurring Events
Discontinued Operations (1,038) (962) 1265.79% (76) 893 92.16% (969)
Extraordinary Items
Effect of Accounting Changes
Other Items
Net Income 13,641 (510) 35.15% 14,151 2,507 21.53% 11,644
Preferred Stock and Other Adjustments (1,031) (731) 243.67% (300)
Net Income Applicable to Common Shares 13,641 521 3.97% 13,120 1,776 15.66% 11,344

Horizontal BS

Period Ending 31-Dec-12 Amt Change Percent Change 31-Dec-11 Amt Change Percent Change 31-Dec-10
Balance Sheet
Assets
Cash And Cash Equivalents 77,356 (7,145) 8.46% 84,501 5,558 7.04% 78,943
Short Term Investment 48,510 1,136 2.40% 47,374 3,436 7.82% 43,938
Net Receivables 287,489 (20,468) 6.65% 307,957 (21,247) 6.45% 329,204
Inventory 15,374 1,582 11.47% 13,792 2,266 19.66% 11,526
Total Current Assets 428,729 (24,895) 5.49% 453,624 (9,987) 2.15% 463,611
Long Term Investments
Property, Plant & Equipment 69,954 3,504 5.27% 66,450 (36,649) 35.55% 103,099
Goodwill 73,447 822 1.13% 72,625 8,237 12.79% 64,388
Intangible Assets 11,987 (81) 0.67% 12,068 2,097 21.03% 9,971
Accumlated Amortization
Other Assets 101,211 (12,211) 10.77% 113,422 6,698 6.28% 106,724
Deferred Long Term Asset Changes
Total Assets 685,328 (32,861) 4.58% 718,189 (29,604) 3.96% 747,793
Liabilities
Current Liabilities
Accounts Payable 28,532 (1,014) 3.43% 29,546 (27,397) 48.11% 56,943
Short/Current Long Term Debt 131,515 (35,354) 21.19% 166,869 18,892 12.77% 147,977
Other Current Liabilities 61,356 3,445 5.95% 57,911 (9,417) 13.99% 67,328
Total Current Liabilites 221,403 (32,923) 12.95% 254,326 (17,922) 6.58% 272,248
Long Term Debt 236,084 (7,375) 3.03% 243,459 (49,864) 17.00% 293,323
Other Liabilities 99,446 (2,955) 2.89% 102,401 47,130 85.27% 55,271
Deferred Long Term Liability Charges (75) 56 42.75% (131) (2,884) 104.76% 2,753
Minority Interest 5,444 3,748 220.99% 1,696 (3,566) 67.77% 5,262
Negative Goodwill
Total Liabilites 562,302 (39,449) 6.56% 601,751 (27,106) 4.31% 628,857
Stockholders' Equity
Misc Stock
Redeemable Preferred Stock
Preferred Stock
Common Stock 702 - 0 0.00% 702 - 0 0% 702
Retained Earnings 144,055 6,269 4.55% 137,786 6,649 5.07% 131,137
Treauary Stock (34,571) (2,802) 20.35% (31,769) 169 0.53% (31,938)
Capital Surplus - 0
Other Stockholder Equity 12,840 3,121 32.11% 9,719 (9,316) 48.94% 19,035
Total Stockholder Equity 123,026 6,588 5.66% 116,438 (2,498) 2.10% 118,936
Net Tangilble Assets 37,592 5,847 18.42% 31,745 (12,832) 28.79% 44,577

Ratio Analysis

2012 2011
Current Ratio 1.94 0.6316220382
A/R Turnover 0.0012696138 0.0011852304

Trend Analysis BS

Period Ending 2012 2011 2010
Balance Sheet
Assets
Cash And Cash Equivalents 97.99% 107.04% 100%
Short Term Investment 110.41% 107.82% 100%
Net Receivables 87.33% 93.55% 100%
Inventory 133.39% 119.66% 100%
Total Current Assets 92.48% 97.85% 100%
Long Term Investments
Property, Plant & Equipment 67.85% 64.45% 100%
Goodwill 114.07% 112.79% 100%
Intangible Assets 120.22% 121.03% 100%
Accumlated Amortization
Other Assets 94.83% 106.28% 100%
Deferred Long Term Asset Changes
Total Assets 91.65% 96.04% 100%
Liabilities
Current Liabilities
Accounts Payable 50.11% 51.89% 100%
Short/Current Long Term Debt 88.88% 112.77% 100%
Other Current Liabilities 91.13% 86.01% 100%
Total Current Liabilites 81.32% 93.42% 100%
Long Term Debt 80.49% 83.00% 100%
Other Liabilities 179.92% 185.27% 100%
Deferred Long Term Liability Charges -2.72% -4.76% 100%
Minority Interest 103.46% 32.23% 100%
Negative Goodwill
Total Liabilites 89.42% 95.69% 100%
Stockholders' Equity
Misc Stock
Redeemable Preferred Stock
Preferred Stock
Common Stock
Retained Earnings 100.00% 100.00% 100%
Treauary Stock 109.85% 105.07% 100%
Capital Surplus -108.24% -99.47% 100%
Other Stockholder Equity 67.45% 51.06% 100%
Total Stockholder Equity 103.44% 97.90% 100%
Net Tangilble Assets 84.33% 71.21% 100%

Trend Analysis IS

Period Ending 2012 2011 2010
Income Statement
Total Revenue 98.52% 98.48% 100%
Cost of Revenue 103.27% 95.27% 100%
Gross Profit 93.79% 101.68% 100%
Operating Expense
Research Development
Selling General and Administrative 95.67% 98.24% 100%
Non Recurring 54.92% 55.77% 100%
Others
Total Operating Expenses
Operating Income or Loss 100.64% 117.03% 100%
Income from Continuting Operations
Total other Income/Expenses Net
Earnings Before Interest and Taxes 100.64% 117.03% 100%
Interest Expense 80.50% 93.51% 100%
Income before Tax 122.69% 142.79% 100%
Income Tax Expense 241.00% 552.26% 100%
Minority Interest 41.68% 54.58% 100%
Net Income From Continuing Ops 113.34% 110.43% 100%
Non-recurring Events
Discontinued Operations 107.12% 7.84% 100%
Extraordinary Items
Effect of Accounting Changes
Other Items
Net Income 117.15% 121.53% 100%
Preferred Stock and Other Adjustments 343.67% 100%
Net Income Applicable to Common Shares 120.25% 115.66% 100%