Company Information ACCT 370 Excel Project General Electric Co Multinational Conglomerate Asher Braatz Company Name General Electric Co Ticker Symbol GE Industry Conglomerate - Aviation, Healthcare,...

1 answer below »
Making a PowerPoint based on the excel work that has been done.


Company Information ACCT 370 Excel Project General Electric Co Multinational Conglomerate Asher Braatz Company NameGeneral Electric Co Ticker SymbolGE IndustryConglomerate - Aviation, Healthcare, Power and Renewable Energy Products and Services OfferedAircraft engineers, Electrical Distribution, Electric Motors, Energy, Finance, Software Major CompetitorsBentley Systems, 3M, Siemens, Philips, Honeywell, Mitsubishi Historical Income Statement General Electric Co Historical Income Statements As on 2020, 2019 and 2018 In Millions 202020192018 Sales of goods$49,464.00$58,949.0060148 Sales of services23,558.0028,538.0028,792.00 GE Capital revenues from services6,597.007,728.008,072.00 Total revenues79,619.0095,215.0097,012.00 Cost of goods sold42,041.0045,902.0047,570.00 Cost of services sold18,380.0021,009.0021,833.00 Selling, general and administrative expenses12,621.0013,949.0014,643.00 Research and development2,565.003,118.003,415.00 Interest and other financial charges3,273.004,227.004,766.00 Insurance losses and annuity benefits2,397.003,294.002,790.00 Goodwill impairments1,717.001,486.0022,136.00 Non-operating benefit costs2,433.002,844.002,753.00 Other costs and expenses382.00458.00414.00 Total costs and expenses85,809.0096,287.00120,320.00 Other income11,387.002,222.002,321.00 Earnings (loss) from continuing operations before income taxes5,197.001,150.00(20,987.00) Benefit (provision) for income taxes474.00(726.00)(93.00) Earnings (loss) from continuing operations5,671.00424.00(21,080.00) Earnings (loss) from discontinued operations, net of taxes(125.00)(5,335.00)(1,363.00) Net earnings (loss)5,546.00(4,911.00)(22,443.00) Less net earnings (loss) attributable to noncontrolling interests(158.00)66.00(89.00) Net earnings (loss) attributable to the Company5,704.00(4,977.00)(22,354.00) Preferred stock dividends(474.00)(460.00)(447.00) Net earnings (loss) attributable to GE common shareholders5,230.00(5,437.00)(22,801.00) Amounts attributable to GE common shareholders Earnings (loss) from continuing operations5,672.00423.00(21,080.00) Less net earnings (loss) attributable to noncontrolling interests, continuing operations(158.00)7.00(90.00) Earnings (loss) from continuing operations attributable to the Company5,830.00416.00(20,990.00) Preferred stock dividends(474.00)(460.00)(447.00) Earnings (loss) from continuing operations attributable to GE common shareholders5,356.00(44.00)(21,437.00) Earnings (loss) from discontinued operations, net of taxes(126.00)(5,335.00)(1,363.00) Less net earnings (loss) attributable to noncontrolling interests, discontinued operations- 058.001.00 Net earnings (loss) attributable to GE common shareholders$5,230.00($5,437.00)($22,801.00) Fields Using Formulas Historical Balance Sheet General Electric Co Historical Balance Sheets As on 2020, 2019 and 2018 In Millions Assets202020192018 Cash, cash equivalents and restricted cash$36,630.00$35,811.00$31,124.00 Investment securities7,319.009,888.0033,508.00 Current receivables16,691.0016,569.0014,645.00 Financing receivables – net1,265.001,077.007,699.00 Inventories, including deferred inventory costs 15,890.0017,215.0013,803.00 Other GE Capital receivables3,331.002,635.007,143.00 Receivable from GE Capital- 0- 0- 0 Current contract assets 5,765.007,390.00- 0 All other current assets1,521.003,362.00- 0 Assets of businesses held for sale- 09,149.001,629.00 Current assets88,412.00103,096.00109,551.00 Investment securities42,549.0038,632.00- 0 Financing receivables – net1,771.002,057.00- 0 Other GE Capital receivables4,661.004,509.00- 0 Property, plant and equipment – net44,662.0045,879.0043,611.00 Receivable from GE Capital- 0- 0 Goodwill25,524.0026,734.0033,974.00 Other intangible assets – net9,774.0010,653.0012,178.00 Contract and other deferred assets5,888.005,737.0017,431.00 All other assets14,597.0013,882.0018,357.00 Deferred income taxes12,081.009,889.0012,117.00 Assets of discontinued operations3,532.004,109.0063,853.00 Total assets253,451.00265,177.00311,072.00 Liabilities and Equity Short-term borrowings4,778.0023,641.0012,776.00 Short-term borrowings assumed by GE- 0- 0- 0 Accounts payable and equipment project accruals16,476.0017,357.0013,826.00 Progress collections and deferred income 18,215.0018,389.0018,983.00 All other current liabilities16,600.0017,820.0014,866.00 Liabilities of businesses held for sale - 01,658.00708.00 Current liabilities56,069.0078,865.0061,159.00 Deferred income1,801.001,555.001,875.00 Long-term borrowings70,288.0067,242.0088,949.00 Long-term borrowings assumed by GE - 0- 0- 0 Insurance liabilities and annuity benefits42,191.0039,826.0035,562.00 Non-current compensation and benefits29,752.0031,687.0031,926.00 All other liabilities16,077.0015,938.0020,839.00 Liabilities of discontinued operations200.00203.0019,281.00 Total liabilities216,378.00235,316.00259,591.00 Preferred stock (5,939,875 shares outstanding at both December 31, 2020 and December 31, 2019)6.006.006.00 Common stock (8,765,493,000 and 8,738,434,000 shares outstanding at December 31, 2020 and December 31, 2019, respectively)702.00702.00702.00 Accumulated other comprehensive income (loss) – net attributable to GE(9,749.00)(11,732.00)(14,414.00) Other capital34,307.0034,405.0035,503.00 Retained earnings92,247.0087,732.0093,109.00 Less common stock held in treasury(81,961.00)(82,797.00)(83,925.00) Total GE shareholders’ equity35,552.0028,316.0030,981.00 Noncontrolling interests1,521.001,545.0020,500.00 Total equity37,073.0029,861.0051,481.00 Total liabilities and equity$253,451.00$265,177.00$311,072.00 Fields Using Formulas Historical Statement of Cash Fl General Electric Co Historical Statement of Cash Flows As on 2020, 2019 and 2018 In Millions 202020192018 Net earnings (loss)$5,546.00($4,912.00)($22,443.00) (Earnings) loss from discontinued operations125.005,335.001,363.00 Adjustments to reconcile net earnings (loss) to cash provided from operating activities: Depreciation and amortization of property, plant and equipment4,636.004,026.004,419.00 Amortization of intangible assets1,382.001,569.002,163.00 Goodwill impairments1,718.001,486.0022,136.00 (Gains) losses on purchases and sales of business interests(12,526.00)(53.00)(1,522.00) (Gains) losses on equity securities 2,105.00(693.00)(166.00) Principal pension plans cost 3,559.003,878.004,226.00 Principal pension plans employer contributions (2,806.00)(298.00)(6,283.00) Other postretirement benefit plans (net) (893.00)(1,228.00)(1,033.00) Provision (benefit) for income taxes (474.00)726.0093.00 Cash recovered (paid) during the year for income taxes (1,441.00)(1,950.00)(1,404.00) Changes in operating working capital: Decrease (increase) in current receivables(1,319.00)(2,851.00)(358.00) Decrease (increase) in inventories, including deferred inventory costs1,105.00(1,581.00)(573.00) Decrease (increase) in current contract assets1,631.00891.00751.00 Increase (decrease) in accounts payable and equipment project accruals(575.00)2,674.00666.00 Increase (decrease) in progress collections and current deferred income(216.00)1,531.00(563.00) All other operating activities2,040.001,869.001,739.00 Cash from (used for) operating activities – continuing operations3,597.0010,419.003,211.00 Cash from (used for) operating activities – discontinued operations- 0(1,647.00)1,767.00 Cash from (used for) operating activities3,597.008,772.004,978.00 Additions to property, plant and equipment(3,252.00)(5,813.00)(6,627.00) Dispositions of property, plant and equipment1,644.003,718.004,093.00 Additions to internal-use software(151.00)(282.00)(320.00) Net decrease (increase) in GE Capital financing receivables(20.00)1,117.001,796.00 Proceeds from sale of discontinued operations- 05,864.0029.00 Proceeds from principal business dispositions20,596.004,683.008,425.00 Net cash from (payments for) principal businesses purchased(85.00)(68.00)(1.00) Capital contribution from GE Industrial to GE Capital- 0- 0- 0 Sales of retained ownership interests417.003,383.00- 0 Net (purchases) dispositions of GE Capital investment securities (Note 3)(1,352.00)(1,616.00)2,534.00 All other investing activities(1,019.00)(302.00)8,996.00 Cash from (used for) investing activities – continuing operations16,778.0010,684.0018,925.00 Cash from (used for) investing activities – discontinued operations(136.00)(1,745.00)(645.00) Cash from (used for) investing activities16,642.008,939.0018,280.00 Net increase (decrease) in borrowings (maturities of 90 days or less)(4,168.00)280.00(4,343.00) Newly issued debt (maturities longer than 90 days)15,028.002,185.003,120.00 Repayments and other reductions (maturities longer than 90 days)(29,876.00)(16,567.00)(20,319.00) Capital contribution from GE Industrial to GE Capital- 0- 0- 0 Dividends paid to shareholders(648.00)(649.00)(4,474.00) All other financing activities(189.00)(1,013.00)(1,329.00) Cash from (used for) financing activities – continuing operations(19,853.00)(15,764.00)(27,345.00) Cash from (used for) financing activities – discontinued operations1.00(369.00)(4,461.00) Cash from (used for) financing activities(19,852.00)(16,133.00)(31,806.00) Effect of currency exchange rate changes on cash, cash equivalents and restricted cash144.00(49.00)(628.00) Increase (decrease) in cash, cash equivalents and restricted cash531.001,529.00(9,176.00) Cash, cash equivalents and restricted cash at beginning of year37,077.0035,548.0044,724.00 Cash, cash equivalents and restricted cash at end of year37,608.0037,077.0035,548.00 Less cash, cash equivalents and restricted cash of discontinued operations at end of year523.00638.004,424.00 Cash, cash equivalents and restricted cash of continuing operations at end of year$37,085.00$36,439.00$31,124.00 Fields Using Formulas Phillips Histrocial Income Stat Philips Group Historical Income Statements As on 2020, 2019 and 2018 In Millions 202020192018 Sales$19,535.00$19,482.00$18,121.00 Cost of sales(10,754.00)(10,607.00)(9,568.00) Gross margin8,781.008,875.008,553.00 Selling expenses(4,606.00)(4,682.00)(4,500.00) General and administrative expenses(668.00)(631.00)(631.00) Research and development expenses(1,915.00)(1,884.00)(1,759.00) Other business income123.00155.0088.00 Other business expenses(173.00)(188.00)(33.00) Income from operations1,542.001,645.001,718.00 Financial income160.00117.0051.00 Financial expenses(204.00)(233.00)(264.00) Investments in associates, net of income taxes(9.00)1.00(2.00) Income before taxes1,489.001,530.001,503.00 Income tax expense(284.00)(337.00)(193.00) Income from continuing operations1,205.001,193.001,310.00 Discontinued operations, net of income taxes(10.00)(19.00)(213.00) Net income$1,195.00$1,174.00$1,097.00 Fields Using Formulas Philips Historical Balance Shee Philips Group Historical Balance Sheets As on 2020, 2019 and 2018 In Millions Assets202020192018 Non-current assets Property, plant and equipment$2,682.00$2,866.00$1,712.00 Goodwill8,014.008,654.008,503.00 Intangible assets excluding goodwill2,997.003,466.003,589.00 Non-current receivables230.00178.00162.00 Investments in associates241.00232.00245.00 Other non-current financial assets430.00248.00360.00 Non-current derivative financial assets6.001.001.00 Deferred tax assets1,820.001,865.001,828.00 Other non-current assets66.0047.0047.00 Total non-current assets16,486.0017,557.0016,447.00 Current assets Inventories2,993.002,773.002,674.00 Other current financial assets-1.00436.00 Other current assets424.00476.00469.00 Current derivative financial assets105.0038.0036.00 Income tax receivable150.00177.00147.00 Current receivables4,156.004,554.004,035.00 Assets classified as held for sale173.0015.0087.00 Cash and cash equivalents3,226.001,425.001,688.00 Total current assets11,227.009,459.009,572.00 Total assets27,713.0027,016.0026,019.00 Equity Common shares182.00179.00185.00 Reserves(340.00)652.00548.00 Other12,028.0011,766.0011,355.00 Equity11,870.0012,597.0012,088.00 Non-controlling interests31.0028.0029.00 Group equity11,901.0012,625.0012,117.00 Non-current liabilities Long-term debt5,705.004,939.003,427.00 Non-current derivative financial liabilities86.00124.00114.00 Long-term
Answered Same DayDec 17, 2021

Answer To: Company Information ACCT 370 Excel Project General Electric Co Multinational Conglomerate Asher...

Nitish Lath answered on Dec 18 2021
102 Votes
Financial Analysis Presentation
Financial Analysis Presentation
Asher Braatz
ACCT 370
Mrs. Geilser
Introduction
General Electric Compan
y
Ticker symbol is (GE)
Aviation, Healthcare, Power and Renewable Energy, These are all the industries they encompass.
The products they sell are - Aircraft engineers, Electrical Distribution, Electric Motors, Energy, Finance, Software. Which is also very complex.
Competitors - 3M, Honeywell, Bentley, Phillips.
Cash Flow
Operating- 2018- 4,978,00/ 2019- 8,772.00/ 2020- 3,597.00
Investing- 2018- 18,280.00/ 2019- 8,939.00/ 2020- 16,642.00
Financing- 2018- 31,806.00/ 2019- 16,133.00/ 2020- 19,852.00
Positive operational cash flows in all years which is a positive indicator.
Cash Flow Contd…
Principal business disposition in all three years and lesser investment in PPE
Increased repayment of debt obligations which has strengthened debt equity proportion (GE, 2021)
Repayment of financing obligations majorly from sale of capital investments which shows the higher disposition of business rather than expansion
Ratio Analysis
Increase in liquidity position over past three years i.e. increase in current ratio from 1.31 times to 1.58 times
Higher liquid assets to settle current obligations i.e. higher quick ratio as compared to its competitors v/s industry average – 1.29 v/s 1.06 v/s 1.25 times (GE, 2021)
Higher leverage ratio due to higher proportion of debt – not...
SOLUTION.PDF

Answer To This Question Is Available To Download