Market analysis1

%5bCompany+Name%5d+Market+Analysis+Worksheet+%5bDate%5d+Model+Key%0d%0aNumbers+in+white+cells+are+entered+by+user.+Numbers+in+gray+cells+are+calculated+for+you.+These+generally+should+not+be+altered.%0d%0a%0d%0aGeneral+Information%0d%0aDate+of+analysis+12%2f31%2f04+Marketing+manager+Rich+Haddock+Summary+of+market+opportunity+and+key+assumptions%3a+We+will+begin+selling+product+X+to+the+retail+market+in+January+of+next+year.+We+will+attempt+to+position+our+product+as+the+low-priced+alternative%2c+stressing+market+share+over+pure+profitability.%0d%0a%0d%0aProduct+Market+Analysis%0d%0aNumber+of+potential+new+customers+Percentage+of+potential+customers+with+adequate+funds+to+purchase+Number+of+available+customers+with+budget+Market+share+projections+Estimated+share+of+annual+market+Competitor+%231+share+Competitor+%232+share+Competitor+%233+share+No-buy+decision+Total+Number+of+converted+customers+%5bCompany+Name%5d+Competitors+Total+active+customers+Estimated+number+of+remaining+customers%0d%0a%0d%0aYear+1+100%2c000+25.0%25+25%2c000%0d%0a%0d%0aYear+2+150%2c000+27.5%25+41%2c250%0d%0a%0d%0aYear+3+200%2c000+30.0%25+60%2c000%0d%0a%0d%0aYear+4+250%2c000+35.0%25+87%2c500%0d%0a%0d%0a25.00%25+20.00%25+15.00%25+0.00%25+40.00%25+100.00%25%0d%0a%0d%0a25.00%25+20.00%25+15.00%25+5.00%25+35.00%25+100.00%25%0d%0a%0d%0a30.00%25+20.00%25+15.00%25+5.00%25+30.00%25+100.00%25%0d%0a%0d%0a30.00%25+20.00%25+10.00%25+5.00%25+35.00%25+100.00%25%0d%0a%0d%0a6%2c250+8%2c750+15%2c000+10%2c000%0d%0a%0d%0a10%2c313+16%2c500+26%2c813+14%2c438%0d%0a%0d%0a18%2c000+24%2c000+42%2c000+18%2c000%0d%0a%0d%0a26%2c250+30%2c625+56%2c875+30%2c625%0d%0a%0d%0a%0cFinancial+Projections%0d%0aChannel+mix+Direct+Indirect+Average+sale+per+direct+customer+Average+sale+per+indirect+customer+Direct+annual+revenue+Indirect+annual+revenue+Direct+gross+margin+%25+Indirect+gross+margin+%25+Direct+gross+margin+%24+Indirect+gross+margin+%24%0d%0a%0d%0aYear+1+80%25+20%25+%24200+%24225+%241%2c000%2c000+%24281%2c250+25%25+28%25+%24250%2c000+%2478%2c750%0d%0a%0d%0aYear+2+75%25+25%25+%24205+%24233+%241%2c585%2c547+%24600%2c703+28%25+30%25+%24443%2c953+%24180%2c211%0d%0a%0d%0aYear+3+75%25+25%25+%24215+%24240+%242%2c902%2c500+%241%2c080%2c000+32%25+35%25+%24928%2c800+%24378%2c000%0d%0a%0d%0aYear+4+70%25+30%25+%24220+%24243+%244%2c042%2c500+%241%2c913%2c625+36%25+39%25+%241%2c455%2c300+%24746%2c314%0d%0a%0d%0a%0c%0c%0cAnnual+Revenue%0d%0a%244%2c500%2c000+%244%2c000%2c000+%243%2c500%2c000+%243%2c000%2c000+%242%2c500%2c000+%242%2c000%2c000+%241%2c500%2c000+%241%2c000%2c000+%24500%2c000+%240+Year+1+Year+2%0d%0aDirect+annual+revenue%0d%0a%0d%0aYear+3%0d%0aIndirect+annual+revenue%0d%0a%0d%0aYear+4%0d%0a%0d%0a%0cGross+Margin%0d%0a%241%2c600%2c000+%241%2c400%2c000+%241%2c200%2c000+%241%2c000%2c000+%24800%2c000+%24600%2c000+%24400%2c000+%24200%2c000+%240+Year+1+Year+2%0d%0aDirect+gross+margin+%24%0d%0a%0d%0aYear+3%0d%0aIndirect+gross+margin+%24%0d%0a%0d%0aYear+4%0d%0a%0d%0a%0c