Three-statement models, DCF valuations, and scenario analysis built from primary-source filings. Every historical line ties to the 10-K it came from.
Most public financial models on the internet are detached from their source filings — figures appear without an audit trail, scenarios are toggled without traceability, and the balance sheet is left to drift. This repository publishes models where every historical line reconciles back to the 10-K, 10-Q, or press release it came from, and the workbook refuses to be treated as correct until a validation tab confirms structural integrity (balance-sheet identity, cash-flow ties, inter-statement consistency).
I'm Alven, a CPA finalist (Kenya) awaiting ICPAK membership. This repository is where I publish modelling work as I build out the technical side of accounting and finance.
- 📑 Primary-source sourcing — every workbook ships alongside the filings it was built from
- 🔍 Validation tab reconciles each historical line to its source and runs the balance-sheet identity, cash-flow ties, and inter-statement consistency checks
- 🎚️ Scenario toggles — bear / base / bull, but only on questions where the answer changes materially across them
- 🎨 Colour-coded inputs, locked calculated cells, single source of truth for assumptions
- 📂 No macros, no external feeds, no add-ins — opens in Excel or LibreOffice Calc
| Layer | Tools |
|---|---|
| Spreadsheet | Microsoft Excel (LibreOffice Calc compatible) |
| Modelling | Native formulas only — no VBA, no add-ins |
| Source filings | SEC EDGAR 10-K / 10-Q / press releases |
git clone https://github.com/alvenyuka/Financial-Analyst.git
cd Financial-Analyst
# Open Apple_Financial_Model.xlsx in Excel or LibreOffice Calc- Open the model file in Excel or LibreOffice Calc.
- Review the assumptions tab (colour-coded inputs).
- Toggle scenarios where wired up.
- Confirm the Validation tab is fully green before trusting any output.
- Cross-check any historical line against the source filing in
Source_filings/.
A few conventions run through every analysis in this repository.
A dedicated tab holds assumptions and inputs. Every other tab recalculates from it. Inputs are colour-coded; calculated cells are locked.
Each workbook ships alongside the 10-K, 10-Q, and press releases the figures were taken from. The validation tab reconciles each historical line back to the filing it came from.
The validation tab runs the balance-sheet identity (assets = liabilities + equity), the cash flow ties (net income → retained earnings, depreciation → PPE), and inter-statement consistency checks. The workbook does not treat a model as correct until those checks pass.
Bear, base, and bull scenarios are wired up on questions where the answer changes materially across them. Where it does not, the model stays single-case to keep the audit trail clean.
Files open in Excel or LibreOffice Calc. No macros, no external data feeds, no add-ins.
Financial-Analyst/
├── README.md
├── banner.svg
├── Apple_Financial_Model.xlsx # three-statement model, DCF, scenario toggles
└── Source_filings/ # 10-K, 10-Q, press releases backing the model
| Company | Ticker | Status | Workbook |
|---|---|---|---|
| Apple Inc. | AAPL | ✅ Complete | Apple_Financial_Model.xlsx |
Additional company analyses will follow the same structure.
- Apple Inc. (AAPL) — three-statement model, DCF, validation harness
- Microsoft (MSFT)
- Safaricom (SCOM.NR) — Nairobi Securities Exchange
- Equity Group Holdings (EQTY.NR)
If you'd like a particular company modelled in this style, open an issue.
If you spot an error in any model, open an issue. Reproduction steps and the offending cell reference make a fix possible.
MIT — see LICENSE.
Built by Alven Yuka — CPA Finalist (Kenya), awaiting ICPAK membership.
📫 alvenyuka2@gmail.com · 💼 LinkedIn · 🐙 GitHub · 🛠️ Fiverr: alvenemmanuel