Non Profit Financial Model

The Ultimate in Modern Non Profit Financial Planning & Analysis

For any non-profit organization

  • Assumptions (General, revenue stream, form, financial, inventory, tax, franchise, dividend, and more)
  • Investment budget (start-up costs, unlimited number of new/existing assets, depreciation schedule using SLN, DB, DDB or SYD)
  • Funding (shareholders' capital, unlimited number of new/existing loans, deferred loans, flexible loans, amortization - 5 years)
  • Beginning balance sheet (with and without historic data)
  • Personnel wizard - add persons, groups or departments (max. 10), monthly and quarterly (3 years), annual (5 years)
  • Personnel assumptions - payroll burden, hourly/overtime rates, bonuses payment schedule
  • Personnel plan monthly & quarterly (3 years) - with headcount, payroll, overtime, bonuses and payroll burden summary
  • Personnel plan annual (5 years)

  • Grant & Pledges - monthly 3 years, annual 5 years
  • Memberships - monthly 3 years, annual 5 years
  • Donations - (cash and in-kind), monthly 3 years, annual 5 years
  • Fundraising and Events
  • Other exempt business income - monthly 3 years, annual 5 years
  • Product details & Cost of Goods with minimum stock level entry (3 years) - Add/Edit/Remove product lines and products using the
    products wizard to add up to 3 (6 in the AE version) product lines (or market areas) and unlimited products per product line.
  • Sales projections monthly & quarterly (3 years) - enter sales by units or amounts, or in bulk per product line, rebates & allowances
  • Sales projections annual (5 years)
  • Revenue summary monthly and quarterly 3 years
  • Revenue summary annual 5 years
     
  • Programs - funds allocation, program expenses, personnel and M&G expenses (monthly 3 years, annual 5 years)
  • Statement of activities monthly & quarterly (3 years) - with automated discounts & returns, bad debts and losses & thefts.
  • Statement of activities (Income statement or Profit & Loss) annual (5 years) - with EBITDA and earnings per share details for companies
  • Tax account - sales tax, income tax (5 years)
  • Inventory account (5 years)
  • Cash flow projection monthly & quarterly (3 years) - direct method used
  • Cash flow projection annual (5 years)
  • Statement of financial position projection monthly (3 years)
  • Statement of financial position projection annual (5 years) - with no. of shares issued and net asset value per share details
  • Notes to the financial statements - with automated data from the projections
  • Timeline with a task wizard (3 years) - entries are as easy as 1-2-3, with project cost, start date and end date
NON PROFIT ORGANIZATION ANALYSIS
  • Historic ratios (3 years)
  • Projected ratios (5 years) - for business valuation
  • Industry standards comparison (5 years)
  • Loan capacity ratios (5 years)
  • Financial summary with CAGR (5 years)
  • Annual dynamic sensitivity analysis (best/worst case scenarios) (5 years)
  • Annual dynamic What-If analysis (5 years)
  • Comparison analysis - personnel, sales, advertising, income, cash flow, balance sheet (5 years)
  • Line of Credit (Overdraft) scenario
THE ADVANCED EDITION - AE - ALSO INCLUDES:
  • Development planning (up to 4 phases), 5 years prior and 5 years of planning with automated development timeline
  • Revenue on investments (Exempt)
  • Revenue on investments (Unrelated)
  • Advertising & promotion plan detailed (3 years), annual (5 years)
  • Annual summary matrix (balanced scorecard) - beginning balance, income statement, cash flow, ending balance (5 years)
  • Annual summarized projections (income statement, cash flow, balance sheet, ratios) up to 10 years
  • Annual ROA / ROE / SGR dynamic analysis tree (5 years)
  • Projected ratios including IRR/NPV, SGR, Z-score
  • Detailed break-even analysis per product line with break-even charts per product line
  • Revenue analysis per product line (5 years)
  • Executive dashboard
  • Exchange rate multiplier to easily convert values into another currency
ADDITIONAL TOOLS
  • Membership & donors list workbook
  • Equipment, office, lunch room, machinery list worksheets
  • Personal financial statement worksheet
  • Partnership accounts worksheet