Description
Prepare a 12-month cash flow budget based on the data given in Figure 6.15 (page 122), Grant Funding Conditions. Assume that the fiscal year is from July 1 to June 30 and that each grant will begin in the fiscal year, but not all begin at the start of the FY.
Use the data in the attached file to calculate the cash outflows. Please note that expenses for programs that begin months into the FY do not begin until that point either. MBA6224_Cashflow Problem Expense Data for Students Week 4.xlsx 
download
I have provided a suggested template for the "bottom line" cash calculation.
Note: You have $50,000 cash on hand plus access to a $50,000 bank Line of Credit (LOC)
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions.I have included the revenue and expenditure sheet in the Cash flow excel to avoid linking the data into external sources. Please review the documents. :) Thank you!
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:
July
August
September
October
November
December
January
February
March
April
May
June
Cash on Hand (beginning cash)
50.000
2.759
(57.800)
(115.214)
(136.288)
(163.399)
(188.066)
(159.922)
(158.239)
(108.499)
(95.506)
(109.354)
RECEIPTS from Support
Grants - confirmed
Grants - anticipated
Individual contributions
Special events
83.703
0
0
0
76.703
0
0
0
76.703
0
0
0
93.702
0
0
0
86.702
0
0
0
86.702
0
0
0
115.663
0
0
0
108.663
0
0
0
166.719
0
0
0
118.184
0
0
0
111.184
0
0
0
114.934
0
0
0
8.367
8.367
8.367
8.367
8.367
8.367
8.367
8.367
8.367
8.367
8.367
8.367
TOTAL RECEIPTS
92.070
85.070
85.070
102.069
95.069
95.069
124.029
117.029
175.086
126.551
119.551
123.301
DISBURSEMENTS for Operations
Payroll
Employee Benefits (Payroll Taxes, Insurance, Retirement)
25.417
7.955
25.417
7.955
25.417
7.955
29.463
7.955
29.463
7.955
29.463
7.955
29.463
7.955
29.463
7.955
29.463
7.955
29.463
7.955
29.463
7.955
29.463
7.955
33.372
4.000
3.840
33.372
4.000
3.520
33.372
4.000
2.560
37.418
4.000
2.240
37.418
4.000
2.560
37.418
4.000
3.200
37.418
4.000
3.840
37.418
4.000
3.520
37.418
4.000
2.560
37.418
4.000
1.600
37.418
4.000
1.280
37.418
4.000
1.280
7.840
98.099
0
5.280
77.301
4.400
9.000
79.485
78.203
50.627
70.409
6.560
63.518
6.600
0
11.250
81.368
5.600
70.539
0
7.520
57.009
4.400
9.000
104.737
7.200
57.269
6.600
0
11.250
75.119
7.840
50.627
0
6.560
64.803
4.400
9.000
98.099
6.560
84.702
6.600
0
11.250
102.552
6.240
79.485
0
7.520
91.337
4.400
9.000
70.539
90.701
5.280
84.449
6.600
0
11.250
102.299
0
0
0
0
0
0
0
0
0
0
0
0
0
139.311
0
145.629
0
142.484
0
123.142
0
122.180
0
119.736
0
95.885
0
115.347
0
125.346
0
113.557
0
133.399
0
144.997
Funds released from restricted
RECEIPTS from Revenue
Fees at time of service
Accounts receivable collection
Rent/facility use
Ticket sales
Contract services
RECEIPTS from other sources
Loan/Line of credit proceeds
TOTAL STAFFING
Rent
Utilities
Maintenance, repair
TOTAL OCCUPANCY
Office exp (phone, postage, supplies)
Printing and marketing
Equipment leases
Insurance
TOTAL OTHER OPERATING
Legal
Accounting & audit
TOTAL PROFESSIONAL SERVICES
TOTAL PROGRAM RELATED
TOTAL OPERATING DISBURSEMENTS
DISBURSEMENTS for Financing
Mortgage payments
Loan payments
Payments on past due obligations
DISBURSEMENTS for Capital Expenses
20210808060156cash_flow_budget
Download available at: www. nonprofitsassistancefund.org in the Financial Management Resources section
Nonprofits Assistance Fund Cashflow Projections
TOTAL DISBURSEMENTS
139.311
145.629
142.484
123.142
122.180
119.736
95.885
115.347
125.346
113.557
133.399
144.997
NET CASH FOR THE PERIOD
(47.241)
(60.559)
(57.414)
(21.073)
(27.111)
(24.667)
28.144
1.682
49.740
12.994
(13.848)
(21.696)
2.759
(57.800)
(115.214)
(136.288)
(163.399)
(188.066)
(159.922)
(108.499)
(95.506)
(109.354)
(131.050)
ENDING CASH
20210808060156cash_flow_budget
(158.239)
Download available at: www. nonprofitsassistancefund.org in the Financial Management Resources section
Nonprofits Assistance Fund Cashflow Projections
Year total
50.000
1.239.563
0
0
0
0
0
100.400
0
0
0
0
0
0
0
1.339.963
341.416
95.460
0
436.876
48.000
32.000
0
80.000
879.137
44.000
36.000
45.000
1.004.137
0
0
0
0
0
1.521.013
0
0
0
0
20210808060156cash_flow_budget
Download available at: www. nonprofitsassistancefund.org in the Financial Management Resources section
Nonprofits Assistance Fund Cashflow Projections
1.521.013
(181.050)
(131.050)
20210808060156cash_flow_budget
Download available at: www. nonprofitsassistancefund.org in the Financial Management Resources section
Annual Budget
Salaries and Wages (general)
Salaries and Wages (Homeless Youth
Program)
Jul
Aug
Sep
$
8,33%
12.916,67 $
8,33%
12.916,67 $
8,33%
12.916,67
$
0,00%
$
0,00%
$
0,00%
-
$
0,00%
$
0,00%
$...
