{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Ratio Analysis"],"not_rendered":{"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Ratio Analysis","index":0,"n_rows":40,"n_cols":7,"rows_kept":40,"merged":[[3,2,3,6],[4,3,4,6],[41,2,41,6]]}
[]
[]
[]
[null,null,"Key Ratios - Ratio Analysis"]
[]
[]
[{"$nulls":3},2006,{"$f":"D7+1","v":2007},{"$f":"E7+1","v":2008},{"$f":"F7+1","v":2009}]
[]
[null,null,"Balance Sheet"]
[null,null,"Cash",{"v":451000,"d":"451,000 "},{"v":464530,"d":"464,530 "},{"v":478465.9,"d":"478,466 "},{"v":492819.87700000004,"d":"492,820 "}]
[null,null,"Notes Receivable",{"v":1200,"d":"1,200 "},{"v":3200,"d":"3,200 "},{"v":3000,"d":"3,000 "},{"v":3400,"d":"3,400 "}]
[null,null,"Accounts receivable, net",{"v":350000,"d":"350,000 "},{"v":360500,"d":"360,500 "},{"v":371315,"d":"371,315 "},{"v":382454.45,"d":"382,454 "}]
[null,null,"Total current assets",{"v":1212200,"d":"1,212,200 "},{"v":1250530,"d":"1,250,530 "},{"v":1287749.9,"d":"1,287,750 "},{"v":1326692.397,"d":"1,326,692 "}]
[null,null,"Total long-term assets",{"v":2055000,"d":"2,055,000 "},{"v":2115900,"d":"2,115,900 "},{"v":2178627,"d":"2,178,627 "},{"v":2243235.81,"d":"2,243,236 "}]
[null,null,"Total current liabilities",{"v":936000,"d":"936,000 "},{"v":964080,"d":"964,080 "},{"v":993002.4,"d":"993,002 "},{"v":1022792.4719999998,"d":"1,022,792 "}]
[null,null,"Total long-term liabilities",{"v":780200,"d":"780,200 "},{"v":807850,"d":"807,850 "},{"v":834070,"d":"834,070 "},{"v":861681.9,"d":"861,682 "}]
[null,null,"Total shareholders' equity",{"v":1551000,"d":"1,551,000 "},{"v":1594500,"d":"1,594,500 "},{"v":1639305,"d":"1,639,305 "},{"v":1685454.15,"d":"1,685,454 "}]
[]
[null,null,"Income Statement"]
[null,null,"Total sales",{"v":2010000,"d":"2,010,000 "},{"v":2060000,"d":"2,060,000 "},{"v":2121800,"d":"2,121,800 "},{"v":2391800,"d":"2,391,800 "}]
[null,null,"Gross profit",{"v":1065000,"d":"1,065,000 "},{"v":1086650,"d":"1,086,650 "},{"v":1119249.5,"d":"1,119,250 "},{"v":1270899.5,"d":"1,270,900 "}]
[null,null,"Total operating expenses",{"v":317133,"d":"317,133 "},{"v":320766.99,"d":"320,767 "},{"v":324509.9997000002,"d":"324,510 "},{"v":328149.9997000002,"d":"328,150 "}]
[null,null,"Income (loss) before taxes",{"v":764117,"d":"764,117 "},{"v":782620.51,"d":"782,621 "},{"v":811979.1252999997,"d":"811,979 "},{"v":960976.6252999997,"d":"960,977 "}]
[null,null,"Net income (loss)",{"v":615554,"d":"615,554 "},{"v":633476.62,"d":"633,477 "},{"v":659056.9185999997,"d":"659,057 "},{"v":798347.5285999997,"d":"798,348 "}]
[]
[null,null,"KEY RATIOS"]
[]
[null,null,"Profitability Ratios"]
[null,null,"Return on equity",{"$f":"IF(D17 <> 0, D24/D17, 0)","v":{"v":0.3968755641521599,"d":"40%"}},{"$f":"IF(E17 <> 0, E24/E17, 0)","v":{"v":0.3972885669488868,"d":"40%"}},{"$f":"IF(F17 <> 0, F24/F17, 0)","v":{"v":0.40203434906866004,"d":"40%"}},{"$f":"IF(G17 <> 0, G24/G17, 0)","v":{"v":0.4736690871122183,"d":"47%"}}]
[null,null,"Return on assets",{"$f":"IF(D13+D14<>0,D24/(D13+D14),0)","v":{"v":0.18840413809990206,"d":"19%"}},{"$f":"IF(E13+E14<>0,E24/(E13+E14),0)","v":{"v":0.18817460039270087,"d":"19%"}},{"$f":"IF(F13+F14<>0,F24/(F13+F14),0)","v":{"v":0.19012846485331694,"d":"19%"}},{"$f":"IF(G13+G14<>0,G24/(G13+G14),0)","v":{"v":0.2236312559548343,"d":"22%"}}]
[null,null,"Return on sales",{"$f":"IF(D20<>0,D24/D20,0)","v":{"v":0.3062457711442786,"d":"31%"}},{"$f":"IF(E20<>0,E24/E20,0)","v":{"v":0.3075129223300971,"d":"31%"}},{"$f":"IF(F20<>0,F24/F20,0)","v":{"v":0.31061217767932875,"d":"31%"}},{"$f":"IF(G20<>0,G24/G20,0)","v":{"v":0.3337852364746215,"d":"33%"}}]
[null,null,"Gross profit margin",{"$f":"IF(D20<>0,D21/D20,0)","v":{"v":0.5298507462686567,"d":"53%"}},{"$f":"IF(E20<>0,E21/E20,0)","v":{"v":0.5275,"d":"53%"}},{"$f":"IF(F20<>0,F21/F20,0)","v":{"v":0.5275,"d":"53%"}},{"$f":"IF(G20<>0,G21/G20,0)","v":{"v":0.5313569278367757,"d":"53%"}}]
[null,null,"Asset turnover ratio",{"$f":"IF(D13+D14<>0,D20/(D13+D14),0)","v":{"v":0.615205680705191,"d":"62%"}},{"$f":"IF(E13+E14<>0,E20/(E13+E14),0)","v":{"v":0.6119242045727967,"d":"61%"}},{"$f":"IF(F13+F14<>0,F20/(F13+F14),0)","v":{"v":0.6121088563681578,"d":"61%"}},{"$f":"IF(G13+G14<>0,G20/(G13+G14),0)","v":{"v":0.6699854622594654,"d":"67%"}}]
[]
[null,null,"Leverage and Liquidity Ratios"]
[null,null,"Current ratio",{"$f":"IF(D15<>0,D13/D15,0)","v":{"v":1.2950854700854701,"d":"1.30"}},{"$f":"IF(E15<>0,E13/E15,0)","v":{"v":1.2971226454236162,"d":"1.30"}},{"$f":"IF(F15<>0,F13/F15,0)","v":{"v":1.2968245595378218,"d":"1.30"}},{"$f":"IF(G15<>0,G13/G15,0)","v":{"v":1.2971276513267105,"d":"1.30"}}]
[null,null,"Quick or acid test ratio",{"$f":"IF(D15<>0,(D10+D11+D12)/D15,0)","v":{"v":0.857051282051282,"d":"0.86"}},{"$f":"IF(E15<>0,(E10+E11+E12)/E15,0)","v":{"v":0.8590884573894283,"d":"0.86"}},{"$f":"IF(F15<>0,(F10+F11+F12)/F15,0)","v":{"v":0.8587903715036338,"d":"0.86"}},{"$f":"IF(G15<>0,(G10+G11+G12)/G15,0)","v":{"v":0.8590934632925223,"d":"0.86"}}]
[null,null,"Leverage ratio",{"$f":"IF(D17<>0,(D13+D14)/D17,0)","v":{"v":2.1065119277885236,"d":"211%"}},{"$f":"IF(E17<>0,(E13+E14)/E17,0)","v":{"v":2.1112762621511445,"d":"211%"}},{"$f":"IF(F17<>0,(F13+F14)/F17,0)","v":{"v":2.1145405522462264,"d":"211%"}},{"$f":"IF(G17<>0,(G13+G14)/G17,0)","v":{"v":2.1180808786759346,"d":"212%"}}]
[null,null,"Long-term debt ratio",{"$f":"IF(D16+D17<>0,D16/(D16+D17),0)","v":{"v":0.3346774193548387,"d":"0.335"}},{"$f":"IF(E16+E17<>0,E16/(E16+E17),0)","v":{"v":0.33627489749620165,"d":"0.336"}},{"$f":"IF(F16+F17<>0,F16/(F16+F17),0)","v":{"v":0.3372193864658614,"d":"0.337"}},{"$f":"IF(G16+G17<>0,G16/(G16+G17),0)","v":{"v":0.33829441501564084,"d":"0.338"}}]
[null,null,"Debt to equity ratio",{"$f":"IF(D17<>0,(D15+D16)/D17,0)","v":{"v":1.1065119277885236,"d":"1.107"}},{"$f":"IF(E17<>0,(E15+E16)/E17,0)","v":{"v":1.1112762621511445,"d":"1.111"}},{"$f":"IF(F17<>0,(F15+F16)/F17,0)","v":{"v":1.1145408572535311,"d":"1.115"}},{"$f":"IF(G17<>0,(G15+G16)/G17,0)","v":{"v":1.1180810655691822,"d":"1.118"}}]