Grants management · Fiscal analysis

Reliable stewardship.
Clearer financial decisions.

I’m a grants management professional building a practical financial analysis portfolio. I use structured fiscal data, transparent assumptions and clear variance notes to turn budgets into useful decisions.

Separate portfolio · All case data and organization names below are fictional.

Where experience meets analysis
Grant stewardshipBudget monitoringFinancial modellingFiscal forecasting
Featured case study · 01

Read the budget.
Ask the right questions.

A fictional community health programme provides a safe way to demonstrate budget-to-actual review, variance interpretation and a forward-looking planning scenario.

Fiscal performance · FY2023/24–FY2025/26

Illustrative Community Health Programme

Three-year budget execution review · TZS millions

Fictional organization · Synthetic dataset
Approved budget and expenditureTZS millions
Synthetic budget and expenditure over three fiscal yearsBudget and expenditure in TZS millions: FY2023/24, 1,200 and 1,160; FY2024/25, 1,350 and 1,380; FY2025/26, 1,500 and 1,470. These values are fictional. 1,5001,0005000 FY23/24 FY24/25 FY25/26
BudgetExpenditure
4,0503-year budget
4,0103-year spend
99.0%Overall execution
FY2025/26 category reviewTZS millions
CategoryBudgetActualVariance
Personnel600620+20
Medical supplies500465−35
Community outreach260240−20
Administration & logistics140145+5
Total1,5001,470−30

Decision note. Expenditure closed TZS 30m below the synthetic allocation. The category view flags a TZS 20m personnel overspend and TZS 35m supplies underspend for follow-up. Timing, commitments, eligibility and delivery evidence should be checked before assigning causes.

Every organization name and amount is fabricated for demonstration. This is not a report of a real employer, donor, grantee or public budget.Download the synthetic dataset ↓
Planning view · FY2026/27–FY2027/28

Forecast as a range,
not a promise.

A simple scenario extends the synthetic FY2025/26 baseline by an assumed 8.2% annual planning uplift, with the sensitivity range shown beside the central case.

FY2026/27 · central caseTZS 1,590mFrom 1,470m · +8.2% assumption
FY2026/27 · sensitivity1,510–1,670mAbout ±5% around central case
FY2027/28 · central caseTZS 1,720mSecond year at ~8.2% uplift

Forecasts are synthetic planning scenarios, not estimates of Tanzania’s government budget or a real organization. The uplift is an explicit modeling assumption; no external fiscal data is represented.

Selected modelling exercises · 02–04

Useful models.
Visible assumptions.

The examples below are self-directed learning and portfolio exercises. They show the questions, methods and controls I am developing.

02 / CAPITAL ALLOCATION

Capital budgeting & sensitivity

Frame a fictional investment decision with cash-flow timing, NPV, IRR and payback. Test how the recommendation changes when cost, timing or operating benefits move.

NPV / IRRScenario analysisDecision note
03 / ASSET PLANNING

PP&E and depreciation forecast

Connect capital additions, useful lives, depreciation and closing net book value in a clear roll-forward, with assumptions kept separate from formulas.

Asset roll-forwardD&A scheduleForecast controls
04 / CASH & DEBT

Loan amortization & cash flow

Show how payment frequency, rates and term shape principal repayment, interest expense and remaining balance over a loan’s life.

AmortizationCash planningModel checks
Data protection: these cases use made-up entities and values. They do not reproduce the contents of private workbooks or disclose any client, partner, employer or donor information.
How I work

From source to decision.

01 · Define

Clarify the decision, period, unit and source before analysis.

02 · Structure

Separate inputs, calculations and outputs; check totals and links.

03 · Interpret

Explain material variances without claiming causes the data cannot prove.

04 · Communicate

Show assumptions, scenarios, limitations and next questions plainly.

About John

Practical grants work.
Growing analytical range.

I bring practical experience in grants management, including partner accountability, budget monitoring, donor compliance, field verification and programme close-out. Those responsibilities shape how I approach financial analysis: keep the trail clear, check what the numbers can support and make follow-up useful to programme teams.

My financial analysis portfolio demonstrates developing skills through structured models and synthetic case studies. It is presented alongside my existing profile as a separate body of work.

Grants managementPractical experience
Financial analysisDeveloping through applied models
Fiscal analysisBudget execution · variance · scenarios
ToolsExcel · financial modelling

For my existing professional profile, visit the current profile ↗.

Let’s connect

Clear analysis starts with a good question.

For finance, grants management or programme analysis opportunities.

Email John