Nonprofit 5 Year Budget and Financial Model: Dashboard, 3 Statements, Program Costs, Staffing

Description
A fully linked five year budget and financial model for a nonprofit organisation. Built for the three moments that matter: the founding board deciding what the organisation can afford, the funder application that asks for a multi year budget, and the annual planning cycle. It answers how much reserve the organisation needs, when the next hire is affordable, and what losing a major grant does to cash. Income is built from four sources, each with its own volume, monthly growth, ceiling and direct program cost percentage: individual donors times average gift, grants times average award, program participants times fee, and events times average net. Program delivery cost is modelled as a direct cost against the income that funds it, so the true cost of running a program is visible rather than buried in overheads. Fifteen linked worksheets: Start Here, Dashboard, Inputs, Revenue, program delivery costs, Payroll, Opex, CapEx, a statement of activities, Cash Flow, Balance Sheet, Break even, Scenarios, Funding and Checks. Monthly across 60 months with annual summaries. A staffing roster with start and end months, burden and wage inflation. Opening reserves, an optional loan, the reserve requirement and the cash low point. A lost grant stress test on a single scenario switch. Benchmarks beside your own numbers: personnel as a share of revenue, overheads, operating surplus. A Checks tab proves the balance sheet balances every month. Tax defaults to zero. Restricted versus unrestricted tracking lives in the companion grant tracker. Excel 2016 or later and Google Sheets, no macros. Includes a one page quick start guide with a Google Sheets copy link.