· Interactive course
Model architecture and construction
Build and test a decision model with linked schedules, scenarios and clear checks. Nine lessons and 27 exercises; six are free. Design and handoff require review.
- 27 exercises
- 38 graded cells
- 237 minutes of practice
- 2 free lessons
What you’ll learn to do
- Decision, layers and timeline
- Scenarios, links and checks
- Review, robustness and handoff
Course syllabus
Decision, layers and timeline
Define the decision before the workbookFree
specify a decision, output, boundary and time basis another analyst can challenge.
Separate evidence, assumptions, calculations and outputsFree
trace an output to its drivers without overwriting source evidence.
Build a timeline that can changeFull access
construct consistent monthly schedules and extend the reporting horizon without changing commercial logic.
Scenarios, links and checks
Switch assumptions without hiding hardcodesFull access
run coherent scenarios and controlled sensitivities through the same model.
Link schedules and document circularityFull access
build one-way dependencies and explain the chosen interest and financing method.
Design checks before finishing the modelFull access
distinguish an incomplete build, a failed numerical control and a design issue requiring review.
Review, robustness and handoff
Review the model as the next analystFull access
deliver a readable workbook with a reproducible change log and concise handoff.
Test changes and repairs systematicallyFull access
reproduce a small test matrix and explain what each test detects.
Case: construct, explain and hand off the Cedar modelFull access
build a decision model, change it safely and explain its limitations.
Guides for this course
Review a concept before your next exercise.
Keep practicing
Check your skills with the free financial modeling test, or explore a related course.
Included in full access
This course and every other on FinX, plus every course added later.
$99.99 USD · paid once
One-time payment. No recurring subscription. 30-day money-back guarantee. Review the final total at checkout.
Secure checkout by Paddle. Tax is added where it applies; you see the total before you pay.
Read the refund policyBefore you start
Be comfortable working with formulas and reading financial statements. Review a foundation course if you need a refresher.
Use a laptop or desktop browser for the workbook. No Excel installation is needed.