Session 24: Model Auditing & Error-Proofing

Learning Objectives

What You'll Learn Today

Section 1

Why Model Auditing Matters

Real-world model failures and their consequences

💭

Think About It

A junior analyst at a major bank makes a spreadsheet error that overstates revenue by ₹500 Cr. The deal closes. Six months later, the error is discovered. Who is responsible? What could have prevented this?

Think about review processes, error-checking formulas, and the culture of model validation.

💥 Real-World Model Failure Cases

Spreadsheet errors are not hypothetical — they have caused billions in losses:

Year	Organization	What Went Wrong	Impact
2013	JPMorgan Chase	Excel copy-paste error in VaR model — data from one sheet not updated in another	$6.2 Billion trading loss ("London Whale")
2010	Miami-Dade County	Spreadsheet error in budget model overstated surplus by ₹$200M	Emergency budget cuts, public trust damaged
2008	Barclays Capital	Hidden rows in Lehman Brothers deal spreadsheet contained 179 contracts marked "hidden" instead of "included"	$2.3B in unwanted toxic assets acquired
2003	TransAlta (Canada)	Cut-and-paste error in power contract bidding model — wrong tab referenced	$24M loss on mispriced contracts
2016	UK Government	Excel auto-correct changed gene names (e.g., SEPT2 → Sep-2) in COVID data tracking	15,841 cases lost from tracking database

⚠️The 90% Rule

Research by Panko & Halverson (2001) found that 88% of all spreadsheets contain errors, and 50% of those errors are material (affecting decisions). The larger the model, the more likely errors exist. A 100-worksheet model with 10,000 formulas has an estimated 98% probability of containing at least one material error.

📊 The Taxonomy of Modeling Errors

Model errors fall into three broad categories. Understanding the taxonomy helps you build targeted defenses against each type:

Error Type	Description	Example	Detection Method
Mechanical Errors	Pointing to wrong cells, range errors, deleted references	Formula references C12 instead of C13 (off-by-one)	#REF! errors, Trace Precedents
Logic Errors	Correct formulas but wrong business logic	Using gross debt instead of net debt in EV calculation	Peer review, sanity checks
Assumption Errors	Flawed inputs or assumptions driving the model	Assuming 15% perpetual growth when industry average is 3%	Sensitivity analysis, benchmarking
Omission Errors	Forgetting to include a relevant item	Missing deferred tax liability in PPA	Checklist, model mapping
Structural Errors	Poor model architecture causing cascading errors	Circular references without intentional circularity	Circular reference checker

☠️ The 7 Deadly Sins of Financial Modeling

Sin #1: Hardcoding Numbers Inside Formulas

=B5 * 1.10 — What is 1.10? A growth rate? A multiplier? Nobody knows. When it changes, someone must find and fix every formula manually.

✅ Fix: Put all assumptions in a dedicated assumptions sheet. Reference the cell: =B5 * Growth_Rate

Sin #2: No Color Coding Convention

When every cell looks the same, nobody can tell which cells are inputs (editable) vs. formulas (don't touch) vs. links to other sheets.

✅ Fix: Blue font = hard-coded input | Black font = formula | Green font = link to another sheet. Apply consistently.

Sin #3: Multiple Inputs for the Same Assumption

Revenue growth is 12% in one sheet, 15% in another, 10% in a third. Which one drives the model? Nobody knows — and they give different answers.

✅ Fix: ONE source of truth. Every assumption lives in exactly one cell. All references point to that cell.

Sin #4: Broken Links & #REF! Errors

Someone deleted a row or column that other formulas referenced. Now half the model shows #REF! and the cascade is impossible to trace.

✅ Fix: Never delete rows/columns — hide them instead. Use Edit → Find → #REF! to scan regularly. Lock structural cells.

Sin #5: Overly Complex Formulas (The "God Formula")

=IF(AND(A5>0,B5100,I5*J5,K5)) — A 4-line formula that nobody can audit. One typo = total failure.

✅ Fix: Break complex formulas into helper rows/columns. Each cell should do ONE calculation. Use named ranges for readability.

Sin #6: No Balance Sheet Check / Cash Flow Check

The model looks fine but assets ≠ liabilities + equity by ₹47 Cr. Nobody noticed because there's no automatic validation row.

✅ Fix: Add a BS Check row: =Total_Assets - (Total_Liabilities + Total_Equity). It MUST be zero. Make it conditional-formatted RED if not.

Sin #7: No Version Control or Documentation

model_v3_FINAL_v2_REAL_FINAL.xlsx — Sound familiar? Nobody knows what changed between versions or who changed it.

✅ Fix: Use a changelog tab. Name files with dates: Model_2026-04-30_v4.xlsx. Track changes: what, when, why, by whom.

Section 2

Excel Audit Tools & Techniques

The built-in tools that catch 80% of errors

🔧 Essential Excel Auditing Tools

📍 Trace Precedents

Ctrl + [

Shows arrows to all cells that feed into the selected cell. Answer: "Where does this number come from?"

Use: Select any formula → Formulas tab → Trace Precedents. Blue arrows show direct links. Red arrows show errors.

📍 Trace Dependents

Ctrl + ]

Shows arrows to all cells that depend on the selected cell. Answer: "If I change this, what breaks?"

Use: Select any input → Formulas tab → Trace Dependents. See the cascade of impact.

🔍 Go To Special

F5 → Special

Jump to specific cell types: Constants, Formulas, Blanks, Conditional Formats, Data Validation, Differences.

Pro tip: Go To Special → Formulas → uncheck Numbers/Text/Booleans → keep Errors to find ALL error cells instantly.

👁️ Evaluate Formula

Formulas → Evaluate Formula

Step through a complex formula one operation at a time. See the intermediate results at each step.

Best for: Debugging nested IF statements, complex INDEX-MATCH combinations.

📐 Show Formulas

Ctrl + ` (backtick)

Toggles between showing formula results and the actual formulas. Instantly see the structure of your model.

Audit use: Switch to formula view → print to PDF → review every formula visually.

🔎 Error Checking

Formulas → Error Checking

Excel's built-in error scanner finds #DIV/0!, #VALUE!, #REF!, #NAME?, #N/A, and #NULL! errors across the entire workbook.

Workflow: Run this FIRST before any manual review.

⚡ Advanced Audit Techniques

1. The F2 Key — Cell Audit Shortcut

Press F2 on any cell to enter edit mode. The formula appears with colored range references. Each reference has a different color matching the border around the referenced range. This is the fastest way to visually verify a formula.

2. The Watch Window

Formulas → Watch Window — Add critical cells (BS check, cash balance, NPV) to a floating panel. As you make changes, the Watch Window updates in real-time. You can see if your BS check goes non-zero while editing other sheets.

3. Conditional Formatting for Error Detection

BS Check Conditional Format

Rule: =ABS(BS_Check_Row) > 0.01
Format: Red fill, white bold text

Rule: =ISERROR(A1) ← Highlight all error cells
Rule: =ISFORMULA(A1) ← Highlight all formula cells (audit coverage)

4. The Range Finder (Double-Click Technique)

Double-click the border of a cell reference while editing a formula. Excel takes you to that referenced cell. Perfect for verifying links across sheets — double-click and confirm you're pulling from the right place.

5. Inquire Add-In (Professional)

Excel's Inquire add-in (File → Options → Add-ins → COM Add-ins → Inquire) provides professional-grade auditing:

Workbook Analysis: Maps all formulas, external links, hidden sheets, and circular references
Workbook Relationship: Visual diagram showing how workbooks are linked
Cell Relationship: Interactive dependency tree for any cell
Compare Files: Cell-by-cell comparison of two workbook versions

✏️ Worked Example 1: Auditing a Broken Revenue Model

Scenario: You inherit a 3-statement model from a departing colleague. Revenue seems too high. Find and fix all errors using systematic auditing.

Symptoms reported:

Revenue growth shows 18% (expected ~10%)
Balance sheet doesn't balance (off by ₹25 Cr)
Cash flow statement shows negative operating cash flow (should be positive)

Step 1: Run Excel Error Check (2 minutes)

Formulas → Error Checking

Found: #REF! error in cell D45 — a deleted row in the PP&E schedule. The depreciation formula references a row that was deleted.

Fix: Restore the deleted row from backup. Link the depreciation formula correctly.

Step 2: Check the BS Check Row (1 minute)

BS Check = Total Assets - Total Liabilities - Total Equity = ₹25 Cr (not zero!)

Press F2 on the BS check → the Retained Earnings link shows it's pulling from the wrong row in the income statement (net income + other comprehensive income instead of just net income).

Fix: Correct the Retained Earnings link to pull only net income.

Step 3: Trace Revenue Growth (3 minutes)

Revenue cell D15 formula: =C15 * (1 + 0.18)

Found Sin #1! The growth rate is hardcoded as 0.18 inside the formula. It should reference the assumptions sheet cell where growth is 10%.

Fix: Replace with =C15 * (1 + Assumptions!D12) where D12 = 10%

Step 4: Check Cash Flow Statement (2 minutes)

Operating CF shows −₹50 Cr. Trace Precedents on the "Change in Working Capital" line shows it's pulling the wrong sign — adding NWC increase instead of subtracting it.

Formula shows: =D20-D19 when it should be =D19-D20

Fix: Reverse the subtraction. NWC increase = cash outflow → subtract from operating CF.

Step 5: Verify with Go To Special (1 minute)

F5 → Special → Formulas → check only "Errors" → 2 more #N/A errors found in hidden rows 85-90 (legacy calculations).

Fix: Delete the hidden legacy rows entirely.

✅Audit Summary

5 errors found in 9 minutes:
1. #REF! error from deleted row → Fixed
2. Wrong Retained Earnings link → BS balanced (₹25 Cr gap closed)
3. Hardcoded 18% growth → Corrected to 10% from assumptions
4. Reversed NWC sign → Operating CF now +₹120 Cr
5. Legacy #N/A errors in hidden rows → Cleaned up

Lesson: A systematic 10-minute audit caught errors that could have led to a ₹500 Cr+ valuation mistake.

Section 3

Consistency Checks & Validation

Automated checks that catch errors before humans review the model

✅ The Master Validation Checklist

Build these checks INTO your model — they should update automatically as data changes:

Check #1: Balance Sheet Balancing

Add a row at the bottom of the balance sheet:

BS_Check = Total_Assets - Total_Liabilities - Total_Shareholders_Equity
Must equal 0 (or within ±0.01 due to rounding)
Conditional format: GREEN if = 0, RED if ≠ 0

Check #2: Cash Flow Reconciliation

Verify that the ending cash from CF statement matches the balance sheet cash:

CF_Check = Ending_Cash_CF - Cash_on_BS
Must equal 0. If not, the CF statement is not properly linked to the BS.

Check #3: Retained Earnings Roll-Forward

Verify that Retained Earnings changes by exactly Net Income − Dividends:

RE_Check = Ending_RE - Beginning_RE - Net_Income + Dividends
Must equal 0. Catches missing or incorrect RE links.

Check #4: PP&E Roll-Forward

Verify that PP&E moves correctly: Beginning + CapEx − Depreciation − Disposals = Ending

PPE_Check = Ending_PPE - Beginning_PPE - CapEx + Depreciation + Disposals
Must equal 0. Catches broken depreciation or CapEx links.

Check #5: Debt Roll-Forward

Debt_Check = Ending_Debt - Beginning_Debt + Repayments - New_Borrowings
Must equal 0. Catches broken repayment or drawdown schedules.

Check #6: Interest Coverage

Interest_Check = EBITDA / Interest_Expense
Should be > 2.0x for healthy companies. Flag if < 1.5x.

Check #7: Revenue Growth Sanity

Growth_Check = (Revenue_t - Revenue_{t-1}) / Revenue_{t-1}
Compare with: Industry average, historical growth, management guidance.
Flag if growth > 30% or < -10% without explanation.

Check #8: Sum-of-Parts Cross-Check

NWC_Check = (Current_Assets - Current_Liabilities) - Sum_of_individual_NWC_items
Must equal 0. Ensures no working capital items are double-counted or missed.

💡Pro Tip: The Dashboard Approach

Create a dedicated "Checks" tab in your model with all validation checks listed. Include a summary cell: =IF(AND(BS_Check=0, CF_Check=0, RE_Check=0, PPE_Check=0), "✅ ALL CLEAR", "❌ ERRORS FOUND"). This gives reviewers instant confidence (or alerts them to problems).

✏️ Worked Example 2: Building a Model Dashboard with Validation Checks

Objective: Add a professional validation dashboard to any financial model.

Structure of the "Checks" Tab

Row	Check Name	Formula	Expected	Status
3	BS Balance	=BS!Total_Assets - BS!Total_LE	0	=IF(C3=0,"✅","❌")
4	Cash Match	=CF!Ending_Cash - BS!Cash	0	=IF(C4=0,"✅","❌")
5	RE Roll-Forward	=BS!RE_End - BS!RE_Beg - IS!NI + CF!Div	0	=IF(C5=0,"✅","❌")
6	PP&E Roll-Forward	=BS!PPE_End - BS!PPE_Beg - CF!CapEx + IS!Dep	0	=IF(C6=0,"✅","❌")
7	Debt Roll-Forward	=BS!Debt_End - BS!Debt_Beg + CF!Repay - CF!Borrow	0	=IF(C7=0,"✅","❌")
8	Revenue Growth	=(IS!Rev_t - IS!Rev_{t-1})/IS!Rev_{t-1}	5-15%	=IF(AND(C8>=0.05,C8<=0.15),"✅","⚠️")
9	Interest Coverage	=IS!EBITDA / IS!Interest	> 2.0x	=IF(C9>=2,"✅","⚠️")
11	OVERALL STATUS	=COUNTIF(E3:E9,"❌")	0	=IF(C11=0,"✅ MODEL CLEAN","❌ "&C11&" ERRORS")

Conditional Formatting for the Dashboard

Apply to the Status column (E3:E11):

✅ → Green fill (#D1FAE5)
❌ → Red fill (#FEE2E2)
⚠️ → Yellow fill (#FEF3C7)

Apply to Overall Status cell (E11):

Green fill + "✅ MODEL CLEAN" when all checks pass
Red fill + "❌ 3 ERRORS" when any check fails — shows count

Section 4

Documentation Standards & Best Practices

Building models that others can understand, use, and trust

🎨 Color Coding Standards (Industry Convention)

Color	Meaning	When to Use	Example
Blue Font	Hard-coded input / assumption	Any number you type in manually — growth rates, margins, tax rate, WACC	Revenue growth: 10%
Black Font	Formula / calculation	Any cell with a formula — revenues, EBITDA, NPV, ratios	=C5*(1+C6)
Green Font	Link to another sheet	Any cell pulling data from a different worksheet in the same workbook	=Assumptions!D12
Red Font	Error / warning / check	Validation checks, error alerts, items needing attention	❌ BS does not balance!
Purple Font	External link / API data	Data pulled from Bloomberg, Capital IQ, Yahoo Finance, or other external sources	=BloombergBDP("AAPL US","PX_LAST")

📐 Model Structure Standards (FAST Standard)

The FAST Standard (Flexible, Appropriate, Structured, Transparent) is the most widely adopted financial modeling standard in investment banking and private equity:

Principle	Meaning	How to Implement
F — Flexible	Model adapts easily to new scenarios	Never hardcode. All assumptions in one place. Use dropdowns for scenarios. Data tables for sensitivities.
A — Appropriate	Right level of detail for the decision	Don't model 50 line items for a back-of-envelope valuation. Match granularity to the decision's importance.
S — Structured	Consistent, logical layout	Standard tab order: Cover → Assumptions → IS → BS → CF → DCF → Sensitivity → Checks. Same timeline across all sheets.
T — Transparent	Anyone can understand the model	Simple formulas. Helper columns for complex calcs. Comments on key assumptions. Named ranges for readability.

📋 The Changelog Tab

Every professional model includes a changelog tab that tracks all modifications:

Date	Version	Changed By	What Changed	Why	Cells Affected
2026-04-30	v1.0	Afzal	Initial model build	New project	All
2026-05-02	v1.1	Priya	WACC updated from 10% to 11.5%	MFA feedback — risk premium too low	Assumptions!D15
2026-05-05	v1.2	Afzal	Added scenario analysis tab	Client requested bull/base/bear	New tab: Scenarios
2026-05-08	v1.3	Rahul	Fixed debt repayment formula	Cash sweep was backward	Debt!E22:H22

📁 File Naming Convention

Standard Format

ProjectName_YYYY-MM-DD_vN.N.xlsm

Example: TechCorp_DCF_2026-04-30_v1.0.xlsm
Example: TechCorp_DCF_2026-05-08_v1.3.xlsm

❌ BAD: model_final_FINAL_v2_REAL_FINAL.xlsx

🏷️ Named Ranges — The Secret to Readable Models

Compare these two formulas — they do the same thing:

Without Named Ranges (Unreadable)

=IF('Assumptions'!D12>0, 'IS'!C15*(1+'Assumptions'!D12), 'IS'!C15)

With Named Ranges (Readable)

=IF(Growth_Rate>0, Prior_Revenue*(1+Growth_Rate), Prior_Revenue)

How to create named ranges: Select cell → Click the Name Box (top-left, left of formula bar) → Type the name → Press Enter. Or use Formulas → Name Manager for bulk management.

💡Named Range Best Practices

Use descriptive names: WACC not r; Revenue_Growth not g
Use underscores instead of spaces: Tax_Rate not Tax Rate
Prefix with category: Input_Growth_Rate, Calc_WACC, Check_BS_Balance
Document all named ranges in the assumptions sheet

Section 5

The Master Audit Checklist

Print this and use it before delivering ANY model

📋 30-Point Model Audit Checklist

#	Category	Check	Pass?
📐 STRUCTURAL CHECKS
1	Structure	Standard tab order: Cover → Assumptions → IS → BS → CF → Valuation → Sensitivity → Checks	☐
2	Structure	Timeline is consistent across all tabs (same start year, same periods)	☐
3	Structure	Each row performs ONE calculation (no "god formulas")	☐
4	Structure	No hidden rows/columns with calculations (formatting-only hiding is OK)	☐
5	Structure	No merged cells in data/formula areas (causes reference problems)	☐
🔢 FORMULA CHECKS
6	Formulas	No hardcoded numbers inside formulas (all inputs in assumptions sheet)	☐
7	Formulas	No #REF!, #VALUE!, #DIV/0!, #N/A, #NAME? errors anywhere	☐
8	Formulas	No circular references (unless intentionally modeled with iteration)	☐
9	Formulas	Color coding applied: Blue=Input, Black=Formula, Green=Cross-sheet link	☐
10	Formulas	All formulas are consistent across rows (no row-by-row variations)	☐
⚖️ BALANCE SHEET CHECKS
11	BS Check	Total Assets = Total Liabilities + Equity (for ALL periods)	☐
12	BS Check	Ending cash on CF statement = Cash on balance sheet	☐
13	BS Check	Retained earnings rolls forward correctly (Beg + NI − Div = End)	☐
14	BS Check	PP&E roll-forward balances (Beg + CapEx − Dep = End)	☐
15	BS Check	Debt roll-forward balances (Beg − Repay + New Borrow = End)	☐
16	BS Check	Working capital items are calculated consistently (DSO, DIO, DPO)	☐
📊 INCOME STATEMENT CHECKS
17	IS Check	Revenue growth rates are reasonable (consistent with industry/management)	☐
18	IS Check	EBITDA margins trend logically (not jumping 10% without reason)	☐
19	IS Check	Depreciation as % of PP&E is reasonable (typically 3-8% for most industries)	☐
20	IS Check	Interest expense matches debt schedule (interest rate × average debt balance)	☐
21	IS Check	Tax rate is consistent and reasonable (25.17% for Indian companies)	☐
💰 VALUATION CHECKS
22	Valuation	WACC components are internally consistent (β, risk-free rate, ERP)	☐
23	Valuation	Terminal value is reasonable (< 75% of total enterprise value)	☐
24	Valuation	Terminal growth rate < WACC and reasonable (typically 2-4%)	☐
25	Valuation	Implied multiples from terminal value are in market range	☐
📝 DOCUMENTATION CHECKS
26	Documentation	Cover page with project name, date, version, author, purpose	☐
27	Documentation	Key assumptions are documented with sources	☐
28	Documentation	Changelog is maintained with all modifications	☐
29	Documentation	File naming follows convention: Project_Date_Version	☐
30	Documentation	Sheet protection is ON for formula cells; inputs are unlocked	☐

Practice Lab

Hands-On Audit Exercises

🏋️ Exercise 1: Find the 10 Errors (20 min)

Objective: You receive a model with 10 planted errors. Use systematic auditing to find and fix them all.

Errors to find (don't peek!):

A hardcoded number inside a formula
A #REF! error from a deleted cell
Balance sheet that doesn't balance
Cash flow ending cash ≠ balance sheet cash
Revenue formula referencing wrong year
Depreciation not linked to PP&E schedule
Interest expense using wrong debt balance
Terminal growth rate > WACC (impossible!)
Two different tax rates on different sheets
A SUM range missing the last cell

Systematic Approach

Round 1 (2 min): Run Error Checking → finds #REF! error (#2)

Round 2 (2 min): Go To Special → Constants → Numbers → identifies hardcoded values in formula areas (#1)

Round 3 (1 min): Check BS Check row → finds ₹37 Cr imbalance (#3)

Round 4 (1 min): Compare CF ending cash with BS cash → mismatch (#4)

Round 5 (3 min): Trace Precedents on revenue → formula pulls from wrong column (#5)

Round 6 (2 min): Trace Precedents on depreciation → links to wrong cell (#6)

Round 7 (2 min): Verify interest = rate × debt → wrong balance used (#7)

Round 8 (1 min): Check terminal growth vs WACC → 8% growth, 7.5% WACC (#8)

Round 9 (2 min): Compare tax rates across sheets → 25.17% vs 30% (#9)

Round 10 (2 min): Audit SUM ranges → find missing cell at end of range (#10)

🏋️ Exercise 2: Build a Validation Dashboard (25 min)

Objective: Take any existing model (from Sessions 4-11) and add a professional "Checks" tab with all 8 validation checks from Section 3.

Deliverables:

Checks tab with all 8 automated validation rows
Conditional formatting: green ✅ for pass, red ❌ for fail
Summary cell with overall model status
Print-ready layout (fit on one page)

See Worked Example 2 above for the complete dashboard structure with formulas and conditional formatting rules.

Additional Tips

1. Place the Checks tab as the last tab in the workbook so reviewers find it immediately

2. Add a hyperlink on the Cover page: "Click here for Model Validation Status" → links to Checks!E11

3. Use Data Validation on input cells to prevent impossible values (e.g., growth > 100%)

4. Protect formula cells: Review → Protect Sheet → allow users to only edit blue (input) cells

🏋️ Exercise 3: Fix a Broken Model (30 min)

Objective: You receive a DCF model that gives an enterprise value of ₹45,000 Cr when the expected answer is ~₹15,000 Cr. Find and fix what's wrong.

Hints:

Check if the WACC is correct (is it 8% or did someone enter 3%?)
Check if terminal value is using perpetuity formula correctly
Verify that the terminal year is the last projected year, not a future year
Check if FCFF is using the right definition (EBIT × (1-t) + D&A − CapEx − ΔNWC)

Root Cause Analysis

Error: The terminal value formula used the terminal growth rate instead of WACC in the denominator:

❌ Wrong: TV = FCF_{n+1} / (g - g) → This divides by (WACC − g) but g was entered as WACC, giving (3% − 3%) = 0 → #DIV/0! → Excel showed ₹45,000 Cr from the last explicit year's FCF multiplied by 30 (a legacy "fix").

✅ Correct: TV = FCF_{n+1} / (WACC - g) = FCF_{n+1} / (10% - 3%) = FCF_{n+1} / 7%

Corrected EV: ₹15,200 Cr (matches expected range)

Lesson

Terminal value typically accounts for 60-75% of total EV. If your TV seems too high (or too low), the FIRST thing to check is the denominator: (WACC − g). A 1% error here can change the valuation by 20-30%.

Quick Review

📚 Key Terms — Click to Flip

Knowledge Check

Test Your Understanding

10 questions on Model Auditing & Error-Proofing

Summary

Key Takeaways

📝 What We Covered Today

88% of spreadsheets contain errors — model auditing is not optional, it's essential. Real-world failures cost billions.
The 7 Deadly Sins — hardcoding, no color coding, duplicate assumptions, broken links, complex formulas, no BS check, no version control
Excel audit tools — Trace Precedents/Dependents, Go To Special, Evaluate Formula, Watch Window, Show Formulas, Inquire Add-In
8 essential validation checks — BS balance, cash reconciliation, RE roll-forward, PP&E roll-forward, debt roll-forward, plus sanity checks
FAST Standard — Flexible, Appropriate, Structured, Transparent. The industry standard for professional models.
Color coding convention — Blue = input, Black = formula, Green = cross-sheet link, Red = error/check, Purple = external data
30-point audit checklist — use before delivering any model to decision-makers

📚Next Session

Session 25: Industry Modeling – Banking
We'll build a bank financial model — net interest margin, provision for loan losses, regulatory capital (CRAR), and the unique aspects of bank balance sheets.