Chinememma Obodozie

Base Recurring Revenue (cash collected) Revenue from New Clients (recognized this month) Total Revenue Recognized Cost of Sales (30% of revenue) Operating Costs (50% of revenue minus COS) Remaining Profit (before S&M) Sales & Marketing Budget (50% of remaining profit, >=0) Planned New Clients (floor(S&M / 800)) Acquisition Cost (actual_new_clients * 800) Client Lump-Sum Payments Received (10000 each, received after 4 months) Total Cash Inflow (base + client payments) Total Cash Outflow (COS + Op Costs + Acq Cost) Net Cash Flow (In - Out) Cash Balance (cumulative) Active New Clients (whose 12-month recognition includes this month) Cumulative New Clients Acquired Assumtions Acquisition cost per New Client Annual Sales per Client /Year Sales per new client per Month Collection from per New Client full year in 4th Month 30% 50% 50% 800 10,-,000 Month 1 50,000 50,000 15,000 17,500 17,500 8,750 10 8,000 50,000 40,500 9,500 9,- Month 2 Month 3 Month 4 50,000 50,000 50,000 8,333 18,333 30,000 58,333 68,333 80,000 17,500 20,500 24,000 20,417 23,917 28,000 20,417 23,917 28,000 10,208 11,958 14,-,600 11,200 13,600 50,000 50,000 50,000 47,517 55,617 65,600 2,483 5,617 - 15,600 11,983 6,367 9,- Month 5 50,000 44,167 94,167 28,250 32,958 32,958 16,-,000 100,000 150,000 77,208 72,792 63,- Month 6 50,000 60,833 110,833 33,250 38,792 38,792 19,-,200 120,000 170,000 91,242 78,758 142,- Month 7 50,000 80,833 130,833 39,250 45,792 45,792 22,-,400 140,000 190,000 107,442 82,558 224,- Month 8 50,000 104,167 154,167 46,250 53,958 53,958 26,-,400 170,000 220,000 126,608 93,392 318,- Month 9 50,000 131,667 181,667 54,500 63,583 63,583 31,-,200 200,000 250,000 149,283 100,717 418,- Month 10 50,000 164,167 214,167 64,250 74,958 74,958 37,-,800 240,000 290,000 176,008 113,992 532,- Month 11 50,000 202,500 252,500 75,750 88,375 88,375 44,-,000 280,000 330,000 208,125 121,875 654,- Month 12 50,000 248,333 298,333 89,500 104,417 104,417 52,-,000 330,000 380,000 245,917 134,083 788,- Month 13 50,000 294,167 344,167 103,250 120,458 120,458 60,-,000 390,000 440,000 283,708 156,292 945,- Month 14 50,000 346,667 396,667 119,000 138,833 138,833 69,-,800 460,000 510,000 326,633 183,367 1,128,- Month 15 50,000 406,667 456,667 137,000 159,833 159,833 79,-,200 550,000 600,000 376,033 223,967 1,352,- Month 16 50,000 475,000 525,000 157,500 183,750 183,750 91,-,200 650,000 700,000 432,450 267,550 1,620,- Month 17 50,000 553,333 603,333 181,000 211,167 211,167 105,-,800 750,000 800,000 496,967 303,033 1,923,- Month 18 50,000 642,500 692,500 207,750 242,375 242,375 121,-,800 860,000 910,000 570,925 339,075 2,262,-,019 Month 19 50,000 745,000 795,000 238,500 278,250 278,250 139,-,400 990,000 1,040,000 655,150 384,850 2,647,-,192 Month 20 50,000 861,667 911,667 273,500 319,083 319,083 159,-,200 1,140,000 1,190,000 751,783 438,217 3,085,-,391 Month 21 50,000 995,000 1,045,000 313,500 365,750 365,750 182,-,400 1,310,000 1,360,000 861,650 498,350 3,583,-,619 Month 22 50,000 1,146,667 1,196,667 359,000 418,833 418,833 209,-,800 1,510,000 1,560,000 986,633 573,367 4,157,-,880 Month 23 50,000 1,318,333 1,368,333 410,500 478,917 478,917 239,-,200 1,730,000 1,780,000 1,128,617 651,383 4,808,-,179 Month 24 50,000 1,513,333 1,563,333 469,000 547,167 547,167 273,-,800 1,990,000 2,040,000 1,288,967 751,033 5,559,-,520