SaaSGrandfathering
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAU
1
Scenario 1: No customers lost due to lack of grandfathering
2
3
SummaryYear 1Year 2Year 3
4
Year 1Year 2Year 3123456789101112Total Year 1123456789101112Total Year 2123456789101112Total Year 3
5
AssumptionsRevenues from Group A customers
6
Group A customers begining of month1,000975951927904881859838817796776757738720702684667650634618603588573559545531518505492480468456445434423412
7
Customers1000Lost Group A customers252424232322212120201919181818171716161515151414141313131212121111111110
8
Current ARPC$100Total Group A customers end of month975951927904881859838817796776757738720702684667650634618603588573559545531518505492480468456445434423412402
9
Current MRR$100,000Revenues from Group A customers based on old pricing$1,021,806$754,091$556,518$97,500$95,063$92,686$90,369$88,110$85,907$83,759$81,665$79,624$77,633$75,692$73,800$1,021,806$71,955$70,156$68,402$66,692$65,025$63,399$61,814$60,269$58,762$57,293$55,861$54,464$754,091$53,103$51,775$50,481$49,219$47,988$46,788$45,619$44,478$43,366$42,282$41,225$40,194$556,518
10
Churn rate (p.m.)2.50%Revenues from Group A customers due to pricing increase$510,903$377,046$278,259$48,750$47,531$46,343$45,184$44,055$42,953$41,880$40,833$39,812$38,816$37,846$36,900$510,903$35,977$35,078$34,201$33,346$32,512$31,700$30,907$30,134$29,381$28,646$27,930$27,232$377,046$26,551$25,887$25,240$24,609$23,994$23,394$22,809$22,239$21,683$21,141$20,613$20,097$278,259
11
Customer growth (p.m.)5.00%
12
Price increase50%Revenues from Group B customers
13
ARPC after price increase$150Customers beginning of month1,0001,0251,0511,0771,1041,1311,1601,1891,2181,2491,2801,3121,3451,3791,4131,4481,4851,5221,5601,5991,6391,6801,7221,7651,8091,8541,9001,9481,9962,0462,0982,1502,2042,2592,3152,373
14
Lost customers252626272828293030313233343435363738394041424344454648495051525455565859
15
New customers50515354555758596162646667697172747678808284868890939597100102105108110113116119
16
Customers end of month1,0251,0511,0771,1041,1311,1601,1891,2181,2491,2801,3121,3451,3791,4131,4481,4851,5221,5601,5991,6391,6801,7221,7651,8091,8541,9001,9481,9962,0462,0982,1502,2042,2592,3152,3732,433
17
Thereof Group B customers501001502002503013514024535045556076597117648188719269811,0361,0921,1491,2061,2641,3231,3831,4431,5041,5671,6301,6941,7591,8251,8931,9612,031
18
Revenues from Group B customers$588,357$1,721,461$3,001,650$7,500$15,000$22,505$30,019$37,547$45,094$52,664$60,263$67,894$75,563$83,275$91,034$588,357$98,844$106,712$114,642$122,638$130,706$138,850$147,076$155,389$163,794$172,296$180,901$189,613$1,721,461$198,438$207,381$216,449$225,646$234,979$244,452$254,073$263,846$273,778$283,875$294,143$304,589$3,001,650
19
20
Total revenues$2,121,066$2,852,598$3,836,428$153,750$157,594$161,534$165,572$169,711$173,954$178,303$182,760$187,329$192,013$196,813$201,733$2,121,066$206,777$211,946$217,245$222,676$228,243$233,949$239,798$245,792$251,937$258,236$264,692$271,309$2,852,598$278,092$285,044$292,170$299,474$306,961$314,635$322,501$330,564$338,828$347,298$355,981$364,880$3,836,428
21
Thereof from Group A customers based on old pricing48%26%15%63%60%57%55%52%49%47%45%43%40%38%37%48%35%33%31%30%28%27%26%25%23%22%21%20%26%19%18%17%16%16%15%14%13%13%12%12%11%15%
22
Revenue portion that you give up by grandfathering existing plans >>>Thereof from Group A customers due to pricing increase24%13%7%32%30%29%27%26%25%23%22%21%20%19%18%24%17%17%16%15%14%14%13%12%12%11%11%10%13%10%9%9%8%8%7%7%7%6%6%6%6%7.25308%
23
Thereof from Group B customers28%60%78%5%10%14%18%22%26%30%33%36%39%42%45%28%48%50%53%55%57%59%61%63%65%67%68%70%60%71%73%74%75%77%78%79%80%81%82%83%83%78%
24
25
26
Scenario 2: Customers lost due to lack of grandfathering
27
28
SummaryYear 1Year 2Year 3
29
Year 1Year 2Year 3123456789101112Total Year 1123456789101112Total Year 2123456789101112Total Year 3
30
AssumptionsRevenues from Group A customers
31
Group A customers begining of month950926903881859837816796776756738719701684666650634618602587573558544531517504492480468456444433423412402392
32
Customers1000Lost Group A customers242323222121202019191818181717161615151514141413131312121211111111101010
33
Current ARPC$100Total Group A customers end of month926903881859837816796776756738719701684666650634618602587573558544531517504492480468456444433423412402392382
34
Current MRR$100,000Revenues from Group A customers based on old pricing$970,716$716,387$528,692$92,625$90,309$88,052$85,850$83,704$81,611$79,571$77,582$75,642$73,751$71,908$70,110$970,716$68,357$66,648$64,982$63,357$61,773$60,229$58,723$57,255$55,824$54,428$53,068$51,741$716,387$50,447$49,186$47,957$46,758$45,589$44,449$43,338$42,254$41,198$40,168$39,164$38,185$528,692
35
Churn rate (p.m.)2.50%Revenues from Group A customers due to pricing increase$485,358$358,193$264,346$46,313$45,155$44,026$42,925$41,852$40,806$39,786$38,791$37,821$36,876$35,954$35,055$485,358$34,179$33,324$32,491$31,679$30,887$30,115$29,362$28,628$27,912$27,214$26,534$25,870$358,193$25,224$24,593$23,978$23,379$22,794$22,225$21,669$21,127$20,599$20,084$19,582$19,092$264,346
36
Customer growth (p.m.)5.00%
37
Price increase50%Revenues from Group B customers
38
ARPC after price increase$150Customers beginning of month9509749981,0231,0491,0751,1021,1291,1571,1861,2161,2461,2781,3101,3421,3761,4101,4461,4821,5191,5571,5961,6351,6761,7181,7611,8051,8501,8971,9441,9932,0432,0942,1462,2002,255
39
Customers lost due to lack of grandfathering5.00%Lost customers242425262627282829303031323334343536373839404142434445464749505152545556
40
New customers484950515254555658596162646567697172747678808284868890939597100102105107110113
41
Customers end of month9749981,0231,0491,0751,1021,1291,1571,1861,2161,2461,2781,3101,3421,3761,4101,4461,4821,5191,5571,5961,6351,6761,7181,7611,8051,8501,8971,9441,9932,0432,0942,1462,2002,2552,311
42
Thereof Group B customers48951431902382863343824304795275776266767267778288799319841,0371,0911,1461,2011,2571,3131,3711,4291,4881,5481,6091,6711,7341,7981,8631,929
43
Revenues from Group B customers$558,939$1,635,388$2,851,568$7,125$14,250$21,379$28,518$35,670$42,839$50,031$57,250$64,499$71,785$79,111$86,482$558,939$93,902$101,377$108,910$116,506$124,170$131,908$139,723$147,620$155,604$163,681$171,856$180,132$1,635,388$188,516$197,012$205,627$214,364$223,230$232,230$241,369$250,654$260,089$269,681$279,436$289,359$2,851,568
44
45
Total revenues$2,015,013$2,709,968$3,644,606$146,063$149,714$153,457$157,293$161,226$165,256$169,388$173,622$177,963$182,412$186,972$191,647$2,015,013$196,438$201,349$206,382$211,542$216,831$222,251$227,808$233,503$239,340$245,324$251,457$257,743$2,709,968$264,187$270,792$277,562$284,501$291,613$298,903$306,376$314,035$321,886$329,933$338,182$346,636$3,644,606
46
Thereof from Group A customers based on old pricing48%26%15%63%60%57%55%52%49%47%45%43%40%38%37%48%35%33%31%30%28%27%26%25%23%22%21%20%26%19%18%17%16%16%15%14%13%13%12%12%11%15%
47
Thereof from Group A customers due to pricing increase24%13%7%32%30%29%27%26%25%23%22%21%20%19%18%24%17%17%16%15%14%14%13%12%12%11%11%10%13%10%9%9%8%8%7%7%7%6%6%6%6%7%
48
Thereof from Group B customers28%60%78%5%10%14%18%22%26%30%33%36%39%42%45%28%48%50%53%55%57%59%61%63%65%67%68%70%60%71%73%74%75%77%78%79%80%81%82%83%83%78%
49
50
Total revenues without grandfathering$2,015,013$2,709,968$3,644,606$146,063$149,714$153,457$157,293$161,226$165,256$169,388$173,622$177,963$182,412$186,972$191,647$2,015,013$196,438$201,349$206,382$211,542$216,831$222,251$227,808$233,503$239,340$245,324$251,457$257,743$2,709,968$264,187$270,792$277,562$284,501$291,613$298,903$306,376$314,035$321,886$329,933$338,182$346,636$3,644,606
51
Total revenues with grandfathering$1,610,163$2,475,553$3,558,168$105,000$110,063$115,191$120,388$125,656$131,001$136,423$141,928$147,518$153,196$158,967$164,833$1,610,163$170,799$176,868$183,044$189,330$195,730$202,249$208,890$215,658$222,556$229,589$236,761$244,077$2,475,553$251,540$259,156$266,930$274,865$282,967$291,241$299,692$308,324$317,144$326,157$335,368$344,783$3,558,168
52
53
Group A = existing customers before the price increase
54
Group B = new customers after the price increase
Loading...