FINANCIAL MODELING / SCENARIO ANALYSIS
Personal finance scenario model.
BASE CASE
—
SENSITIVITY
—
STRESS TEST
A scenario-modeling system comparing long-term financial outcomes under shifting assumptions, built to stress-test major decisions before committing to them.
CONTROL ROOM
Personal Finance Scenario Control Room
SYSTEM 05
∞
Scenarios
Variable
Status
Readout
Financing Terms
Base
Affordability
Debt Structure
Stress
Cash needs
Sensitivity
Live
Decision view
PERSONAL FINANCE SCENARIO SCHEMA
A clear model for comparing long-term financing outcomes.
01
Assumption Set
Financing terms and cash needs
02
Scenario Engine
Base, optimistic, conservative, stress
03
Sensitivity View
Variable impact across outcomes
CHALLENGE
Evaluating a major personal financial decision required comparing dozens of interconnected variables across multiple scenarios while understanding their long-term implications.
SOLUTION
Built a dynamic scenario analysis model capable of testing financing assumptions, debt structures, cash requirements, and affordability across major life decisions to support informed decision-making.
MY ROLE
Designed financial model architecture, built the scenario engine, created sensitivity analysis, developed executive outputs, and structured decision-support dashboards.
TOOLS
Excel
Financial Modeling
Sensitivity Analysis
Scenario Planning
Decision Support
IMPACT
Modeled 4 distinct financing scenarios across a major life decision, surfacing a swing of over $80K in long-term outcome depending on financing structure chosen.
SCENARIO COMPARISON
Base Case
Standard financing terms
Stable
Low
Optimistic
Faster income growth
Strong
Low
Conservative
Flat income, higher rates
Tight
Medium
Stress Test
Income disruption
Deficit
High