Longwood Laser Engraving Corp. has prepared the following financial statements. Set up a ratio worksheet similar to the one discussed in class. Calculate all of the ratios for Longwood Laser Engraving. Make sure you calculate the ratios for both 2008 and 2009. Use IF function to conduct the self analysis after those ratios. Be careful about the formats of the cells. Conditional Formatting is not required in this exercise.

Conditional Formatting is not required in this exercise, The Cens, 2S 7 D 8 Longwood Laser Engraving 9 Income Statement Longwood Laser Engraving 10 For the Years 2008 and 2009 Balance Sheet 11 For the Year Ended December 31, 2009 12 Sales (on Credit) 2008 2009 S2.900,000 $2.350,000sets 13 Cost of Goods 2.030,000 1.645,000 Cash Gross Profit S52,000 870,000 705,000 Marketable Securities 25.000 15 Depreciation 62,000 58.000 Accounts Receivable 420.000 16 Selling & Admin Expense 425,000 190.000 Inventory 515.000 17 Lease Expense 65.000 65.000 Total Current Assets 1,012.000 18 Net Operating Income (EBIT) 318.000 192,000 Gross Fixed Assets 2.680.000 19 Interest Expense 112.000 68,000 Accumulated Depreciation (547.000,00) 20 Earnings Before Taxes 206,000 124,000 Ner Plant & Equipment 2.133.000.00 21 Taxes 72.100 43.100 Total $3.145,000 22 Net Income (available to shareholders) $133.900 S80.600 23 Liabilities wwer's Equity 24 Notes: Accounts Payable S505.000 25 Accrued Expenses 35.000 38.000 26 Shares 30,000 540.000 Total Current Liabilities 27 Long-term Debt 1.168 100 28 Total Labs 1.70, 100 Common Stock (52) 76.000 29 Additional Paid in Capital 691.000 30 LongWood FA Blue Sky FA 541,000 21.000 372.000 420.000 834,000 2170000 (485,000.00 1,685,000.00 52,539.000 5310.000 30.000 340,000 1,061,000 1.401.000 60.000 50.000 Apple FA Edit EDT A 2 Alerts Gold olenergy E Type here to search Zoom ve Oft Topic_Three Ratio Analysis 3 (1) - Excel Home Insert Page Layout Formulas Data Review View Help O Search Sh X Times New R 11 I U AA A General $ % 40 00 .00 Conditional Formatting Format as Table Cell Styles 2 Cells Editing Ide ard Font Alignment Number Styles Idea fx Longwood Laser Engraving Corp. has prepared the following financial statements. Set up worksheet similar to the one discussed in class. Calculate all of the ratios for Longwood La Engraving. Make sure you calculate the ratios for both 2008 and 2009. Use IF function to B D tio Analysis gwood Laser Engraving Corp. has prepared the following financial statements. Set up a ratio worksheet similar to the one discussed in class. Calculate all of the ratios for Longwo both 2008 and 2009. Use IF function to conduct the self analysis after those ratios. Be careful about the formats of the cells. Conditional Formatting is not required in this exercis 2008 Longwood Laser Engraving Income Statement For the Years 2008 and 2009 2009 les (on Credit) $2,900,000 ist of Good 2,030,000 Gross Profit 870,000 ociation 62.000 elling & Admin Expense 425,000 case Expense 65,000 Net Operating Income (EBIT) 318.000) INILTUS F.xpicus 112.000 Farmings Before Taxes 206,000 Taxes 72,100 Net Income (wynilable to shareholders) S133,900 Longwood Luser Engraving Balance Sheet For the Year Ended December 31, 2009 2008 2009 $2,350,000 Assets 1,645,000 Cash S52,000 705,000 Murketable Securities 25,000 58,000 As Receivable 420.000 390,000 Inventory 515.000 65,000 Focal current Anne 1,012.000 192,OCKICS Fixed Assets 2,680,000 68,000 Accumulated Depreciation (547,000.00) 124,000 Ner Plan laut 2, 133,000.00 43,400 Total Mets 53,145,000 S80,600 Lahilities & Owner's Eqwiy Accounts Payable SSUS.NO 541,00 21,000 372.000 420.000 854.000 2.170,000 (455,000.00) 1,685,000.00 S2.539.000 5310.000 Notes: LongWood FA Apple FA Blue Sky FA + eady ype here to search Topic_Three Ratio Analysis 3 (1) - Excel Eve Off Sha Search Data View Review Help Formulas Home Insert Page Layout X General $ %> .00 Conditional Formatting 2 Format as Table Cell Styles Cells Times New R 11 BIU A A A A O A Editing Idea Ideas Number Styles Alignment oard Font f Longwood Laser Engraving Corp. has prepared the following financial statements. Set up worksheet similar to the one discussed in class. Calculate all of the ratios for Longwood La Engraving. Make sure you calculate the ratios for both 2008 and 2009. Use IF function to F D B $133.900 Net Income (available to shareholders) $80,600 Liabilities & Owner's Eynity Accounts Payable Accrued Expenses 30.000 Total Current Liabilities Notes: 38.000 Shares Long-tem Debi Folal liabilmes Common Stock (S2 par) Additional Paid-in-Capital Rctained Famings Toral wder's Party Total Liah & Owner's Equity SS05,000 35,000 $40,000 1.168.100 1,708,100 76,000 401 000 669.900 1,136.900 $3,145.000 $310.000 30.000 340,000 1.061.000 1.401,000 60.000 $42.000 536.000 1.138.000 $2.539,000 3 4 Ratio Trend Sell Analysis 2009 2008 Liquidity Katios Elliciency Ratius 3 Ratin 37 38 Current Ratio 39 Quick Ratio 4 41 Laversity Tur 42 AR TOT 13 Avent Collection Period 44 Fixed Asset Tover 45 Tonal Asset Tumevc 365/ Average Receivable Turnover) Long Wood FA Apple FA Blue Sky FA + Ready O FE Type here to search ile Home Insert Page Layout Formulas Data Review View Help Search X Times New R 11 B T == ab General $ % Conditional Formatting Format as Table Cell Styles Cells Clipboard Font Alignment Number Styles 3 > fx Longwood Laser Engraving Corp. has prepared the following financial staten worksheet similar to the one discussed in class. Calculate all of the ratios for Engraving. Make sure you calculate the ratios for both 2008 and 2009. Use IF B C Efficiency Ratios D Inventory Tumover AR Tower 3 Average Collection Period 4 Tixed Asset Turnover Total Asset Tumover 365/(Average Receival Leverage Ratios 17 Total Debt Ratio at Asset 18 Debt to F.quity Coverage Katios 50 Times Interest Eamed Profitability Ratius - 52 Gross Profit Margin 53 Net Profit Margin 54 Return on Total Assets 55 Return on Equity 56 Farings per Share 57 Tax Rate 58 59 60 61 62 63 LongWood FA Apple FA Blue Sky FA + Ready Type here to search