Excel Template with Financial Contributions

Document Sample
Excel Template with Financial Contributions Powered By Docstoc
					         USING THIS CASH FLOW PROJECTION WORKSHEET

         The worksheet was developed using categories frequently used by nonprofit organizations.
         It will require modification to match your organization's financial situation.

         BLUE headings are category headings with no entry required.

         GREEN headings are subtotals and totals.
         Formulas are entered for these rows. They may require modification. Be sure to verify
         all formulas.

         BLACK headings are common cash receipt and disbursement categories. These
         should be modified for you organization. Remember that adding or deleting rows may
         affect the formulas.

         PURPLE headings are the cash totals and balances. The worksheet includes the
         formulas to calculate the cash flow balances

         STARTING CASH is the blue box at the top. An accurate estimate of this will
         help obtain the best results with this worksheet.

         We recommend that you save a blank worksheet before you make changes to
         the categories or formulas.




         This worksheet has been made available as a convenience for visitors to this web site.
         Nonprofits Assistance Fund makes no assurances or guarantees
         of the accuracy of the formulas or the information. Please review all input and
         calculations carefully before relying on this worksheet for financial management.




REV/DEC 2004
REV/DEC 2004
                                                        Nonprofits Assistance Fund Cashflow Projections
                                   Month:                                                                                                           Year total

Cash on Hand (beginning cash)               0   0   0      0           0          0           0           0     0          0          0         0                0


RECEIPTS from Support
Grants - confirmed                                                                                                                                               0
Grants - anticipated                                                                                                                                             0
Individual contributions                                                                                                                                         0
Special events                                                                                                                                                   0
                                                                                                                                                                 0
Funds released from restricted                                                                                                                                   0
RECEIPTS from Revenue
Fees at time of service                                                                                                                                          0
Accounts receivable collection                                                                                                                                   0
Rent/facility use                                                                                                                                                0
Ticket sales                                                                                                                                                     0
Contract services                                                                                                                                                0
                                                                                                                                                                 0
RECEIPTS from other sources
Loan/Line of credit proceeds                                                                                                                                     0
                                                                                                                                                                 0
TOTAL RECEIPTS                              0   0   0      0           0          0           0           0     0          0          0         0                0

DISBURSEMENTS for Operations
Payroll                                                                                                                                                          0
Payroll taxes                                                                                                                                                    0
Benefits and staff exp                                                                                                                                           0
TOTAL STAFFING                              0   0   0      0           0          0           0           0     0          0          0         0                0
Rent                                                                                                                                                             0
Utilities                                                                                                                                                        0
Maintenance, repair                                                                                                                                              0
TOTAL OCCUPANCY                             0   0   0      0           0          0           0           0     0          0          0         0                0
Office exp (phone, postage, supplies)                                                                                                                            0
Printing and marketing                                                                                                                                           0
Equipment leases                                                                                                                                                 0
Insurance                                                                                                                                                        0
TOTAL OTHER OPERATING                       0   0   0      0           0          0           0           0     0          0          0         0                0
Legal                                                                                                                                                            0
Accounting & audit                                                                                                                                               0
TOTAL PROFESSIONAL SERVICES                 0   0   0      0           0          0           0           0     0          0          0         0                0
                                                                                                                                                                 0
TOTAL PROGRAM RELATED                       0   0   0      0           0          0           0           0     0          0          0         0                0
TOTAL OPERATING DISBURSEMENTS               0   0   0      0           0          0           0           0     0          0          0         0                0
DISBURSEMENTS for Financing
Mortgage payments                                                                                                                                                0
Loan payments                                                                                                                                                    0
Payments on past due obligations                                                                                                                                 0
DISBURSEMENTS for Capital Expenses
                                                                                                                                                                 0
TOTAL DISBURSEMENTS                         0   0   0      0           0          0           0           0     0          0          0         0                0

NET CASH FOR THE PERIOD                     0   0   0      0           0          0           0           0     0          0          0         0                0

ENDING CASH                                 0   0   0      0           0          0           0           0     0          0          0         0                0




331a65a8-5690-4e10-b008-da6fcdb48442.xls                       Download available at: www. nonprofitsassistancefund.org in the Financial Management Resources section

				
DOCUMENT INFO
Description: Excel Template with Financial Contributions document sample