%5bCompany+Name%5d+Ratio+Analysis+Input+Worksheet+%5bDate%5d%0d%0aGray+cells+will+be+calculated+for+you.+You+do+not+need+to+enter+anything+into+them.%0d%0a%0d%0aLine+Item+Inventory+Total+assets+Owners'+equity+Number+of+common+shares%0d%0a%0d%0aBeginning+of+Year+%2412%2c500+%24120%2c000+%2429%2c000+25%2c000%0d%0a%0d%0aLine+Item+Current+assets+Fixed+assets+Total+assets+Average+total+assets+Cash+and+cash+equivalents+Inventory+Average+inventory+Current+liabilities+Total+liabilities+Owners'+equity+Number+of+common+shares+Average+number+of+common+shares+Average+owners'+equity+Market+price+per+share+Cash+flow+Cash+flow+per+share+Dividends+paid+Total+sales+Operating+expenses+Operating+income+Advertising+expense+Marketing+expense+Earnings+before+interest+and+taxes+Interest+expense+Net+income%0d%0a%0d%0aQ1+45%2c000+80%2c000+125%2c000+122%2c500+15%2c000+15%2c000+13%2c750+23%2c000+125%2c000+28%2c000+25%2c000+25%2c000+28%2c500+10.00+175%2c000+7.00+5%2c000+145%2c000+68%2c000+77%2c000+18%2c000+11%2c000+132%2c000+24%2c000+89%2c000%0d%0a%0d%0aQ2+46%2c000+80%2c000+126%2c000+123%2c000+18%2c000+18%2c000+15%2c250+25%2c000+125%2c000+30%2c900+25%2c000+25%2c000+29%2c950+10.00+186%2c000+7.44+5%2c000+156%2c000+68%2c000+88%2c000+18%2c000+11%2c000+127%2c000+24%2c000+87%2c000%0d%0a%0d%0aQ3+46%2c500+80%2c000+126%2c500+123%2c250+16%2c500+16%2c500+14%2c500+22%2c500+125%2c000+32%2c000+25%2c000+25%2c000+30%2c500+10.00+169%2c000+6.76+5%2c000+135%2c600+68%2c000+67%2c600+18%2c000+11%2c000+114%2c500+24%2c000+95%2c000%0d%0a%0d%0aQ4+43%2c000+80%2c000+123%2c000+121%2c500+14%2c350+14%2c350+13%2c425+25%2c600+125%2c000+28%2c000+25%2c000+25%2c000+28%2c500+10.00+155%2c000+6.20+5%2c000+125%2c000+68%2c000+57%2c000+18%2c000+11%2c000+98%2c000+24%2c000+65%2c000%0d%0a%0d%0aAnnual+%2443%2c000+%2480%2c000+%24123%2c000+%24121%2c500+%2414%2c350+%2414%2c350+%2413%2c425+%2425%2c600+%24125%2c000+%2428%2c000+25%2c000+25%2c000+%2428%2c500+%2410.00+%24685%2c000+%2427.40+%2420%2c000+%24561%2c600+%24272%2c000+%24289%2c600+%2472%2c000+%2444%2c000+%24471%2c500+%2496%2c000+%24336%2c000%0d%0a%0d%0a%0c%5bCompany+Name%5d+Ratio+Analysis%0d%0aLiquidity+Ratios%0d%0aDefinition%3a+Current+Ratio+%3d+Industry+Average+Variance+Quarterly+Growth%2fDecline+Quick+Ratio+%3d+Industry+Average+Variance+Quarterly+Growth%2fDecline+Net+Working+Capital+%3d+Current+Assets+%e2%80%93+Current+Liabilities+Total+Assets+Ratio+Industry+Average+Variance+Quarterly+Growth%2fDecline+Current+Liabilities+to+%3d+Inventory+Ratio+Industry+Average+Variance+Quarterly+Growth%2fDecline+Cash+Ratio+%3d+Industry+Average+Variance+Quarterly+Growth%2fDecline+Operating+Ratio+%3d+Industry+Average+Variance+Quarterly+Growth%2fDecline+Operating+Expenses+Operating+Income+Cash+and+Cash+Equivalents+Current+Liabilities+Current+Liabilities+Inventory+Current+Assets+%e2%80%93+Inventory+Current+Liabilities+Current+Assets+Current+Liabilities+1.96+2.00+(0.04)+%3d+%2445%2c000+%2423%2c000+1.84+2.00+(0.16)+(0.12)+%3d+%2445%2c000+-+%2415%2c000+%2423%2c000+1.12+7.00+(5.88)+(0.18)+%3d+%2445%2c000+-+%2423%2c000+%24125%2c000+0.17+%3d+%2446%2c000+-+%2425%2c000+%24126%2c000+%3d+%2446%2c000+-+%2418%2c000+%2425%2c000+%3d+%2446%2c000+%2425%2c000+2.07+2.00+0.07+0.23+1.33+7.30+(5.97)+0.21+0.19+%3d+%2446%2c500+-+%2422%2c500+%24126%2c500+%3d+%2446%2c500+-+%2416%2c500+%2422%2c500+%3d+%2446%2c500+%2422%2c500+1.68+2.00+(0.32)+(0.39)+1.12+7.20+(6.08)+(0.21)+0.14+%3d+%2443%2c000+-+%2425%2c600+%24123%2c000+%3d+%2443%2c000+-+%2414%2c350+%2425%2c600+%3d+%2443%2c000+%2425%2c600+1.68+2.00+(0.32)+%3d+%2443%2c000+%2425%2c600+Q1+Q2+Q3+Q4+Annual%0d%0a%0d%0a1.30+7.00+(5.70)%0d%0a%0d%0a1.12+2.00+(0.88)%0d%0a%0d%0a%3d%0d%0a%0d%0a%2443%2c000+-+%2414%2c350+%2425%2c600%0d%0a%0d%0a0.18%0d%0a%0d%0a0.14%0d%0a%0d%0a%3d%0d%0a%0d%0a%2443%2c000+-+%2425%2c600+%24123%2c000%0d%0a%0d%0a2.00+(1.82)%0d%0a%0d%0a2.00+(1.83)+(0.01)+%3d+%2423%2c000+%2415%2c000+1.39+%3d+%2425%2c000+%2418%2c000%0d%0a%0d%0a2.00+(1.81)+0.02+1.36+%3d+%2422%2c500+%2416%2c500%0d%0a%0d%0a2.00+(1.86)+(0.05)+1.78+%3d+%2425%2c600+%2414%2c350%0d%0a%0d%0a2.00+(1.86)%0d%0a%0d%0a1.53%0d%0a%0d%0a1.78%0d%0a%0d%0a%3d%0d%0a%0d%0a%2425%2c600+%2414%2c350%0d%0a%0d%0a2.00+(0.47)%0d%0a%0d%0a2.00+(0.61)+(0.14)+%3d+%2415%2c000+%2423%2c000+0.72+2.00+(1.28)+0.07+%3d+%2468%2c000+%2477%2c000+0.77+2.00+(1.23)+(0.11)+%3d+%2468%2c000+%2488%2c000+%3d+%2418%2c000+%2425%2c000%0d%0a%0d%0a2.00+(0.64)+(0.03)+0.73+2.00+(1.27)+0.01+1.01+2.00+(0.99)+0.23+%3d+%2468%2c000+%2467%2c600+%3d+%2416%2c500+%2422%2c500%0d%0a%0d%0a2.00+(0.22)+0.42+0.56+2.00+(1.44)+(0.17)+1.19+2.00+(0.81)+0.19+%3d+%2468%2c000+%2457%2c000+%3d+%2414%2c350+%2425%2c600%0d%0a%0d%0a2.00+(0.22)%0d%0a%0d%0a0.65+2.00+(1.35)%0d%0a%0d%0a0.56+2.00+(1.44)%0d%0a%0d%0a%3d%0d%0a%0d%0a%2414%2c350+%2425%2c600%0d%0a%0d%0a0.88+2.00+(1.12)%0d%0a%0d%0a0.94+2.00+(1.06)%0d%0a%0d%0a%3d%0d%0a%0d%0a%24272%2c000+%24289%2c600%0d%0a%0d%0aThe+following+calculations+can+be+used+for+any+expense+line+item+or+grouping+of+expense+line+items%3a+Advertising+Expense+%3d+to+Sales+Ratio+Industry+Average+Variance+Quarterly+Growth%2fDecline+Marketing+Expense+%3d+to+Sales+Ratio+Industry+Average+Variance+Quarterly+Growth%2fDecline+Marketing+Expense+Total+Sales+Advertising+Expense+Total+Sales+0.12+%3d+%2418%2c000+%24145%2c000+0.12+%3d+%2418%2c000+%24156%2c000+0.13+%3d+%2418%2c000+%24135%2c600+0.14+%3d+%2418%2c000+%24125%2c000+0.13+%3d+%2472%2c000+%24561%2c600%0d%0a%0d%0a2.00+(1.88)%0d%0a%0d%0a2.00+(1.88)+(0.01)+%3d+%2411%2c000+%24145%2c000+0.07+%3d+%2411%2c000+%24156%2c000%0d%0a%0d%0a2.00+(1.87)+0.02+0.08+%3d+%2411%2c000+%24135%2c600%0d%0a%0d%0a2.00+(1.86)+0.01+0.09+%3d+%2411%2c000+%24125%2c000%0d%0a%0d%0a2.00+(1.87)%0d%0a%0d%0a0.08%0d%0a%0d%0a0.08%0d%0a%0d%0a%3d%0d%0a%0d%0a%2444%2c000+%24561%2c600%0d%0a%0d%0a2.00+(1.92)%0d%0a%0d%0a2.00+(1.93)+(0.01)%0d%0a%0d%0a2.00+(1.92)+0.01%0d%0a%0d%0a2.00+(1.91)+0.01%0d%0a%0d%0a2.00+(1.92)%0d%0a%0d%0a%0c%5bCompany+Name%5d+Ratio+Analysis%0d%0aAsset+Ratios%0d%0aDefinition%3a+Inventory+Turnover+Ratio+%3d+Total+Sales+Average+Inventory+10.55+%3d+%24145%2c000+%2413%2c750+10.23+%3d+%24156%2c000+%2415%2c250+9.35+%3d+%24135%2c600+%2414%2c500+9.31+%3d+%24125%2c000+%2413%2c425+41.83+%3d+%24561%2c600+%2413%2c425+Q1+Q2+Q3+Q4+Annual%0d%0a%0d%0aIndustry+Average+Variance+Quarter+Growth%2fDecline+Fixed+Assets+Turnover+%3d+Ratio+Industry+Average+Variance+Quarter+Growth%2fDecline+Total+Assets+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Asset+to+Equity+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Total+Assets+Owners'+Equity+Total+Sales+Total+Assets+Total+Sales+Fixed+Assets%0d%0a%0d%0a6.00+4.55%0d%0a%0d%0a6.00+4.23+(0.32)+%3d+%24145%2c000+%2480%2c000+1.95+%3d+%24156%2c000+%2480%2c000%0d%0a%0d%0a6.00+3.35+(0.88)+1.70+%3d+%24135%2c600+%2480%2c000%0d%0a%0d%0a6.00+3.31+(0.04)+1.56+%3d+%24125%2c000+%2480%2c000%0d%0a%0d%0a2.00+39.83%0d%0a%0d%0a1.81%0d%0a%0d%0a7.02%0d%0a%0d%0a%3d%0d%0a%0d%0a%24561%2c600+%2480%2c000%0d%0a%0d%0a2.00+(0.19)%0d%0a%0d%0a2.00+(0.05)+0.14+%3d+%24145%2c000+%24125%2c000+1.24+2.00+(0.76)+0.08+%3d+%24125%2c000+%2428%2c000+4.08+2.00+2.08+(0.39)+%3d+%24126%2c000+%2430%2c900+%3d+%24156%2c000+%24126%2c000%0d%0a%0d%0a2.00+(0.31)+(0.26)+1.07+2.00+(0.93)+(0.17)+3.95+2.00+1.95+(0.12)+%3d+%24126%2c500+%2432%2c000+%3d+%24135%2c600+%24126%2c500%0d%0a%0d%0a2.00+(0.44)+(0.13)+1.02+2.00+(0.98)+(0.06)+4.39+2.00+2.39+0.44+%3d+%24123%2c000+%2428%2c000+%3d+%24125%2c000+%24123%2c000%0d%0a%0d%0a2.00+5.02%0d%0a%0d%0a1.16+2.00+(0.84)%0d%0a%0d%0a4.57+2.00+2.57%0d%0a%0d%0a%3d%0d%0a%0d%0a%24561%2c600+%24123%2c000%0d%0a%0d%0a4.46+2.00+2.46%0d%0a%0d%0a4.39+2.00+2.39%0d%0a%0d%0a%3d%0d%0a%0d%0a%24123%2c000+%2428%2c000%0d%0a%0d%0a%0c%5bCompany+Name%5d+Ratio+Analysis%0d%0aProfitability+Ratios%0d%0aDefinition%3a+Return+on+Assets+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Return+on+Equity+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Profit+Margin+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Basic+Earnings+%3d+Power+Ratio+Industry+Average+Variance+Quarter+Growth%2fDecline+Earnings+per+Share+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Net+Income+Average+Number+of+Common+Shares+Earnings+Before+Interest+and+Taxes+Total+Assets+Net+Income+Total+Sales+Net+Income+Average+Owners'+Equity+Net+Income+Average+Total+Assets+0.73+2.00+(1.27)+%3d+%2489%2c000+%24122%2c500+0.71+2.00+(1.29)+(0.02)+%3d+%2489%2c000+%2428%2c500+2.90+2.00+0.90+(0.22)+%3d+%2489%2c000+%24145%2c000+0.56+2.00+(1.44)+(0.06)+%3d+%24132%2c000+%24125%2c000+1.01+%3d+%24127%2c000+%24126%2c000+%3d+%2487%2c000+%24156%2c000+%3d+%2487%2c000+%2429%2c950+%3d+%2487%2c000+%24123%2c000+0.77+2.00+(1.23)+0.06+3.11+2.00+1.11+0.21+0.70+2.00+(1.30)+0.14+0.91+%3d+%24114%2c500+%24126%2c500+%3d+%2495%2c000+%24135%2c600+%3d+%2495%2c000+%2430%2c500+%3d+%2495%2c000+%24123%2c250+0.53+2.00+(1.47)+(0.24)+2.28+2.00+0.28+(0.83)+0.52+2.00+(1.48)+(0.18)+0.80+%3d+%2498%2c000+%24123%2c000+%3d+%2465%2c000+%24125%2c000+%3d+%2465%2c000+%2428%2c500+%3d+%2465%2c000+%24121%2c500+2.77+2.00+0.77+%3d+%24336%2c000+%24121%2c500+Q1+Q2+Q3+Q4+Annual%0d%0a%0d%0a3.12+2.00+1.12%0d%0a%0d%0a11.79+2.00+9.79%0d%0a%0d%0a%3d%0d%0a%0d%0a%24336%2c000+%2428%2c500%0d%0a%0d%0a0.61+2.00+(1.39)%0d%0a%0d%0a0.60+2.00+(1.40)%0d%0a%0d%0a%3d%0d%0a%0d%0a%24336%2c000+%24561%2c600%0d%0a%0d%0a1.06%0d%0a%0d%0a3.83%0d%0a%0d%0a%3d%0d%0a%0d%0a%24471%2c500+%24123%2c000%0d%0a%0d%0a2.00+(0.94)%0d%0a%0d%0a2.00+(0.99)+(0.05)+%3d+%2489%2c000+%2425%2c000+3.48+2.00+1.48+(0.08)+%3d+%2487%2c000+%2425%2c000%0d%0a%0d%0a2.00+(1.09)+(0.10)+3.80+2.00+1.80+0.32+%3d+%2495%2c000+%2425%2c000%0d%0a%0d%0a2.00+(1.20)+(0.11)+2.60+2.00+0.60+(1.20)+%3d+%2465%2c000+%2425%2c000%0d%0a%0d%0a2.00+1.83%0d%0a%0d%0a3.56+2.00+1.56%0d%0a%0d%0a13.44+2.00+11.44%0d%0a%0d%0a%3d%0d%0a%0d%0a%24336%2c000+%2425%2c000%0d%0a%0d%0a%0c%5bCompany+Name%5d+Ratio+Analysis%0d%0aDebt+Ratios%0d%0aDefinition%3a+Total+Debt+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Interest+Coverage+Ratio+%3d+Earnings+Before+Interest+and+Taxes+Interest+Expense+Total+Liabilities+Total+Assets+1.00+2.00+(1.00)+%3d+%24125%2c000+%24125%2c000+0.99+2.00+(1.01)+(0.01)+%3d+%24132%2c000+%2424%2c000+5.29+%3d+%24127%2c000+%2424%2c000+%3d+%24125%2c000+%24126%2c000+0.99+2.00+(1.01)+(0.00)+4.77+%3d+%24114%2c500+%2424%2c000+%3d+%24125%2c000+%24126%2c500+1.02+2.00+(0.98)+0.03+4.08+%3d+%2498%2c000+%2424%2c000+%3d+%24125%2c000+%24123%2c000+1.02+2.00+(0.98)+%3d+%24125%2c000+%24123%2c000+Q1+Q2+Q3+Q4+Annual%0d%0a%0d%0a5.50%0d%0a%0d%0a4.91%0d%0a%0d%0a%3d%0d%0a%0d%0a%24471%2c500+%2496%2c000%0d%0a%0d%0aIndustry+Average+Variance+Quarter+Growth%2fDecline+Debt%2fEquity+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Loan+to+Value+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Total+Loan+Value+of+Collateral+or+Property+Total+Liabilities+Owners'+Equity%0d%0a%0d%0a2.00+3.50%0d%0a%0d%0a2.00+3.29+(0.21)+%3d+%24125%2c000+%2428%2c000+4.05+2.00+2.05+(0.42)+%3d+%2425%2c000+%2465%2c000+0.37+2.00+(1.63)+(0.02)+%3d+%2424%2c000+%2465%2c000+%3d+%24125%2c000+%2430%2c900%0d%0a%0d%0a2.00+2.77+(0.52)+3.91+2.00+1.91+(0.14)+0.35+2.00+(1.65)+(0.02)+%3d+%2423%2c000+%2465%2c000+%3d+%24125%2c000+%2432%2c000%0d%0a%0d%0a2.00+2.08+(0.69)+4.46+2.00+2.46+0.56+0.34+2.00+(1.66)+(0.02)+%3d+%2422%2c000+%2465%2c000+%3d+%24125%2c000+%2428%2c000%0d%0a%0d%0a2.00+2.91%0d%0a%0d%0a4.46+2.00+2.46%0d%0a%0d%0a4.46+2.00+2.46%0d%0a%0d%0a%3d%0d%0a%0d%0a%24125%2c000+%2428%2c000%0d%0a%0d%0a0.38+2.00+(1.62)%0d%0a%0d%0a0.34+2.00+(1.66)%0d%0a%0d%0a%3d%0d%0a%0d%0a%2422%2c000+%2465%2c000%0d%0a%0d%0a%0c%5bCompany+Name%5d+Ratio+Analysis%0d%0aMarket+Ratios%0d%0aDefinition%3a+Earnings+per+Share+%3d+Net+Income+(EPS)+Ratio+Average+Number+of+Common+Shares+Industry+Average+Variance+Quarter+Growth%2fDecline+Price+to+Earnings+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Price+to+Cash+%3d+Flow+Ratio+Industry+Average+Variance+Quarter+Growth%2fDecline+Payout+Ratio+%3d+Industry+Average+Variance+Quarter+Growth%2fDecline+Dividends+Paid+Net+Income+Market+Price+per+Share+Cash+Flow+per+Share+Market+Price+per+Share+Earnings+per+Share+%243.56+%3d+%2489%2c000+25%2c000+%243.48+%3d+%2487%2c000+25%2c000+%243.80+%3d+%2495%2c000+25%2c000+%242.60+%3d+%2465%2c000+25%2c000+%2413.44+%3d+%24336%2c000+25%2c000+Q1+Q2+Q3+Q4+Annual%0d%0a%0d%0a2.00+1.56%0d%0a%0d%0a2.00+1.48+(0.08)+%3d+%2410.00+%243.56+2.87+2.00+0.87+0.06+%3d+%2410.00+%247.00+1.34+%3d+%2410.00+%247.44+%3d+%2410.00+%243.48%0d%0a%0d%0a2.00+1.80+0.32+2.63+2.00+0.63+(0.24)+1.48+%3d+%2410.00+%246.76+%3d+%2410.00+%243.80%0d%0a%0d%0a2.00+0.60+(1.20)+3.85+2.00+1.85+1.21+1.61+%3d+%2410.00+%246.20+%3d+%2410.00+%242.60%0d%0a%0d%0a2.00+11.44%0d%0a%0d%0a2.81+2.00+0.81%0d%0a%0d%0a0.74+2.00+(1.26)%0d%0a%0d%0a%3d%0d%0a%0d%0a%2410.00+%2413.44%0d%0a%0d%0a1.43%0d%0a%0d%0a0.36%0d%0a%0d%0a%3d%0d%0a%0d%0a%2410.00+%2427.40%0d%0a%0d%0a2.00+(0.57)%0d%0a%0d%0a2.00+(0.66)+(0.08)+%3d+%245%2c000+%2489%2c000+0.06+2.00+(1.94)+0.00+%3d+%245%2c000+%2487%2c000%0d%0a%0d%0a2.00+(0.52)+0.14+0.05+2.00+(1.95)+(0.00)+%3d+%245%2c000+%2495%2c000%0d%0a%0d%0a2.00+(0.39)+0.13+0.08+2.00+(1.92)+0.02+%3d+%245%2c000+%2465%2c000%0d%0a%0d%0a2.00+(1.64)%0d%0a%0d%0a0.06+2.00+(1.94)%0d%0a%0d%0a0.06+2.00+(1.94)%0d%0a%0d%0a%3d%0d%0a%0d%0a%2420%2c000+%24336%2c000%0d%0a%0d%0a%0c