Question

1 Approved Answer

Posted on Jul 11, 2024

Clipboard Font Alignment Number A3 fi Longwood Laser Engraving Corp. has prepared the following financial statements. Set up a ra ratios for Longwood Laser Engraving.

image text in transcribed

Clipboard Font Alignment Number A3 fi Longwood Laser Engraving Corp. has prepared the following financial statements. Set up a ra ratios for Longwood Laser Engraving. Make sure you calculate the ratios for both 2008 and 2 careful about the formats of the cells. Conditional Formatting is not required in this exercise. 8 32 33 D Total Owner's Equity Total Liah & Owner's Equity E 1,436,900 S3,145,000 1,138,000 $2,539,000 34 35 36 Ratio 37 2009 Ratio Trend 2008 Liquidity Ratios Sell Analysis Efficiency Ratios 365/(Average Receivable Turnover) Leverage Ratios 38 Current Ratio 39 Quick Ratio 40 41 Inventory Turnover 42 A/R Turnover 43 Average Collection Period 44 Fixed Asset Turnover 45 Total Assct Tumover 46 47 Total Debt Ratio al Asset 48 Debt to Equity 49 50 Times Interest Earried 51 52 Cross Profit Margin 53 Net Profit Margin 54 Return on Total Assets 55 Return on Equity 56 Earnings per Share 57 Tax Rate Coverage Ratios Profitability Ratios LongWood FA Apple FA Blue Sky FA Ready Type here to search AL O E HE BE AutoSave Topic Three Ratio Analysis 3 (1) - Excel ile Home Insert Page Layout Formulas Data Review View Help O Search X Times New Roma - 11 === ab Wrap Text Custom BIU a.A Merge Bl Center $ %98- Conditional Format Formatting Table Clipboard Font Alignment Number Styles > fax 310000 B D 1 2 Ratin Analysis 3. Lungwood Laser Engraving Corp. has prepared the following linancial statements. Set up a ratin workabel slumber to the one discussed in class. Calculace all of the calls for Longwood Laser Engraving. Make sure you calculate 4 mins for both and 2009. IT function to conduct the self analysererate. Be careful about the mats of the cell. Conditional Formatting is not required in this cerise Logo Laser Engraving Incen Name For the Year 2008 and 2009 www 52.900.000 2.030.000 870.000 62,000 Longwood lasergraving Balance Sheet For the Year Emiled reember 51, 241119 2009 70 19 12 Sales font 3 nds 12 4 Pro Cros Profit 15 Deprecation The Adm. Expense 20 2004 32.350.000 1.045.000 Cash TUS,DU Marketable cu 18.00 Accornis Recente 1B Nel Opaling menm ( 19 Expo Laming efore lates 318.000 112.000 2011 72.100 $133,00 65.000 TOMMY 192/100 Foods ... 68 lepecson 124,000 Mar Pawat Fat Yaral Issers 58,00 J. Chrique 24111 120100 51.5.000 1.0.2.00 2 AICI 1312) 2.137.500.00 53.16.00 37200 20.000 354.000 1.10,000 1185 2,685,000.00 97.50.000 22 Net Income (available Luxurx) 25 24 Notes Adelp 30.000 1X TI 27 LO 2 DELI 35.00 SA LA IN 1,700.00 1.100 US1000 1.400.000 : Nacral Kas 50 31 Long Wood FA Apple FA Blue Sky FA + + Ready 1 Type here to search 26 x Times New Roma 11 ' ab Wrap Text Custom B U v ara Merge & Center $ % ) lipboard Font Alignment Number 4 4 fx 310000 B c D Retained Eames Total Omar's Eyzny Total Liab. & ener's Eywing E 6169.000 1,136.000 S3,145,000 536.000 1.138.000 52,539,000 Rathe 2009 2008 Liquidity Ratios Ratio Trend Sell Analysis Current Ratio Quick Rat Eficiency Ratios Inventory Turnover ARTOVCI Average Collection Period Fixel Asset Tuove Total Asset over 365/Average Receivable Tumover) Leverage Ratios Total Delst Ratio at Asset Debt to Equity Coverage Racing I'mnes laterest Eames Profitability Ratios Gross Profit Mangin 3 Net Profit Marm 4 Hour on lolal Assets -5 Rehin om uity 66 Earnings por Share 57 Tax Ratio 59 51 Long Wood FA Apple FA Blue Sky FA + Ready Type here to search 26 Clipboard Font Alignment Number A3 fi Longwood Laser Engraving Corp. has prepared the following financial statements. Set up a ra ratios for Longwood Laser Engraving. Make sure you calculate the ratios for both 2008 and 2 careful about the formats of the cells. Conditional Formatting is not required in this exercise. 8 32 33 D Total Owner's Equity Total Liah & Owner's Equity E 1,436,900 S3,145,000 1,138,000 $2,539,000 34 35 36 Ratio 37 2009 Ratio Trend 2008 Liquidity Ratios Sell Analysis Efficiency Ratios 365/(Average Receivable Turnover) Leverage Ratios 38 Current Ratio 39 Quick Ratio 40 41 Inventory Turnover 42 A/R Turnover 43 Average Collection Period 44 Fixed Asset Turnover 45 Total Assct Tumover 46 47 Total Debt Ratio al Asset 48 Debt to Equity 49 50 Times Interest Earried 51 52 Cross Profit Margin 53 Net Profit Margin 54 Return on Total Assets 55 Return on Equity 56 Earnings per Share 57 Tax Rate Coverage Ratios Profitability Ratios LongWood FA Apple FA Blue Sky FA Ready Type here to search AL O E HE BE AutoSave Topic Three Ratio Analysis 3 (1) - Excel ile Home Insert Page Layout Formulas Data Review View Help O Search X Times New Roma - 11 === ab Wrap Text Custom BIU a.A Merge Bl Center $ %98- Conditional Format Formatting Table Clipboard Font Alignment Number Styles > fax 310000 B D 1 2 Ratin Analysis 3. Lungwood Laser Engraving Corp. has prepared the following linancial statements. Set up a ratin workabel slumber to the one discussed in class. Calculace all of the calls for Longwood Laser Engraving. Make sure you calculate 4 mins for both and 2009. IT function to conduct the self analysererate. Be careful about the mats of the cell. Conditional Formatting is not required in this cerise Logo Laser Engraving Incen Name For the Year 2008 and 2009 www 52.900.000 2.030.000 870.000 62,000 Longwood lasergraving Balance Sheet For the Year Emiled reember 51, 241119 2009 70 19 12 Sales font 3 nds 12 4 Pro Cros Profit 15 Deprecation The Adm. Expense 20 2004 32.350.000 1.045.000 Cash TUS,DU Marketable cu 18.00 Accornis Recente 1B Nel Opaling menm ( 19 Expo Laming efore lates 318.000 112.000 2011 72.100 $133,00 65.000 TOMMY 192/100 Foods ... 68 lepecson 124,000 Mar Pawat Fat Yaral Issers 58,00 J. Chrique 24111 120100 51.5.000 1.0.2.00 2 AICI 1312) 2.137.500.00 53.16.00 37200 20.000 354.000 1.10,000 1185 2,685,000.00 97.50.000 22 Net Income (available Luxurx) 25 24 Notes Adelp 30.000 1X TI 27 LO 2 DELI 35.00 SA LA IN 1,700.00 1.100 US1000 1.400.000 : Nacral Kas 50 31 Long Wood FA Apple FA Blue Sky FA + + Ready 1 Type here to search 26 x Times New Roma 11 ' ab Wrap Text Custom B U v ara Merge & Center $ % ) lipboard Font Alignment Number 4 4 fx 310000 B c D Retained Eames Total Omar's Eyzny Total Liab. & ener's Eywing E 6169.000 1,136.000 S3,145,000 536.000 1.138.000 52,539,000 Rathe 2009 2008 Liquidity Ratios Ratio Trend Sell Analysis Current Ratio Quick Rat Eficiency Ratios Inventory Turnover ARTOVCI Average Collection Period Fixel Asset Tuove Total Asset over 365/Average Receivable Tumover) Leverage Ratios Total Delst Ratio at Asset Debt to Equity Coverage Racing I'mnes laterest Eames Profitability Ratios Gross Profit Mangin 3 Net Profit Marm 4 Hour on lolal Assets -5 Rehin om uity 66 Earnings por Share 57 Tax Ratio 59 51 Long Wood FA Apple FA Blue Sky FA + Ready Type here to search 26