NRSA Philippines — Financial Tools
01 · Financial Planning
3-Year Budget Model
Comprehensive income, expenditure, and surplus/deficit projection for NRSA Philippines — Years 1 through 3. Adjust assumptions to model your scenario.
✓ Zero formula errors Interactive — edit inputs ₱ Philippine Peso
Revenue by Stream
Year 1 → Year 3 projection (₱ millions)
Expenditure by Category
Year 1 → Year 3 projection (₱ millions)
Detailed 3-Year Budget
All figures in Philippine Pesos (₱) — click values to edit
Line Item Year 1 (₱) Year 2 (₱) Year 3 (₱) 3-Yr Total
Growth & Assumption Inputs (blue = editable)
% growth Year 1 to Year 2
02 · Planning
Financial Scenario Planner
Model Conservative, Base, and Optimistic funding scenarios. Understand your range of outcomes and the funding gap in each case.
Scenario Income Statement
Realistic assumptions, most likely outcome
3-Year Revenue Comparison
⚡ Key Risk — Conservative Scenario

If the first international grant is delayed by 6+ months, NRSA needs at least ₱3M in founder bridge funding to reach the point of self-sustaining operations. The conservative scenario models this gap explicitly.

🎯 Optimistic Triggers

Optimistic scenario is achieved if: (1) Bloomberg BIGRS grant secured in Year 1, (2) two ₱1M+ Founding Corporate Partners signed, and (3) DepEd MOU signed enabling training revenue in Year 2.

03 · Planning
12-Month Cash Flow Forecast
Monthly opening/closing balance, inflows, and outflows for Year 1. Identify months where cash balance may fall below the minimum operating reserve.
Monthly Cash Flow — Year 1
All values in ₱ · Minimum reserve line shown at ₱500,000
📌 Cash Flow Management Rule

NRSA Philippines must never allow its cash balance to fall below ₱500,000 (minimum operating reserve = 1 month of estimated operational costs). If the forecast shows a month below this threshold, the Executive Director must alert the Finance & Audit Committee at least 60 days in advance.

04 · Revenue
Grant Pipeline
Track all grant applications, expected decisions, and funding probabilities. Weighted pipeline value is the key input to the Base Case scenario.
Active Grant Pipeline
Probability-weighted values drive the Base Case revenue forecast
Funder / ProgramAmount (₱)StageProbabilityWeighted ValueDecision
Pipeline by Stage
Grant Application Calendar
05 · Revenue
Fundraising Tracker
Track all CSR donations, individual gifts, and event revenue against monthly and annual targets. Thermometer gauge updates live.
Annual Fundraising Progress
Year 1 Target ₱8,000,000
0% raised ₱0 raised
Monthly Fundraising Log
DonorCategoryAmountMonth
06 · Governance
Reserve Fund Monitor
Track NRSA Philippines' operating reserve — the financial buffer that ensures the organization can continue operating if revenue is delayed. Target: 3 months of operating costs.
Reserve Health Gauge
0
months of operating costs covered
Reserve Build-Up Plan
Reserve Fund Policy

NRSA Philippines' Board-approved policy requires maintaining a reserve fund equal to a minimum of 3 months of budgeted operating costs. The reserve must be held in a separate, interest-bearing bank account and may only be drawn down with Board approval.

07 · Governance
Financial Compliance Calendar
Every regulatory filing, tax obligation, and governance deadline NRSA Philippines must meet annually. Click to mark as complete.
Compliance Checklist
Annual Filing Calendar
⚠️ Late Filing Consequences

Late SEC filings incur a ₱1,000/day penalty. Late BIR returns face 25% surcharge + 12% annual interest. Missing PCNC renewal risks losing accreditation — which would invalidate Official Receipts issued to donors.