{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Data Entry","Comprehensive Ratio Analysis"],"not_rendered":{"defined_names":86,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Data Entry","index":0,"n_rows":109,"n_cols":12,"rows_kept":109,"merged":[[59,2,59,6],[60,3,60,7],[110,2,110,7]]}
[]
[]
[]
[null,null,"Data Entry For Comprehensive Ratio Analysis"]
[]
[{"$nulls":7},"Four Year",{"$nulls":3},"This template is like a moving picture of how well the business is doing in terms of"]
[{"$nulls":3},2010,2011,2012,2013,"Totals",{"$nulls":3},"sales, costs, and profitability, usually prepared on a monthly basis but covering an"]
[{"$nulls":11},"accounting period of one year."]
[null,null,"Sales"]
[null,null,"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 "},{"$f":"SUM(D10:G10)","v":{"v":8583600,"d":"8,583,600 "}},{"$nulls":3},"Enter data into the yellow shaded sales, then view the resulting report on the following worksheet."]
[null,null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(D11:G11)","v":{"v":0,"d":"0 "}}]
[null,null,"Total Sales",{"$f":"SUM(D10:D11)","v":{"v":2010000,"d":"2,010,000 "}},{"$f":"SUM(E10:E11)","v":{"v":2060000,"d":"2,060,000 "}},{"$f":"SUM(F10:F11)","v":{"v":2121800,"d":"2,121,800 "}},{"$f":"SUM(G10:G11)","v":{"v":2391800,"d":"2,391,800 "}},{"$f":"SUM(H10:H11)","v":{"v":8583600,"d":"8,583,600 "}}]
[]
[null,null,"Less Cost of Goods Sold"]
[null,null,"Materials",{"v":320000,"d":"320,000 "},{"v":329600,"d":"329,600 "},{"v":339488,"d":"339,488 "},{"v":389088,"d":"389,088 "},{"$f":"SUM(D15:G15)","v":{"v":1378176,"d":"1,378,176 "}}]
[null,null,"Labor",{"v":500000,"d":"500,000 "},{"v":515000,"d":"515,000 "},{"v":530450,"d":"530,450 "},{"v":545450,"d":"545,450 "},{"$f":"SUM(D16:G16)","v":{"v":2090900,"d":"2,090,900 "}}]
[null,null,"Overhead",{"v":125000,"d":"125,000 "},{"v":128750,"d":"128,750 "},{"v":132612.5,"d":"132,613 "},{"v":186362.5,"d":"186,363 "},{"$f":"SUM(D17:G17)","v":{"v":572725,"d":"572,725 "}}]
[null,null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(D18:G18)","v":{"v":0,"d":"0 "}}]
[null,null,"Total Cost of Goods Sold",{"$f":"SUM(D15:D18)","v":{"v":945000,"d":"945,000 "}},{"$f":"SUM(E15:E18)","v":{"v":973350,"d":"973,350 "}},{"$f":"SUM(F15:F18)","v":{"v":1002550.5,"d":"1,002,551 "}},{"$f":"SUM(G15:G18)","v":{"v":1120900.5,"d":"1,120,901 "}},{"$f":"SUM(H15:H18)","v":{"v":4041801,"d":"4,041,801 "}}]
[]
[null,null,"Gross Profit",{"$f":"D12-D19","v":{"v":1065000,"d":"1,065,000 "}},{"$f":"E12-E19","v":{"v":1086650,"d":"1,086,650 "}},{"$f":"F12-F19","v":{"v":1119249.5,"d":"1,119,250 "}},{"$f":"G12-G19","v":{"v":1270899.5,"d":"1,270,900 "}},{"$f":"H12-H19","v":{"v":4541799,"d":"4,541,799 "}}]
[]
[null,null,"Operating Expenses"]
[null,null,"Salaries and wages",{"v":190000,"d":"190,000 "},{"v":190000,"d":"190,000 "},{"v":190000,"d":"190,000 "},{"v":190000,"d":"190,000 "},{"$f":"SUM(D24:G24)","v":{"v":760000,"d":"760,000 "}}]
[null,null,"Employee benefits",{"v":50000,"d":"50,000 "},{"v":51500,"d":"51,500 "},{"v":53045,"d":"53,045 "},{"v":54545,"d":"54,545 "},{"v":209090,"d":"209,090 "}]
[null,null,"Payroll taxes",{"v":30000,"d":"30,000 "},{"v":30900,"d":"30,900 "},{"v":31827,"d":"31,827 "},{"v":32727,"d":"32,727 "},{"v":125454,"d":"125,454 "}]
[null,null,"Rent",{"v":5000,"d":"5,000 "},{"v":5150,"d":"5,150 "},{"v":5304.5,"d":"5,305 "},{"v":5454.5,"d":"5,455 "},{"v":20909,"d":"20,909 "}]
[null,null,"Utilities",{"v":3000,"d":"3,000 "},{"v":3090,"d":"3,090 "},{"v":3182.7,"d":"3,183 "},{"v":3272.7,"d":"3,273 "},{"v":12545.400000000001,"d":"12,545 "}]
[null,null,"Repairs and maintenance",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Insurance",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Travel",{"v":2133,"d":"2,133 "},{"v":2196.99,"d":"2,197 "},{"v":2262.8997,"d":"2,263 "},{"v":2262.8997,"d":"2,263 "},{"v":8855.7894,"d":"8,856 "}]
[null,null,"Telephone",{"v":11000,"d":"11,000 "},{"v":11330,"d":"11,330 "},{"v":11669.9,"d":"11,670 "},{"v":12669.9,"d":"12,670 "},{"v":46669.8,"d":"46,670 "}]
[null,null,"Postage",{"v":4000,"d":"4,000 "},{"v":4120,"d":"4,120 "},{"v":4243.6,"d":"4,244 "},{"v":4243.6,"d":"4,244 "},{"v":16607.2,"d":"16,607 "}]
[null,null,"Office supplies",{"v":6000,"d":"6,000 "},{"v":6180,"d":"6,180 "},{"v":6365.4,"d":"6,365 "},{"v":6365.4,"d":"6,365 "},{"v":24910.800000000003,"d":"24,911 "}]
[null,null,"Advertising",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Marketing/promotion",{"v":3000,"d":"3,000 "},{"v":3090,"d":"3,090 "},{"v":3182.7,"d":"3,183 "},{"v":3182.7,"d":"3,183 "},{"v":12455.400000000001,"d":"12,455 "}]
[null,null,"Professional fees",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Training and development",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Bank charges",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Depreciation",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Interest Expense",{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":24000,"d":"24,000 "}]
[null,null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Operating Expenses",{"$f":"SUM(D24:D42)","v":{"v":317133,"d":"317,133 "}},{"$f":"SUM(E24:E42)","v":{"v":320766.99,"d":"320,767 "}},{"$f":"SUM(F24:F42)","v":{"v":324509.9997000002,"d":"324,510 "}},{"$f":"SUM(G24:G42)","v":{"v":328149.9997000002,"d":"328,150 "}},{"$f":"SUM(D43:G43)","v":{"v":1290559.9894000005,"d":"1,290,560 "}}]
[]
[null,null,"Operating Income",{"$f":"D21-D43","v":{"v":747867,"d":"747,867 "}},{"$f":"E21-E43","v":{"v":765883.01,"d":"765,883 "}},{"$f":"F21-F43","v":{"v":794739.5002999997,"d":"794,740 "}},{"$f":"G21-G43","v":{"v":942749.5002999997,"d":"942,750 "}},{"$f":"H21-H43","v":{"v":3251239.0105999997,"d":"3,251,239 "}}]
[]
[null,null,"Interest income (expense)",{"v":16250,"d":"16,250 "},{"v":16737.5,"d":"16,738 "},{"v":17239.625,"d":"17,240 "},{"v":18227.125,"d":"18,227 "},{"$f":"SUM(D47:G47)","v":{"v":68454.25,"d":"68,454 "}}]
[null,null,"Other income (expense)",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(D48:G48)","v":{"v":0,"d":"0 "}}]
[null,null,"Total Nonoperating Income (Expense)",{"$f":"SUM(D47:D48)","v":{"v":16250,"d":"16,250 "}},{"$f":"SUM(E47:E48)","v":{"v":16737.5,"d":"16,738 "}},{"$f":"SUM(F47:F48)","v":{"v":17239.625,"d":"17,240 "}},{"$f":"SUM(G47:G48)","v":{"v":18227.125,"d":"18,227 "}},{"$f":"SUM(H47:H48)","v":{"v":68454.25,"d":"68,454 "}}]
[]
[null,null,"Income (Loss) Before Taxes",{"$f":"D45+D49","v":{"v":764117,"d":"764,117 "}},{"$f":"E45+E49","v":{"v":782620.51,"d":"782,621 "}},{"$f":"F45+F49","v":{"v":811979.1252999997,"d":"811,979 "}},{"$f":"G45+G49","v":{"v":960976.6252999997,"d":"960,977 "}},{"$f":"H45+H49","v":{"v":3319693.2605999997,"d":"3,319,693 "}}]
[]
[null,null,"Income Taxes",{"v":148563,"d":"148,563 "},{"v":149143.89,"d":"149,144 "},{"v":152922.20669999992,"d":"152,922 "},{"v":162629.0967,"d":"162,629 "},{"$f":"SUM(D53:G53)","v":{"v":613258.1934,"d":"613,258 "}}]
[]
[null,null,"Net Income (Loss)",{"$f":"D51-D53","v":{"v":615554,"d":"615,554 "}},{"$f":"E51-E53","v":{"v":633476.62,"d":"633,477 "}},{"$f":"F51-F53","v":{"v":659056.9185999997,"d":"659,057 "}},{"$f":"G51-G53","v":{"v":798347.5285999997,"d":"798,348 "}},{"$f":"H51-H53","v":{"v":2706435.0671999995,"d":"2,706,435 "}}]
[]
[null,null,"Cumulative Net Income (Loss)",{"$f":"D55","v":{"v":615554,"d":"615,554 "}},{"$f":"E55+D57","v":{"v":1249030.62,"d":"1,249,031 "}},{"$f":"F55+E57","v":{"v":1908087.5385999999,"d":"1,908,088 "}},{"$f":"G55+F57","v":{"v":2706435.0671999995,"d":"2,706,435 "}},{"$f":"H55+G57","v":{"v":5412870.134399999,"d":"5,412,870 "}}]
[]
[]
[null,null,"Balance Sheet - Years 1 to 4"]
[]
[]
[{"$nulls":3},"Opening","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"ASSETS"]
[]
[null,null,"Current Assets"]
[null,null,"Cash",{"v":507604.47331000003,"d":"507,604 "},{"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":4300,"d":"4,300 "},{"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":393928.0835,"d":"393,928 "},{"v":350000,"d":"350,000 "},{"v":360500,"d":"360,500 "},{"v":371315,"d":"371,315 "},{"v":382454.45,"d":"382,454 "}]
[null,null,"Inventory",{"v":450203.524,"d":"450,204 "},{"v":400000,"d":"400,000 "},{"v":412000,"d":"412,000 "},{"v":424360,"d":"424,360 "},{"v":437090.8,"d":"437,091 "}]
[null,null,"Other",{"v":11255.0881,"d":"11,255 "},{"v":10000,"d":"10,000 "},{"v":10300,"d":"10,300 "},{"v":10609,"d":"10,609 "},{"v":10927.27,"d":"10,927 "}]
[null,null,"Total Current Assets",{"$f":"SUM(D68:D72)","v":{"v":1367291.16891,"d":"1,367,291 "}},{"$f":"SUM(E68:E72)","v":{"v":1212200,"d":"1,212,200 "}},{"$f":"SUM(F68:F72)","v":{"v":1250530,"d":"1,250,530 "}},{"$f":"SUM(G68:G72)","v":{"v":1287749.9,"d":"1,287,750 "}},{"$f":"SUM(H68:H72)","v":{"v":1326692.397,"d":"1,326,692 "}}]
[]
[null,null,"Long-Term Assets"]
[null,null,"Property, plant, and equipment",{"v":2701221.1440000003,"d":"2,701,221 "},{"v":2400000,"d":"2,400,000 "},{"v":2472000,"d":"2,472,000 "},{"v":2546160,"d":"2,546,160 "},{"v":2622544.8,"d":"2,622,545 "}]
[null,null,"Less accumulated depreciation",{"v":450203.524,"d":"450,204 "},{"v":400000,"d":"400,000 "},{"v":412000,"d":"412,000 "},{"v":424360,"d":"424,360 "},{"v":437090.8,"d":"437,091 "}]
[null,null,"Net property, plant, and equipment",{"$f":"+D76-D77","v":{"v":2251017.62,"d":"2,251,018 "}},{"$f":"+E76-E77","v":{"v":2000000,"d":"2,000,000 "}},{"$f":"+F76-F77","v":{"v":2060000,"d":"2,060,000 "}},{"$f":"+G76-G77","v":{"v":2121800,"d":"2,121,800 "}},{"$f":"+H76-H77","v":{"v":2185454,"d":"2,185,454 "}}]
[null,null,"Other long-term assets",{"v":58765.264299999995,"d":"58,765 "},{"v":55000,"d":"55,000 "},{"v":55900,"d":"55,900 "},{"v":56827,"d":"56,827 "},{"v":57781.81,"d":"57,782 "}]
[null,null,"Total Long-Term Assets",{"$f":"SUM(D78:D79)","v":{"v":2309782.8843,"d":"2,309,783 "}},{"$f":"SUM(E78:E79)","v":{"v":2055000,"d":"2,055,000 "}},{"$f":"SUM(F78:F79)","v":{"v":2115900,"d":"2,115,900 "}},{"$f":"SUM(G78:G79)","v":{"v":2178627,"d":"2,178,627 "}},{"$f":"SUM(H78:H79)","v":{"v":2243235.81,"d":"2,243,236 "}}]
[]
[null,null,"Total Assets",{"$f":"D73+D80","v":{"v":3677074.05321,"d":"3,677,074 "}},{"$f":"E73+E80","v":{"v":3267200,"d":"3,267,200 "}},{"$f":"F73+F80","v":{"v":3366430,"d":"3,366,430 "}},{"$f":"G73+G80","v":{"v":3466376.9,"d":"3,466,377 "}},{"$f":"H73+H80","v":{"v":3569928.2070000004,"d":"3,569,928 "}}]
[]
[null,null,"LIABILITIES AND SHAREHOLDERS' EQUITY"]
[]
[null,null,"Current Liabilities"]
[null,null,"Short-term debt",{"v":675305.286,"d":"675,305 "},{"v":600000,"d":"600,000 "},{"v":618000,"d":"618,000 "},{"v":636540,"d":"636,540 "},{"v":655636.2,"d":"655,636 "}]
[null,null,"Current maturities of long-term debt",{"v":112550.881,"d":"112,551 "},{"v":100000,"d":"100,000 "},{"v":103000,"d":"103,000 "},{"v":106090,"d":"106,090 "},{"v":109272.7,"d":"109,273 "}]
[null,null,"Accounts payable",{"v":112550.881,"d":"112,551 "},{"v":100000,"d":"100,000 "},{"v":103000,"d":"103,000 "},{"v":106090,"d":"106,090 "},{"v":109272.7,"d":"109,273 "}]
[null,null,"Income taxes payable",{"v":33765.264299999995,"d":"33,765 "},{"v":30000,"d":"30,000 "},{"v":30900,"d":"30,900 "},{"v":31827,"d":"31,827 "},{"v":32781.81,"d":"32,782 "}]
[null,null,"Accrued liabilities",{"v":101295.79289999999,"d":"101,296 "},{"v":90000,"d":"90,000 "},{"v":92700,"d":"92,700 "},{"v":95481,"d":"95,481 "},{"v":98345.43,"d":"98,345 "}]
[null,null,"Other",{"v":18008.14096,"d":"18,008 "},{"v":16000,"d":"16,000 "},{"v":16480,"d":"16,480 "},{"v":16974.4,"d":"16,974 "},{"v":17483.632,"d":"17,484 "}]
[null,null,"Total Current Liabilities",{"$f":"SUM(D87:D92)","v":{"v":1053476.24616,"d":"1,053,476 "}},{"$f":"SUM(E87:E92)","v":{"v":936000,"d":"936,000 "}},{"$f":"SUM(F87:F92)","v":{"v":964080,"d":"964,080 "}},{"$f":"SUM(G87:G92)","v":{"v":993002.4,"d":"993,002 "}},{"$f":"SUM(H87:H92)","v":{"v":1022792.4719999998,"d":"1,022,792 "}}]
[]
[null,null,"Long-Term Liabilities"]
[null,null,"Long-term debt less current maturities",{"v":692156.286,"d":"692,156 "},{"v":601200,"d":"601,200 "},{"v":624200,"d":"624,200 "},{"v":645630,"d":"645,630 "},{"v":668308.2,"d":"668,308 "}]
[null,null,"Deferred income taxes",{"v":112550.881,"d":"112,551 "},{"v":100000,"d":"100,000 "},{"v":103000,"d":"103,000 "},{"v":106090,"d":"106,090 "},{"v":109272.7,"d":"109,273 "}]
[null,null,"Other long-term liabilities",{"v":85903,"d":"85,903 "},{"v":79000,"d":"79,000 "},{"v":80650,"d":"80,650 "},{"v":82350,"d":"82,350 "},{"v":84101,"d":"84,101 "}]
[null,null,"Total Long-Term Liabilities",{"$f":"SUM(D96:D98)","v":{"v":890610.1669999999,"d":"890,610 "}},{"$f":"SUM(E96:E98)","v":{"v":780200,"d":"780,200 "}},{"$f":"SUM(F96:F98)","v":{"v":807850,"d":"807,850 "}},{"$f":"SUM(G96:G98)","v":{"v":834070,"d":"834,070 "}},{"$f":"SUM(H96:H98)","v":{"v":861681.8999999999,"d":"861,682 "}}]
[]
[null,null,"Total Liabilities",{"$f":"D93+D99","v":{"v":1944086.41316,"d":"1,944,086 "}},{"$f":"E93+E99","v":{"v":1716200,"d":"1,716,200 "}},{"$f":"F93+F99","v":{"v":1771930,"d":"1,771,930 "}},{"$f":"G93+G99","v":{"v":1827072.4,"d":"1,827,072 "}},{"$f":"H93+H99","v":{"v":1884474.3719999997,"d":"1,884,474 "}}]
[null,null,"Shareholders' Equity"]
[null,null,"Common stock",{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "}]
[null,null,"Additional paid-in capital",{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "}]
[null,null,"Retained earnings",{"v":56275.4405,"d":"56,275 "},{"v":50000,"d":"50,000 "},{"v":51500,"d":"51,500 "},{"v":53045,"d":"53,045 "},{"v":54636.35,"d":"54,636 "}]
[null,null,"Other",{"v":1575712.334,"d":"1,575,712 "},{"v":1400000,"d":"1,400,000 "},{"v":1442000,"d":"1,442,000 "},{"v":1485260,"d":"1,485,260 "},{"v":1529817.8,"d":"1,529,818 "}]
[null,null,"Total Shareholders' Equity",{"$f":"SUM(D103:D106)","v":{"v":1732987.7745,"d":"1,732,988 "}},{"$f":"SUM(E103:E106)","v":{"v":1551000,"d":"1,551,000 "}},{"$f":"SUM(F103:F106)","v":{"v":1594500,"d":"1,594,500 "}},{"$f":"SUM(G103:G106)","v":{"v":1639305,"d":"1,639,305 "}},{"$f":"SUM(H103:H106)","v":{"v":1685454.1500000001,"d":"1,685,454 "}}]
[]
[null,null,"Total Liabilities and Shareholders' Equity",{"$f":"D93+D99+D107","v":{"v":3677074.1876600003,"d":"3,677,074 "}},{"$f":"E93+E99+E107","v":{"v":3267200,"d":"3,267,200 "}},{"$f":"F93+F99+F107","v":{"v":3366430,"d":"3,366,430 "}},{"$f":"G93+G99+G107","v":{"v":3466377.4,"d":"3,466,377 "}},{"$f":"H93+H99+H107","v":{"v":3569928.522,"d":"3,569,929 "}}]

{"sheet":"Comprehensive Ratio Analysis","index":1,"n_rows":87,"n_cols":10,"rows_kept":87}
[]
[null,"FSIC",{"$nulls":3},1213,1214,1215,1216]
[null,"ABD","Allowance for Bad Debt",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"AD","Accumulated Depreciation",null,null,{"$f":"'Data Entry'!E77","v":{"v":400000,"d":"$400,000"}},{"$f":"'Data Entry'!F77","v":{"v":412000,"d":"$412,000"}},{"$f":"'Data Entry'!G77","v":{"v":424360,"d":"$424,360"}},{"$f":"'Data Entry'!H77","v":{"v":437090.8,"d":"$437,091"}}]
[null,"ADE","Amortization and Depreciation Expense",null,null,{"$f":"'Data Entry'!D40","v":{"v":1000,"d":"$1,000"}},{"$f":"'Data Entry'!E40","v":{"v":1030,"d":"$1,030"}},{"$f":"'Data Entry'!F40","v":{"v":1060.9,"d":"$1,061"}},{"$f":"'Data Entry'!G40","v":{"v":1060.9,"d":"$1,061"}}]
[null,"AP","Accounts Payable",null,null,{"$f":"'Data Entry'!E89","v":{"v":100000,"d":"$100,000"}},{"$f":"'Data Entry'!F89","v":{"v":103000,"d":"$103,000"}},{"$f":"'Data Entry'!G89","v":{"v":106090,"d":"$106,090"}},{"$f":"'Data Entry'!H89","v":{"v":109272.7,"d":"$109,273"}}]
[null,"AR","Accounts Receivable",null,null,{"$f":"'Data Entry'!E70","v":{"v":350000,"d":"$350,000"}},{"$f":"'Data Entry'!F70","v":{"v":360500,"d":"$360,500"}},{"$f":"'Data Entry'!G70","v":{"v":371315,"d":"$371,315"}},{"$f":"'Data Entry'!H70","v":{"v":382454.45,"d":"$382,454"}}]
[null,"BDE","Bad Debt Expense",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"CCE","Cash & Cash Equivalent",null,null,{"$f":"'Data Entry'!E68","v":{"v":451000,"d":"$451,000"}},{"$f":"'Data Entry'!F68","v":{"v":464530,"d":"$464,530"}},{"$f":"'Data Entry'!G68","v":{"v":478465.9,"d":"$478,466"}},{"$f":"'Data Entry'!H68","v":{"v":492819.87700000004,"d":"$492,820"}}]
[null,"COS","Cost of Sales",null,null,{"$f":"'Data Entry'!D19","v":{"v":945000,"d":"$945,000"}},{"$f":"'Data Entry'!E19","v":{"v":973350,"d":"$973,350"}},{"$f":"'Data Entry'!F19","v":{"v":1002550.5,"d":"$1,002,551"}},{"$f":"'Data Entry'!G19","v":{"v":1120900.5,"d":"$1,120,901"}}]
[null,"EQ","Equity",null,null,{"$f":"'Data Entry'!E107","v":{"v":1551000,"d":"$1,551,000"}},{"$f":"'Data Entry'!F107","v":{"v":1594500,"d":"$1,594,500"}},{"$f":"'Data Entry'!G107","v":{"v":1639305,"d":"$1,639,305"}},{"$f":"'Data Entry'!H107","v":{"v":1685454.1500000001,"d":"$1,685,454"}}]
[null,"INT","Interest Expense",null,null,{"$f":"'Data Entry'!D41","v":{"v":6000,"d":"$6,000"}},{"$f":"'Data Entry'!E41","v":{"v":6000,"d":"$6,000"}},{"$f":"'Data Entry'!F41","v":{"v":6000,"d":"$6,000"}},{"$f":"'Data Entry'!G41","v":{"v":6000,"d":"$6,000"}}]
[null,"INV","Inventory",null,null,{"$f":"'Data Entry'!E71","v":{"v":400000,"d":"$400,000"}},{"$f":"'Data Entry'!F71","v":{"v":412000,"d":"$412,000"}},{"$f":"'Data Entry'!G71","v":{"v":424360,"d":"$424,360"}},{"$f":"'Data Entry'!H71","v":{"v":437090.8,"d":"$437,091"}}]
[null,"IT","Income Taxes",null,null,{"$f":"'Data Entry'!D53","v":{"v":148563,"d":"$148,563"}},{"$f":"'Data Entry'!E53","v":{"v":149143.89,"d":"$149,144"}},{"$f":"'Data Entry'!F53","v":{"v":152922.20669999992,"d":"$152,922"}},{"$f":"'Data Entry'!G53","v":{"v":162629.0967,"d":"$162,629"}}]
[null,"LTD","Long Term Debt",null,null,{"$f":"'Data Entry'!E99","v":{"v":780200,"d":"$780,200"}},{"$f":"'Data Entry'!F99","v":{"v":807850,"d":"$807,850"}},{"$f":"'Data Entry'!G99","v":{"v":834070,"d":"$834,070"}},{"$f":"'Data Entry'!H99","v":{"v":861681.8999999999,"d":"$861,682"}}]
[null,"NS","Net Sales",null,null,{"$f":"'Data Entry'!D12","v":{"v":2010000,"d":"$2,010,000"}},{"$f":"'Data Entry'!E12","v":{"v":2060000,"d":"$2,060,000"}},{"$f":"'Data Entry'!F12","v":{"v":2121800,"d":"$2,121,800"}},{"$f":"'Data Entry'!G12","v":{"v":2391800,"d":"$2,391,800"}}]
[null,"OC","Officers Compensation",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"OCA","Other Current Assets",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"OCL","Other Current Liabilities",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"ONCA","Other Non-Current Assets",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"ONCL","Other Non-Current Liabilities",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"ONOE","Other Non-Operating Expense",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"ONOI","Other Non-Operating Income",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"OOE","Other Operating Expense",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"PPE","Property, Plant, & Equipment",null,null,{"$f":"'Data Entry'!E76","v":{"v":2400000,"d":"$2,400,000"}},{"$f":"'Data Entry'!F76","v":{"v":2472000,"d":"$2,472,000"}},{"$f":"'Data Entry'!G76","v":{"v":2546160,"d":"$2,546,160"}},{"$f":"'Data Entry'!H76","v":{"v":2622544.8,"d":"$2,622,545"}}]
[null,"RE","Retained Earnings",null,null,{"$f":"'Data Entry'!E105","v":{"v":50000,"d":"$50,000"}},{"$f":"'Data Entry'!F105","v":{"v":51500,"d":"$51,500"}},{"$f":"'Data Entry'!G105","v":{"v":53045,"d":"$53,045"}},{"$f":"'Data Entry'!H105","v":{"v":54636.35,"d":"$54,636"}}]
[null,"STD","Short Term Debt",null,null,{"$f":"'Data Entry'!E87","v":{"v":600000,"d":"$600,000"}},{"$f":"'Data Entry'!F87","v":{"v":618000,"d":"$618,000"}},{"$f":"'Data Entry'!G87","v":{"v":636540,"d":"$636,540"}},{"$f":"'Data Entry'!H87","v":{"v":655636.2,"d":"$655,636"}}]
[null,"FY","Fiscal Year",null,null,2001,2001,2001,2001]
[null,"PN","Period Number",null,null,1,2,3,4]
[null,"PI","Period Index",null,null,1213,1214,1215,1216]
[null,"DP","Days in Period",null,null,30,31,30,31]
[null,"DY","Days in Year",null,null,365,365,365,365]
[null,"ED","Period End",null,null,"2000-04-30","2000-05-31","2000-06-30","2000-07-31"]
[null,"CA","Current Assets",null,null,{"$f":"'Data Entry'!E73","v":{"v":1212200,"d":"$1,212,200"}},{"$f":"'Data Entry'!F73","v":{"v":1250530,"d":"$1,250,530"}},{"$f":"'Data Entry'!G73","v":{"v":1287749.9,"d":"$1,287,750"}},{"$f":"'Data Entry'!H73","v":{"v":1326692.397,"d":"$1,326,692"}}]
[null,"CL","Current Liabilities",null,null,{"$f":"'Data Entry'!E93","v":{"v":936000,"d":"$936,000"}},{"$f":"'Data Entry'!F93","v":{"v":964080,"d":"$964,080"}},{"$f":"'Data Entry'!G93","v":{"v":993002.4,"d":"$993,002"}},{"$f":"'Data Entry'!H93","v":{"v":1022792.4719999998,"d":"$1,022,792"}}]
[null,"QA","Quick Assets",null,null,{"$f":"('Data Entry'!D73-'Data Entry'!D71)","v":{"v":917087.64491,"d":"$917,088"}},{"$f":"('Data Entry'!E73-'Data Entry'!E71)","v":{"v":812200,"d":"$812,200"}},{"$f":"('Data Entry'!F73-'Data Entry'!F71)","v":{"v":838530,"d":"$838,530"}},{"$f":"('Data Entry'!G73-'Data Entry'!G71)","v":{"v":863389.8999999999,"d":"$863,390"}}]
[null,"ARN","Accounts Receivables Net",null,null,{"$f":"'Data Entry'!E70","v":{"v":350000,"d":"$350,000"}},{"$f":"'Data Entry'!F70","v":{"v":360500,"d":"$360,500"}},{"$f":"'Data Entry'!G70","v":{"v":371315,"d":"$371,315"}},{"$f":"'Data Entry'!H70","v":{"v":382454.45,"d":"$382,454"}}]
[null,"NW","Net Worth",null,null,{"$f":"'Data Entry'!D82-'Data Entry'!D101","v":{"v":1732987.64005,"d":"$1,732,988"}},{"$f":"'Data Entry'!E82-'Data Entry'!E101","v":{"v":1551000,"d":"$1,551,000"}},{"$f":"'Data Entry'!F82-'Data Entry'!F101","v":{"v":1594500,"d":"$1,594,500"}},{"$f":"'Data Entry'!G82-'Data Entry'!G101","v":{"v":1639304.5,"d":"$1,639,305"}}]
[null,"TL","Total Liabilities",null,null,{"$f":"'Data Entry'!E101","v":{"v":1716200,"d":"$1,716,200"}},{"$f":"'Data Entry'!F101","v":{"v":1771930,"d":"$1,771,930"}},{"$f":"'Data Entry'!G101","v":{"v":1827072.4,"d":"$1,827,072"}},{"$f":"'Data Entry'!H101","v":{"v":1884474.3719999997,"d":"$1,884,474"}}]
[null,"WC","Working Capital",null,null,{"$f":"'Data Entry'!D73-'Data Entry'!D93","v":{"v":313814.9227499999,"d":"$313,815"}},{"$f":"'Data Entry'!E73-'Data Entry'!E93","v":{"v":276200,"d":"$276,200"}},{"$f":"'Data Entry'!F73-'Data Entry'!F93","v":{"v":286450,"d":"$286,450"}},{"$f":"'Data Entry'!G73-'Data Entry'!G93","v":{"v":294747.4999999999,"d":"$294,748"}}]
[null,"TA","Total Assets",null,null,{"$f":"'Data Entry'!E82","v":{"v":3267200,"d":"$3,267,200"}},{"$f":"'Data Entry'!F82","v":{"v":3366430,"d":"$3,366,430"}},{"$f":"'Data Entry'!G82","v":{"v":3466376.9,"d":"$3,466,377"}},{"$f":"'Data Entry'!H82","v":{"v":3569928.2070000004,"d":"$3,569,928"}}]
[null,"NI","Net Income",null,null,{"$f":"'Data Entry'!D55","v":{"v":615554,"d":"$615,554"}},{"$f":"'Data Entry'!E55","v":{"v":633476.62,"d":"$633,477"}},{"$f":"'Data Entry'!F55","v":{"v":659056.9185999997,"d":"$659,057"}},{"$f":"'Data Entry'!G55","v":{"v":798347.5285999997,"d":"$798,348"}}]
[null,"IBT","Income Before Tax",null,null,{"$f":"'Data Entry'!D51","v":{"v":764117,"d":"$764,117"}},{"$f":"'Data Entry'!E51","v":{"v":782620.51,"d":"$782,621"}},{"$f":"'Data Entry'!F51","v":{"v":811979.1252999997,"d":"$811,979"}},{"$f":"'Data Entry'!G51","v":{"v":960976.6252999997,"d":"$960,977"}}]
[null,"FA","Fixed Assets",null,null,{"$f":"'Data Entry'!E80","v":{"v":2055000,"d":"$2,055,000"}},{"$f":"'Data Entry'!F80","v":{"v":2115900,"d":"$2,115,900"}},{"$f":"'Data Entry'!G80","v":{"v":2178627,"d":"$2,178,627"}},{"$f":"'Data Entry'!H80","v":{"v":2243235.81,"d":"$2,243,236"}}]
[null,"OE","Operating Expenses",null,null,{"$f":"'Data Entry'!D43","v":{"v":317133,"d":"$317,133"}},{"$f":"'Data Entry'!E43","v":{"v":320766.99,"d":"$320,767"}},{"$f":"'Data Entry'!F43","v":{"v":324509.9997000002,"d":"$324,510"}},{"$f":"'Data Entry'!G43","v":{"v":328149.9997000002,"d":"$328,150"}}]
[null,"IBIT","Income Before Interest & Taxes",null,null,{"$f":"'Data Entry'!D45","v":{"v":747867,"d":"$747,867"}},{"$f":"'Data Entry'!E45","v":{"v":765883.01,"d":"$765,883"}},{"$f":"'Data Entry'!F45","v":{"v":794739.5002999997,"d":"$794,740"}},{"$f":"'Data Entry'!G45","v":{"v":942749.5002999997,"d":"$942,750"}}]
[null,null,"Net Fixed Assets to Net Worth",null,null,{"v":-0.06459830716618731,"d":"($0)"},{"v":-0.06448399158383548,"d":"($0)"},{"v":-0.0644800830799861,"d":"($0)"},{"v":-0.06444409257784739,"d":"($0)"}]
[null,null,"Officers Compensation to Net Sales",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[]
[null,null,"Comprehensive Ratios Report\n"]
[null,null," ","Description"," ",{"$f":"'Data Entry'!D7","v":2010},{"$f":"'Data Entry'!E7","v":2011},{"$f":"'Data Entry'!F7","v":2012},{"$f":"'Data Entry'!G7","v":2013},{"$f":"I52+1","v":2014}]
[null,null,"Financial Health Ratios"]
[null,null,"Altman Z Score-Small Business/Service",null,null,{"$f":"IF(TA=0,\"N/A\",\nWC/TA*6.56+\nRE/TA*3.26+\nIBIT/TA*6.72+\nEQ/TL*1.05)","v":{"v":3.167124525626268,"d":"3.17"}},{"$f":"IF(TA=0,\"N/A\",\nWC/TA*6.56+\nRE/TA*3.26+\nIBIT/TA*6.72+\nEQ/TL*1.05)","v":{"v":3.0617893125608733,"d":"3.06"}},{"$f":"IF(TA=0,\"N/A\",\nWC/TA*6.56+\nRE/TA*3.26+\nIBIT/TA*6.72+\nEQ/TL*1.05)","v":{"v":3.074776435831348,"d":"3.07"}},{"$f":"IF(TA=0,\"N/A\",\nWC/TA*6.56+\nRE/TA*3.26+\nIBIT/TA*6.72+\nEQ/TL*1.05)","v":{"v":3.3052447541852334,"d":"3.31"}},{"$f":"FORECAST(J52,F54:I54,F52:I52)","v":{"v":3.2590707092877835,"d":"3.26"}}]
[null,null,"Liquidity Ratios"]
[null,null,"Current Ratio",null,null,{"$f":"IF(CL=0,\"N/A\",CA/CL)","v":{"v":1.2950854700854701,"d":"1.30"}},{"$f":"IF(CL=0,\"N/A\",CA/CL)","v":{"v":1.2971226454236162,"d":"1.30"}},{"$f":"IF(CL=0,\"N/A\",CA/CL)","v":{"v":1.2968245595378218,"d":"1.30"}},{"$f":"IF(CL=0,\"N/A\",CA/CL)","v":{"v":1.2971276513267105,"d":"1.30"}},{"$f":"FORECAST(J52,F56:I56,F52:I52)","v":{"v":1.2979971960528864,"d":"1.30"}}]
[null,null,"Gross Margin Percentage",null,null,{"$f":"IF(CL=0,\"N/A\",QA/CL)","v":{"v":0.9797944924252137,"d":"0.98"}},{"$f":"IF(CL=0,\"N/A\",QA/CL)","v":{"v":0.8424612065388765,"d":"0.84"}},{"$f":"IF(CL=0,\"N/A\",QA/CL)","v":{"v":0.844439046672999,"d":"0.84"}},{"$f":"IF(CL=0,\"N/A\",QA/CL)","v":{"v":0.8441496429003831,"d":"0.84"}},{"$f":"FORECAST($J$52,F57:I57,$F$52:$I$52)","v":{"v":0.7764719200242638,"d":"0.78"}}]
[null,null,"Activity Ratios"]
[null,null,"Days Sales in AR",null,null,{"$f":"IF(NS=0,\"N/A\",ARN*DP/NS)","v":{"v":5.223880597014926,"d":"5.22"}},{"$f":"IF(NS=0,\"N/A\",ARN*DP/NS)","v":{"v":5.425,"d":"5.43"}},{"$f":"IF(NS=0,\"N/A\",ARN*DP/NS)","v":5.25},{"$f":"IF(NS=0,\"N/A\",ARN*DP/NS)","v":{"v":4.956972970148006,"d":"4.96"}},{"v":4.970032671640553,"d":"4.97"}]
[null,null,"Inventory Turnover",null,null,{"$f":"(COS)/(INV)","v":{"v":2.3625,"d":"2.36"}},{"$f":"(COS)/(INV)","v":{"v":2.3625,"d":"2.36"}},{"$f":"(COS)/(INV)","v":{"v":2.3625,"d":"2.36"}},{"$f":"(COS)/(INV)","v":{"v":2.5644568588494656,"d":"2.56"}},{"v":2.564456858849468,"d":"2.56"}]
[null,null,"Days Inventory",null,null,{"$f":"IF(COS=0,\"N/A\",(INV*365)/COS)","v":{"v":154.4973544973545,"d":"154.50"}},{"$f":"IF(COS=0,\"N/A\",(INV*365)/COS)","v":{"v":154.4973544973545,"d":"154.50"}},{"$f":"IF(COS=0,\"N/A\",(INV*365)/COS)","v":{"v":154.4973544973545,"d":"154.50"}},{"$f":"IF(COS=0,\"N/A\",(INV*365)/COS)","v":{"v":142.3303335130995,"d":"142.33"}},{"v":142.3303335130986,"d":"142.33"}]
[null,null,"Net Sales to Inventory",null,null,{"$f":"(NS)/(INV)","v":{"v":5.025,"d":"5.03"}},{"$f":"(NS)/(INV)","v":{"v":5,"d":"5.00"}},{"$f":"(NS)/(INV)","v":{"v":5,"d":"5.00"}},{"$f":"(NS)/(INV)","v":{"v":5.472089552102218,"d":"5.47"}},{"v":5.459589552102159,"d":"5.46"}]
[null,null,"Days Purchases in AP",null,null,{"$f":"IF(COS=0,\"N/A\",(AP*365)/COS)","v":{"v":38.62433862433863,"d":"38.62"}},{"$f":"IF(COS=0,\"N/A\",(AP*365)/COS)","v":{"v":38.62433862433863,"d":"38.62"}},{"$f":"IF(COS=0,\"N/A\",(AP*365)/COS)","v":{"v":38.62433862433863,"d":"38.62"}},{"$f":"IF(COS=0,\"N/A\",(AP*365)/COS)","v":{"v":35.582583378274876,"d":"35.58"}},{"v":35.58258337827465,"d":"35.58"}]
[null,null,"Net Sales to Working Capital",null,null,{"$f":"(NS)/(WC)","v":{"v":6.405049136561497,"d":"6.41"}},{"$f":"(NS)/(WC)","v":{"v":7.4583635047067345,"d":"7.46"}},{"$f":"(NS)/(WC)","v":{"v":7.407226392040496,"d":"7.41"}},{"$f":"(NS)/(WC)","v":{"v":8.114742279408649,"d":"8.11"}},{"v":8.615830907148165,"d":"8.62"}]
[null,null,"Total Assets to Net Sales",null,null,{"$f":"(TA)/(NS)","v":{"v":1.6254726368159205,"d":"1.63"}},{"$f":"(TA)/(NS)","v":{"v":1.6341893203883495,"d":"1.63"}},{"$f":"(TA)/(NS)","v":{"v":1.6336963427278726,"d":"1.63"}},{"$f":"(TA)/(NS)","v":{"v":1.4925696993895812,"d":"1.49"}},{"v":1.4966815523455637,"d":"1.50"}]
[null,null,"Net Sales to AR",null,null,{"$f":"(NS)/(ARN)","v":{"v":5.742857142857143,"d":"5.74"}},{"$f":"(NS)/(ARN)","v":{"v":5.714285714285714,"d":"5.71"}},{"$f":"(NS)/(ARN)","v":{"v":5.714285714285714,"d":"5.71"}},{"$f":"(NS)/(ARN)","v":{"v":6.2538166309739625,"d":"6.25"}},{"v":6.2395309166882384,"d":"6.24"}]
[null,null,"Net Sales to Net Fixed Assets",null,null,{"$f":"(NS)/(FA)","v":{"v":0.9781021897810219,"d":"0.98"}},{"$f":"(NS)/(FA)","v":{"v":0.9735809820880004,"d":"0.97"}},{"$f":"(NS)/(FA)","v":{"v":0.9739161407620488,"d":"0.97"}},{"$f":"(NS)/(FA)","v":{"v":1.0662276294528303,"d":"1.07"}},{"v":1.064134604943341,"d":"1.06"}]
[null,null,"Net Sales to Total Assets",null,null,{"$f":"(NS)/(TA)","v":{"v":0.615205680705191,"d":"0.62"}},{"$f":"(NS)/(TA)","v":{"v":0.6119242045727967,"d":"0.61"}},{"$f":"(NS)/(TA)","v":{"v":0.6121088563681578,"d":"0.61"}},{"$f":"(NS)/(TA)","v":{"v":0.6699854622594654,"d":"0.67"}},{"v":0.6684370500909438,"d":"0.67"}]
[null,null,"Net Sales to Net Worth",null,null,{"$f":"(NS)/(NW)","v":{"v":1.1598467026239192,"d":"1.16"}},{"$f":"(NS)/(NW)","v":{"v":1.3281753707285622,"d":"1.33"}},{"$f":"(NS)/(NW)","v":{"v":1.3306992787707745,"d":"1.33"}},{"$f":"(NS)/(NW)","v":{"v":1.4590333888548466,"d":"1.46"}},{"v":1.544459676928284,"d":"1.54"}]
[null,null,"Amortization and Depreciation Expense to Net Sales",null,null,{"$f":"IF(NS=0,\"N/A\",ADE/NS)","v":{"v":4.9751243781094524E-4,"d":"0.00"}},{"$f":"IF(NS=0,\"N/A\",ADE/NS)","v":{"v":0.0005,"d":"0.00"}},{"$f":"IF(NS=0,\"N/A\",ADE/NS)","v":{"v":0.0005,"d":"0.00"}},{"$f":"IF(NS=0,\"N/A\",ADE/NS)","v":{"v":4.4355715360816126E-4,"d":"0.00"}},{"v":4.4480093470268545E-4,"d":"0.00"}]
[null,null,"Profitability Ratios"]
[null,null,"Gross Profit Percentage",null,null,{"$f":"IF(NS=0,\"N/A\",(NS-COS)/NS)","v":{"v":0.5298507462686567,"d":"52.99%"}},{"$f":"IF(NS=0,\"N/A\",(NS-COS)/NS)","v":{"v":0.5275,"d":"52.75%"}},{"$f":"IF(NS=0,\"N/A\",(NS-COS)/NS)","v":{"v":0.5275,"d":"52.75%"}},{"$f":"IF(NS=0,\"N/A\",(NS-COS)/NS)","v":{"v":0.5313569278367757,"d":"53.14%"}},{"$f":"FORECAST($J$52,F72:I72,$F$52:$I$52)","v":{"v":0.5301815547024473,"d":"53%"}}]
[null,null,"Operating Expenses as % of Net Sales",null,null,{"$f":"IF(NS=0,\"N/A\",OE/NS)","v":{"v":0.15777761194029852,"d":"15.78%"}},{"$f":"IF(NS=0,\"N/A\",OE/NS)","v":{"v":0.15571213106796117,"d":"15.57%"}},{"$f":"IF(NS=0,\"N/A\",OE/NS)","v":{"v":0.15294089909510802,"d":"15.29%"}},{"$f":"IF(NS=0,\"N/A\",OE/NS)","v":{"v":0.13719792612258558,"d":"13.72%"}},{"v":0.13477956969999028,"d":"13%"}]
[null,null,"Return on Total Assets",null,null,{"$f":"(NI)/(TA)","v":{"v":0.18840413809990206,"d":"18.84%"}},{"$f":"(NI)/(TA)","v":{"v":0.18817460039270087,"d":"18.82%"}},{"$f":"(NI)/(TA)","v":{"v":0.19012846485331694,"d":"19.01%"}},{"$f":"(NI)/(TA)","v":{"v":0.2236312559548343,"d":"22.36%"}},{"v":0.22449341933154088,"d":"22%"}]
[null,null,"Return on Net Worth",null,null,{"$f":"(NI)/(NW)","v":{"v":0.35519814785421094,"d":"35.52%"}},{"$f":"(NI)/(NW)","v":{"v":0.40843108961960023,"d":"40.84%"}},{"$f":"(NI)/(NW)","v":{"v":0.41333140081530245,"d":"41.33%"}},{"$f":"(NI)/(NW)","v":{"v":0.4870038047232834,"d":"48.70%"}},{"v":0.5160704312038291,"d":"52%"}]
[null,null,"Return on Net Sales",null,null,{"$f":"IF(NS=0,\"N/A\",NI/NS)","v":{"v":0.3062457711442786,"d":"30.62%"}},{"$f":"IF(NS=0,\"N/A\",NI/NS)","v":{"v":0.3075129223300971,"d":"30.75%"}},{"$f":"IF(NS=0,\"N/A\",NI/NS)","v":{"v":0.31061217767932875,"d":"31.06%"}},{"$f":"IF(NS=0,\"N/A\",NI/NS)","v":{"v":0.3337852364746215,"d":"33.38%"}},{"v":0.3359684397421461,"d":"34%"}]
[null,null,"Income before tax to Net Worth",null,null,{"$f":"(IBT)/(NW)","v":{"v":0.4409246680939708,"d":"44%"}},{"$f":"(IBT)/(NW)","v":{"v":0.5045909155383623,"d":"50%"}},{"$f":"(IBT)/(NW)","v":{"v":0.5092374570711821,"d":"51%"}},{"$f":"(IBT)/(NW)","v":{"v":0.5862099599555786,"d":"59%"}},{"v":0.6203663544441724,"d":"62%"}]
[null,null,"Income before tax to Total Assets",null,null,{"$f":"(IBT)/(TA)","v":{"v":0.23387518364348678,"d":"23%"}},{"$f":"(IBT)/(TA)","v":{"v":0.23247788012820703,"d":"23%"}},{"$f":"(IBT)/(TA)","v":{"v":0.23424432735517012,"d":"23%"}},{"$f":"(IBT)/(TA)","v":{"v":0.2691865408989721,"d":"27%"}},{"v":0.2693711127548113,"d":"27%"}]
[null,null,"Retained Earning to Net Income",null,null,{"$f":"((F26))/(NI)","v":{"v":0.08122764209151431,"d":"8%"}},{"$f":"((G26))/(NI)","v":{"v":0.08129739657952964,"d":"8%"}},{"$f":"((H26))/(NI)","v":{"v":0.08048621978308144,"d":"8%"}},{"$f":"((I26))/(NI)","v":{"v":0.0684367998180085,"d":"7%"}},{"v":0.06806608866379182,"d":"7%"}]
[null,null,"Coverage Ratios"]
[null,null,"Times Interest Earned",null,null,{"$f":"IF(INT=0,\"N/A\",IBIT/INT)","v":{"v":124.6445,"d":"124.64"}},{"$f":"IF(INT=0,\"N/A\",IBIT/INT)","v":{"v":127.64716833333334,"d":"127.65"}},{"$f":"IF(INT=0,\"N/A\",IBIT/INT)","v":{"v":132.45658338333328,"d":"132.46"}},{"$f":"IF(INT=0,\"N/A\",IBIT/INT)","v":{"v":157.12491671666663,"d":"157.12"}},{"$f":"FORECAST($J$52,F81:I81,$F$52:$I$52)","v":{"v":161.0309584083334,"d":"161.03"}}]
[null,null,"Interest Expense to Net Sales",null,null,{"$f":"IF(NS=0,\"N/A\",INT/NS)","v":{"v":2.9850746268656717E-3,"d":"0.00"}},{"$f":"IF(NS=0,\"N/A\",INT/NS)","v":{"v":0.002912621359223301,"d":"0.00"}},{"$f":"IF(NS=0,\"N/A\",INT/NS)","v":{"v":0.002827787727401263,"d":"0.00"}},{"$f":"IF(NS=0,\"N/A\",INT/NS)","v":{"v":2.5085709507483905E-3,"d":"0.00"}},{"v":2.4299275010161714E-3,"d":"0.00"}]
[null,null,"Current Liabilities to Net Worth",null,null,{"$f":"IF(NW=0,\"N/A\",CL/NW)","v":{"v":0.5401077182368101,"d":"0.54"}},{"$f":"IF(NW=0,\"N/A\",CL/NW)","v":{"v":0.6215860735009672,"d":"0.62"}},{"$f":"IF(NW=0,\"N/A\",CL/NW)","v":{"v":0.6227672624647225,"d":"0.62"}},{"$f":"IF(NW=0,\"N/A\",CL/NW)","v":{"v":0.6239185410642134,"d":"0.62"}},{"v":0.665248313178175,"d":"0.67"}]
[null,null,"Current Liabilities to Inventory",null,null,{"$f":"IF(INV=0,\"N/A\",CL/INV)","v":2.34},{"$f":"IF(INV=0,\"N/A\",CL/INV)","v":2.34},{"$f":"IF(INV=0,\"N/A\",CL/INV)","v":2.34},{"$f":"IF(INV=0,\"N/A\",CL/INV)","v":2.34},2.34]
[null,null,"AP to Net Sales",null,null,{"$f":"(AP)/(NS)","v":{"v":0.04975124378109453,"d":"0.05"}},{"$f":"(AP)/(NS)","v":0.05},{"$f":"(AP)/(NS)","v":0.05},{"$f":"(AP)/(NS)","v":{"v":0.045686386821640605,"d":"0.05"}},{"v":0.04581076493109304,"d":"0.05"}]
[null,null,"Total Liabilities to Net Worth",null,null,{"$f":"IF(NW=0,\"N/A\",TL/NW)","v":{"v":0.9903128910662539,"d":"0.99"}},{"$f":"IF(NW=0,\"N/A\",TL/NW)","v":{"v":1.1424435847840104,"d":"1.14"}},{"$f":"IF(NW=0,\"N/A\",TL/NW)","v":{"v":1.1458591407964878,"d":"1.15"}},{"$f":"IF(NW=0,\"N/A\",TL/NW)","v":{"v":1.1495572494310848,"d":"1.15"}},{"v":1.2273303742962014,"d":"1.23"}]
[null,null,"Net Worth to Total Liabilities",null,null,{"$f":"IF(TL=0,\"N/A\",NW/TL)","v":{"v":1.009781866944412,"d":"1.01"}},{"$f":"IF(TL=0,\"N/A\",NW/TL)","v":{"v":0.875316745018144,"d":"0.88"}},{"$f":"IF(TL=0,\"N/A\",NW/TL)","v":{"v":0.8727076168410185,"d":"0.87"}},{"$f":"IF(TL=0,\"N/A\",NW/TL)","v":{"v":0.8699001293714597,"d":"0.87"}},{"v":0.8013630043197679,"d":"0.80"}]