Financial modelling: Financial foundations
Apply Financial modelling through value, risk, markets.
Intermediate / Structured learning draft / Version 0.9
Structured learning draftFinancial Modelling with Excel & Python
Build a clearer, auditable financial workflow. You will finish with a fictional financial model with assumptions and checks.
This open learning manuscript is undergoing course-specific editorial review. It does not provide certification. Progress and notes are stored only in this browser.
Finance & fintechTool stack
Pythonpandas
12guided lessons
4focused modules
1reviewable project
PDFoffline workbook
The problem
What this course helps you do
Financial Modelling with Excel & Python is a structured, practical course covering Financial modelling, Excel, DCF, Valuation, Python. It emphasizes explainable methods, checked work and a final outcome that can be reviewed.
Who it is for
Learners studying financial technology and analytical methods.
Prerequisites
- Basic percentages and spreadsheet skills
Portfolio-ready project
Produce a reviewable Financial Modelling with Excel & Python project using Financial modelling, Excel, DCF.
Deliverable: A working Financial Modelling with Excel & Python artefact plus an evidence-based self-review.
Practice fileCash-flow practice fileFictional receipts and expenses with dates and KES amounts.Planning template · MarkdownProject briefDefine the user, outcome, boundaries, evidence and acceptance criteria before building.Printable workbook · PDFComplete course workbookA4-ready lesson prompts, project worksheets, evidence logs and references.
Downloads open without an account. Practice data is fictional; review each file before using it in another system.
Definition of done
- The output matches the stated outcome.
- Inputs and decisions are reproducible.
- Boundary and failure evidence is included.
- Limitations and responsibility considerations are explicit.
Course plan
From first concept to finished work
Excel: Tools and data
Apply Excel through records, analysis, controls.
DCF: Applied decisions
Apply DCF through scenarios, evaluation, reporting.
Valuation: Risk and governance
Apply Valuation through security, regulation, review.
Source-led learning
Authoritative references
Course claims are grounded in primary documentation and recognized public guidance. Recheck version-sensitive information before professional use.
- National Payments SystemCentral Bank of Kenya
- Financial educationOECD