File Home Insert Page Layout Formulas Chapter 14 and 15 (5) (Protected View - Excel Tell me what you want to do Data Review View PROTECTED VIEW Be careful-Hes from the Internet can contain viruses. Unless you need to fit it's safe to stay in Protected view Enable Edition 25 X DE 1. Ratio Analysis 3 NURTISYSTEM, INC 4 RATIO 5 Liquidity Ratios 6 Quick 7 Current 2014 2013 0.802310953 0.716937343 1.480596899 1.458271064 2014 2012 2011 2010 industry average 0.80173703 1.692120-107 1.272564542 1.00 1.903111699 2.874944666 2.866175877 2.00 9 Leverage Ratios: 10 Debt Ratio 11 Times interest Earned 12 Debt to net worth 055 0.494822189 0.490878032 0.389173474 0.501456563 0.500003334 205.943662 123.247191 -2.18560708 40.87393162 #DIV/0! 0.979501036 0.964165834 0.637125888 1.005843272 1.000013338 13 10.00 37.00 14 Activity Ratios: 15 Inventory Turnover 16 Days Sales in Inventory 17 Accounts Receivable Turnover 18 Average Collection Period 19 Fixed Asset Turnover 20 Total Asset Turnover 7.40001487 7,061100099,015114972 6.295773307 7.8.20155147 49.32422521 51.69165626404660 57.97540385 46.67426581 33.02334917 46.276298 79 45.76304937 35.83997142 55.04699654 11.05278565 7 3 6 735778 10 18415991 6.6306978 15.01184313 13.7571939 14.17269578 13.48076988 14.84427806 3.667992211 3.49539753 4.033067009 2.669273847 3.39780132 22 Profitability Ratios: 23 Profit Margin Return on investment 25 Return on Total Equity 0.047908247 0020581648-0007067663 0.030550451 0.066017683 0.175727077 0.071941042 -0025504359 0.081547548 0.224316953 0.347851932 0.141304139 0.06666225 0.1635716 0.448636897 29 required: 31 Identity 10 things you think are significant in these ratios. These can relate to patterns 32 you see in a particular ratio over the years presented, or a comparison of the most recent year 2014 33 to the industry were As part of your answer you must say why you think it is important and why you selected 34 that item for significant 36 Additionally, you must do at least one ratio from each of the following major sections 30 Liquidity ratios Sheet1 Sheet2 Type here to search HP L1706 hp File Chapter 14 and 15 (5) Protected View - Excel Home Insert Page Layout Formulas Data Review View Tell me what you want to do PROTECTED VIEW Be carefullestrom the Internet can contain Viruses. Unless you need to edit it's safe to stay in Protected view Enable Editing K25 fo 10.00 37.00 14 Activity Ratios: 15 Inventory Turnover 16 Days Sales in Twentory 17 Accounts Receivable Turnover 18 Average Collection Period 19 Fixed Asset Turnover 20 Total Asset Turnover 7.40001487 7.0611005999015314972 6.295773307 7.8.20155147 49.32422521 51.6916562640.48665088 57.97540385 46.6226581 33,02334917 46.276297 46.7630497 35.83997142 55.00099654 11.05278565 7.887406936 7.BO530792810.15115991 6.63069782 15.01184313 13.7571939 14.17264578 13.4807518 14.84427905 3.667932211 3.49539753 4013067089 2.669273517 39783132 22 Profitability Ratios: 23 Profit Margin 24 Return on investment 25 Return on Total Equity 0.04790827 0.020581643 -0.002067663 0.030550461 0.06601763 0.175727077 0.071141042 0.028504359 08154154 0.22316953 0.347851932 0.141304139 0.016665225 0.1635716 0.448636897 29 required: 31 Identity 10 things you think are significant in these ratios. There can relate to patterns 32 you see in a particular ratio over the years presented, or a comparison of the most recent year 2014 33 to the industry average. As part of your answer you must say why you think it is important and why you selected 34 that em for significance. Additionally, you must do at least one ratio from each of the following major ti EF Type here to search HP 1700 hp Home Insert Page Layout Formulas Dita Review Chapter 14 and 15 Protected el-rel View Tell me what you want to do PROTECTED VIEW Becau-Riebrom the internet con continues. Unless you need to it's to stay in Protected View. able Editing X i n the yellow spaces with the correct numbers Johnson Corporation for the year ended December 31, 2019 Beging Duct Materials Purchase of Direct Materials Direct Materials Available for U Ending wet Material De Materials Used Director Manufacturing Overhead Mantung Cost ed the current Manufacturing Cost Account Ending Work in process le Home Insert Page Layout Formula Date Review View Chapter 14 and 15 Protected Viel-Becel all me what you want to die to Protected View PONCHO VIEW Be r me o .com you fill in the yellow e s with the correct numbers Ending Direct Materials Dessed Direct labor Manufacturing Costs incurred During the current Period Beginning Work in Pro Goods for Sale Endnud File Home Insert Page Layout Formulas Chapter 14 and 15 (5) (Protected View - Excel Tell me what you want to do Data Review View PROTECTED VIEW Be careful-Hes from the Internet can contain viruses. Unless you need to fit it's safe to stay in Protected view Enable Edition 25 X DE 1. Ratio Analysis 3 NURTISYSTEM, INC 4 RATIO 5 Liquidity Ratios 6 Quick 7 Current 2014 2013 0.802310953 0.716937343 1.480596899 1.458271064 2014 2012 2011 2010 industry average 0.80173703 1.692120-107 1.272564542 1.00 1.903111699 2.874944666 2.866175877 2.00 9 Leverage Ratios: 10 Debt Ratio 11 Times interest Earned 12 Debt to net worth 055 0.494822189 0.490878032 0.389173474 0.501456563 0.500003334 205.943662 123.247191 -2.18560708 40.87393162 #DIV/0! 0.979501036 0.964165834 0.637125888 1.005843272 1.000013338 13 10.00 37.00 14 Activity Ratios: 15 Inventory Turnover 16 Days Sales in Inventory 17 Accounts Receivable Turnover 18 Average Collection Period 19 Fixed Asset Turnover 20 Total Asset Turnover 7.40001487 7,061100099,015114972 6.295773307 7.8.20155147 49.32422521 51.69165626404660 57.97540385 46.67426581 33.02334917 46.276298 79 45.76304937 35.83997142 55.04699654 11.05278565 7 3 6 735778 10 18415991 6.6306978 15.01184313 13.7571939 14.17269578 13.48076988 14.84427806 3.667992211 3.49539753 4.033067009 2.669273847 3.39780132 22 Profitability Ratios: 23 Profit Margin Return on investment 25 Return on Total Equity 0.047908247 0020581648-0007067663 0.030550451 0.066017683 0.175727077 0.071941042 -0025504359 0.081547548 0.224316953 0.347851932 0.141304139 0.06666225 0.1635716 0.448636897 29 required: 31 Identity 10 things you think are significant in these ratios. These can relate to patterns 32 you see in a particular ratio over the years presented, or a comparison of the most recent year 2014 33 to the industry were As part of your answer you must say why you think it is important and why you selected 34 that item for significant 36 Additionally, you must do at least one ratio from each of the following major sections 30 Liquidity ratios Sheet1 Sheet2 Type here to search HP L1706 hp File Chapter 14 and 15 (5) Protected View - Excel Home Insert Page Layout Formulas Data Review View Tell me what you want to do PROTECTED VIEW Be carefullestrom the Internet can contain Viruses. Unless you need to edit it's safe to stay in Protected view Enable Editing K25 fo 10.00 37.00 14 Activity Ratios: 15 Inventory Turnover 16 Days Sales in Twentory 17 Accounts Receivable Turnover 18 Average Collection Period 19 Fixed Asset Turnover 20 Total Asset Turnover 7.40001487 7.0611005999015314972 6.295773307 7.8.20155147 49.32422521 51.6916562640.48665088 57.97540385 46.6226581 33,02334917 46.276297 46.7630497 35.83997142 55.00099654 11.05278565 7.887406936 7.BO530792810.15115991 6.63069782 15.01184313 13.7571939 14.17264578 13.4807518 14.84427905 3.667932211 3.49539753 4013067089 2.669273517 39783132 22 Profitability Ratios: 23 Profit Margin 24 Return on investment 25 Return on Total Equity 0.04790827 0.020581643 -0.002067663 0.030550461 0.06601763 0.175727077 0.071141042 0.028504359 08154154 0.22316953 0.347851932 0.141304139 0.016665225 0.1635716 0.448636897 29 required: 31 Identity 10 things you think are significant in these ratios. There can relate to patterns 32 you see in a particular ratio over the years presented, or a comparison of the most recent year 2014 33 to the industry average. As part of your answer you must say why you think it is important and why you selected 34 that em for significance. Additionally, you must do at least one ratio from each of the following major ti EF Type here to search HP 1700 hp Home Insert Page Layout Formulas Dita Review Chapter 14 and 15 Protected el-rel View Tell me what you want to do PROTECTED VIEW Becau-Riebrom the internet con continues. Unless you need to it's to stay in Protected View. able Editing X i n the yellow spaces with the correct numbers Johnson Corporation for the year ended December 31, 2019 Beging Duct Materials Purchase of Direct Materials Direct Materials Available for U Ending wet Material De Materials Used Director Manufacturing Overhead Mantung Cost ed the current Manufacturing Cost Account Ending Work in process le Home Insert Page Layout Formula Date Review View Chapter 14 and 15 Protected Viel-Becel all me what you want to die to Protected View PONCHO VIEW Be r me o .com you fill in the yellow e s with the correct numbers Ending Direct Materials Dessed Direct labor Manufacturing Costs incurred During the current Period Beginning Work in Pro Goods for Sale Endnud