SAMPLE STARTUP NPO PROFORMA OPERATING BUDGET by xfk17120

VIEWS: 6 PAGES: 6

									                                                                     SAMPLE STARTUP NPO
                                                                 PROFORMA OPERATING BUDGET
                                                                            -AND-
                                                                SCHED OF OPERATING CASH FLOWS

OPERATING BUDGET
                           Month 1    Month 2    Month 3     Month 4     Month 5    Month 6    Month 7     Month 8     Month 9    Month 10    Month 11   Month 12   FY Total
REVENUES
Private Donations             2,000                                                    1,500                  1,000       1,000                    500      2,000      8,000
Fundraisers                   1,200                             1,200                             1,200                                                     1,200      4,800
Grants                                   3,000                                                                                                                         3,000
Program Fees                                                    2,500       2,500      4,000                              2,500      2,500       2,500                16,500
TOTAL REVENUES                3,200      3,000        -         3,700       2,500      5,500      1,200       1,000       3,500      2,500       3,000      3,200     32,300


EXPENSES
Compensation                  1,000      1,000      1,000       1,000       1,000      1,000      1,000       1,000       1,000      1,000       1,000      1,000     12,000
Newsletter                      300                               300                               300                                300                             1,200
Promotion                       250       250        250          250         250        250        250        250         250         250         250        250      3,000
Facility                        500       500        500          500       1,000      1,000      1,000        500         500       1,000       1,000      1,000      9,000
Volunteer Training                                   100          100                                          100         100                                           400
Workshop Materials                                   500                                                                   500                                         1,000
Travel                         100        100                                                      100         100                                            100        500
Scholarships                                                     250         250        250                                250         250         250                 1,500
Professional Development                   200                                                                  200                                                      400
TOTAL EXPENSES                2,150      2,050      2,350       2,400       2,500      2,500      2,650       2,150       2,600      2,800       2,500      2,350     29,000


NET GAIN/(LOSS)               1,050       950      (2,350)      1,300         -        3,000     (1,450)     (1,150)       900        (300)        500        850      3,300


CASH FLOW FROM OPERATING ACTIVITIES
Beg Cash                   -     1,050              2,000        (350)       950         950      3,950       2,500       1,350      2,250       1,950      2,450        -
Net Effect of Operations 1,050     950             (2,350)      1,300        -         3,000     (1,450)     (1,150)        900       (300)        500        850      3,300
Ending Cash              1,050   2,000               (350)        950        950       3,950      2,500       1,350       2,250      1,950       2,450      3,300      3,300
                                                                              SAMPLE STARTUP NPO
                                                                           PROFORMA CAPITAL BUDGET
                                                                                     -AND-
                                                                         SCHED OF OPERATING CASH FLOWS



CAPITAL BUDGET
                                        Month 1     Month 2     Month 3     Month 4     Month 5     Month 6     Month 7     Month 8     Month 9     Month 10     Month 11     Month 12     FY Total
REVENUES
Sale of Assets                               -           -           -           -           -           -           -           -           -            -            -            -           -
TOTAL REVENUES                               -           -           -           -           -           -           -           -           -            -            -            -           -


EXPENSES              Purchase Price
Office Equipment*               2,500        78          78          78          78          78          78          78          78          78           78           78           78          936
Program Equipment**             5,000       155         155         155         155         155         155         155         155         155          155          155          155        1,860
TOTAL EXPENSES                              233         233         233         233         233         233         233         233         233          233          233          233        2,796


NET GAIN/(LOSS)                             (233)       (233)       (233)       (233)       (233)       (233)       (233)       (233)       (233)       (233)        (233)        (233)      (2,796)


CASH FLOW FROM CAPTIAL ACTIVITES
Beg Cash                                     -          (233)       (466)       (699)       (932)     (1,165)     (1,398)     (1,631)     (1,864)      (2,097)      (2,330)      (2,563)        -
Net Effect of Capital                       (233)       (233)       (233)       (233)       (233)       (233)       (233)       (233)       (233)        (233)        (233)        (233)     (2,796)
Ending Cash                                 (233)       (466)       (699)       (932)     (1,165)     (1,398)     (1,631)     (1,864)     (2,097)      (2,330)      (2,563)      (2,796)     (2,796)


                      Terms:
                      * 36mo at 7%
                      ** 36mo at 7%
                                                               SAMPLE STARTUP NPO
                                                  PROFORMA CONSOLODATED SCHEDULE OF CASH FLOWS




CONSOLODATED SCHEDULE OF CASH FLOWS
                                   Month 1  Month 2    Month 3     Month 4     Month 5    Month 6    Month 7     Month 8     Month 9 Month 10 Month 11 Month 12 FY Total
Beg Cash                               -        817       1,534      (1,049)        18       (215)      2,552         869       (514)     153     (380)    (113)     -
Net Effect of Operating Activities   1,050      950      (2,350)      1,300        -        3,000      (1,450)     (1,150)       900     (300)     500      850    3,300
Net Effect of Captial Activities      (233)    (233)       (233)       (233)      (233)      (233)       (233)       (233)      (233)    (233)    (233)    (233)  (2,796)
Ending Cash                            817    1,534      (1,049)         18       (215)     2,552         869        (514)       153     (380)    (113)     504      504
                                                                                                                    SAMPLE STARTUP NPO
                                                                                                                PROFORMA OPERATING BUDGET
                                                                                                                           -AND-
                                                                                                               SCHED OF OPERATING CASH FLOWS




OPERATING BUDGET
                                      Month 1               Month 2          Month 3          Month 4          Month 5          Month 6          Month 7         Month 8          Month 9          Month 10         Month 11          Month 12      FY Total
REVENUES
Private Donations           2000                                                                                         1500                              1000            1000                               500              2000              =SUM(B4:M4)
Fundraisers                 1200                                                       1200                                               1200                                                                                 1200              =SUM(B5:M5)
Grants                                               3000                                                                                                                                                                                        =SUM(B6:M6)
Program Fees                                                                           2500             2500             4000                                              2500             2500              2500                               =SUM(B7:M7)
TOTAL REVENUES              =SUM(B4:B7)              =SUM(C4:C7)      =SUM(D4:D7)      =SUM(E4:E7)      =SUM(F4:F7)      =SUM(G4:G7)      =SUM(H4:H7)      =SUM(I4:I7)     =SUM(J4:J7)      =SUM(K4:K7)       =SUM(L4:L7)      =SUM(M4:M7)       =SUM(N4:N7)


EXPENSES
Compensation                1000                     1000             1000             1000             1000             1000             1000             1000            1000             1000              1000             1000              =SUM(B12:M12)
Newsletter                  300                                                        300                                                300                                               300                                                  =SUM(B13:M13)
Promotion                   250                      250              250              250              250              250              250              250             250              250               250              250               =SUM(B14:M14)
Facility                    500                      500              500              500              1000             1000             1000             500             500              1000              1000             1000              =SUM(B15:M15)
Volunteer Training                                                    100              100                                                                 100             100                                                                   =SUM(B16:M16)
Workshop Materials                                                    500                                                                                                  500                                                                   =SUM(B17:M17)
Travel                      100                      100                                                                                  100              100                                                                 100               =SUM(B18:M18)
Scholarships                                                                           250              250              250                                               250              250               250                                =SUM(B19:M19)
Professional Development                             200                                                                                                   200                                                                                   =SUM(B20:M20)
TOTAL EXPENSES              =SUM(B12:B20)            =SUM(C12:C20)    =SUM(D12:D20)    =SUM(E12:E20)    =SUM(F12:F20)    =SUM(G12:G20)    =SUM(H12:H20)    =SUM(I12:I20)   =SUM(J12:J20)    =SUM(K12:K20)     =SUM(L12:L20)    =SUM(M12:M20)     =SUM(N12:N20)


NET GAIN/(LOSS)             =B8-B21                  =C8-C21          =D8-D21          =E8-E21          =F8-F21          =G8-G21          =H8-H21          =I8-I21         =J8-J21          =K8-K21           =L8-L21          =M8-M21           =N8-N21



CASH FLOW FROM OPERATI
Beg Cash                 ='Sched of Cash Flows'!B3   =B30             =C30             =D30             =E30             =F30             =G30             =H30            =I30             =J30              =K30             =L30              =B28
Net Effect of Operations =B24                        =C24             =D24             =E24             =F24             =G24             =H24             =I24            =J24             =K24              =L24             =M24              =N24
Ending Cash              =B28+B29                    =C28+C29         =D28+D29         =E28+E29         =F28+F29         =G28+G29         =H28+H29         =I28+I29        =J28+J29         =K28+K29          =L28+L29         =M28+M29          =N28+N29
                                                                                                                   SAMPLE STARTUP NPO
                                                                                                                PROFORMA CAPITAL BUDGET
                                                                                                                          -AND-
                                                                                                              SCHED OF OPERATING CASH FLOWS




CAPITAL BUDGET
                                                 Month 1              Month 2        Month 3       Month 4        Month 5       Month 6       Month 7       Month 8       Month 9       Month 10      Month 11       Month 12       FY Total
REVENUES
Sale of Assets                         0                           0              0             0              0             0             0             0             0             0             0              0              =SUM(C4:N4)
TOTAL REVENUES                         =SUM(C4:C4)                 =SUM(D4:D4)    =SUM(E4:E4)   =SUM(F4:F4)    =SUM(G4:G4)   =SUM(H4:H4)   =SUM(I4:I4)   =SUM(J4:J4)   =SUM(K4:K4)   =SUM(L4:L4)   =SUM(M4:M4)    =SUM(N4:N4)    =SUM(O4:O4)


EXPENSES              Purchase Price
Office Equipment*     2500             78                          78             78           78           78           78           78           78                  78           78             78             78             =SUM(C9:N9)
Program Equipment**   5000             155                         155            155          155          155          155          155          155                 155          155            155            155            =SUM(C10:N10)
TOTAL EXPENSES                         =SUM(C9:C10)                =SUM(D9:D10)   =SUM(E9:E10) =SUM(F9:F10) =SUM(G9:G10) =SUM(H9:H10) =SUM(I9:I10) =SUM(J9:J10)        =SUM(K9:K10) =SUM(L9:L10)   =SUM(M9:M10)   =SUM(N9:N10)   =SUM(O9:O10)


NET GAIN/(LOSS)                        =C5-C11                     =D5-D11        =E5-E11       =F5-F11        =G5-G11       =H5-H11       =I5-I11       =J5-J11       =K5-K11       =L5-L11       =M5-M11        =N5-N11        =O5-O11



CASH FLOW FROM CAPT
Beg Cash                               ='Sched of Cash Flows'!B3   =C20           =D20          =E20           =F20          =G20          =H20          =I20          =J20          =K20          =L20           =M20           =C18
Net Effect of Capital                  =C14                        =D14           =E14          =F14           =G14          =H14          =I14          =J14          =K14          =L14          =M14           =N14           =O14
Ending Cash                            =C18+C19                    =D18+D19       =E18+E19      =F18+F19       =G18+G19      =H18+H19      =I18+I19      =J18+J19      =K18+K19      =L18+L19      =M18+M19       =N18+N19       =O18+O19


                      Terms:
                      * 36mo at 7%
                      ** 36mo at 7%
                                                                                                                                                                             SAMPLE STARTUP NPO
                                                                                                                                                                 PROFORMA CONSOLODATED SCHEDULE OF CASH FLOWS




CONSOLODATED SCHEDULE OF C
                                               Month 1                   Month 2                   Month 3                   Month 4                   Month 5                   Month 6                   Month 7                   Month 8                   Month 9                  Month 10                  Month 11                   Month 12                  FY Total
Beg Cash                             0                         =B6                       =C6                       =D6                       =E6                       =F6                       =G6                       =H6                       =I6                       =J6                       =K6                       =L6                       =B3
Net Effect of Operating Activities   ='Operating Budget'!B24   ='Operating Budget'!C24   ='Operating Budget'!D24   ='Operating Budget'!E24   ='Operating Budget'!F24   ='Operating Budget'!G24   ='Operating Budget'!H24   ='Operating Budget'!I24   ='Operating Budget'!J24   ='Operating Budget'!K24   ='Operating Budget'!L24   ='Operating Budget'!M24   ='Operating Budget'!N24
Net Effect of Captial Activities     ='Capital Budget'!C14     ='Capital Budget'!D14     ='Capital Budget'!E14     ='Capital Budget'!F14     ='Capital Budget'!G14     ='Capital Budget'!H14     ='Capital Budget'!I14     ='Capital Budget'!J14     ='Capital Budget'!K14     ='Capital Budget'!L14     ='Capital Budget'!M14     ='Capital Budget'!N14     ='Capital Budget'!O14
Ending Cash                          =SUM(B3:B5)               =SUM(C3:C5)               =SUM(D3:D5)               =SUM(E3:E5)               =SUM(F3:F5)               =SUM(G3:G5)               =SUM(H3:H5)               =SUM(I3:I5)               =SUM(J3:J5)               =SUM(K3:K5)               =SUM(L3:L5)               =SUM(M3:M5)               =SUM(N3:N5)

								
To top