ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBL
1
CAUTION: These projections are only a generic template to help a project do their own research and planning.
DO NOT USE these numbers as your project's projection without doing your own research and modifying with your own assumptions and costs for your market and situation. Please read additional guidance on the second tab (at bottom of screen) labelled "READ this first".
2
----------------------------------------------------------- Y E A R O N E ------------------------------------------------------------------------- ----------------------------------------------------------- Y E A R T W O ------------------------------------------------------------------------- ----------------------------------------------------------- Y E A R T H R E E ------------------------------------------------------------------------- ----------------------------------------------------------- Y E A R F O U R ------------------------------------------------------------------------- ----------------------------------------------------------- Y E A R F I V E -------------------------------------------------------------------------
3
Rate - TasaJan-Yr 1FebMarchAprilMayJuneJulyAugSeptOctNovDecJan-Yr 2FebMarchAprilMayJuneJulyAugSeptOctNovDecJan-Yr 3FebMarchAprilMayJuneJulyAugSeptOctNovDecJan-Yr 4FebMarchAprilMayJuneJulyAugSeptOctNovDecJan-Yr 5FebMarchAprilMayJuneJulyAugSeptOctNovDec
4
INCOME - INGRESOS
5
Cost of Acquiring Client - Costo de Adquerir Cliente$250
6
Avg Revenue/client/month - ingreso por cliente/mes$300
7
# of regular clients:2468101214161820222426283032343638404244464850525456586062646668707274767880828486889092949698100102104106108110112114116118120
8
Revenue, regular clients -- Ingresos, clientes regulares6001,2001,8002,4003,0003,6004,2004,8005,4006,0006,6007,2007,8008,4009,0009,60010,20010,80011,40012,00012,60013,20013,80014,40015,00015,60016,20016,80017,40018,00018,60019,20019,80020,40021,00021,60022,20022,80023,40024,00024,60025,20025,80026,40027,00027,60028,20028,80029,40030,00030,60031,20031,80032,40033,00033,60034,20034,80035,40036,000
9
Revenues, 1-time jobs - Ingresos, trabajos de una vez601201802403003604204805406006607207808409009601,0201,0801,1401,2001,2601,3201,3801,4401,5001,5601,6201,6801,7401,8001,8601,9201,9802,0402,1002,1602,2202,2802,3402,4002,4602,5202,5802,6402,7002,7602,8202,8802,9403,0003,0603,1203,1803,2403,3003,3603,4203,4803,5403,600
10
TOTAL Income - Ingresos6601,3201,9802,6403,3003,9604,6205,2805,9406,6007,2607,9208,5809,2409,90010,56011,22011,88012,54013,20013,86014,52015,18015,84016,50017,16017,82018,48019,14019,80020,46021,12021,78022,44023,10023,76024,42025,08025,74026,40027,06027,72028,38029,04029,70030,36031,02031,68032,34033,00033,66034,32034,98035,64036,30036,96037,62038,28038,94039,600
11
12
Cost of Services (COS)
Costo de Servicios
77.5%5111,0231,5342,0462,5573,0693,5804,0914,6035,1145,6266,1376,6497,1607,6728,1838,6949,2069,71710,22910,74011,25211,76312,27412,78613,29713,80914,32014,83215,34315,85416,36616,87717,38917,90018,41218,92319,43419,94620,45720,96921,48021,99222,50323,01523,52624,03724,54925,06025,57226,08326,59527,10627,61728,12928,64029,15229,66330,17530,686
13
14
Gross Profit -- Ganancia Cruda1492974465947438911,0401,1891,3371,4861,6341,7831,9312,0802,2282,3772,5262,6742,8232,9713,1203,2683,4173,5663,7143,8634,0114,1604,3084,4574,6064,7544,9035,0515,2005,3485,4975,6465,7945,9436,0916,2406,3886,5376,6856,8346,9837,1317,2807,4287,5777,7257,8748,0238,1718,3208,4688,6178,7658,914
15
Gross Profit Rate -- Tasa de Ganancia Cruda22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%22.5%
16
17
18
19
General Expenses - Gastos Generales$6,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,5856,585
20
21
Net "Regular Profit" -- Ganancia Neto Regular(6,437)(6,288)(6,140)(5,991)(5,843)(5,694)(5,545)(5,397)(5,248)(5,100)(4,951)(4,803)(4,654)(4,505)(4,357)(4,208)(4,060)(3,911)(3,763)(3,614)(3,466)(3,317)(3,168)(3,020)(2,871)(2,723)(2,574)(2,426)(2,277)(2,128)(1,980)(1,831)(1,683)(1,534)(1,386)(1,237)(1,088)(940)(791)(643)(494)(346)(197)(48)1002493975466948439911,1401,2891,4371,5861,7341,8832,0312,1802,329
22
23
Growth & Develop (G & D) - Crecimiento & Desarrollo
24
G&D, yrs 1-2 (see G&D Detail tab)$4,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,7084,708
25
G&D, yrs 3-4 (60% of starting G&D)$2,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,8252,825
26
G&D, yr 5 (20% of starting G&D; last month is $0)$9429429429429429429429429429429429420
27
Total Expense (includes COS) -- Total de Gastos 11,80412,31612,82713,33913,85014,36114,87315,38415,89616,40716,91917,43017,94218,45318,96419,47619,98720,49921,01021,52222,03322,54423,05623,56722,19622,70723,21923,73024,24124,75325,26425,77626,28726,79927,31027,82228,33328,84429,35629,86730,37930,89031,40231,91332,42432,93633,44733,95932,58733,09933,61034,12134,63335,14435,65636,16736,67937,19037,70137,271
28
29
NET INCOME -- INGRESO NETO(11,144)(10,996)(10,847)(10,699)(10,550)(10,401)(10,253)(10,104)(9,956)(9,807)(9,659)(9,510)(9,362)(9,213)(9,064)(8,916)(8,767)(8,619)(8,470)(8,322)(8,173)(8,024)(7,876)(7,727)(5,696)(5,547)(5,399)(5,250)(5,101)(4,953)(4,804)(4,656)(4,507)(4,359)(4,210)(4,062)(3,913)(3,764)(3,616)(3,467)(3,319)(3,170)(3,022)(2,873)(2,724)(2,576)(2,427)(2,279)(247)(99)501993474966447939411,0901,2392,329
30
31
Adjustments to reconcile Net Income to net cash from operations
32
[note: this section can be developed to create a cash flow management tool.]
33
Investment (typically on philanthropic terms)400,000
34
Net Cash Increase (loss) for period
Aumento (perdida) de efectivo para el periodo
(11,144)(10,996)(10,847)(10,699)(10,550)(10,401)(10,253)(10,104)(9,956)(9,807)(9,659)(9,510)(9,362)(9,213)(9,064)(8,916)(8,767)(8,619)(8,470)(8,322)(8,173)(8,024)(7,876)(7,727)(5,696)(5,547)(5,399)(5,250)(5,101)(4,953)(4,804)(4,656)(4,507)(4,359)(4,210)(4,062)(3,913)(3,764)(3,616)(3,467)(3,319)(3,170)(3,022)(2,873)(2,724)(2,576)(2,427)(2,279)(247)(99)501993474966447939411,0901,2392,329
35
Cumulative Cash Increase (loss)
Aumento (perdida) de Efectivo Acumulativo
(11,144)(22,140)(32,987)(43,686)(54,236)(64,637)(74,890)(84,995)(94,951)(104,758)(114,416)(123,926)(133,288)(142,501)(151,565)(160,481)(169,248)(177,867)(186,337)(194,659)(202,832)(210,856)(218,732)(226,459)(232,155)(237,702)(243,101)(248,351)(253,453)(258,405)(263,210)(267,866)(272,373)(276,731)(280,941)(285,003)(288,916)(292,680)(296,296)(299,763)(303,082)(306,252)(309,274)(312,147)(314,871)(317,447)(319,874)(322,153)(322,400)(322,499)(322,449)(322,250)(321,903)(321,407)(320,763)(319,970)(319,029)(317,939)(316,700)(314,372)
36
Cumulative Investment
37
Cash Balance400,000388,856377,860367,013356,314345,764335,363325,110315,005305,049295,242285,584276,074266,712257,499248,435239,519230,752222,133213,663205,341197,168189,144181,268173,541167,845162,298156,899151,649146,547141,595136,790132,134127,627123,269119,059114,997111,084107,320103,704100,23796,91893,74890,72687,85385,12982,55380,12677,84777,60077,50177,55177,75078,09778,59379,23780,03080,97182,06183,30085,628
38
39
"Regular Profit" Break even point (monthly gross)29,255
40
Annual Total Earned Revenue ProjectionYear One, earned revenue:51,480Year Two, earned revenue:146,520Year Three, earned revenue:241,560Year Four, earned revenue:336,600Year Five, earned revenue:431,640
41
Annual Budget Projection (all Expenses including COS)
Year One, Expenses:175,406Year Two, Expenses:249,053Year Three, Expenses:300,103Year Four, Expenses:373,750Year Five, Expenses:423,859
42
Annual Net Income (Loss) to be subsidized/financedYear One, Net Income (Loss):(123,926)Year Two, Net Income (Loss):(102,533)Year Three, Net Income (Loss):(58,543)Year Four, Net Income (Loss):(37,150)Year Five, Net Income (Loss):7,781
43
Shared under a Creative Commons 4.0 License -- You are free to adapt and further share this material if
you agree to credit the TeamWorks Development Institute as the original source. You may not sell this content to others.