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

{"sheet":"Financial Comparison Analysis","index":0,"n_rows":43,"n_cols":10,"rows_kept":43,"merged":[[45,1,45,9]]}
[]
[]
[null,"Financial Comparison Analysis"]
[null,"Your Company, Inc"]
[]
[{"$nulls":3},"Industry Average",{"$nulls":3},"Company Actual"]
[{"$nulls":3},2007,{"$f":"D7+1","v":2008},{"$f":"E7+1","v":2009},null,{"$f":"D7","v":2007},{"$f":"H7+1","v":2008},{"$f":"I7+1","v":2009}]
[null,"ASSETS"]
[null,"Cash",null,{"v":1500,"d":"$1,500"},{"v":1560,"d":"$1,560"},{"v":1490,"d":"$1,490"},null,{"v":2230,"d":"$2,230"},{"v":2450,"d":"$2,450"},{"v":2670,"d":"$2,670"}]
[null,"Accounts receivable",null,{"v":250,"d":"$250"},{"v":300,"d":"$300"},{"v":360,"d":"$360"},null,{"v":370,"d":"$370"},{"v":420,"d":"$420"},{"v":440,"d":"$440"}]
[null,"Inventory",null,{"v":500,"d":"$500"},{"v":650,"d":"$650"},{"v":740,"d":"$740"},null,{"v":800,"d":"$800"},{"v":875,"d":"$875"},{"v":840,"d":"$840"}]
[null,null,"Total Current Assets",{"$f":"IF(SUM(D9:D11),SUM(D9:D11),\"\")","v":{"v":2250,"d":"$2,250"}},{"$f":"IF(SUM(E9:E11),SUM(E9:E11),\"\")","v":{"v":2510,"d":"$2,510"}},{"$f":"IF(SUM(F9:F11),SUM(F9:F11),\"\")","v":{"v":2590,"d":"$2,590"}},null,{"$f":"IF(SUM(H9:H11),SUM(H9:H11),\"\")","v":{"v":3400,"d":"$3,400"}},{"$f":"IF(SUM(I9:I11),SUM(I9:I11),\"\")","v":{"v":3745,"d":"$3,745"}},{"$f":"IF(SUM(J9:J11),SUM(J9:J11),\"\")","v":{"v":3950,"d":"$3,950"}}]
[null,"Fixed assets (net)",null,{"v":1250,"d":"$1,250"},{"v":1340,"d":"$1,340"},{"v":1290,"d":"$1,290"},null,{"v":2650,"d":"$2,650"},{"v":2790,"d":"$2,790"},{"v":2850,"d":"$2,850"}]
[null,"TOTAL ASSETS",null,{"$f":"IF(OR(D13<>0,SUM(D12)),SUM(D12:D13),\"\")","v":{"v":3500,"d":"$3,500"}},{"$f":"IF(OR(E13<>0,SUM(E12)),SUM(E12:E13),\"\")","v":{"v":3850,"d":"$3,850"}},{"$f":"IF(OR(F13<>0,SUM(F12)),SUM(F12:F13),\"\")","v":{"v":3880,"d":"$3,880"}},null,{"$f":"IF(OR(H13<>0,SUM(H12)),SUM(H12:H13),\"\")","v":{"v":6050,"d":"$6,050"}},{"$f":"IF(OR(I13<>0,SUM(I12)),SUM(I12:I13),\"\")","v":{"v":6535,"d":"$6,535"}},{"$f":"IF(OR(J13<>0,SUM(J12)),SUM(J12:J13),\"\")","v":{"v":6800,"d":"$6,800"}}]
[]
[null,"LIABILITIES & EQUITY"]
[null,"Accts & notes payable",null,{"v":1800,"d":"$1,800"},{"v":1870,"d":"$1,870"},{"v":1910,"d":"$1,910"},null,{"v":3370,"d":"$3,370"},{"v":3650,"d":"$3,650"},{"v":3975,"d":"$3,975"}]
[null,"Accrued & other payables",null,{"v":350,"d":"$350"},{"v":380,"d":"$380"},{"v":385,"d":"$385"},null,{"v":590,"d":"$590"},{"v":635,"d":"$635"},{"v":650,"d":"$650"}]
[null,null,"Total Current Liabilities",{"$f":"IF(OR(D18<>0,D17),D17+D18,\"\")","v":{"v":2150,"d":"$2,150"}},{"$f":"IF(OR(E18<>0,E17),E17+E18,\"\")","v":{"v":2250,"d":"$2,250"}},{"$f":"IF(OR(F18<>0,F17),F17+F18,\"\")","v":{"v":2295,"d":"$2,295"}},null,{"$f":"IF(OR(H18<>0,H17),H17+H18,\"\")","v":{"v":3960,"d":"$3,960"}},{"$f":"IF(OR(I18<>0,I17),I17+I18,\"\")","v":{"v":4285,"d":"$4,285"}},{"$f":"IF(OR(J18<>0,J17),J17+J18,\"\")","v":{"v":4625,"d":"$4,625"}}]
[null,"Long-term debt",null,{"v":800,"d":"$800"},{"v":940,"d":"$940"},{"v":1060,"d":"$1,060"},null,{"v":1650,"d":"$1,650"},{"v":1780,"d":"$1,780"},{"v":1825,"d":"$1,825"}]
[null,null,"Total Debt",{"$f":"IF(SUM(D19,D20),D19+D20,\"\")","v":{"v":2950,"d":"$2,950"}},{"$f":"IF(SUM(E19,E20),E19+E20,\"\")","v":{"v":3190,"d":"$3,190"}},{"$f":"IF(SUM(F19,F20),F19+F20,\"\")","v":{"v":3355,"d":"$3,355"}},null,{"$f":"IF(SUM(H19,H20),H19+H20,\"\")","v":{"v":5610,"d":"$5,610"}},{"$f":"IF(SUM(I19,I20),I19+I20,\"\")","v":{"v":6065,"d":"$6,065"}},{"$f":"IF(SUM(J19,J20),J19+J20,\"\")","v":{"v":6450,"d":"$6,450"}}]
[null,"Shareholders' equity",null,{"$f":"IF(OR(SUM(D14)<>0,SUM(D21)),SUM(D14)-SUM(D21),\"\")","v":{"v":550,"d":"$550"}},{"$f":"IF(OR(SUM(E14)<>0,SUM(E21)),SUM(E14)-SUM(E21),\"\")","v":{"v":660,"d":"$660"}},{"$f":"IF(OR(SUM(F14)<>0,SUM(F21)),SUM(F14)-SUM(F21),\"\")","v":{"v":525,"d":"$525"}},null,{"$f":"IF(OR(SUM(H14)<>0,SUM(H21)),SUM(H14)-SUM(H21),\"\")","v":{"v":440,"d":"$440"}},{"$f":"IF(OR(SUM(I14)<>0,SUM(I21)),SUM(I14)-SUM(I21),\"\")","v":{"v":470,"d":"$470"}},{"$f":"IF(OR(SUM(J14)<>0,SUM(J21)),SUM(J14)-SUM(J21),\"\")","v":{"v":350,"d":"$350"}}]
[null,"TOTAL LIABILITIES & EQUITY",null,{"$f":"IF(SUM(D14,D21),SUM(D21:D22),\"\")","v":{"v":3500,"d":"$3,500"}},{"$f":"IF(SUM(E14,E21),SUM(E21:E22),\"\")","v":{"v":3850,"d":"$3,850"}},{"$f":"IF(SUM(F14,F21),SUM(F21:F22),\"\")","v":{"v":3880,"d":"$3,880"}},null,{"$f":"IF(SUM(H14,H21),SUM(H21:H22),\"\")","v":{"v":6050,"d":"$6,050"}},{"$f":"IF(SUM(I14,I21),SUM(I21:I22),\"\")","v":{"v":6535,"d":"$6,535"}},{"$f":"IF(SUM(J14,J21),SUM(J21:J22),\"\")","v":{"v":6800,"d":"$6,800"}}]
[]
[null,"INCOME DATA"]
[null,"Net sales",null,{"v":1900,"d":"$1,900"},{"v":2250,"d":"$2,250"},{"v":1985,"d":"$1,985"},null,{"v":3540,"d":"$3,540"},{"v":3740,"d":"$3,740"},{"v":3850,"d":"$3,850"}]
[null,"Cost of goods sold",null,{"v":1095,"d":"$1,095"},{"v":1250,"d":"$1,250"},{"v":1125,"d":"$1,125"},null,{"v":1830,"d":"$1,830"},{"v":1910,"d":"$1,910"},{"v":2250,"d":"$2,250"}]
[null,null,"Gross Profit",{"$f":"IF(OR(D26<>0,D27),D26-D27,\"\")","v":{"v":805,"d":"$805"}},{"$f":"IF(OR(E26<>0,E27),E26-E27,\"\")","v":{"v":1000,"d":"$1,000"}},{"$f":"IF(OR(F26<>0,F27),F26-F27,\"\")","v":{"v":860,"d":"$860"}},null,{"$f":"IF(OR(H26<>0,H27),H26-H27,\"\")","v":{"v":1710,"d":"$1,710"}},{"$f":"IF(OR(I26<>0,I27),I26-I27,\"\")","v":{"v":1830,"d":"$1,830"}},{"$f":"IF(OR(J26<>0,J27),J26-J27,\"\")","v":{"v":1600,"d":"$1,600"}}]
[null,"Operating expenses",null,{"v":250,"d":"$250"},{"v":420,"d":"$420"},{"v":365,"d":"$365"},null,{"v":780,"d":"$780"},{"v":830,"d":"$830"},{"v":790,"d":"$790"}]
[null,"Operating profit",null,{"$f":"IF(OR(SUM(D28)<>0,D29),D28-D29,\"\")","v":{"v":555,"d":"$555"}},{"$f":"IF(OR(SUM(E28)<>0,E29),E28-E29,\"\")","v":{"v":580,"d":"$580"}},{"$f":"IF(OR(SUM(F28)<>0,F29),F28-F29,\"\")","v":{"v":495,"d":"$495"}},null,{"$f":"IF(OR(SUM(H28)<>0,H29),H28-H29,\"\")","v":{"v":930,"d":"$930"}},{"$f":"IF(OR(SUM(I28)<>0,I29),I28-I29,\"\")","v":{"v":1000,"d":"$1,000"}},{"$f":"IF(OR(SUM(J28)<>0,J29),J28-J29,\"\")","v":{"v":810,"d":"$810"}}]
[null,"All other expenses (net)",null,{"v":375,"d":"$375"},{"v":410,"d":"$410"},{"v":420,"d":"$420"},null,{"v":640,"d":"$640"},{"v":705,"d":"$705"},{"v":750,"d":"$750"}]
[null,"PROFIT BEFORE TAXES",null,{"$f":"IF(OR(SUM(D30)<>0,D31),D30-D31,\"\")","v":{"v":180,"d":"$180"}},{"$f":"IF(OR(SUM(E30)<>0,E31),E30-E31,\"\")","v":{"v":170,"d":"$170"}},{"$f":"IF(OR(SUM(F30)<>0,F31),F30-F31,\"\")","v":{"v":75,"d":"$75"}},null,{"$f":"IF(OR(SUM(H30)<>0,H31),H30-H31,\"\")","v":{"v":290,"d":"$290"}},{"$f":"IF(OR(SUM(I30)<>0,I31),I30-I31,\"\")","v":{"v":295,"d":"$295"}},{"$f":"IF(OR(SUM(J30)<>0,J31),J30-J31,\"\")","v":{"v":60,"d":"$60"}}]
[]
[null,"FINANCIAL RATIOS"]
[null,"Current",null,{"$f":"IF(SUM(D19),SUM(D12)/SUM(D19),\"\")","v":{"v":1.0465116279069768,"d":"1.0"}},{"$f":"IF(SUM(E19),SUM(E12)/SUM(E19),\"\")","v":{"v":1.1155555555555556,"d":"1.1"}},{"$f":"IF(SUM(F19),SUM(F12)/SUM(F19),\"\")","v":{"v":1.1285403050108933,"d":"1.1"}},null,{"$f":"IF(SUM(H19),SUM(H12)/SUM(H19),\"\")","v":{"v":0.8585858585858586,"d":"0.9"}},{"$f":"IF(SUM(I19),SUM(I12)/SUM(I19),\"\")","v":{"v":0.8739789964994166,"d":"0.9"}},{"$f":"IF(SUM(J19),SUM(J12)/SUM(J19),\"\")","v":{"v":0.8540540540540541,"d":"0.9"}}]
[null,"Total debt / total assets",null,{"$f":"IF(SUM(D14),SUM(D21)/SUM(D14),\"\")","v":{"v":0.8428571428571429,"d":"0.8"}},{"$f":"IF(SUM(E14),SUM(E21)/SUM(E14),\"\")","v":{"v":0.8285714285714286,"d":"0.8"}},{"$f":"IF(SUM(F14),SUM(F21)/SUM(F14),\"\")","v":{"v":0.8646907216494846,"d":"0.9"}},null,{"$f":"IF(SUM(H14),SUM(H21)/SUM(H14),\"\")","v":{"v":0.9272727272727272,"d":"0.9"}},{"$f":"IF(SUM(I14),SUM(I21)/SUM(I14),\"\")","v":{"v":0.928079571537873,"d":"0.9"}},{"$f":"IF(SUM(J14),SUM(J21)/SUM(J14),\"\")","v":{"v":0.9485294117647058,"d":"0.9"}}]
[null,"Total debt / equity",null,{"$f":"IF(SUM(D22),SUM(D21)/(D22),\"\")","v":{"v":5.363636363636363,"d":"5.4"}},{"$f":"IF(SUM(E22),SUM(E21)/(E22),\"\")","v":{"v":4.833333333333333,"d":"4.8"}},{"$f":"IF(SUM(F22),SUM(F21)/(F22),\"\")","v":{"v":6.390476190476191,"d":"6.4"}},null,{"$f":"IF(SUM(H22),SUM(H21)/(H22),\"\")","v":{"v":12.75,"d":"12.8"}},{"$f":"IF(SUM(I22),SUM(I21)/(I22),\"\")","v":{"v":12.904255319148936,"d":"12.9"}},{"$f":"IF(SUM(J22),SUM(J21)/(J22),\"\")","v":{"v":18.428571428571427,"d":"18.4"}}]
[null,"Collection period days",null,{"$f":"IF(SUM(D26),SUM(D10)/(SUM(D26)/(340+25)),\"\")","v":{"v":48.02631578947368,"d":"48.0"}},{"$f":"IF(SUM(E26),SUM(E10)/(SUM(E26)/(340+25)),\"\")","v":{"v":48.66666666666667,"d":"48.7"}},{"$f":"IF(SUM(F26),SUM(F10)/(SUM(F26)/(340+25)),\"\")","v":{"v":66.19647355163728,"d":"66.2"}},null,{"$f":"IF(SUM(H26),SUM(H10)/(SUM(H26)/(340+25)),\"\")","v":{"v":38.1497175141243,"d":"38.1"}},{"$f":"IF(SUM(I26),SUM(I10)/(SUM(I26)/(340+25)),\"\")","v":{"v":40.98930481283423,"d":"41.0"}},{"$f":"IF(SUM(J26),SUM(J10)/(SUM(J26)/(340+25)),\"\")","v":{"v":41.714285714285715,"d":"41.7"}}]
[null,"Net sales / inventory",null,{"$f":"IF(SUM(D11),SUM(D26)/SUM(D11),\"\")","v":3.8},{"$f":"IF(SUM(E11),SUM(E26)/SUM(E11),\"\")","v":{"v":3.4615384615384617,"d":"3.5"}},{"$f":"IF(SUM(F11),SUM(F26)/SUM(F11),\"\")","v":{"v":2.6824324324324325,"d":"2.7"}},null,{"$f":"IF(SUM(H11),SUM(H26)/SUM(H11),\"\")","v":{"v":4.425,"d":"4.4"}},{"$f":"IF(SUM(I11),SUM(I26)/SUM(I11),\"\")","v":{"v":4.274285714285714,"d":"4.3"}},{"$f":"IF(SUM(J11),SUM(J26)/SUM(J11),\"\")","v":{"v":4.583333333333333,"d":"4.6"}}]
[null,"Total assets turnover",null,{"$f":"IF(SUM(D14),SUM(D26)/SUM(D14),\"\")","v":{"v":0.5428571428571428,"d":"0.5"}},{"$f":"IF(SUM(E14),SUM(E26)/SUM(E14),\"\")","v":{"v":0.5844155844155844,"d":"0.6"}},{"$f":"IF(SUM(F14),SUM(F26)/SUM(F14),\"\")","v":{"v":0.5115979381443299,"d":"0.5"}},null,{"$f":"IF(SUM(H14),SUM(H26)/SUM(H14),\"\")","v":{"v":0.5851239669421487,"d":"0.6"}},{"$f":"IF(SUM(I14),SUM(I26)/SUM(I14),\"\")","v":{"v":0.5723029839326702,"d":"0.6"}},{"$f":"IF(SUM(J14),SUM(J26)/SUM(J14),\"\")","v":{"v":0.5661764705882353,"d":"0.6"}}]
[null,"Gross profit margin",null,{"$f":"IF(SUM(D26),SUM(D28)/SUM(D26),\"\")","v":{"v":0.4236842105263158,"d":"42%"}},{"$f":"IF(SUM(E26),SUM(E28)/SUM(E26),\"\")","v":{"v":0.4444444444444444,"d":"44%"}},{"$f":"IF(SUM(F26),SUM(F28)/SUM(F26),\"\")","v":{"v":0.4332493702770781,"d":"43%"}},null,{"$f":"IF(SUM(H26),SUM(H28)/SUM(H26),\"\")","v":{"v":0.4830508474576271,"d":"48%"}},{"$f":"IF(SUM(I26),SUM(I28)/SUM(I26),\"\")","v":{"v":0.4893048128342246,"d":"49%"}},{"$f":"IF(SUM(J26),SUM(J28)/SUM(J26),\"\")","v":{"v":0.4155844155844156,"d":"42%"}}]
[null,"Operating profit margin",null,{"$f":"IF(SUM(D26),SUM(D30)/SUM(D26),\"\")","v":{"v":0.29210526315789476,"d":"29%"}},{"$f":"IF(SUM(E26),SUM(E30)/SUM(E26),\"\")","v":{"v":0.2577777777777778,"d":"26%"}},{"$f":"IF(SUM(F26),SUM(F30)/SUM(F26),\"\")","v":{"v":0.24937027707808565,"d":"25%"}},null,{"$f":"IF(SUM(H26),SUM(H30)/SUM(H26),\"\")","v":{"v":0.2627118644067797,"d":"26%"}},{"$f":"IF(SUM(I26),SUM(I30)/SUM(I26),\"\")","v":{"v":0.26737967914438504,"d":"27%"}},{"$f":"IF(SUM(J26),SUM(J30)/SUM(J26),\"\")","v":{"v":0.21038961038961038,"d":"21%"}}]
[null,"Return on equity",null,{"$f":"IF(SUM(D22),SUM(D32)/SUM(D22),\"\")","v":{"v":0.32727272727272727,"d":"33%"}},{"$f":"IF(SUM(E22),SUM(E32)/SUM(E22),\"\")","v":{"v":0.25757575757575757,"d":"26%"}},{"$f":"IF(SUM(F22),SUM(F32)/SUM(F22),\"\")","v":{"v":0.14285714285714285,"d":"14%"}},null,{"$f":"IF(SUM(H22),SUM(H32)/SUM(H22),\"\")","v":{"v":0.6590909090909091,"d":"66%"}},{"$f":"IF(SUM(I22),SUM(I32)/SUM(I22),\"\")","v":{"v":0.6276595744680851,"d":"63%"}},{"$f":"IF(SUM(J22),SUM(J32)/SUM(J22),\"\")","v":{"v":0.17142857142857143,"d":"17%"}}]