| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Profitability Forecasting Model | |||||||||||||||||||||||||||||||||||||||||||||||||||||
2 | Explanation Video: | https://www.loom.com/share/67593203a1034d3391aad13134c558d6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | Make your own copy of this file to fill it out via File -> Make a copy | |||||||||||||||||||||||||||||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
5 | Yellow = Input Field | |||||||||||||||||||||||||||||||||||||||||||||||||||||
6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
7 | Input | |||||||||||||||||||||||||||||||||||||||||||||||||||||
8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
9 | 2025 | 2026 | 2027 | 2028 | ||||||||||||||||||||||||||||||||||||||||||||||||||
10 | CM1 Margin | 70% | <- fill out the yellow fields here and potentially overwrite yellow fields in the table below if needed | New Customers | 315,378 | 449,654 | 641,099 | 914,054 | ||||||||||||||||||||||||||||||||||||||||||||||
11 | CM2 Margin | 50% | Total Revenue | 80,464,698 | 120,400,312 | 171,920,117 | 245,204,434 | |||||||||||||||||||||||||||||||||||||||||||||||
12 | CLV First Order (historical) | 52.56 | Cum. EBITDA | 11,556,674 | 18,293,659 | 26,164,963 | 37,332,967 | |||||||||||||||||||||||||||||||||||||||||||||||
13 | CLV Extension (historical) | 179% | Cash Balance | 12,556,674 | 30,850,333 | 57,015,297 | 94,348,264 | |||||||||||||||||||||||||||||||||||||||||||||||
14 | CLV (historical) | 146.58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
15 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
16 | CLV / CAC Ratio | 3.31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
17 | CAC (historical) | 44.33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
18 | Starting Marketing Budget | 1,000,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
19 | Marketing Budget Growth | 3% | ||||||||||||||||||||||||||||||||||||||||||||||||||||
20 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
21 | Payback Period (months) | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
22 | CCC (in months) | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
24 | Starting Cash Balance | 1,000,000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
25 | Overhead Costs | 18% | ||||||||||||||||||||||||||||||||||||||||||||||||||||
26 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
28 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
29 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
34 | enter and/or overwrite the yellow rows if needed | |||||||||||||||||||||||||||||||||||||||||||||||||||||
35 | Seasonal effect overwrite: | -9.4% | -0.1% | +10.5% | +29.7% | -13.0% | +21.4% | +26.1% | -2.3% | +11.2% | +11.2% | -43.3% | -0.2% | -9.4% | -0.1% | +10.5% | +29.7% | -13.0% | +21.4% | +26.1% | -2.3% | +11.2% | +11.2% | -43.3% | -0.2% | -9.4% | -0.1% | +10.5% | +29.7% | -13.0% | +21.4% | +26.1% | -2.3% | +11.2% | +11.2% | -43.3% | -0.2% | -9.4% | -0.1% | +10.5% | +29.7% | -13.0% | +21.4% | +26.1% | -2.3% | +11.2% | +11.2% | -43.3% | -0.2% | -9.4% | -0.1% | +10.5% | ||
36 | Retention adjustments: | 0% | 0% | 0% | 0% | 0% | 0% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | ||
37 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
38 | Start date: | |||||||||||||||||||||||||||||||||||||||||||||||||||||
39 | Unit Economics | 01/01/2025 | 01/02/2025 | 01/03/2025 | 01/04/2025 | 01/05/2025 | 01/06/2025 | 01/07/2025 | 01/08/2025 | 01/09/2025 | 01/10/2025 | 01/11/2025 | 01/12/2025 | 01/01/2026 | 01/02/2026 | 01/03/2026 | 01/04/2026 | 01/05/2026 | 01/06/2026 | 01/07/2026 | 01/08/2026 | 01/09/2026 | 01/10/2026 | 01/11/2026 | 01/12/2026 | 01/01/2027 | 01/02/2027 | 01/03/2027 | 01/04/2027 | 01/05/2027 | 01/06/2027 | 01/07/2027 | 01/08/2027 | 01/09/2027 | 01/10/2027 | 01/11/2027 | 01/12/2027 | 01/01/2028 | 01/02/2028 | 01/03/2028 | 01/04/2028 | 01/05/2028 | 01/06/2028 | 01/07/2028 | 01/08/2028 | 01/09/2028 | 01/10/2028 | 01/11/2028 | 01/12/2028 | 01/01/2029 | 01/02/2029 | 01/03/2029 | ||
40 | CCC Month | 1/3/2025 | 1/4/2025 | 1/5/2025 | 1/6/2025 | 1/7/2025 | 1/8/2025 | 1/9/2025 | 1/10/2025 | 1/11/2025 | 1/12/2025 | 1/1/2026 | 1/2/2026 | 1/3/2026 | 1/4/2026 | 1/5/2026 | 1/6/2026 | 1/7/2026 | 1/8/2026 | 1/9/2026 | 1/10/2026 | 1/11/2026 | 1/12/2026 | 1/1/2027 | 1/2/2027 | 1/3/2027 | 1/4/2027 | 1/5/2027 | 1/6/2027 | 1/7/2027 | 1/8/2027 | 1/9/2027 | 1/10/2027 | 1/11/2027 | 1/12/2027 | 1/1/2028 | 1/2/2028 | 1/3/2028 | 1/4/2028 | 1/5/2028 | 1/6/2028 | 1/7/2028 | 1/8/2028 | 1/9/2028 | 1/10/2028 | 1/11/2028 | 1/12/2028 | 1/1/2029 | 1/2/2029 | 1/3/2029 | 1/4/2029 | 1/5/2029 | ||
41 | Marketing Budget | 1,000,000 | 1,030,000 | 1,060,900 | 1,092,727 | 1,125,509 | 1,159,274 | 1,194,052 | 1,229,874 | 1,266,770 | 1,304,773 | 1,343,916 | 1,384,234 | 1,425,761 | 1,468,534 | 1,512,590 | 1,557,967 | 1,604,706 | 1,652,848 | 1,702,433 | 1,753,506 | 1,806,111 | 1,860,295 | 1,916,103 | 1,973,587 | 2,032,794 | 2,093,778 | 2,156,591 | 2,221,289 | 2,287,928 | 2,356,566 | 2,427,262 | 2,500,080 | 2,575,083 | 2,652,335 | 2,731,905 | 2,813,862 | 2,898,278 | 2,985,227 | 3,074,783 | 3,167,027 | 3,262,038 | 3,359,899 | 3,460,696 | 3,564,517 | 3,671,452 | 3,781,596 | 3,895,044 | 4,011,895 | 4,132,252 | 4,256,219 | 4,383,906 | ||
42 | CAC | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | ||
43 | New Customers | 22,222 | 22,889 | 23,576 | 24,283 | 25,011 | 25,762 | 26,534 | 27,331 | 28,150 | 28,995 | 29,865 | 30,761 | 31,684 | 32,634 | 33,613 | 34,621 | 35,660 | 36,730 | 37,832 | 38,967 | 40,136 | 41,340 | 42,580 | 43,857 | 45,173 | 46,528 | 47,924 | 49,362 | 50,843 | 52,368 | 53,939 | 55,557 | 57,224 | 58,941 | 60,709 | 62,530 | 64,406 | 66,338 | 68,329 | 70,378 | 72,490 | 74,664 | 76,904 | 79,211 | 81,588 | 84,035 | 86,557 | 89,153 | 91,828 | 94,583 | 97,420 | ||
44 | CLV First Order | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | 52.56 | ||
45 | Total Net Revenue | 4,621,072 | 5,312,851 | 5,922,280 | 6,788,911 | 5,615,662 | 7,087,617 | 7,993,199 | 7,076,340 | 7,927,510 | 8,164,165 | 5,827,985 | 8,127,106 | 7,912,821 | 8,633,958 | 9,477,040 | 10,784,260 | 8,658,063 | 10,902,526 | 11,490,511 | 10,086,651 | 11,234,321 | 11,526,742 | 8,231,679 | 11,461,741 | 11,184,824 | 12,229,529 | 13,427,723 | 15,324,258 | 12,345,852 | 15,573,074 | 16,437,537 | 14,435,204 | 16,093,881 | 16,573,827 | 11,836,209 | 16,458,198 | 16,006,210 | 17,464,513 | 19,144,723 | 21,848,728 | 17,602,233 | 22,203,480 | 23,435,998 | 20,581,150 | 22,946,026 | 23,630,315 | 16,875,604 | 23,465,455 | 22,821,029 | 24,900,219 | 17,055,899 | ||
46 | Net Revenue New Customers | 2,335,793 | 2,405,867 | 2,478,043 | 2,552,384 | 2,628,956 | 2,707,824 | 2,789,059 | 2,872,731 | 2,958,913 | 3,047,680 | 3,139,111 | 3,233,284 | 3,330,283 | 3,430,191 | 3,533,097 | 3,639,090 | 3,748,262 | 3,860,710 | 3,976,532 | 4,095,827 | 4,218,702 | 4,345,263 | 4,475,621 | 4,609,890 | 4,748,187 | 4,890,632 | 5,037,351 | 5,188,472 | 5,344,126 | 5,504,450 | 5,669,583 | 5,839,671 | 6,014,861 | 6,195,307 | 6,381,166 | 6,572,601 | 6,769,779 | 6,972,872 | 7,182,058 | 7,397,520 | 7,619,446 | 7,848,029 | 8,083,470 | 8,325,974 | 8,575,753 | 8,833,026 | 9,098,017 | 9,370,957 | 9,652,086 | 9,941,648 | 2,933,293 | ||
47 | Net Revenue Repeat Customers | 2,285,279 | 2,906,984 | 3,444,237 | 4,236,527 | 2,986,706 | 4,379,792 | 5,204,140 | 4,203,609 | 4,968,597 | 5,116,484 | 2,688,874 | 4,893,822 | 4,582,538 | 5,203,766 | 5,943,944 | 7,145,170 | 4,909,801 | 7,041,816 | 7,513,979 | 5,990,824 | 7,015,619 | 7,181,478 | 3,756,057 | 6,851,851 | 6,436,637 | 7,338,896 | 8,390,372 | 10,135,786 | 7,001,726 | 10,068,625 | 10,767,954 | 8,595,534 | 10,079,020 | 10,378,521 | 5,455,043 | 9,885,598 | 9,236,432 | 10,491,641 | 11,962,664 | 14,451,208 | 9,982,788 | 14,355,451 | 15,352,528 | 12,255,176 | 14,370,273 | 14,797,289 | 7,777,587 | 14,094,498 | 13,168,943 | 14,958,571 | 14,122,606 | ||
48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
49 | COGS | - 1,776,684 | - 2,036,673 | - 1,684,698 | - 2,126,285 | - 2,397,960 | - 2,122,902 | - 2,378,253 | - 2,449,249 | - 1,748,395 | - 2,438,132 | - 2,373,846 | - 2,590,187 | - 2,843,112 | - 3,235,278 | - 2,597,419 | - 3,270,758 | - 3,447,153 | - 3,025,995 | - 3,370,296 | - 3,458,023 | - 2,469,504 | - 3,438,522 | - 3,355,447 | - 3,668,859 | - 4,028,317 | - 4,597,277 | - 3,703,756 | - 4,671,922 | - 4,931,261 | - 4,330,561 | - 4,828,164 | - 4,972,148 | - 3,550,863 | - 4,937,459 | - 4,801,863 | - 5,239,354 | - 5,743,417 | - 6,554,618 | - 5,280,670 | - 6,661,044 | - 7,030,799 | - 6,174,345 | - 6,883,808 | - 7,089,094 | - 5,062,681 | - 7,039,637 | - 6,846,309 | - 7,470,066 | - 5,116,770 | - | - | ||
50 | CM1 | 2,844,388 | 3,276,178 | 4,237,581 | 4,662,626 | 3,217,702 | 4,964,715 | 5,614,946 | 4,627,091 | 6,179,115 | 5,726,033 | 3,454,139 | 5,536,919 | 5,069,708 | 5,398,680 | 6,879,621 | 7,513,502 | 5,210,910 | 7,876,530 | 8,120,215 | 6,628,629 | 8,764,817 | 8,088,219 | 4,876,232 | 7,792,883 | 7,156,507 | 7,632,251 | 9,723,968 | 10,652,336 | 7,414,591 | 11,242,513 | 11,609,373 | 9,463,056 | 12,543,018 | 11,636,368 | 7,034,346 | 11,218,844 | 10,262,794 | 10,909,894 | 13,864,053 | 15,187,684 | 10,571,434 | 16,029,135 | 16,552,190 | 13,492,055 | 17,883,345 | 16,590,678 | 10,029,295 | 15,995,390 | 17,704,259 | 24,900,219 | 17,055,899 | ||
51 | CM1 Margin | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | ||
52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
53 | Logistic & Transaction Costs | - 924,214 | - 1,062,570 | - 1,184,456 | - 1,357,782 | - 1,123,132 | - 1,417,523 | - 1,598,640 | - 1,415,268 | - 1,585,502 | - 1,632,833 | - 1,165,597 | - 1,625,421 | - 1,582,564 | - 1,726,792 | - 1,895,408 | - 2,156,852 | - 1,731,613 | - 2,180,505 | - 2,298,102 | - 2,017,330 | - 2,246,864 | - 2,305,348 | - 1,646,336 | - 2,292,348 | - 2,236,965 | - 2,445,906 | - 2,685,545 | - 3,064,852 | - 2,469,170 | - 3,114,615 | - 3,287,507 | - 2,887,041 | - 3,218,776 | - 3,314,765 | - 2,367,242 | - 3,291,640 | - 3,201,242 | - 3,492,903 | - 3,828,945 | - 4,369,746 | - 3,520,447 | - 4,440,696 | - 4,687,200 | - 4,116,230 | - 4,589,205 | - 4,726,063 | - 3,375,121 | - 4,693,091 | - 4,564,206 | - 4,980,044 | - 3,411,180 | ||
54 | CM2 | 2,310,536 | 2,656,425 | 2,961,140 | 3,394,456 | 2,807,831 | 3,543,808 | 3,996,600 | 3,538,170 | 3,963,755 | 4,082,082 | 2,913,992 | 4,063,553 | 3,956,410 | 4,316,979 | 4,738,520 | 5,392,130 | 4,329,032 | 5,451,263 | 5,745,255 | 5,043,326 | 5,617,160 | 5,763,371 | 4,115,839 | 5,730,871 | 5,592,412 | 6,114,764 | 6,713,862 | 7,662,129 | 6,172,926 | 7,786,537 | 8,218,769 | 7,217,602 | 8,046,941 | 8,286,914 | 5,918,105 | 8,229,099 | 8,003,105 | 8,732,256 | 9,572,361 | 10,924,364 | 8,801,117 | 11,101,740 | 11,717,999 | 10,290,575 | 11,473,013 | 11,815,157 | 8,437,802 | 11,732,728 | 11,410,514 | 12,450,110 | 8,527,949 | ||
55 | CM2 New Customers | 1,167,897 | 1,202,933 | 1,239,021 | 1,276,192 | 1,314,478 | 1,353,912 | 1,394,530 | 1,436,365 | 1,479,456 | 1,523,840 | 1,569,555 | 1,616,642 | 1,665,141 | 1,715,096 | 1,766,548 | 1,819,545 | 1,874,131 | 1,930,355 | 1,988,266 | 2,047,914 | 2,109,351 | 2,172,632 | 2,237,811 | 2,304,945 | 2,374,093 | 2,445,316 | 2,518,676 | 2,594,236 | 2,672,063 | 2,752,225 | 2,834,792 | 2,919,835 | 3,007,430 | 3,097,653 | 3,190,583 | 3,286,300 | 3,384,889 | 3,486,436 | 3,591,029 | 3,698,760 | 3,809,723 | 3,924,014 | 4,041,735 | 4,162,987 | 4,287,877 | 4,416,513 | 4,549,008 | 4,685,479 | 4,826,043 | 4,970,824 | 1,466,647 | ||
56 | CM2 Repeat Customers | 1,142,640 | 1,453,492 | 1,722,118 | 2,118,263 | 1,493,353 | 2,189,896 | 2,602,070 | 2,101,804 | 2,484,299 | 2,558,242 | 1,344,437 | 2,446,911 | 2,291,269 | 2,601,883 | 2,971,972 | 3,572,585 | 2,454,900 | 3,520,908 | 3,756,990 | 2,995,412 | 3,507,809 | 3,590,739 | 1,878,029 | 3,425,926 | 3,218,319 | 3,669,448 | 4,195,186 | 5,067,893 | 3,500,863 | 5,034,312 | 5,383,977 | 4,297,767 | 5,039,510 | 5,189,260 | 2,727,522 | 4,942,799 | 4,618,216 | 5,245,820 | 5,981,332 | 7,225,604 | 4,991,394 | 7,177,726 | 7,676,264 | 6,127,588 | 7,185,136 | 7,398,644 | 3,888,794 | 7,047,249 | 6,584,471 | 7,479,285 | 7,061,303 | ||
57 | CM2 Margin | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | 50% | ||
58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
59 | CM3 | 1,310,536 | 1,626,425 | 1,900,240 | 2,301,729 | 1,682,322 | 2,384,534 | 2,802,547 | 2,308,296 | 2,696,985 | 2,777,309 | 1,570,076 | 2,679,319 | 2,530,649 | 2,848,445 | 3,225,930 | 3,834,163 | 2,724,325 | 3,798,415 | 4,042,822 | 3,289,820 | 3,811,049 | 3,903,076 | 2,199,736 | 3,757,284 | 3,559,618 | 4,020,986 | 4,557,270 | 5,440,840 | 3,884,998 | 5,429,972 | 5,791,506 | 4,717,522 | 5,471,858 | 5,634,578 | 3,186,199 | 5,415,237 | 5,104,827 | 5,747,030 | 6,497,578 | 7,757,337 | 5,539,079 | 7,741,841 | 8,257,303 | 6,726,058 | 7,801,561 | 8,033,561 | 4,542,758 | 7,720,833 | 7,278,262 | 8,193,890 | 4,144,043 | ||
60 | CM3 Margin | 28.4% | 30.6% | 32.1% | 33.9% | 30.0% | 33.6% | 35.1% | 32.6% | 34.0% | 34.0% | 26.9% | 33.0% | 32.0% | 33.0% | 34.0% | 35.6% | 31.5% | 34.8% | 35.2% | 32.6% | 33.9% | 33.9% | 26.7% | 32.8% | 31.8% | 32.9% | 33.9% | 35.5% | 31.5% | 34.9% | 35.2% | 32.7% | 34.0% | 34.0% | 26.9% | 32.9% | 31.9% | 32.9% | 33.9% | 35.5% | 31.5% | 34.9% | 35.2% | 32.7% | 34.0% | 34.0% | 26.9% | 32.9% | 31.9% | 32.9% | 24.3% | ||
62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
63 | Overhead | - 831,793 | - 956,313 | - 1,066,010 | - 1,222,004 | - 1,010,819 | - 1,275,771 | - 1,438,776 | - 1,273,741 | - 1,426,952 | - 1,469,550 | - 1,049,037 | - 1,462,879 | - 1,424,308 | - 1,554,112 | - 1,705,867 | - 1,941,167 | - 1,558,451 | - 1,962,455 | - 2,068,292 | - 1,815,597 | - 2,022,178 | - 2,074,814 | - 1,481,702 | - 2,063,113 | - 2,013,268 | - 2,201,315 | - 2,416,990 | - 2,758,366 | - 2,222,253 | - 2,803,153 | - 2,958,757 | - 2,598,337 | - 2,896,899 | - 2,983,289 | - 2,130,518 | - 2,962,476 | - 2,881,118 | - 3,143,612 | - 3,446,050 | - 3,932,771 | - 3,168,402 | - 3,996,626 | - 4,218,480 | - 3,704,607 | - 4,130,285 | - 4,253,457 | - 3,037,609 | - 4,223,782 | - 4,107,785 | - 4,482,039 | - 3,070,062 | ||
64 | EBITDA | 478,743 | 670,112 | 834,230 | 1,079,725 | 671,503 | 1,108,763 | 1,363,772 | 1,034,555 | 1,270,033 | 1,307,759 | 521,039 | 1,216,440 | 1,106,342 | 1,294,333 | 1,520,063 | 1,892,996 | 1,165,874 | 1,835,961 | 1,974,530 | 1,474,222 | 1,788,871 | 1,828,263 | 718,034 | 1,694,171 | 1,546,349 | 1,819,671 | 2,140,280 | 2,682,474 | 1,662,745 | 2,626,818 | 2,832,749 | 2,119,185 | 2,574,959 | 2,651,289 | 1,055,682 | 2,452,761 | 2,223,709 | 2,603,417 | 3,051,528 | 3,824,566 | 2,370,677 | 3,745,215 | 4,038,823 | 3,021,451 | 3,671,276 | 3,780,105 | 1,505,150 | 3,497,051 | 3,170,477 | 3,711,851 | 1,073,982 | ||
65 | Cumulative EBITDA | 478,743 | 1,148,855 | 1,983,085 | 3,062,810 | 3,734,312 | 4,843,076 | 6,206,847 | 7,241,402 | 8,511,435 | 9,819,195 | 10,340,234 | 11,556,674 | 12,663,016 | 13,957,348 | 15,477,411 | 17,370,407 | 18,536,281 | 20,372,242 | 22,346,772 | 23,820,994 | 25,609,866 | 27,438,129 | 28,156,162 | 29,850,333 | 31,396,683 | 33,216,354 | 35,356,634 | 38,039,108 | 39,701,853 | 42,328,671 | 45,161,420 | 47,280,605 | 49,855,565 | 52,506,854 | 53,562,536 | 56,015,297 | 58,239,006 | 60,842,423 | 63,893,951 | 67,718,517 | 70,089,193 | 73,834,408 | 77,873,231 | 80,894,683 | 84,565,959 | 88,346,064 | 89,851,213 | 93,348,264 | 96,518,741 | 100,230,592 | 101,304,573 | ||
66 | EBITDA Margin | 10.4% | 12.6% | 14.1% | 15.9% | 12.0% | 15.6% | 17.1% | 14.6% | 16.0% | 16.0% | 8.9% | 15.0% | 14.0% | 15.0% | 16.0% | 17.6% | 13.5% | 16.8% | 17.2% | 14.6% | 15.9% | 15.9% | 8.7% | 14.8% | 13.8% | 14.9% | 15.9% | 17.5% | 13.5% | 16.9% | 17.2% | 14.7% | 16.0% | 16.0% | 8.9% | 14.9% | 13.9% | 14.9% | 15.9% | 17.5% | 13.5% | 16.9% | 17.2% | 14.7% | 16.0% | 16.0% | 8.9% | 14.9% | 13.9% | 14.9% | 6.3% | ||
67 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
68 | Cash Balance | 1,478,743 | 2,148,855 | 2,983,085 | 4,062,810 | 4,734,312 | 5,843,076 | 7,206,847 | 8,241,402 | 9,511,435 | 10,819,195 | 11,340,234 | 12,556,674 | 13,663,016 | 14,957,348 | 16,477,411 | 18,370,407 | 19,536,281 | 21,372,242 | 23,346,772 | 24,820,994 | 26,609,866 | 28,438,129 | 29,156,162 | 30,850,333 | 32,396,683 | 34,216,354 | 36,356,634 | 39,039,108 | 40,701,853 | 43,328,671 | 46,161,420 | 48,280,605 | 50,855,565 | 53,506,854 | 54,562,536 | 57,015,297 | 59,239,006 | 61,842,423 | 64,893,951 | 68,718,517 | 71,089,193 | 74,834,408 | 78,873,231 | 81,894,683 | 85,565,959 | 89,346,064 | 90,851,213 | 94,348,264 | 97,518,741 | 101,230,592 | 102,304,573 | ||
69 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
71 | CLV 90d | 81.04 | 81.33 | 75.53 | 72.64 | 78.31 | 78.20 | 75.32 | 77.21 | 72.77 | 68.65 | 73.94 | 80.49 | 83.89 | 84.21 | 77.83 | 74.64 | 79.85 | 78.20 | 75.32 | 77.21 | 72.77 | 68.65 | 73.94 | 80.49 | 83.89 | 84.21 | 77.83 | 74.64 | 79.85 | 78.20 | 75.32 | 77.21 | 72.77 | 68.65 | 73.94 | 73.39 | 75.57 | 84.21 | 77.83 | 74.64 | 79.85 | 78.20 | 75.32 | 77.21 | 72.77 | 68.65 | 73.94 | 80.49 | |||||
72 | CLV 180d | 91.28 | 94.15 | 94.82 | 92.06 | 96.66 | 94.55 | 90.89 | 91.22 | 89.51 | 85.87 | 93.36 | 92.33 | 95.16 | 97.65 | 97.83 | 94.06 | 98.21 | 94.55 | 90.89 | 91.22 | 89.51 | 85.87 | 93.36 | 92.33 | 95.16 | 97.65 | 97.83 | 94.06 | 98.21 | 94.55 | 90.89 | 91.22 | 89.51 | 85.87 | 93.36 | 92.33 | 95.16 | 97.65 | 97.83 | 94.06 | 98.21 | 94.55 | 90.89 | 91.22 | 89.51 | ||||||||
73 | CLV 365d | 116.47 | 117.83 | 118.53 | 115.74 | 120.91 | 120.14 | 117.38 | 119.26 | 117.41 | 113.89 | 120.54 | 118.32 | 120.35 | 121.33 | 121.54 | 117.74 | 122.45 | 120.14 | 117.38 | 119.26 | 117.41 | 113.89 | 120.54 | 118.32 | 120.35 | 121.33 | 121.54 | 117.74 | 122.45 | 120.14 | 117.38 | 119.26 | 117.41 | 113.89 | 120.54 | 118.32 | 120.35 | 121.33 | 121.54 | ||||||||||||||
74 | CAC | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | 45.00 | ||
75 | CLV 365d / CAC | 2.59 | 2.62 | 2.63 | 2.57 | 2.69 | 2.67 | 2.61 | 2.65 | 2.61 | 2.53 | 2.68 | 2.63 | 2.67 | 2.70 | 2.70 | 2.62 | 2.72 | 2.67 | 2.61 | 2.65 | 2.61 | 2.53 | 2.68 | 2.63 | 2.67 | 2.70 | 2.70 | 2.62 | 2.72 | 2.67 | 2.61 | 2.65 | 2.61 | 2.53 | 2.68 | 2.63 | 2.67 | 2.70 | 2.70 | ||||||||||||||
76 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
101 |