Read the Cover
Confirm purpose, scope, version, compatibility, evidence class, limitations, and model status.
TDAT Financial Model Library
A 24-model, multi-discipline library for the finance models people rebuild again and again—planning, statements, valuation, transactions, cash, debt, risk, projects, and personal decisions. Every download is released only after its inputs, logic, checks, documentation, privacy, and appearance meet one shared standard.
downloadable Excel models
career families · 41 roles
finance decision domains
published checks across the library
The same way into every workbook
Confirm purpose, scope, version, compatibility, evidence class, limitations, and model status.
Replace approved hardcodes and drivers without burying assumptions inside calculation formulas.
Use outputs to answer a finance question—not simply to generate another spreadsheet.
Resolve every core FAIL, review warnings, and document material changes before relying on the output.
Model catalogue
Reset the filters or request the decision model you were looking for.
Career family map
Swipe horizontally to compare role titles, models, and decisions.
| Career family | Included role titles | Start here | Add next | Typical decision |
|---|---|---|---|---|
| Corporate Finance & FP&A | CFO Office · Corporate Finance · Financial Reporting · Finance Business Partner · FP&A · Fractional CFO · Regional Finance | 3-Statement · Budget & Rolling Forecast | Variance Bridge · Capex · Consolidation | What changed, how does the outlook move, and what should management do next? |
| Commercial & Operational Finance | Commercial Finance · HR Finance · Operations Finance · Pricing Finance · Sales Finance | Pricing & Margin Waterfall · Variance Bridge | Headcount · Working Capital · Capex | Which price, mix, customer, capacity, or cost action protects contribution? |
| Accounting & Controllership | Accounting · Controllership | 3-Statement · Multi-Entity Consolidation | Working Capital · Debt · ECL | Do the statements, entities, movements, and controls reconcile reliably? |
| Investment, Valuation & Transactions | Corporate Development · Equity Research · Investment Analyst · Investment Banking · Leveraged Finance · M&A Advisory · Private Equity · Valuation Advisory · Venture Capital | DCF · Trading Comps · 3-Statement | Accretion / Dilution · LBO · Capex | What is the asset worth, does the deal create value, and which assumptions drive returns? |
| Treasury, Funding & Real Assets | Infrastructure Finance · Project Finance · Structured Finance · Treasury | 13-Week Cash · Debt & Covenant · Project Finance | FX Exposure · Debt Sculpting · Working Capital | When does cash tighten, is funding resilient, and is the project bankable? |
| Banking, Credit & Risk | Banking Finance · Commercial Banking · Credit Analysis · Credit Risk · Enterprise Risk · Lending · Market Risk · Portfolio Risk · Risk Analytics | Credit Underwriting / DSCR · ECL | Market Stress · Debt & Covenant · Project Finance | What loss, concentration, leverage, or downside can the borrower or portfolio absorb? |
| SME, Startup & Personal Finance | Financial Education / Learner · Founder · Individual / Household · SME Finance · Startup Finance | SME Forecast · SaaS Unit Economics · Personal Budget | 13-Week Cash · Retirement Planner | How should runway, growth, debt, savings, and long-term goals be balanced? |
TDAT Model Standard 1.0
Purpose, model ID, owner, version, as-of date, currency, units, scenario, evidence, and limitations.
Inputs, calculations, outputs, checks, sources, and change history remain visible and logically separated.
No hidden hardcodes, broken references, undisclosed circulars, opaque formulas, or volatile shortcuts in the core.
Statements, bridges, cash, debt, retained earnings, valuation, or risk relationships reconcile where applicable.
Central controls, consistent time axes, modular schedules, scenario logic, and copy-across formulas support adaptation.
Quick start, workbook map, assumptions, sources, checks, compatibility, usage note, and issue-report details travel with the file.
No real company records, personal data, local paths, hidden connections, macros, or external links in public core templates.
Available means the workbook exists, required checks pass, screenshots come from the file, and limitations are visible.
Workbook appearance system
Brand navy, cobalt, teal, and amber structure the workbook. Finance-semantic font colors stay separate so users can audit what is editable, calculated, linked, or exceptional.
Not every model needs every tab, but each required function has one obvious home.
Questions & answers
It is a growing collection of reusable Excel models for planning, reporting, valuation, cash, transactions, risk, projects, and personal decisions. Each model is designed to be understandable, adaptable, and reviewable—not a black box.
The library is built for finance analysts, FP&A teams, transaction professionals, treasury and risk users, founders, SME owners, and learners who want a governed starting point. Every card names the intended roles and decision.
Starter models require basic Excel and finance knowledge. Practitioner models assume familiarity with statements, operating drivers, and review workflows. Advanced models may include integrated financing, transaction, risk, or project-finance mechanics and should receive specialist review.
An available release includes a macro-free .xlsx file, synthetic worked data, in-workbook guidance, assumptions, visible checks, version information, limitations, compatibility notes, and a public model page. Roadmap cards do not pretend those assets exist.
Edit blue-font hardcodes and clearly labeled control cells. Pale amber indicates a scenario or switch. Black formulas calculate within a sheet, green formulas reference another sheet, and red is reserved for a failure or an external link. Review the Checks sheet after every material change.
Use the control and assumptions areas where supported. Currency and unit labels can be changed without rewriting the core logic. Extending the timeline requires copying the final forecast formula pattern, preserving references and formats, then confirming all checks again.
Yes when the model structure supports modular expansion. Add detail in source, driver, or schedule blocks—not by inserting hardcodes into statement outputs. Reconcile the new dimension back to the original totals and keep the public checks visible.
No. Public downloads use synthetic or clearly illustrative values unless a model page explicitly states that evidence is sanitized and approved for public use. Never interpret example outputs as measured company performance.
You may use an authorized downloaded copy. Keep the company version inside the company’s approved environment, remove identifiers before sharing externally, and inspect comments, hidden sheets, formulas, links, connections, paths, and document properties before distribution.
Core public templates are designed without macros, external workbook links, add-in dependencies, or unexplained circular references. Any future exception must be disclosed on the card, model page, Cover sheet, and Checks sheet.
The supported Excel version is shown on each model page. Basic formulas may transfer, but formatting, data validation, comments, charts, named ranges, or financial functions can behave differently. Unless explicitly tested, Google Sheets and LibreOffice are marked not verified.
Start with the Checks sheet. Common causes are sign errors, incomplete opening balances, a working-capital line mapped twice, missing debt movements, incorrect cash-flow signs, retained-earnings logic, or a new row that was added to one statement but not its supporting schedule.
PASS means the stated control is within its published tolerance. WARN requires review but may not break the model. FAIL means a core relationship is outside tolerance and the output should not be relied upon. PASS is not a guarantee that assumptions or accounting treatment fit every business.
Each model has a stable ID, route, and canonical filename. Semantic versions live inside the workbook, registry, and changelog: a major version breaks structure or inputs, a minor version adds compatible capability, and a patch fixes formulas, wording, formatting, or QA without changing the core contract.
You may copy and adapt the current public template for learning, interview cases, personal analysis, or internal business planning. Do not resell or redistribute an unchanged copy as your own product. You remain responsible for sources, assumptions, professional review, and suitability.
No. They are educational and analytical templates. They do not replace company policy, accounting standards, licensed investment advice, regulated risk methodology, legal advice, tax advice, lender requirements, or an appropriate subject-matter review.
Use the contact action below. For an issue, include the model ID, version, affected sheet or cell, and a public-safe description. Do not email confidential data, company workbooks, credentials, or identifiable records.
Shape the next release
Describe the decision, role, frequency, inputs, expected outputs, and the checks that would make the template trustworthy.