90.2K

Verified Solution

Link Copied!

Company "M" Income Statement Fiscal Year End: December 31, Amounts in $M USD 2007 2008 2009 2010 2011 2012 Net Income 663.0 71.0 (453.0) 1,003.0 1,018.0 1,394.0 Depreciation & Amort. 916.0 951.0 799.0 723.0 766.0 843.0 Depreciation & Amort., Total 916.0 951.0 799.0 723.0 766.0 843.0 Other Amortization - 62.0 27.0 19.0 6.0 0 (Gain) Loss On Sale Of Invest. - - - (16.0) - - Asset Writedown & Restructuring Costs 56.0 283.0 183.0 23.0 21.0 21.0 (Income) Loss on Equity Invest. (11.0) (19.0) (112.0) (132.0) (121.0) (135.0) Other Operating Activities 63.0 (19.0) 138.0 103.0 151.0 (36.0) Change in Acc. Receivable 36.0 826.0 (38.0) (589.0) (909.0) (298.0) Change In Inventories (97.0) (124.0) 14.0 (164.0) (282.0) (334.0) Change in Acc. Payable (259.0) (475.0) 226.0 550.0 475.0 184.0 Change in Unearned Rev. (21.0) (26.0) (14.0) (3.0) (4.0) (2.0) Change in Inc. Taxes 66.0 (232.0) 134.0 212.0 (29.0) 55.0 Change in Other Net Operating Assets 181.0 (244.0) (385.0) 149.0 118.0 203.0 Cash from Ops. 1,593.0 1,054.0 519.0 1,878.0 1,210.0 1,895.0 Capital Expenditure (741.0) (739.0) (616.0) (746.0) (1,236.0) (1,324.0) Sale of Property, Plant, and Equipment 109.0 65.0 68.0 244.0 168.0 151.0 Cash Acquisitions (46.0) (158.0) (50.0) (106.0) (120.0) (180.0) Divestitures - - - (91.0) (39.0) 0 Invest. in Marketable & Equity Securt. (190.0) (231.0) (236.0) (119.0) 139.0 59.0 Net (Inc.) Dec. in Loans Originated/Sold - - - - - - Other Investing Activities - - - - (184.0) (212.0) Cash from Investing (868.0) (1,063.0) (834.0) (818.0) (1,272.0) (1,506.0) Short Term Debt Issued 16.0 827.0 - - 150.0 - Long-Term Debt Issued 12.0 3.0 5.0 22.0 11.0 - Total Debt Issued 28.0 830.0 5.0 22.0 161.0 263.0 Short Term Debt Repaid - - (851.0) (8.0) - - Long-Term Debt Repaid (79.0) (354.0) (296.0) (71.0) (24.0) - Total Debt Repaid (79.0) (354.0) (1,147.0) (79.0) (24.0) (152.0) Issuance of Common Stock 1,560.0 - 2.0 48.0 59.0 6.0 Repurchase of Common Stock (1,334.0) (247.0) - (323.0) (407.0) (143.0) Common Dividends Paid (131.0) (140.0) (21.0) (100.0) (236.0) (248.0) Total Dividends Paid (131.0) (140.0) (21.0) (100.0) (236.0) (248.0) Special Dividend Paid - - - - - - Other Financing Activities - - (1.0) (12.0) (10.0) (8.0) Cash from Financing 44.0 89.0 (1,162.0) (444.0) (457.0) (282.0) Foreign Exchange Rate Adj. 300.0 (277.0) 60.0 (5.0) (37.0) 13.0 Net Change in Cash 1,069.0 (197.0) (1,417.0) 611.0 (556.0) 120.0 Ratios Growth Rates 2007 2008 2009 2010 2011 2012 Revenue Growth % increase year over year Gross Profit EBITDA EBIT Net Income Profitability Return on Assets Return on Equity Gross Margin % Liquidity Current Ratio Quick Ratio Avg Days Sales Outstanding Avg Days Payable Outstanding Long Term Solvency Total Debt / Equity Total Debt/Tangible Net Worth Operational Efficiency Accounts Receivable Turnover Inventory Turnover

Financial Summary What would the net effect of the company adding a $10,000,000 Term Loan that will be used to finance a foreign explansion plan @ prime plus 1.5% to be repaid in 10 years. Would you give the loan? What conditions would you add, if any?

Restructuring Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest. (84.0) (26.0)(32.0) 100.0) 153.0 129.0)(16.0) 1.0) 15.0 (1a) 1,700.0 30.0 10.0 Asset Wntedown Insurance Settiements Other Unusual Items (283.0) (830) (230) 26.0 477.0) 15.0 22.0) 1,217.0 EBT Incl Unusual Items 1,152.0 328.0 1,197.0 Income Tax Expense Earnings from Cont. Ops. 2020 3130 ,387.0 90 663.0 Earnings of Discontinued Ops Extraord Item & Account. Change Net Income to Company 663.0 71.0 (453.0) 1,387.0 Minority Int, in Eamings r0 Net Income Restructuring Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest. (84.0) (26.0)(32.0) 100.0) 153.0 129.0)(16.0) 1.0) 15.0 (1a) 1,700.0 30.0 10.0 Asset Wntedown Insurance Settiements Other Unusual Items (283.0) (830) (230) 26.0 477.0) 15.0 22.0) 1,217.0 EBT Incl Unusual Items 1,152.0 328.0 1,197.0 Income Tax Expense Earnings from Cont. Ops. 2020 3130 ,387.0 90 663.0 Earnings of Discontinued Ops Extraord Item & Account. Change Net Income to Company 663.0 71.0 (453.0) 1,387.0 Minority Int, in Eamings r0 Net Income

Answer & Explanation Solved by verified expert

See Answer