Spreadsheet: 861145d1709113545-building-customer-cohort-chart-with-dynamic-renewal-rates-and-periods-subscriber-cohort-chart_v2
Sheet: Sheet1

 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00 | 2027-07-01 00:00:00 | 2027-08-01 00:00:00 | 2027-09-01 00:00:00 | 2027-10-01 00:00:00 | 2027-11-01 00:00:00 | 2027-12-01 00:00:00 | 2028-01-01 00:00:00 | 2028-02-01 00:00:00 | 2028-03-01 00:00:00
New subscribers
Annual | 1000 |  | 1040.4 | 1061.208 | 1082.43216 | 1104.0808032 | 1126.162419264 | 1148.68566764928 | 1171.659381002266 | 1195.092568622311 | 1218.994419994757 | 1243.374308394653 | 1268.241794562546 | 1293.606630453797 | 1319.478763062873 | 1345.86833832413 | 1372.785705090613 | 1400.241419192425 | 1428.246247576274 | 1456.811172527799 | 1485.947395978355 | 1515.666343897922 | 1545.979670775881 | 1576.899264191398 | 1608.437249475226 | 1640.605994464731 | 1673.418114354025 | 1706.886476641106 | 1741.024206173928 | 1775.844690297406 | 1811.361584103355 | 1847.588815785422 | 1884.54059210113 | 1922.231403943153 | 1960.676032022016 | 1999.889552662456 | 2039.887343715706 | 2080.68509059002 | 2122.29879240182 | 2164.744768249857 | 2208.039663614854 | 2252.200456887151 | 2297.244466024894 | 2343.189355345392 | 2390.0531424523 | 2437.854205301346 | 2486.611289407373 | 2536.34351519552
Quarterly | 200 |  | 208.08 | 212.2416 | 216.486432 | 220.81616064 | 225.2324838528 | 229.737133529856 | 234.3318762004531 | 239.0185137244622 | 243.7988839989515 | 248.6748616789305 | 253.6483589125091 | 258.7213260907593 | 263.8957526125745 | 269.173667664826 | 274.5571410181225 | 280.048283838485 | 285.6492495152547 | 291.3622345055598 | 297.189479195671 | 303.1332687795845 | 309.1959341551761 | 315.3798528382796 | 321.6874498950452 | 328.1211988929462 | 334.6836228708051 | 341.3772953282212 | 348.2048412347856 | 355.1689380594813 | 362.2723168206709 | 369.5177631570843 | 376.9081184202261 | 384.4462807886306 | 392.1352064044032 | 399.9779105324913 | 407.9774687431411 | 416.1370181180039 | 424.459758480364 | 432.9489536499713 | 441.6079327229708 | 450.4400913774302 | 459.4488932049788 | 468.6378710690784 | 478.0106284904599 | 487.5708410602691 | 497.3222578814745 | 507.268703039104
Retention rates
Annual | 0.5 |  | 0.51005 | 0.5151505 | 0.520302005 | 0.52550502505 | 0.5307600753005 | 0.5360676760535049 | 0.54142835281404 | 0.5468426363421804 | 0.5523110627056023 | 0.5578341733326583 | 0.5634125150659849 | 0.5690466402166448 | 0.5747371066188112 | 0.5804844776849993 | 0.5862893224618493 | 0.5921522156864678 | 0.5980737378433325 | 0.6040544752217658 | 0.6100950199739835 | 0.6161959701737234 | 0.6223579298754607 | 0.6285815091742153 | 0.6348673242659575 | 0.641215997508617 | 0.6476281574837032 | 0.6541044390585402 | 0.6606454834491257 | 0.667251938283617 | 0.6739244576664531 | 0.6806637022431177 | 0.6874703392655489 | 0.6943450426582044 | 0.7012884930847865 | 0.7083013780156343 | 0.7153843917957906 | 0.7225382357137485 | 0.7297636180708861 | 0.737061254251595 | 0.7444318667941109 | 0.751876185462052 | 0.7593949473166726 | 0.7669888967898393 | 0.7746587857577377 | 0.7824053736153151 | 0.7902294273514683 | 0.798131721624983
Quarterly | 0.4 |  | 0.40804 | 0.4121204 | 0.416241604 | 0.42040402004 | 0.4246080602404 | 0.428854140842804 | 0.433142682251232 | 0.4374741090737443 | 0.4418488501644818 | 0.4462673386661266 | 0.4507300120527879 | 0.4552373121733158 | 0.4597896852950489 | 0.4643875821479994 | 0.4690314579694794 | 0.4737217725491742 | 0.478458990274666 | 0.4832435801774126 | 0.4880760159791868 | 0.4929567761389786 | 0.4978863439003685 | 0.5028652073393721 | 0.5078938594127659 | 0.5129727980068935 | 0.5181025259869625 | 0.5232835512468321 | 0.5285163867593005 | 0.5338015506268935 | 0.5391395661331624 | 0.544530961794494 | 0.549976271412439 | 0.5554760341265634 | 0.5610307944678291 | 0.5666411024125074 | 0.5723075134366326 | 0.5780305885709989 | 0.5838108944567089 | 0.5896490034012759 | 0.5955454934352886 | 0.6015009483696415 | 0.6075159578533379 | 0.6135911174318712 | 0.6197270286061899 | 0.6259242988922518 | 0.6321835418811743 | 0.638505377299986
Active subscribers
Annual
Total active quarterly subscribers
Quarterly
Active subscribers
Annual
Total active quarterly subscribers |  | 404 | 612.08 | 706.7456800000001 | 804.1453992160001 | 904.3592283459233 | 960.0434550029415 | 1017.637386951438 | 1077.210650092806 | 1103.837582750308 | 1131.173638394969 | 1159.239267370707 | 1188.055556189301 | 1217.644248647858 | 1248.027767684249 | 1279.229237997338 | 1311.272509459792 | 1344.18218135234 | 1377.983627449404 | 1412.703021987146 | 1448.367366546158 | 1485.004517882205 | 1522.64321673971 | 1561.313117683954 | 1601.044819989327 | 1641.869899622371 | 1683.820942359797 | 1726.931578083211 | 1771.236516293802 | 1816.771582891936 | 1863.573758268247 | 1911.6812167546 | 1961.133367485141 | 2011.970896719509 | 2064.235811682307 | 2117.971485974929 | 2173.222706617998 | 2230.035722784874 | 2288.458296288979 | 2348.539753890055 | 2410.331041486986 | 2473.884780267339 | 2539.255324886482 | 2606.498823751887 | 2675.673281491131 | 2746.838623685057 | 2820.056763950735 | 2895.391673461993
Quarterly
 |  | 200 | 204 | 208.08 | 212.2416 | 216.486432 | 220.81616064 | 225.2324838528 | 229.737133529856 | 234.3318762004532 | 239.0185137244622 | 243.7988839989515 | 248.6748616789305 | 253.6483589125091 | 258.7213260907594 | 263.8957526125745 | 269.173667664826 | 274.5571410181226 | 280.048283838485 | 285.6492495152547 | 291.3622345055598 | 297.189479195671 | 303.1332687795845 | 309.1959341551761 | 315.3798528382797 | 321.6874498950453 | 328.1211988929462 | 334.6836228708051 | 341.3772953282212 | 348.2048412347856 | 355.1689380594813 | 362.272316820671 | 369.5177631570844 | 376.9081184202261 | 384.4462807886306 | 392.1352064044033 | 399.9779105324913 | 407.9774687431411 | 416.1370181180039 | 424.4597584803641 | 432.9489536499714 | 441.6079327229708 | 450.4400913774302 | 459.4488932049789 | 468.6378710690785 | 478.01062849046 | 487.5708410602692 | 497.3222578814746
 |  |  | 200 | 204 | 208.08 | 212.2416 | 216.486432 | 220.81616064 | 225.2324838528 | 229.737133529856 | 234.3318762004532 | 239.0185137244622 | 243.7988839989515 | 248.6748616789305 | 253.6483589125091 | 258.7213260907594 | 263.8957526125745 | 269.173667664826 | 274.5571410181226 | 280.048283838485 | 285.6492495152547 | 291.3622345055598 | 297.189479195671 | 303.1332687795845 | 309.1959341551761 | 315.3798528382797 | 321.6874498950453 | 328.1211988929462 | 334.6836228708051 | 341.3772953282212 | 348.2048412347856 | 355.1689380594813 | 362.272316820671 | 369.5177631570844 | 376.9081184202261 | 384.4462807886306 | 392.1352064044033 | 399.9779105324913 | 407.9774687431411 | 416.1370181180039 | 424.4597584803641 | 432.9489536499714 | 441.6079327229708 | 450.4400913774302 | 459.4488932049789 | 468.6378710690785 | 478.01062849046 | 487.5708410602692
 |  |  |  |  | 82.42408 | 84.913287216 | 87.4776684899232 | 90.1194940783189 | 92.8411027994841 | 95.6449041040285 | 98.5333802079702 | 101.509088290251 | 104.574662756616 | 107.732817571866 | 110.986348662537 | 114.338136392145 | 117.791148111188 | 121.348440784146 | 125.013163695827 | 128.788561239441 | 132.677975788872 | 136.684850657696 | 140.812733147559 | 145.065277688615 | 149.446249074811 | 153.95952579687 | 158.609103475936 | 163.399098400909 | 168.333751172617 | 173.41743045803 | 178.654636857862 | 184.05000689097 | 189.608317099077 | 195.334488275469 | 201.233589821388 | 207.310844233994 | 213.571631729861 | 220.021495008103 | 226.666144157347 | 233.511461710899 | 240.563507854568 | 247.828525791776 | 255.312947270688 | 263.023398278263 | 270.966704906266 | 279.149899394436 | 287.580226356147 | 296.265149192103
 |  |  |  |  |  | 82.42408 | 84.913287216 | 87.4776684899232 | 90.1194940783189 | 92.8411027994841 | 95.6449041040285 | 98.5333802079702 | 101.509088290251 | 104.574662756616 | 107.732817571866 | 110.986348662537 | 114.338136392145 | 117.791148111188 | 121.348440784146 | 125.013163695827 | 128.788561239441 | 132.677975788872 | 136.684850657696 | 140.812733147559 | 145.065277688615 | 149.446249074811 | 153.95952579687 | 158.609103475936 | 163.399098400909 | 168.333751172617 | 173.41743045803 | 178.654636857862 | 184.05000689097 | 189.608317099077 | 195.334488275469 | 201.233589821388 | 207.310844233994 | 213.571631729861 | 220.021495008103 | 226.666144157347 | 233.511461710899 | 240.563507854568 | 247.828525791776 | 255.312947270688 | 263.023398278263 | 270.966704906266 | 279.149899394436 | 287.580226356147
 |  |  |  |  |  |  |  | 34.9979287258995 | 36.4154148351559 | 37.8903119668094 | 39.4249453820891 | 41.0217345199545 | 42.6831968114817 | 44.4119516487403 | 46.2107245144177 | 48.0823512787003 | 50.0297826701904 | 52.0560889278987 | 54.1644646416562 | 56.3582337885726 | 58.6408549734775 | 61.0159268816132 | 63.4871939521723 | 66.0585522816231 | 68.7340557661334 | 71.5179224927736 | 74.4145413895758 | 77.4284791449363 | 80.5644874072644 | 83.8275102762337 | 87.2226920974416 | 90.7553855727725 | 94.4311601992408 | 98.2558110496302 | 102.235367908763 | 106.376104779803 | 110.684549775595 | 115.167495410606 | 119.832009309726 | 124.685445350789 | 129.735455258387 | 134.990000667261 | 140.457365674287 | 146.146169898827 | 152.065382072069 | 158.224334176752 | 164.632736159579 | 171.300691239514
 |  |  |  |  |  |  |  |  | 34.9979287258995 | 36.4154148351559 | 37.8903119668094 | 39.4249453820891 | 41.0217345199545 | 42.6831968114817 | 44.4119516487403 | 46.2107245144177 | 48.0823512787003 | 50.0297826701904 | 52.0560889278987 | 54.1644646416562 | 56.3582337885726 | 58.6408549734775 | 61.0159268816132 | 63.4871939521723 | 66.0585522816231 | 68.7340557661334 | 71.5179224927736 | 74.4145413895758 | 77.4284791449363 | 80.5644874072644 | 83.8275102762337 | 87.2226920974416 | 90.7553855727725 | 94.4311601992408 | 98.2558110496302 | 102.235367908763 | 106.376104779803 | 110.684549775595 | 115.167495410606 | 119.832009309726 | 124.685445350789 | 129.735455258387 | 134.990000667261 | 140.457365674287 | 146.146169898827 | 152.065382072069 | 158.224334176752 | 164.632736159579
Pricing
Annual | 2500 |  | 2601 | 2653.02 | 2706.0804 | 2760.202008 | 2815.40604816 | 2871.7141691232 | 2929.148452505664 | 2987.731421555777 | 3047.486049986893 | 3108.435770986631 | 3170.604486406363 | 3234.016576134491 | 3298.69690765718 | 3364.670845810324 | 3431.964262726531 | 3500.603547981061 | 3570.615618940682 | 3642.027931319496 | 3714.868489945886 | 3789.165859744804 | 3864.9491769397 | 3942.248160478493 | 4021.093123688063 | 4101.514986161825 | 4183.545285885061 | 4267.216191602763 | 4352.560515434818 | 4439.611725743514 | 4528.403960258384 | 4618.972039463552 | 4711.351480252823 | 4805.57850985788 | 4901.690080055037 | 4999.723881656138 | 5099.718359289262 | 5201.712726475047 | 5305.746981004548 | 5411.861920624639 | 5520.099159037131 | 5630.501142217874 | 5743.111165062232 | 5857.973388363476 | 5975.132856130745 | 6094.635513253361 | 6216.528223518429 | 6340.858787988797
Quarterly | 750 |  | 780.3000000000001 | 795.9060000000001 | 811.8241200000001 | 828.0606024000001 | 844.6218144480001 | 861.5142507369601 | 878.7445357516993 | 896.3194264667334 | 914.245814996068 | 932.5307312959894 | 951.1813459219093 | 970.2049728403475 | 989.6090722971545 | 1009.401253743098 | 1029.58927881796 | 1050.181064394319 | 1071.184685682205 | 1092.608379395849 | 1114.460546983766 | 1136.749757923441 | 1159.48475308191 | 1182.674448143548 | 1206.32793710642 | 1230.454495848548 | 1255.063585765519 | 1280.164857480829 | 1305.768154630446 | 1331.883517723055 | 1358.521188077516 | 1385.691611839066 | 1413.405444075848 | 1441.673552957365 | 1470.507024016512 | 1499.917164496842 | 1529.915507786779 | 1560.513817942515 | 1591.724094301365 | 1623.558576187392 | 1656.02974771114 | 1689.150342665363 | 1722.93334951867 | 1757.392016509044 | 1792.539856839225 | 1828.390653976009 | 1864.958467055529 | 1902.25763639664
Total revenue
Annual
Quarterly