Job Overview
We are seeking an experienced financial modeler to build a 10-year Excel model for a youth development fund that provides blended finance support (grant + loan).
The fund currently faces repayment performance and sustainability challenges. We are remodelling the structure and require a robust, transparent Excel model that compares three strategic options:
1. Government-led model (internal governance and operations improvement)
2. Public–Private Partnership (PPP) (outsourced fund administration and collections via SLA)
3. Hybrid model (segmented instruments by stage; differentiated grant/loan mix)
This is not a basic spreadsheet task. We require a structured, audit-ready financial model with portfolio cohort logic, default and recovery mechanics, and scenario testing.
Scope of Work
You will build one Excel workbook that includes scenario toggles for the three structural options.
Required Model Tabs
· README / User Guide
· Inputs (all assumptions centralised)
· Assumptions Register (source, rationale, range, owner)
· Portfolio Engine (cohort-based disbursements, repayments, defaults, recoveries)
· Operating Cost Model (fixed + variable + collections intensity by option)
· Funding & Recycling (grant inflows, loan capital, reserves)
· 10-Year Outputs (annual cashflows, fund balance, sustainability metrics)
· Stress Tests (downside and sensitivity toggles)
· Dashboards (option comparison – side-by-side)
· Checks & Error Flags (model integrity controls)
Key Technical Requirements
The model must include:
· Cohort-based loan portfolio modelling
· Parameterised default assumptions
· Recovery rate with timing curve
· Ability to change:
o Grant/loan mix
o Tenor and grace period
o Collections effectiveness
o Operating cost intensity
· Separate grant vs loan flows
· Recycling/revolving fund logic
· Scenario selector (dropdown toggle for 3 options)
· Stress testing functionality
Required Outputs
The model must clearly show:
· Annual fund cash position (10 years)
· Revolving/re-lending capacity
· Required subsidy/grant top-up
· Sustainability trajectory
· Side-by-side option comparison dashboard
Quality Standards (Non-Negotiable)
· No hardcoding in calculation sheets
· All assumptions in Inputs tab
· Clear input vs formula formatting
· No circular references
· Structured, audit-ready design
· Checks tab with pass/fail indicators
· Clean, professional formatting
No VBA required unless agreed.
Data Context
Portfolio and operating data is limited.
The model must therefore:
· Be driven by structured assumptions
· Allow easy updates when real data becomes available
· Include ranges and stress-testing logic
We are not looking for perfect forecasting — we are building a decision-support tool.
Deliverables
· Excel workbook (v1 + final)
· 2–3 minute Loom walkthrough video
· Short user guide (README tab or 1-page document)
Timeline
· Kick-off: Within 24 hours of award
· Prototype (structure + toggles): 2 days
· Model v1: 4 days
· Final version (post QA): Next Friday (hard deadline)
Please only apply if you can meet this timeline.
Contract duration of less than 1 month. with 30 hours per week.
Mandatory skills: Microsoft Excel, Financial Modeling, Financial Analysis, Forecasting