{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Financial Statement Ratios"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Financial Statement Ratios","index":0,"n_rows":38,"n_cols":8,"rows_kept":38,"merged":[[40,2,40,7]]}
[]
[]
[null,null,"Financial Statement Ratio Analysis"]
[null,null,"Your Company, inc."]
[null,null,"2009"]
[]
[]
[{"$nulls":5},"Historical",null,"Projected"]
[{"$nulls":5},{"$f":"IF(SUM(C5),C5,\"Year 1\")","v":"Year 1"},null,{"$f":"IF(SUM(C5),C5+1,\"Year 2\")","v":"Year 2"}]
[null,null,"Current Assets",null,null,{"v":4476452,"d":"$4,476,452"},null,{"v":4700000,"d":"$4,700,000"}]
[null,null,"Inventory",null,null,{"v":1000000,"d":"$1,000,000"},null,{"v":1200000,"d":"$1,200,000"}]
[null,null,"Current Liabilities",null,null,{"v":1944305,"d":"$1,944,305"},null,{"v":2100000,"d":"$2,100,000"}]
[]
[null,null,"Net Working Capital",null,null,{"$f":"IF(SUM(F10,F12),F10-F12,\"\")","v":{"v":2532147,"d":"$2,532,147"}},null,{"$f":"IF(SUM(H10,H12),H10-H12,\"\")","v":{"v":2600000,"d":"$2,600,000"}}]
[null,null,"Current Ratio",null,null,{"$f":"IF(F12,F10/F12,\"\")","v":{"v":2.302340424984763,"d":"2.30"}},null,{"$f":"IF(H12,H10/H12,\"\")","v":{"v":2.238095238095238,"d":"2.24"}}]
[null,null,"Quick Ratio",null,null,{"$f":"IF(F14,(F10-F11)/F12,\"\")","v":{"v":1.7880178264212663,"d":"1.79"}},null,{"$f":"IF(H14,(H10-H11)/H12,\"\")","v":{"v":1.6666666666666667,"d":"1.67"}}]
[null,null,"Profitability Analysis"]
[null,null,"Sales",null,null,{"v":9188748,"d":"$9,188,748"},null,{"v":10000000,"d":"$10,000,000"}]
[null,null,"Cost of Sales",null,null,{"v":6844915,"d":"$6,844,915"},null,{"v":6900000,"d":"$6,900,000"}]
[null,null,"Gross Profit",null,null,{"$f":"IF(SUM(F18:F19),F18-F19,\"\")","v":{"v":2343833,"d":"$2,343,833"}},null,{"$f":"IF(SUM(H18:H19),H18-H19,\"\")","v":{"v":3100000,"d":"$3,100,000"}}]
[null,null,"Income from Operations",null,null,{"v":522274,"d":"$522,274"},null,{"v":522274,"d":"$522,274"}]
[null,null,"Net Income",null,null,{"v":310178,"d":"$310,178"},null,{"v":310178,"d":"$310,178"}]
[]
[null,null,"Gross Profit Margin",null,null,{"$f":"IF(F18,F20/F18,\"\")","v":{"v":0.25507642608111575,"d":"25.5%"}},null,{"$f":"IF(H18,H20/H18,\"\")","v":{"v":0.31,"d":"31.0%"}}]
[null,null,"Operating Profit Margin",null,null,{"$f":"IF(F18,F21/F18,\"\")","v":{"v":0.05683842891327524,"d":"5.7%"}},null,{"$f":"IF(H18,H21/H18,\"\")","v":{"v":0.0522274,"d":"5.2%"}}]
[null,null,"Net Profit Margin",null,null,{"$f":"IF(F18,F22/F18,\"\")","v":{"v":0.03375628540471455,"d":"3.4%"}},null,{"$f":"IF(H18,H22/H18,\"\")","v":{"v":0.0310178,"d":"3.1%"}}]
[null,null,"Debt Ratios"]
[null,null,"Total Assets",null,null,{"v":5300000,"d":"$5,300,000"},null,{"v":5500000,"d":"$5,500,000"}]
[null,null,"Total Liabilities",null,null,{"v":4100000,"d":"$4,100,000"},null,{"v":3900000,"d":"$3,900,000"}]
[null,null,"Total Owners' Equity",null,null,{"$f":"IF(SUM(F28:F29),F28-F29,\"\")","v":{"v":1200000,"d":"$1,200,000"}},null,{"$f":"IF(SUM(H28:H29),H28-H29,\"\")","v":{"v":1600000,"d":"$1,600,000"}}]
[]
[null,null,"Debt to Assets",null,null,{"$f":"IF(F28,F29/F28,\"\")","v":{"v":0.7735849056603774,"d":"77.4%"}},null,{"$f":"IF(H28,H29/H28,\"\")","v":{"v":0.7090909090909091,"d":"70.9%"}}]
[null,null,"Debt to Equity",null,null,{"$f":"IF(SUM(F30),F29/F30,\"\")","v":{"v":3.4166666666666665,"d":"342%"}},null,{"$f":"IF(SUM(H30),H29/H30,\"\")","v":{"v":2.4375,"d":"244%"}}]
[null,null,"Investment Return"]
[null,null,"Net Income",null,null,{"$f":"IF(F22,F22,\"\")","v":{"v":310178,"d":"$310,178"}},null,{"$f":"IF(H22,H22,\"\")","v":{"v":310178,"d":"$310,178"}}]
[null,null,"Total Assets",null,null,{"$f":"IF(F28,F28,\"\")","v":{"v":5300000,"d":"$5,300,000"}},null,{"$f":"IF(H28,H28,\"\")","v":{"v":5500000,"d":"$5,500,000"}}]
[]
[null,null,"Return on Investment",null,null,{"$f":"IF(SUM(F36),F35/F36,\"\")","v":{"v":0.058524150943396226,"d":"5.9%"}},null,{"$f":"IF(SUM(H36),H35/H36,\"\")","v":{"v":0.056396,"d":"5.6%"}}]