4/23/2020 1
Getting to the Core: Managing Your Organization’s Finances in Uncertain Times April 23, 2020
Wade Rogers Greg Walker Wilson
Welcome
- Type your questions in the Chat Box at any
Welcome Wade Rogers Greg Walker Wilson Type your questions in the - - PDF document
4/23/2020 Getting to the Core: Managing Your Organizations Finances in Uncertain Times April 23, 2020 Wade Rogers Greg Walker Wilson Welcome Wade Rogers Greg Walker Wilson Type your questions in the Chat Box at any time 1 4/23/2020
April May June Beginning Unrestricted Cash Balance 79,500 $ 67,850 $ 48,950 $ Cash Inflows: Grants 10,500 15,000 17,500 Contributions 2,500 1,500 1,000 Program Fees 750 1,250 350 Accounts Receivable at 3/31 5,000 2,500 1,200 Release of Donor Restrictions 1,400 1,400 1,400 Cash Outflows: Payroll and Payroll Taxes (10,000) (15,000) (10,000) Employee Benefits (2,000) (2,000) (2,000) Other Operating Expense (16,500) (16,500) (16,500) Equipment Leases (850) (850) (850) Loan Payments (1,200) (1,200) (1,200) Capital Expenditures (computers, etc.)
(1,250)
67,850 $ 48,950 $ 39,850 $ Cash Flow Projection
April May June Beginning Unrestricted Cash Balance 79,500 $ 67,850 $ 48,950 $ Cash Inflows: Grants 10,500 15,000 17,500 Contributions 2,500 1,500 1,000 Program Fees 750 1,250 350 Accounts Receivable at 3/31 5,000 2,500 1,200 Release of Donor Restrictions 1,400 1,400 1,400 Cash Outflows: Payroll and Payroll Taxes (10,000) (15,000) (10,000) Employee Benefits (2,000) (2,000) (2,000) Other Operating Expense (16,500) (16,500) (16,500) Equipment Leases (850) (850) (850) Loan Payments (1,200) (1,200) (1,200) Capital Expenditures (computers, etc.)
(1,250)
67,850 $ 48,950 $ 39,850 $ Cash Flow Projection April May June Beginning Unrestricted Cash Balance 79,500 $ 67,850 $ 48,950 $ Cash Inflows: Grants 10,500 15,000 17,500 Contributions 2,500 1,500 1,000 Program Fees 750 1,250 350 Accounts Receivable at 3/31 5,000 2,500 1,200 Release of Donor Restrictions 1,400 1,400 1,400 Cash Outflows: Payroll and Payroll Taxes (10,000) (15,000) (10,000) Employee Benefits (2,000) (2,000) (2,000) Other Operating Expense (16,500) (16,500) (16,500) Equipment Leases (850) (850) (850) Loan Payments (1,200) (1,200) (1,200) Capital Expenditures (computers, etc.)
(1,250)
67,850 $ 48,950 $ 39,850 $ Cash Flow Projection
April May June Beginning Unrestricted Cash Balance 79,500 $ 67,850 $ 48,950 $ Cash Inflows: Grants 10,500 15,000 17,500 Contributions 2,500 1,500 1,000 Program Fees 750 1,250 350 Accounts Receivable at 3/31 5,000 2,500 1,200 Release of Donor Restrictions 1,400 1,400 1,400 Cash Outflows: Payroll and Payroll Taxes (10,000) (15,000) (10,000) Employee Benefits (2,000) (2,000) (2,000) Other Operating Expense (16,500) (16,500) (16,500) Equipment Leases (850) (850) (850) Loan Payments (1,200) (1,200) (1,200) Capital Expenditures (computers, etc.)
(1,250)
67,850 $ 48,950 $ 39,850 $ Cash Flow Projection April May June Beginning Unrestricted Cash Balance 79,500 $ 67,850 $ 48,950 $ Cash Inflows: Grants 10,500 15,000 17,500 Contributions 2,500 1,500 1,000 Program Fees 750 1,250 350 Accounts Receivable at 3/31 5,000 2,500 1,200 Release of Donor Restrictions 1,400 1,400 1,400 Cash Outflows: Payroll and Payroll Taxes (10,000) (15,000) (10,000) Employee Benefits (2,000) (2,000) (2,000) Other Operating Expense (16,500) (16,500) (16,500) Equipment Leases (850) (850) (850) Loan Payments (1,200) (1,200) (1,200) Capital Expenditures (computers, etc.)
(1,250)
67,850 $ 48,950 $ 39,850 $ Cash Flow Projection
https://www.propelnonprofits.org/resources/cash-flow-template/
https://www.wallacefoundation.org/knowledge-center/resources-for- financial-management/pages/revenue-analysis-worksheet.aspx
Unrestricted Funding Required Restricted Funding Already Secured Allocated True Expenses