H3

  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View H3 as PDF for free.

More details

  • Words: 2,390
  • Pages: 14
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

B

C

D

E

F

G Women added

Male heads affected by bolding

1987 31,576,369

1988 32,523,660

1989 33,499,370

1990 34,504,351

1991 35,539,482

1992 36,605,666

% of boldness product works for

H

I

J change to OTC

K

L

M

N

O

P

1993 1994 1995 1996 1997 1998 1999 2000 37,703,836 38,834,951 40000000 41,200,000 42,436,000 43,709,080 45,020,352 46,370,963 !! the age group we are interested in grew by average 3% - higher than overall population 35,818,645 36,893,204 38000000 41,200,000 42,436,000 43,709,080 45,020,352 46,370,963

29,997,551

30,897,477

31,824,402

32,779,134

33,762,508

34,775,383

9.9% cumulative willing to buy New buyers due to fast growing age segment

2,969,758 0

3,058,850 89,093

3,150,616 91,766

3,245,134 94,518

3,342,488 97,354

3,442,763 100,275

3,546,046 103,283

3762000 109,573

4,327,199 126,035

New market share reached who will try Willing & have not tried yet (new base) cumulative who have tried

445,464 n/a 445,464

443,533 2,169,853 888,997

441,086 1,820,533 1,330,083

438,093 1,476,958 1,768,176

447,893 1,126,419 2,216,070

447,559 779,134 2,663,629

457,440 547,864 424,977 negative! Means we reached whole potential market with our current "constraints" 3,121,069 3,668,933 4,233,233 4,812,422 5,400,585

584,172

579,412

592,204

5,984,757

6,564,169

7,156,373

1,496,189 1,641,042 438,129 434,559 $433,549,322 $471,476,355

1,789,093 444,153 $511,406,038

$137,868,684 $149,929,481

$162,627,120

$238,512,824 $259,378,002

$281,344,918

since doctors do not "filter" I assume that every person with boldness with try

3,652,427 106,381

4,078,800 4,201,164 316,800 122,364 Number changes, since price falls ! 564,300 579,190 588,163

4,457,015 129,816

4,590,725 133,710

= (25% of new buyers from growing age segment * 37.93% able to buy) + previously won loyal buyers

loyal full-time buyers (25% try) 111,366 one year try people for 4 month 334,098 abs. max revenue from above (4month + year)* ($660-20%)$117,602,399

917,233 410,898 ###

1,058,308 423,225 $633,274,336

$35,646,748 $41,001,121 $48,314,372

$54,968,212

New Marketshare (Exhibit 3) men = 73% increase so far 11.3% + 7.1% willing to buy if > $ 600, now additional 13.5% Sales company had in the U.S. (men & women) $2,000,000 $34,000,000 $70,000,000 $95,000,000 ### $122,000,000 $84,000,000 $96,000,000 market share captured of conditional maximum market (US) 510% 45% 29% 27% 30% 29% 49% 50% total sales world-wide $32,000,000 $88,000,000 ### ### ### $165,000,000 ### ### marketing spend on men (based on world-data) $45,000,000 $45,000,000 $45,000,000 $45,000,000 $45,000,000 $30,000,000 $34,580,000 $32,400,000 marketing cost as % of sales 141% 51% 39% 32% 30% 18% 30% 27%

Forcast $96,000,000 57% $124,000,000 $75,000,000 60%

20% is the margin for reseller

222,249 332,650 ###

332,521 330,815 ###

442,044 328,570 ###

554,017 665,907 335,920 335,669 ### $410,676,821

780,267 343,080 ###

$660 was taken as average of annual cost: $600 - $720

abs.max. of people of have the money (men 8.68%)

1,203,106 1,350,146 434,392 441,122 $355,846,395 $395,257,392 !new price base $330

$10,207,888 $15,267,598 $20,293,350 $25,278,552 $30,522,624

$113,159,154 $125,691,851 % goes from 8.68% to 31.8%

Women heads affected by bolding % of boldness the product works for 13.2% cumulative willing to buy % Women who have the money (2.52%)

$195,765,336 $217,446,902

$52,856,641

$58,710,663

$64,398,462

$70,032,060

$75,963,128

20,600,000 20,600,000 2,719,200 568,313

21,218,000 21,218,000 2,800,776 585,362

21,854,540 21,854,540 2,884,799 602,923

22,510,176 22,510,176 2,971,343 621,011

23,185,481 23,185,481 3,060,484 639,641

618,000 120,336 205,179 41,036

636,540 123,946 295,617 59,123

655,636 127,665 388,769 77,754

675,305 373,579 484,715 96,943

24,096 88,031 153,884 $7,633,457 $13,944,063 $24,375,217 65% !new price base $330 Forcast $22,171,060 $38,756,595

221,713 $35,119,306

291,576 $46,185,717

363,536 $57,584,121

$55,839,696

$73,435,290

18,302,833 17,387,692 2,295,175 57,838

18,851,918 17,909,322 2,364,031 59,574

19,417,476 18,446,602 2,434,951 60,874

20,000,000 19,000,000 2,508,000 55,176

5,784 5,784 1,157

549,085 60,866 14,720 2,944

565,558 62,643 23,851 4,770

582,524 63,770 32,127 6,425

4,338 $1,374,241 30%

11,040 $3,497,443 53%

17,888 $5,666,985 56%

% goes from 2.52% to 20.9%

New buyers due to fast growing age segment New market share reached who will try cumulative who have tried loyal full-time buyers (20% try)

600,000 116,831 117,374 23,475

since meaningful regrowth only 20% for women, I assume this is the loyal rate

one year try people for 4 month abs. max revenue from above (4month + year)* ($660-20%) New Marketshare (Exh. 3) women

total share with women = 59% increase so far 11.1% + 5.3% willing to buy if > $ 600, now additional 9.7%

$91,558,752 Weights

Forcast under old model / new price Revenue expectation (1 billion in 4-5 years) Analyst "think 400-500 million possible per year"

$200,000,000

### $200,000,000 $200,000,000

$200,000,000

30%

estimate was $250,000 possible per year / or 1 billion in 5 years

without progaine

$450,000,000 ### $450,000,000 $450,000,000 $450,000,000 Total max forcast $217,936,395 $256,203,496 $294,352,520 $332,813,292 $372,903,670 US Weighted forcast $235,761,837 ### $281,611,512 ### $328,742,202 World forcast (ratio average 1.55)$365,430,848 $401,019,252 $436,497,843 $472,266,361 $509,550,413

10% 60%

million men % of total 21.3 23.0% age 29 31.3% age 6.2 11.0% age 56.5 million women% of total 21.6 45.1% age 19.6 41.0% age 6.65 13.9% age 47.85

% of $25,000- % of $50,000+% of $ 75,000+ 25-34 34.40% 4.70% 1.70% 35-44 41.80% 11.80% 6% 45-54 (half) 19.60% 6.95% 8.10% 25-34 35-44 45-54 (half)

17.20% 22.20% 11.10%

1.20% 2.70% 1.50%

0.40% 1% 0.50%

under old price % with new price % 1.47% 9.4% 5.56% 18.6% 1.65% 3.8% 8.68% 31.8% 0.72% 1.52% 0.28% 2.52%

8.5% 10.6% 1.8% 20.9%

m

4.7 11.8 6.95 4.05 6 1.7 35.2 92.8 0.38

34.4 41.8 19.65 95.85

ForeCast estimated people affected bolding pattern it works for subtract % willing to pay % of people who effectively sought treatment possible people seeking treatment

men 40,000,000 38,000,000

women 20,000,000 19,000,000

total 60,000,000 57,000,000

9.90% 3,762,000

13.30% 2,527,000

57,000,000

% people willing to spend people available to buy Annual OTC sales / year potential max sales % people who see moderate success people who might stay with the product sales that might stay

31.90% 26.10% 1,200,078 659,547 $320 $320 $384,024,960 $211,055,040 26% 19% 312,020 125,314 $99,846,490 $40,100,458

% people who have the money people who would have the money to buy potential max sales % people who see moderate success people who might stay with the product sales that might stay

37.93% 1,426,966 $456,628,966 26% 371,011 $118,723,531

7.25% 183,189 $58,620,377 19% 34,806 $11,137,872

cumulative ! Taking place over time thus spread it over the years ! ! Exhibit 5 falsch gerechnet 1,859,625 since new price is roughly half of previous price ### 4.7 1.7 11.8 6 6.95 4.05 35.2

437,334 ### correct now 1,610,154 ### 405,817 ###

4 month supply cost full year

4month

4month 213.33 640

trial 1619418 1799353 1999281 2221423 2468248 2742498 3047220 3385800 3762000 here

rate 404854 1214563 449838 1349515 499820 1499461 555356 1666068 617062 1851186 685625 2056874 761805 2285415 846450 2539350 I end up with the cummulative of 9.9%

1.2 0.4 2.7 1 1.5 0.5 7.3

trial repeat are 25% of trial HOW LONG WILL THEY TRY IT

13.9 8.1

1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000

35.2 7.3

Survey data - is max population do not start at 9 that is the max

only work pattern boldness

95%

3 case talks about others COULD launch it could be that we are in the market place without competition lower price and could lower again if they launch - they go down to 40% market potential

Assumption: 1 year higher try rate then assume decrease since lack of doctor cumulative levels off

Q2 conclusion TIP : they did WELL

the market for rogaine is what rogaine made it to be, since there is NO competition thus market share I have "100%" for prescription thus analyze if we did a good job

sales world 1987 1988 1989 1990 1991 1992 1993 1994 1995

sales us $32 $88 $115 $140 $148 $165 $115 $122 $124

$2 $34 $70 $95 $103 $122 $84 $96 $96

Marketing sales per marketing $ Sales-Marketing consumer measure meadia SALES Amount of users worldiwdetotal market % market sharetotal market women men women advertising ($ in million) next slide (600-720) men men $45.00 $0.71 -$13 16.00 $4.91 110 48,485 40,000,000 0.12% 20,000,000 $45.00 $1.96 $43 2.59 $9.35 110 133,333 40,000,000 0.33% 20,000,000 $45.00 $2.56 $70 1.64 $3.44 110 174,242 40,000,000 0.44% 20,000,000 $45.00 $3.11 $95 1.47 110 212,121 40,000,000 0.53% 20,000,000 $45.00 $3.29 $103 1.44 110 224,242 40,000,000 0.56% 20,000,000 $30.00 $5.50 $135 1.35 women were added 110 250,000 40,000,000 0.63% 20,000,000 $34.58 $3.33 $80 1.37 110 174,242 40,000,000 0.44% 20,000,000 $32.40 $3.77 $90 1.27 110 184,848 40,000,000 0.46% 20,000,000 $75.00 $1.65 $49 1.29 110 187,879 40,000,000 0.47% 20,000,000 ! Text is confusing about what the marketing expenditure is! 12.43

believed

1.55

$250 Q2: has Rogaine been able to capture enough market share 25% of existing consumers will continue to buy product 75% will go to alternative (find the number)

What is your assessment of the revenue performance for Rogaine from 1988 to 1995? How do you support your assessment? (20 points)

Segments male female total

number of heads

Marketing as percentag of sales 140.6% 51.1% 39.1% 32.1% 30.4% 18.2% 30.1% 26.6% 60.5%

% of market

Male heads affected by bolding

1987 40000000

1988 40000000

% of boldness product works for

38,000,000

38,000,000

9.9% cumulative willing to buy New buyers due to fast growing age segment

3,762,000 0

3,762,000 0

New market share reached who will try Willing & have not tried yet (new base) cumulative who have tried

564,300 n/a 564,300

545,490 2,652,210 1,109,790

= (25% of new buyers from growing ag

loyal full-time buyers (25% try) 141,075 one year try people for 4 month 423,225 abs. max revenue from above (4month + year)* ($660-20%)$148,975,200 20% is the margin for reseller

277,448 409,118 ###

$660 was taken as average of annual cost: $600 - $720

abs.max. of people of have the money (men 8.68%)

$12,931,047 $18,965,536

New Marketshare (Exhibit 3) men so far 11.3% + 7.1% willing to buy if > $ 600, now additional Sales company had in the U.S. (men & women) $2,000,000 $34,000,000 market share captured of conditional maximum market (US) 647% 56% total sales world-wide $32,000,000 $88,000,000 marketing spend on men (based on world-data) $45,000,000 $45,000,000 marketing cost as % of sales 141% 51% Women heads affected by bolding % of boldness the product works for 13.2% cumulative willing to buy % Women who have the money (2.52%) New buyers due to fast growing age segment New market share reached who will try cumulative who have tried loyal full-time buyers (20% try) since meaningful regrowth only 20% for women, I assume this is the loyal rate

one year try people for 4 month abs. max revenue from above (4month + year)* ($660-20%) New Marketshare (Exh. 3) women

so far 11.1% + 5.3% willing to buy if > $ 600, now additional

Forcast under old model / new price Revenue expectation (1 billion in 4-5 years) Analyst "think 400-500 million possible per year"

hands attached to heads potentially buging (Gessner formula) average amount of wallets - weighted spending average single hands paying * $620 ( - 20% to company) 5

Women added 1989 40000000

1990 40000000

1991 40000000

1992 40000000

1993 1994 40000000 40000000 !! the age group we are interested 38,000,000 38,000,000

38,000,000

38,000,000

38,000,000

38,000,000

3,762,000 0

3,762,000 0

3,762,000 0

3,762,000 0

3,762,000 0

526,680 2,125,530 1,636,470

507,870 1,617,660 2,144,340

504,108 1,113,552 2,648,448

489,060 624,492 3,137,508

485,298 564,300 139,194 negative! Means we reached whole potential 3,622,806 4,187,106

3,762,000 0

25% of new buyers from growing age segment * 37.93% able to buy) + previously won loyal buyers

409,118 395,010 ###

536,085 380,903 ###

662,112 784,377 378,081 366,795 ### $478,706,976

905,702 363,974 ###

1,046,777 423,225 ###

erage of annual cost: $600 - $720

$24,784,507 $30,387,961 $36,120,726

$41,551,766 $47,069,012 $54,439,709

= 73% increase $70,000,000 $95,000,000 ### $122,000,000 $84,000,000 $96,000,000 35% 32% 35% 34% 56% 57% ### ### ### $165,000,000 ### ### $45,000,000 $45,000,000 $45,000,000 $30,000,000 $34,580,000 $32,400,000 39% 32% 30% 18% 30% 27%

ng to buy if > $ 600, now additional 13.5%

total share with women = 59% increase ng to buy if > $ 600, now additional 9.7%

18,302,833 17,387,692 2,295,175 57,838

18,851,918 17,909,322 2,364,031 59,574

19,417,476 18,446,602 2,434,951 60,874

229,518 229,518 45,904

549,085 291,312 238,454 47,691

565,558 300,051 247,585 49,517

172,138 178,840 185,688 $54,533,365 $56,656,567 $58,826,108 79% 123% 118%

Total max forcast US Weighted forcast World forcast (ratio average)

7

8

8

8.5

9

9.45

change to OTC

1995 1996 1997 1998 1999 2000 40000000 40000000 40000000 40000000 40000000 40000000 e age group we are interested in grew by average 3% - higher than overall population 38000000 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000 since doctors do not "filter" I assume that every person with boldness with try

3762000 0

3,960,000 3,960,000 198,000 0 Number changes, since price falls ! 564,300 562,320 554,400

3,960,000 0

3,960,000 0

3,960,000 0

534,600

514,800

510,840

6,402,726

6,917,526

7,428,366

1,600,682 1,729,382 400,950 386,100 $457,863,516 $490,533,516

1,857,092 383,130 $523,987,596

$145,600,598 $155,989,658

$166,628,056

$251,889,035 $269,862,108

$288,266,536

ative! Means we reached whole potential market with our current "constraints"

4,751,406 1,187,852 423,225 $701,673,192

5,313,726

5,868,126

1,328,432 1,467,032 421,740 415,800 $387,819,036 $423,886,716 !new price base $330

$60,905,233

$123,326,453 $134,795,976 % goes from 8.68% to 31.8%

Forcast $96,000,000 63% $124,000,000 $75,000,000 60% 20,000,000 19,000,000 2,508,000 55,176

$213,354,764 $233,197,038

20,600,000 20,600,000 2,719,200 568,313

21,218,000 21,218,000 2,800,776 585,362

21,854,540 21,854,540 2,884,799 602,923

22,510,176 22,510,176 2,971,343 621,011

23,185,481 23,185,481 3,060,484 639,641

618,000 341,878 428,912 85,782

636,540 352,134 519,351 103,870

655,636 362,698 612,502 122,500

675,305 373,579 708,449 141,690

191,896 255,831 321,684 $60,792,581 $40,523,625 $50,954,779 127% !new price base $330 Forcast $64,432,563 $81,018,098

389,513 $61,698,868

459,377 $72,765,279

531,336 $84,163,683

$98,101,199 $115,696,793

$133,820,255

% goes from 2.52% to 20.9%

582,524 309,052 255,861 51,172

600,000 331,920 341,108 68,222

$200,000,000

### $200,000,000 $200,000,000

$200,000,000

estimate was $250,000 possible per year / or 1 billion in 5 years

$450,000,000 ### $450,000,000 $450,000,000 $450,000,000 al max forcast $277,787,328 $314,215,136 $349,990,234 $385,558,902 $422,086,791 Weighted forcast $271,672,397 ### $314,994,140 ### $358,252,075 rld forcast (ratio average)

9.9

under old price w %ith new price % 0.00% 0.0% 0.00% 0.0% 0.00% 0.0% 0.00% 0.0% 0.00% 0.00% 0.00% 0.00%

0.0% 0.0% 0.0% 0.0%

Laura he sais that using 40m everywhere is fine, but I like it correct this is the 95% for men and women this probably is the difficult part, 9.9% commulative this you can ignore if you take the 40m everywhere

this is the max forecast for Q3 green is Q2

Weights 30% 10% 60%

new price %

Related Documents

H3
October 2019 13
H3
December 2019 6
H3
April 2020 7
H3 Dispute
November 2019 15
Module Viii-h3 Praktijk
August 2019 12
H3 Margin Short Selling
October 2019 17