ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
ActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualActualForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecastForecast
2
 AssumptionRateDec 31, 2023Jan 7, 2024Jan 14, 2024Jan 21, 2024Jan 28, 2024Feb 4, 2024Feb 11, 2024Feb 18, 2024Feb 25, 2024Mar 3, 2024Mar 10, 2024Mar 17, 2024Mar 24, 2024Mar 31, 2024Apr 7, 2024Apr 14, 2024Apr 21, 2024Apr 28, 2024May 5, 2024May 12, 2024May 19, 2024May 26, 2024Jun 2, 2024Jun 9, 2024Jun 16, 2024Jun 23, 2024Jun 30, 2024Jul 7, 2024Jul 14, 2024Jul 21, 2024Jul 28, 2024Aug 4, 2024Aug 11, 2024Aug 18, 2024Aug 25, 2024Sep 1, 2024Sep 8, 2024Sep 15, 2024Sep 22, 2024Sep 29, 2024Oct 6, 2024Oct 13, 2024Oct 20, 2024Oct 27, 2024Nov 3, 2024Nov 10, 2024Nov 17, 2024Nov 24, 2024Dec 1, 2024Dec 8, 2024Dec 15, 2024Dec 22, 2024Dec 29, 2024Jan 5, 2025Jan 12, 2025Jan 19, 2025Jan 26, 2025Feb 2, 2025Feb 9, 2025Feb 16, 2025Feb 23, 2025Mar 2, 2025Mar 9, 2025Mar 16, 2025Mar 23, 2025Mar 30, 2025Apr 6, 2025Apr 13, 2025Apr 20, 2025Apr 27, 2025May 4, 2025May 11, 2025May 18, 2025May 25, 2025Jun 1, 2025Jun 8, 2025Jun 15, 2025Jun 22, 2025Jun 29, 2025Jul 6, 2025Jul 13, 2025Jul 20, 2025Jul 27, 2025Aug 3, 2025Aug 10, 2025Aug 17, 2025Aug 24, 2025Aug 31, 2025Sep 7, 2025Sep 14, 2025Sep 21, 2025Sep 28, 2025Oct 5, 2025Oct 12, 2025Oct 19, 2025Oct 26, 2025Nov 2, 2025
3
B2B Revenue
4
B2B Shopify
% increase on 12wk avg
1.50% 98,437 53,080 59,095 31,363 88,837 30,260 48,791 52,710 72,696 69,652 20,244 28,992 44,487 82,644 55,989 87,615 24,251 70,028 83,850 67,065 83,430 58,710 82,949 62,061 27,551 95,804 67,608 68,590 66,981 70,596 70,644 69,527 69,735 68,576 69,411 68,266 68,791 72,279 70,289 70,516 70,679 70,991 71,025 71,057 71,186 71,309 71,540 71,721 72,013 72,285 72,286 72,455 72,619 72,783 72,934 73,096 73,268 73,445 73,625 73,801 73,977 74,144 74,301 74,471 74,642 74,813 74,985 75,158 75,332 75,507 75,681 75,855 76,029 76,203 76,377 76,552 76,728 76,905 77,082 77,259 77,437 77,615 77,793 77,972 78,151 78,331 78,511 78,691 78,872 79,053 79,235 79,417 79,599 79,782 79,966 80,149 80,334
5
Discounts% of Gross Sales35.00% (34,453) (19,640) (17,729) (7,527) (17,767) (10,591) (10,734) (13,705) (20,355) (19,503) (8,098) (7,538) (16,015) (19,008) (20,156) (18,399) (6,548) (16,106) (24,317) (17,437) (25,863) (21,136) (32,350) (14,895) (9,092) (22,993) (23,663) (24,007) (23,443) (24,708) (24,725) (24,334) (24,407) (24,002) (24,294) (23,893) (24,077) (25,298) (24,601) (24,681) (24,738) (24,847) (24,859) (24,870) (24,915) (24,958) (25,039) (25,102) (25,204) (25,300) (25,300) (25,359) (25,417) (25,474) (25,527) (25,584) (25,644) (25,706) (25,769) (25,831) (25,892) (25,950) (26,005) (26,065) (26,125) (26,185) (26,245) (26,305) (26,366) (26,427) (26,489) (26,549) (26,610) (26,671) (26,732) (26,793) (26,855) (26,917) (26,979) (27,041) (27,103) (27,165) (27,228) (27,290) (27,353) (27,416) (27,479) (27,542) (27,605) (27,669) (27,732) (27,796) (27,860) (27,924) (27,988) (28,052) (28,117)
6
Total B2B Revenue 5,549 33,440 41,367 23,836 71,070 19,669 38,057 39,005 52,341 50,149 12,146 21,454 28,472 63,636 35,833 69,216 17,703 53,922 59,534 49,628 57,567 37,574 50,599 47,166 18,459 72,811 43,945 44,584 43,538 45,887 45,918 45,192 45,328 44,575 45,117 44,373 44,714 46,981 45,688 45,835 45,941 46,144 46,166 46,187 46,271 46,351 46,501 46,618 46,808 46,985 46,986 47,096 47,202 47,309 47,407 47,512 47,624 47,739 47,856 47,971 48,085 48,193 48,296 48,406 48,517 48,628 48,740 48,853 48,966 49,080 49,193 49,306 49,419 49,532 49,645 49,759 49,874 49,988 50,103 50,219 50,334 50,450 50,566 50,682 50,798 50,915 51,032 51,149 51,267 51,385 51,503 51,621 51,740 51,859 51,978 52,097 52,217
7
8
9
10
DTC Revenue
11
Shopify Gross Sales
% increase on 12wk avg
2.50% 179,652 542,424 465,676 392,330 175,098 355,729 574,349 229,285 593,066 207,511 195,260 384,991 181,909 206,405 395,117 599,129 470,869 260,538 336,299 587,565 354,550 553,335 538,232 251,832 162,730 278,169 409,006 410,193 394,054 387,493 398,337 403,636 387,926 390,776 376,891 363,110 372,615 390,543 400,141 399,384 398,461 398,837 399,806 399,932 399,615 400,614 401,454 403,552 407,006 409,944 411,601 412,580 413,707 415,010 416,391 417,808 419,334 421,019 422,762 424,582 426,378 428,033 429,578 431,113 432,696 434,318 435,968 437,640 439,334 441,042 442,753 444,460 446,158 447,848 449,540 451,245 452,965 454,696 456,437 458,185 459,940 461,700 463,464 465,234 467,008 468,789 470,578 472,375 474,179 475,992 477,811 479,636 481,469 483,307 485,153 487,006 488,865
12
Shipping Income% of Gross Sales3.20% 5,390 10,848 13,970 11,770 5,253 14,229 11,487 9,171 11,861 6,225 3,905 7,700 5,457 6,192 15,805 11,983 9,417 7,816 10,089 23,503 7,091 22,133 21,529 5,037 3,255 5,563 13,088 13,126 12,610 12,400 12,747 12,916 12,414 12,505 12,061 11,620 11,924 12,497 12,805 12,780 12,751 12,763 12,794 12,798 12,788 12,820 12,847 12,914 13,024 13,118 13,171 13,203 13,239 13,280 13,325 13,370 13,419 13,473 13,528 13,587 13,644 13,697 13,746 13,796 13,846 13,898 13,951 14,004 14,059 14,113 14,168 14,223 14,277 14,331 14,385 14,440 14,495 14,550 14,606 14,662 14,718 14,774 14,831 14,887 14,944 15,001 15,058 15,116 15,174 15,232 15,290 15,348 15,407 15,466 15,525 15,584 15,644
13
Discounts% of Gross Sales34.50% (53,896) (189,848) (135,046) (125,546) (47,276) (92,490) (189,535) (59,614) (148,267) (72,629) (66,388) (134,747) (61,849) (59,857) (110,633) (185,730) (155,387) (70,345) (90,801) (193,896) (92,183) (138,334) (145,323) (83,105) (53,701) (75,106) (141,107) (141,516) (135,949) (133,685) (137,426) (139,254) (133,834) (134,818) (130,027) (125,273) (128,552) (134,737) (138,049) (137,787) (137,469) (137,599) (137,933) (137,976) (137,867) (138,212) (138,502) (139,225) (140,417) (141,431) (142,002) (142,340) (142,729) (143,178) (143,655) (144,144) (144,670) (145,251) (145,853) (146,481) (147,100) (147,671) (148,204) (148,734) (149,280) (149,840) (150,409) (150,986) (151,570) (152,160) (152,750) (153,339) (153,925) (154,507) (155,091) (155,680) (156,273) (156,870) (157,471) (158,074) (158,679) (159,286) (159,895) (160,506) (161,118) (161,732) (162,349) (162,969) (163,592) (164,217) (164,845) (165,475) (166,107) (166,741) (167,378) (168,017) (168,659)
14
Refunds% of Gross Sales1.00% (1,797) (5,424) (4,657) (3,923) (1,751) (7,115) (11,487) (4,586) (11,861) (2,075) (3,905) (3,850) (1,819) (4,128) (7,902) (11,983) (4,709) (5,211) (6,726) (5,876) (7,091) (5,533) (10,765) (2,518) (3,255) (2,782) (4,090) (4,102) (3,941) (3,875) (3,983) (4,036) (3,879) (3,908) (3,769) (3,631) (3,726) (3,905) (4,001) (3,994) (3,985) (3,988) (3,998) (3,999) (3,996) (4,006) (4,015) (4,036) (4,070) (4,099) (4,116) (4,126) (4,137) (4,150) (4,164) (4,178) (4,193) (4,210) (4,228) (4,246) (4,264) (4,280) (4,296) (4,311) (4,327) (4,343) (4,360) (4,376) (4,393) (4,410) (4,428) (4,445) (4,462) (4,478) (4,495) (4,512) (4,530) (4,547) (4,564) (4,582) (4,599) (4,617) (4,635) (4,652) (4,670) (4,688) (4,706) (4,724) (4,742) (4,760) (4,778) (4,796) (4,815) (4,833) (4,852) (4,870) (4,889)
15
Total DTC Revenue 59,740 358,000 339,943 274,631 131,324 270,354 384,814 174,257 444,800 139,032 128,872 254,094 123,698 148,612 292,387 413,399 320,191 192,798 248,861 411,296 262,367 431,601 403,674 171,246 109,029 205,845 276,897 277,700 266,775 262,333 269,674 273,262 262,626 264,556 255,155 245,825 252,260 264,397 270,896 270,383 269,758 270,013 270,669 270,754 270,539 271,215 271,784 273,205 275,543 277,532 278,654 279,317 280,080 280,961 281,897 282,856 283,889 285,030 286,210 287,442 288,658 289,778 290,824 291,864 292,935 294,034 295,150 296,282 297,429 298,586 299,743 300,899 302,049 303,193 304,339 305,493 306,657 307,829 309,008 310,191 311,379 312,571 313,765 314,963 316,164 317,370 318,581 319,798 321,019 322,246 323,478 324,714 325,954 327,199 328,449 329,703 330,962
16
17
18
19
Amazon
20
Revenue
% increase on 12wk avg
1.00% 28,370 28,709 24,181 26,050 21,437 24,734 29,785 24,007 24,978 24,491 27,406 24,134 20,661 22,422 25,970 23,530 29,179 24,564 28,295 25,629 21,071 27,751 29,561 23,566 25,906 24,290 26,034 26,039 26,250 26,004 26,125 25,942 25,969 26,381 26,266 25,988 26,192 26,216 26,378 26,407 26,438 26,454 26,492 26,523 26,572 26,623 26,643 26,675 26,733 26,778 26,825 26,863 26,901 26,940 26,981 27,022 27,064 27,106 27,146 27,189 27,232 27,274 27,316 27,357 27,399 27,441 27,483 27,525 27,567 27,609 27,652 27,694 27,737 27,780 27,822 27,865 27,907 27,950 27,993 28,036 28,079 28,122 28,165 28,209 28,252 28,295 28,339 28,382 28,426 28,469 28,513 28,557 28,600 28,644 28,688 28,732 28,776
21
22
Seller Fees% of Gross Sales15% (4,256) (4,306) (3,627) (3,908) (3,216) (3,710) (4,468) (3,601) (3,747) (3,674) (4,111) (3,620) (3,099) (3,363) (3,896) (3,530) (4,377) (3,685) (4,244) (3,844) (3,161) (4,163) (4,434) (3,535) (3,886) (3,644) (3,905) (3,906) (3,938) (3,901) (3,919) (3,891) (3,895) (3,957) (3,940) (3,898) (3,929) (3,932) (3,957) (3,961) (3,966) (3,968) (3,974) (3,978) (3,986) (3,993) (3,996) (4,001) (4,010) (4,017) (4,024) (4,029) (4,035) (4,041) (4,047) (4,053) (4,060) (4,066) (4,072) (4,078) (4,085) (4,091) (4,097) (4,104) (4,110) (4,116) (4,122) (4,129) (4,135) (4,141) (4,148) (4,154) (4,161) (4,167) (4,173) (4,180) (4,186) (4,193) (4,199) (4,205) (4,212) (4,218) (4,225) (4,231) (4,238) (4,244) (4,251) (4,257) (4,264) (4,270) (4,277) (4,283) (4,290) (4,297) (4,303) (4,310) (4,316)
23
FBA + Misc Fees% of Gross Sales10% (3,121) (3,445) (3,144) (3,387) (1,929) (2,721) (3,276) (2,641) (3,247) (2,449) (2,467) (3,137) (2,273) (2,242) (3,376) (2,353) (2,626) (2,948) (3,678) (2,819) (2,107) (3,608) (2,660) (2,828) (2,591) (2,672) (2,603) (2,604) (2,625) (2,600) (2,612) (2,594) (2,597) (2,638) (2,627) (2,599) (2,619) (2,622) (2,638) (2,641) (2,644) (2,645) (2,649) (2,652) (2,657) (2,662) (2,664) (2,667) (2,673) (2,678) (2,683) (2,686) (2,690) (2,694) (2,698) (2,702) (2,706) (2,711) (2,715) (2,719) (2,723) (2,727) (2,732) (2,736) (2,740) (2,744) (2,748) (2,752) (2,757) (2,761) (2,765) (2,769) (2,774) (2,778) (2,782) (2,786) (2,791) (2,795) (2,799) (2,804) (2,808) (2,812) (2,817) (2,821) (2,825) (2,830) (2,834) (2,838) (2,843) (2,847) (2,851) (2,856) (2,860) (2,864) (2,869) (2,873) (2,878)
24
Advertising% of Gross Sales20% (7,093) (7,177) (4,836) (6,513) (4,073) (4,699) (5,957) (5,762) (4,746) (4,898) (4,659) (4,344) (5,165) (5,381) (6,233) (4,000) (6,711) (4,422) (5,093) (5,895) (5,057) (6,105) (5,912) (4,242) (6,217) (4,858) (5,207) (5,208) (5,250) (5,201) (5,225) (5,188) (5,194) (5,276) (5,253) (5,198) (5,238) (5,243) (5,276) (5,281) (5,288) (5,291) (5,298) (5,305) (5,314) (5,325) (5,329) (5,335) (5,347) (5,356) (5,365) (5,373) (5,380) (5,388) (5,396) (5,404) (5,413) (5,421) (5,429) (5,438) (5,446) (5,455) (5,463) (5,471) (5,480) (5,488) (5,497) (5,505) (5,513) (5,522) (5,530) (5,539) (5,547) (5,556) (5,564) (5,573) (5,581) (5,590) (5,599) (5,607) (5,616) (5,624) (5,633) (5,642) (5,650) (5,659) (5,668) (5,676) (5,685) (5,694) (5,703) (5,711) (5,720) (5,729) (5,738) (5,746) (5,755)
25
Total Amazon 13,901 13,780 12,574 12,244 12,219 13,604 16,084 12,004 13,238 13,470 16,170 13,032 10,124 11,435 12,466 13,647 15,465 13,510 15,279 13,071 10,746 13,876 16,554 12,961 13,212 13,117 14,319 14,322 14,438 14,302 14,369 14,268 14,283 14,510 14,446 14,294 14,406 14,419 14,508 14,524 14,541 14,550 14,571 14,588 14,615 14,642 14,654 14,671 14,703 14,728 14,754 14,775 14,796 14,817 14,840 14,862 14,885 14,908 14,931 14,954 14,978 15,001 15,024 15,046 15,069 15,092 15,115 15,139 15,162 15,185 15,209 15,232 15,255 15,279 15,302 15,326 15,349 15,373 15,396 15,420 15,444 15,467 15,491 15,515 15,539 15,562 15,586 15,610 15,634 15,658 15,682 15,706 15,730 15,754 15,779 15,803 15,827
26
27
28
29
Cash
30
Opening Balance 500,000 444,046 314,778 724,595 800,702 867,608 760,166 1,134,379 1,235,711 1,682,263 1,336,871 1,477,929 2,041,632 2,103,975 2,077,501 2,198,186 2,401,833 3,045,553 3,075,428 2,806,065 2,964,531 3,004,426 3,276,815 3,202,441 3,187,127 3,796,767 3,995,355 4,140,029 3,873,643 4,909,942 4,914,924 5,169,971 4,816,444 5,016,467 4,990,480 4,993,869 4,497,647 4,665,394 4,641,047 4,963,749 5,172,970 4,878,242 5,007,759 5,041,293 5,160,048 4,952,241 5,139,165 5,174,017 5,349,304 5,141,996 5,277,436 5,318,711 5,455,237 5,636,791 5,320,407 5,512,834 5,550,266 5,734,257 5,502,057 5,761,825 5,790,203 6,068,602 5,807,536 6,006,543 6,001,210 6,270,356 6,406,469 6,259,684 6,407,400 6,460,929 6,600,272 6,481,530 6,632,484 6,689,229 6,831,756 6,693,131 6,847,237 6,907,148 7,062,874 7,306,809 6,968,815 7,267,906 7,276,922 7,481,764 7,220,752 7,505,319 7,517,648 7,735,814 7,918,726 7,711,902 7,942,943 8,014,493 8,171,897 7,879,779 8,048,898 8,211,181 8,408,340
31
INFLOWS
32
B2B Receipts 5,549 33,440 41,367 23,836 71,070 19,669 38,057 39,005 52,341 50,149 12,146 21,454 28,472 63,636 35,833 69,216 17,703 53,922 59,534 49,628 57,567 37,574 50,599 47,166 18,459 72,811 43,945 44,584 43,538 45,887 45,918 45,192 45,328 44,575 45,117 44,373 44,714 46,981 45,688 45,835 45,941 46,144 46,166 46,187 46,271 46,351 46,501 46,618 46,808 46,985 46,986 47,096 47,202 47,309 47,407 47,512 47,624 47,739 47,856 47,971 48,085 48,193 48,296 48,406 48,517 48,628 48,740 48,853 48,966 49,080 49,193 49,306 49,419 49,532 49,645 49,759 49,874 49,988 50,103 50,219 50,334 50,450 50,566 50,682 50,798 50,915 51,032 51,149 51,267 51,385 51,503 51,621 51,740 51,859 51,978 52,097 52,217
33
DTC Receipts 59,740 358,000 339,943 274,631 131,324 270,354 384,814 174,257 444,800 139,032 128,872 254,094 123,698 148,612 292,387 413,399 320,191 192,798 248,861 411,296 262,367 431,601 403,674 171,246 109,029 205,845 276,897 277,700 266,775 262,333 269,674 273,262 262,626 264,556 255,155 245,825 252,260 264,397 270,896 270,383 269,758 270,013 270,669 270,754 270,539 271,215 271,784 273,205 275,543 277,532 278,654 279,317 280,080 280,961 281,897 282,856 283,889 285,030 286,210 287,442 288,658 289,778 290,824 291,864 292,935 294,034 295,150 296,282 297,429 298,586 299,743 300,899 302,049 303,193 304,339 305,493 306,657 307,829 309,008 310,191 311,379 312,571 313,765 314,963 316,164 317,370 318,581 319,798 321,019 322,246 323,478 324,714 325,954 327,199 328,449 329,703 330,962
34
Amazon Receipts 13,901 13,780 12,574 12,244 12,219 13,604 16,084 12,004 13,238 13,470 16,170 13,032 10,124 11,435 12,466 13,647 15,465 13,510 15,279 13,071 10,746 13,876 16,554 12,961 13,212 13,117 14,319 14,322 14,438 14,302 14,369 14,268 14,283 14,510 14,446 14,294 14,406 14,419 14,508 14,524 14,541 14,550 14,571 14,588 14,615 14,642 14,654 14,671 14,703 14,728 14,754 14,775 14,796 14,817 14,840 14,862 14,885 14,908 14,931 14,954 14,978 15,001 15,024 15,046 15,069 15,092 15,115 15,139 15,162 15,185 15,209 15,232 15,255 15,279 15,302 15,326 15,349 15,373 15,396 15,420 15,444 15,467 15,491 15,515 15,539 15,562 15,586 15,610 15,634 15,658 15,682 15,706 15,730 15,754 15,779 15,803 15,827
35
Receivable CollectionsManual 51,341 54,741 62,913 67,206 86,882 50,320 64,964 15,000 40,129 83,291 83,021 57,530 49,245 64,015 36,695 80,826 68,784 68,167 82,117 63,879 85,899 68,070 65,341 87,301
36
Loan Draws 200,000 300,000 500,000 500,000 500,000 800,000
37
Other 8,000
38
39
OUTFLOWS
40
PayrollFixed 55,000 (54,145) (52,416) - (50,884) - (51,226) - (51,587) - (53,785) - (53,611) - (52,014) - (50,352) - (54,086) - (52,888) - (50,567) - (51,220) - (54,198) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) - (55,000) -
41
Shipping + Fulfillment% of Gross Sales5% (1,959) (11,743) (19,065) (17,908) (10,120) (11,601) (12,686) (8,530) (29,828) (11,351) (5,641) (11,022) (6,087) (8,490) (16,411) (14,478) (16,895) (12,336) (18,504) (23,046) (9,598) (14,075) (13,628) (8,736) (7,649) (16,719) (23,831) (23,939) (23,052) (22,904) (23,449) (23,658) (22,883) (22,968) (22,315) (21,569) (22,070) (23,141) (23,522) (23,495) (23,457) (23,491) (23,542) (23,549) (23,540) (23,596) (23,650) (23,764) (23,951) (24,111) (24,194) (24,252) (24,316) (24,390) (24,466) (24,545) (24,630) (24,723) (24,819) (24,919) (25,018) (25,109) (25,194) (25,279) (25,367) (25,457) (25,548) (25,640) (25,733) (25,827) (25,922) (26,016) (26,109) (26,203) (26,296) (26,390) (26,485) (26,580) (26,676) (26,772) (26,869) (26,966) (27,063) (27,160) (27,258) (27,356) (27,454) (27,553) (27,653) (27,752) (27,852) (27,953) (28,053) (28,154) (28,256) (28,358) (28,460)
42
InventoryHistorical21% (21,382) (101,305) (102,410) (80,785) (53,653) (88,052) (118,518) (65,327) (127,595) (56,743) (40,869) (80,803) (40,573) (62,631) (85,171) (129,028) (88,340) (72,864) (93,865) (118,499) (85,977) (120,763) (131,832) (62,471) (36,582) (81,696) (136,656) (70,866) (45,399) (83,635) (105,556) (106,013) (102,330) (101,659) (103,972) (104,812) (101,562) (102,004) (99,239) (96,046) (98,196) (102,698) (104,330) (104,224) (104,071) (104,219) (104,438) (104,477) (104,448) (104,695) (104,924) (105,409) (106,208) (106,892) (107,250) (107,499) (107,778) (108,094) (108,424) (108,764) (109,130) (109,529) (109,942) (110,370) (110,793) (111,185) (111,551) (111,918) (112,295) (112,680) (113,071) (113,468) (113,869) (114,273) (114,678) (115,082) (115,484) (115,884) (116,285) (116,689) (117,096) (117,506) (117,917) (118,331) (118,746) (119,162) (119,579) (119,997) (120,416) (120,837) (121,260) (121,684) (122,110) (122,538) (122,967) (123,398) (123,830)
43
Inventory (Manual)Manual 24,127 (55,042) 51,080 44,034 20,836 59,998 42,389 28,905 36,312
44
Card Payments (9,200) (314,609) - (145,500) (10,000) (344,818) - (153,000) (9,900) (342,974) - (163,500) - (10,900) (263,071) - (153,000) (11,000) (411,849) - (148,500) (9,200) (523,908) - (160,500) - (10,000) (433,186) - (136,000) (15,000) (481,579) - (150,000) (10,000) (614,462) - (150,000) - (10,000) (483,316) - (150,000) (10,000) (391,620) - (150,000) - (395,963) - (150,000) - (10,000) (453,190) - (150,000) (10,000) (392,896) - (150,000) - (404,400) - (150,000) - (10,000) (476,857) - (150,000) (10,000) (406,011) - (150,000) (10,000) (410,815) - (150,000) - (10,000) (495,362) - (150,000) (10,000) (421,681) - (150,000) - (10,000) (426,675) - (150,000) (10,000) (515,379) - (150,000) (10,000) (438,059)
45
Loan Repayments (100,000)
46
Other Cash ExpensesFixed 20,000 (24,237) (30,722) (14,622) (20,388) (30,269) (8,705) (29,137) (17,145) (16,945) (14,182) (12,781) (16,873) (17,141) (13,058) (26,455) (14,211) (11,121) (20,352) (11,077) (22,907) (8,592) (17,817) (18,207) (24,458) (20,026) (19,462) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000)
47
Other Cash Expenses (Manual)Manual (25,000)
48
Other Reconciling (24,223) (23,693) (47,970) 29,521 (43,665) 93,334 95,599 (128,344) 120,441 (69,009) (11,580) 100,931 (99,063) (103,064) 171,108 (84,546) 59,717 (59,717) (57,743) (165,394) (38,118) (85,122) 92,053 (99,802) 193,697 78,890 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
49
Cash Balance 444,046 314,778 724,595 800,702 867,608 760,166 1,134,379 1,235,711 1,682,263 1,336,871 1,477,929 2,041,632 2,103,975 2,077,501 2,198,186 2,401,833 3,045,553 3,075,428 2,806,065 2,964,531 3,004,426 3,276,815 3,202,441 3,187,127 3,796,767 3,995,355 4,140,029 3,873,643 4,909,942 4,914,924 5,169,971 4,816,444 5,016,467 4,990,480 4,993,869 4,497,647 4,665,394 4,641,047 4,963,749 5,172,970 4,878,242 5,007,759 5,041,293 5,160,048 4,952,241 5,139,165 5,174,017 5,349,304 5,141,996 5,277,436 5,318,711 5,455,237 5,636,791 5,320,407 5,512,834 5,550,266 5,734,257 5,502,057 5,761,825 5,790,203 6,068,602 5,807,536 6,006,543 6,001,210 6,270,356 6,406,469 6,259,684 6,407,400 6,460,929 6,600,272 6,481,530 6,632,484 6,689,229 6,831,756 6,693,131 6,847,237 6,907,148 7,062,874 7,306,809 6,968,815 7,267,906 7,276,922 7,481,764 7,220,752 7,505,319 7,517,648 7,735,814 7,918,726 7,711,902 7,942,943 8,014,493 8,171,897 7,879,779 8,048,898 8,211,181 8,408,340 8,196,996
50
Actual Bank 444,046 314,778 724,595 800,702 867,608 760,166 1,134,379 1,235,711 1,682,263 1,336,871 1,477,929 2,041,632 2,103,975 2,077,501 2,198,186 2,401,833 3,045,553 3,075,428 2,806,065 2,964,531 3,004,426 3,276,815 3,202,441 3,187,127 3,796,767 3,995,355
51
Check - - - - (0) - - - - - (0) - - - - - - - - 0 - - - - - (0) - (4,140,029) (3,873,643) (4,909,942) (4,914,924) (5,169,971) (4,816,444) (5,016,467) (4,990,480) (4,993,869) (4,497,647) (4,665,394) (4,641,047) (4,963,749) (5,172,970) (4,878,242) (5,007,759) (5,041,293) (5,160,048) (4,952,241) (5,139,165) (5,174,017) (5,349,304) (5,141,996) (5,277,436) (5,318,711) (5,455,237) (5,636,791) (5,320,407) (5,512,834) (5,550,266) (5,734,257) (5,502,057) (5,761,825) (5,790,203) (6,068,602) (5,807,536) (6,006,543) (6,001,210) (6,270,356) (6,406,469) (6,259,684) (6,407,400) (6,460,929) (6,600,272) (6,481,530) (6,632,484) (6,689,229) (6,831,756) (6,693,131) (6,847,237) (6,907,148) (7,062,874) (7,306,809) (6,968,815) (7,267,906) (7,276,922) (7,481,764) (7,220,752) (7,505,319) (7,517,648) (7,735,814) (7,918,726) (7,711,902) (7,942,943) (8,014,493) (8,171,897) (7,879,779) (8,048,898) (8,211,181) (8,408,340) (8,196,996)
52
53
54
55
56
57
Credit Cards
58
Opening Balance 500,000 690,119 508,520 692,931 674,671 760,549 859,665 1,027,637 971,318 1,185,860 986,111 1,089,286 1,056,263 1,170,697 1,246,441 1,123,797 1,358,071 1,331,545 1,425,747 1,123,341 1,319,528 1,346,656 1,553,228 1,189,336 1,319,108 1,226,719 1,356,953 1,470,795 1,176,778 1,297,099 1,280,070 1,386,574 1,048,551 1,167,579 1,137,215 1,243,652 742,354 868,354 838,121 960,028 1,071,770 709,989 831,628 803,494 915,390 645,600 767,669 739,945 862,720 590,353 714,648 689,330 814,249 929,440 601,752 727,584 703,755 820,291 554,333 681,687 659,474 787,690 511,900 640,878 620,224 749,947 870,058 523,704 654,607 635,914 757,629 483,741 616,271 599,205 722,543 445,469 579,617 564,176 699,147 824,534 464,974 601,196 587,838 714,900 430,704 568,611 556,943 695,701 824,888 537,829 677,879 668,361 799,279 425,255 567,048 559,281 691,955
59
INCREASES
60
Shipping + Fulfillment% of Gross Sales5% 4,570 27,401 22,879 23,877 16,191 17,401 33,830 12,796 29,828 15,135 8,461 16,533 12,174 12,735 22,975 24,131 16,895 14,803 18,504 23,046 25,595 28,151 22,714 17,473 10,199 16,719 23,831 23,939 23,052 22,904 23,449 23,658 22,883 22,968 22,315 21,569 22,070 23,141 23,522 23,495 23,457 23,491 23,542 23,549 23,540 23,596 23,650 23,764 23,951 24,111 24,194 24,252 24,316 24,390 24,466 24,545 24,630 24,723 24,819 24,919 25,018 25,109 25,194 25,279 25,367 25,457 25,548 25,640 25,733 25,827 25,922 26,016 26,109 26,203 26,296 26,390 26,485 26,580 26,676 26,772 26,869 26,966 27,063 27,160 27,258 27,356 27,454 27,553 27,653 27,752 27,852 27,953 28,053 28,154 28,256 28,358 28,460
61
Ad spend% of Net Sales28% 22,198 90,031 129,645 59,693 40,479 104,408 97,260 51,183 164,056 62,430 56,407 82,664 60,868 48,817 68,926 183,394 67,579 61,680 83,267 156,714 105,578 168,903 131,739 67,708 28,047 80,810 75,012 75,229 72,270 71,066 73,055 74,027 71,146 71,668 69,122 66,594 68,338 71,626 73,386 73,247 73,078 73,147 73,324 73,347 73,289 73,473 73,627 74,011 74,645 75,184 75,488 75,667 75,874 76,113 76,366 76,626 76,906 77,215 77,535 77,868 78,198 78,501 78,785 79,066 79,357 79,654 79,956 80,263 80,574 80,887 81,201 81,514 81,825 82,135 82,446 82,758 83,074 83,391 83,710 84,031 84,353 84,676 84,999 85,324 85,649 85,976 86,304 86,634 86,965 87,297 87,630 87,965 88,301 88,639 88,977 89,317 89,658
62
Other ExpensesFixed 25,000 20,536 15,578 31,887 43,669 39,208 39,296 36,882 32,703 30,557 21,079 38,307 31,279 41,393 25,092 28,401 26,749 42,001 28,719 30,598 16,426 44,455 18,719 32,193 44,591 29,865 32,704 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000
63
Other Expenses (Manual)Manual 15,001 20,870 10,592
64
65
Decreases - - - 1 - - - - 1
66
Net 60 Credit Card - (222,609) - - - (246,818) - - - (244,974) - - - - (164,071) - - - (319,849) - - - (416,908) - - - - (311,186) - - - (381,579) - - - (514,462) - - - - (383,316) - - - (291,620) - - - (285,963) - - - - (353,190) - - - (292,896) - - - (294,400) - - - - (376,857) - - - (306,011) - - - (310,815) - - - - (395,362) - - - (321,681) - - - - (326,675) - - - (415,379) - - - (338,059)
67
Net 60 Credit Card (Manual)Manual
68
Credit Card 11 100,000 - (92,000) - - - (98,000) - - - (98,000) - - - - (99,000) - - - (92,000) - - - (107,000) - - - - (100,000) - - - (100,000) - - - (100,000) - - - - (100,000) - - - (100,000) - - - (100,000) - - - - (100,000) - - - (100,000) - - - (100,000) - - - - (100,000) - - - (100,000) - - - (100,000) - - - - (100,000) - - - (100,000) - - - - (100,000) - - - (100,000) - - - (100,000)
69
Credit Card 1 (Manual)Manual (22,000)
70
Credit Card 215 150,000 - - - (145,500) - - - (153,000) - - - (163,500) - - - - (153,000) - - - (148,500) - - - (160,500) - - - - (150,000) - - - (150,000) - - - (150,000) - - - - (150,000) - - - (150,000) - - - (150,000) - - - - (150,000) - - - (150,000) - - - (150,000) - - - - (150,000) - - - (150,000) - - - (150,000) - - - - (150,000) - - - (150,000) - - - - (150,000) - - - (150,000) - -
71
Credit Card 2 (Manual)Manual 14,000
72
Credit Card 325 10,000 (9,200) - - - (10,000) - - - (9,900) - - - - (10,900) - - - (11,000) - - - (9,200) - - - - (10,000) - - - (10,000) - - - (10,000) - - - - (10,000) - - - (10,000) - - - - (10,000) - - - (10,000) - - - (10,000) - - - - (10,000) - - - (10,000) - - - (10,000) - - - (10,000) - - - - (10,000) - - - (10,000) - - - - (10,000) - - - (10,000) - - - (10,000) -
73
Credit Card 3 (Manual)Manual (5,000)
74
Other reconciling 282,828 44,581 20,125 (22,925) (26,630) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
75
Closing Balance 690,119 508,520 692,931 674,671 760,549 859,665 1,027,637 971,318 1,185,860 986,111 1,089,286 1,056,263 1,170,697 1,246,441 1,123,797 1,358,071 1,331,545 1,425,747 1,123,341 1,319,528 1,346,656 1,553,228 1,189,336 1,319,108 1,226,719 1,356,953 1,470,795 1,176,778 1,297,099 1,280,070 1,386,574 1,048,551 1,167,579 1,137,215 1,243,652 742,354 868,354 838,121 960,028 1,071,770 709,989 831,628 803,494 915,390 645,600 767,669 739,945 862,720 590,353 714,648 689,330 814,249 929,440 601,752 727,584 703,755 820,291 554,333 681,687 659,474 787,690 511,900 640,878 620,224 749,947 870,058 523,704 654,607 635,914 757,629 483,741 616,271 599,205 722,543 445,469 579,617 564,176 699,147 824,534 464,974 601,196 587,838 714,900 430,704 568,611 556,943 695,701 824,888 537,829 677,879 668,361 799,279 425,255 567,048 559,281 691,955 397,014
76
Actual Balances 634,910 859,665 986,111 1,123,797 1,123,341 1,189,336
77
Check - - - - 0 - -
78
79
80
Lender
81
Opening Balance 500,000 482,246 374,977 473,089 390,836 351,562 270,550 155,160 402,919 269,573 227,943 189,348 613,159 576,250 531,853 444,292 320,384 724,405 666,798 592,346 469,121 390,547 261,158 140,105 88,762 556,073 494,492 411,566 328,371 1,048,425 970,064 889,472 807,775 729,242 650,102 473,755 400,147 324,582 245,349 164,137 83,052 2,125 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
82
CollectionRate30.00% (17,922) (107,400) (101,983) (82,389) (39,397) (81,106) (115,444) (52,277) (133,440) (41,710) (38,661) (76,228) (37,109) (44,583) (87,716) (124,020) (96,057) (57,839) (74,658) (123,389) (78,710) (129,480) (121,102) (51,374) (32,709) (61,754) (83,069) (83,310) (80,032) (78,700) (80,902) (81,978) (78,788) (79,367) (76,547) (73,748) (75,678) (79,319) (81,269) (81,115) (80,927) (2,125) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
83
Interest% of Balance0.0349% 168 131 95 136 123 94 54 36 94 80 66 39 201 186 155 112 78 233 207 164 136 91 49 31 20 173 144 115 87 338 310 282 254 227 200 140 113 86 57 29 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
84
Repayments (100,000)
85
Draws 200,000 300,000 500,000 500,000 500,000 800,000
86
Closing BalanceMax Allowed 2,000,000 482,246 374,977 473,089 390,836 351,562 270,550 155,160 402,919 269,573 227,943 189,348 613,159 576,250 531,853 444,292 320,384 724,405 666,798 592,346 469,121 390,547 261,158 140,105 88,762 556,073 494,492 411,566 328,371 1,048,425 970,064 889,472 807,775 729,242 650,102 473,755 400,147 324,582 245,349 164,137 83,052 2,125 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
87
88
89
90
91
92
93
94
95
96
97
98
99
100