Grey Beards Excel Add ins

Working financial models, not classroom exercises

The technical workshop of the Financial Modelling Podcast. Templates and Excel add ins built by practitioners who have raised over $1bn using models like these. Download, populate and use today.

Browse templates See the Excel add ins

Templates marketplace

Every template is a live, fully formula driven workbook. No locked cells, no black boxes.

Project Finance

Project Finance Financial Model Template

A fully integrated model for infrastructure, energy and PPP projects. SMART standard aligned structure, semi annual periodicity, senior debt sculpting, DSCR and LLCR, and a full three statement output. A credible starting point instead of building from scratch.

What you get

18+ sheet workbook: cover, user guide, quick start, timeline, assumptions
Complete debt schedule with drawdown, repayment and sculpting logic
Three statements, cash waterfall and distribution lock up tests
Sensitivity tables, scenario manager and a charted dashboard
Error check suite and changelog, lifetime access to the version you buy

Format: .xlsm, macros enabled
Excel: 2016+ / Microsoft 365, Windows and Mac
Periodicity: Semi annual
Dependencies: None, standalone, no external links

$145 USDone timeBuy or enquire

REIPPPP bid model dashboard with returns, lender metrics, integrity checks and key year metrics

Project Finance

REIPPPP Bid Financial Model

Solar PV and onshore wind. Monthly, 25 years of operations, sculpted senior debt, S12B depreciation, and a full nine category Economic Development scoring calculator wired live to your bid inputs. One project's worth of structure you can reuse across every bid window from BW8 onwards.

What you get

14 sheets, around 30,000 formulas, zero errors
Debt sizing sculpted so DSCR holds at your lender target every period
Section 12B 50/30/20 depreciation with tax loss carry forward and a straight line toggle
ED scoring across all nine categories with threshold, target, committed and compliance status
Sensitivity on tariff, CapEx, capacity factor, availability, debt margin and CPI
Ten model audits with PASS and FAIL flags, plus a one page IC dashboard

Format: .xlsx, no macros
Periodicity: Monthly, 25 year operations
Technologies: Solar PV and onshore wind
Licence: Single licence, updates for the BW8 cycle

$145 USDone timeBuy or enquire

Project Finance

Midlands Solar PV Worked Example

A real, end to end, monthly project finance model for a 100 MWp solar PV project in the Northern Cape. Open it, read every formula, use it as the reference your next bid is built against.

What you get

REIPPPP aligned project finance structure, monthly granularity, ZAR
Full sources and uses, sculpted senior debt and DSRA
Returns and lender metrics: IRR, NPV, DSCR, LLCR and PLCR
Model integrity checks on funding, balance sheet and S curves

Format: .xlsx
Scale: 100 MWp utility scale solar PV
Periodicity: Monthly

$145 USDone timeBuy or enquire

Accounting

Grey Beards SME Accounting Workbook

A complete bookkeeping system in one spreadsheet. You enter transactions in one sheet and the workbook does the rest: P&L, cashflow, VAT, balance sheet, budget tracking and a dashboard that tells you whether you are actually making money. It works for any country with a VAT or GST system. Default is South Africa at 15% VAT and 27% corporate tax, and it handles ZAR, GBP, USD, EUR or any other currency.

Who it is for

Small business owners keeping their own books without a full time bookkeeper
Side hustlers tired of monthly cloud accounting subscriptions they barely use
Founders who want a clean handover document for their accountant at year end
Bookkeepers who want a turnkey starting point for new clients

What you get

Settings sheet: company name, currency, tax rates and opening balances, set once
Chart of Accounts pre loaded with 21 standard categories, extendable
Transactions sheet with formulas pre loaded to row 10,000
Monthly P&L across twelve months with a full year column
Budget versus actual tracking month by month
Cashflow that separates money that moved from money only invoiced
VAT summary: collected, paid and net payable before you file
Balance sheet with a balance check, plus a dashboard with a health score out of 100

Sheet by sheet breakdown

Settings: Company name, currency, tax rates, opening balances
Instructions: How to use, colour coding, refund policy
Chart of Accounts: 21 standard categories pre loaded, extendable
Transactions: Single entry point, formulas pre loaded to row 10,000
Monthly P&L: Revenue to net profit after tax, by month
Budget vs Actual: Plan compared to reality, month by month
Cashflow: Cash that actually moved versus invoiced amounts
VAT Summary: VAT collected, VAT paid, net payable
Balance Sheet: Assets, liabilities, equity with balance check
Dashboard: Key metrics, health score out of 100, sanity warnings

Format: .xlsx, no macros
Excel: 2016+ / Microsoft 365, Windows and Mac
Capacity: Pre loaded to 10,000 transaction rows
Tax setup: South Africa default, fully configurable

$39 USDone timeBuy or enquire

Grey Beards three statement financial model cover sheet with instructions

Corporate Finance

Grey Beards Three Statement Corporate Finance Model

Set the active scenario in the Control Panel and the entire model recalculates: revenue build, operating costs, working capital, capex and depreciation, debt, tax and the three integrated statements. On top sit integrity checks, sensitivities, a dashboard, DCF valuation, LBO returns and covenant tests. Inputs are colour coded, blue cells only, and the balance sheet balances.

Who it is for

Corporate FP&A teams building annual plans and board packs
Founders who need a defensible 5 year forecast for an investor deck
Analysts running quick valuation and scenario work
Consultants who want a turnkey three statement skeleton
Students learning how IS, CF and BS actually link together

What you get

Control Panel with scenario switch: 1 Base, 2 Upside, 3 Downside
Assumptions across macro, revenue drivers, opex, working capital, capex, debt and tax
Revenue build on volume times price, with growth checks
Working capital, capex and depreciation, debt and tax schedules
Integrated income statement, cash flow statement and balance sheet
Seven integrity tests including balance sheet balance and cash tie out
Sensitivities, dashboard KPIs and a Revenue and EBITDA chart
Valuation with WACC build and DCF, LBO returns, and covenant tests

Sheet by sheet breakdown

Cover: Branding, version, how to use, colour coding
Control Panel: Scenario switch and quick output summary
Assumptions: Macro, revenue, opex, working capital, capex, debt, tax by year
Revenue Build: Volume times price with YoY growth checks
Operating Costs: Variable COGS and fixed salaries, rent and other opex
Working Capital: AR, inventory, AP, NWC and change in NWC
Capex & Depreciation: Capex as % of revenue with PP&E roll forward
Debt Schedule: Term debt roll forward, interest expense and interest income
Tax: Effective tax rate, no tax on losses
Three Statements: Income statement, cash flow and balance sheet with balance check
Checks: Balance, cash tie out and formula consistency tests
Sensitivities: Two way tables on key valuation and returns drivers
Dashboard: Summary KPIs and Revenue and EBITDA chart
Valuation: WACC build, unlevered FCF, Gordon growth and exit multiple
LBO Returns: Sources and uses, debt paydown and sponsor equity returns
Covenants: Leverage and interest cover tests across the forecast

Format: .xlsx, no macros
Periodicity: Annual, 5 year forecast
Scenarios: Base, Upside, Downside toggle
Currency: USD ($mm), configurable

$25 USDone timeBuy or enquire

Founder valuation and dilution dashboard showing exit equity, founder ownership and net proceeds

Funding rounds sheet with round setup, money in and option pool inputs

Cap table and waterfall sheet showing share by share dilution across rounds

Valuation

GreyBeards Founder Valuation and Dilution Model

Most founders sign a term sheet they do not fully price. This workbook runs the investor's own VC method on your numbers, then walks the round by round reality: SAFE and note conversions, option pool top ups, preferred stock and liquidation preferences, and the cap table after each event. It outputs what you actually keep at exit under base, upside and downside, with red flag checks on the terms that quietly cost founders the most.

Who it is for

Founders raising a pre seed, seed or Series A round
Operators joining a startup who want to understand their option grant
Angel and syndicate investors checking the founder side of a term sheet
Advisors and accelerator mentors prepping founders for a raise

What you get

VC method valuation using the investor's own logic
Round by round cap table with SAFE and convertible note conversions
Option pool top up maths, pre and post money
Liquidation preference modelling: 1x non participating, participating and caps
Base, upside and downside exit scenarios with founder net proceeds
Automatic red flag checks on dilution, preference stacks and pool sizing
Three auto filled pitch slides ready to paste into your deck

Sheet by sheet breakdown

Inputs: Round size, pre money, SAFE terms, pool target, exit assumptions
VC Method: Required return, exit value, implied ownership and pre money
Cap Table: Round by round ownership with conversions and pool top ups
Preferences: Liquidation waterfall: non participating, participating, caps
Scenarios: Base, upside and downside outcomes with founder net proceeds
Red Flags: Checks on dilution, preference stack, pool sizing and conversions
Pitch Slides: Three auto filled summary slides for your deck

Format: .xlsx, no macros
Excel: 2016+ / Microsoft 365, Windows and Mac
Scenarios: Base, Upside, Downside
Background required: None, fill the blue cells

$29 USDone timeBuy or enquire

Excel Workbook Performance Analyzer showing optimisation recommendations

Excel Add in

Excel Performance Analyzer (Full Version)

The full, no expiry version of the Grey Beards Excel Performance Analyzer. Identify performance bottlenecks, oversized sheets, volatile functions and external links across any workbook.

What you get

Full diagnostic engine with no expiry and no nag screen
Exportable Excel report ranked by priority
Unhide all sheets and named ranges in one click

Format: Excel add in
Excel: 2016+ / Microsoft 365

$29 USDone timeBuy or enquire

Coming soon

DCF Valuation Template

WACC build, terminal value methods and a clean output page.

Coming soonComing soon

Performance optimisation tool

Grey Beards Excel Workbook Performance Analyzer

A diagnostic tool that targets the specific things that make financial models slow, so you can keep the detail you need without losing performance.

Deep formula analysis

Identifies volatile functions, array formulas and calculation chains that create bottlenecks.

Sheet by sheet size breakdown

Shows exactly which sheets consume memory and why, so you know where to focus.

Hidden element detection

Reveals and optionally unhides very hidden worksheets and named ranges.

External reference mapping

Finds links to other workbooks that create dependencies and slow calculations.

Practical recommendations

Actionable suggestions tailored to financial modelling best practice.

Detailed reporting

Professional reports with actionable insights, exported straight to Excel.

Grey Beards Excel Workbook Performance Analyzer showing optimisation recommendations

Excel performance analysis report listing high and medium priority issues

7 day trial

Free

Full diagnostic engine
Instant download after signup
Expires after 7 days

Get the trial

Full version

$29 USD one time

Everything in the trial
No expiry, no nag screen
Secure email delivery after checkout

Buy full version

Real results from financial professionals

"Our quarterly consolidation model had grown to 62MB and took over 5 minutes to recalculate. After running the analyzer and implementing its recommendations, the file size dropped to 28MB with calculation time under 45 seconds, without losing any functionality."Investment Banking Analyst

"I inherited a complex LBO model that would crash Excel whenever certain scenarios were run. The Performance Analyzer identified several circular references and excessive conditional formatting that were not visible through normal means. After fixing these issues, the model runs flawlessly."Private Equity Associate

Visual mapping tool

Grey Beards Formula Map

See and understand your Excel model like never before. A bird's eye view of where your formulas and hardcoded values live, your instant X ray for any spreadsheet.

Visual model structure

Colour coded maps of every worksheet so structure is obvious at a glance.

Formula pattern detection

Spot copy relationships and confirm consistency across rows and columns.

Risk identification

Find hardcoded values sitting inside calculation rows and formulas that break the pattern.

Whole workbook analysis

Single sheet in seconds, or map every sheet with one click for full documentation.

Colour coded intelligence

Blue Original formulas requiring attention
Green Safe copied formulas, horizontal
Purple Safe copied formulas, vertical
Orange Copied in both directions
Yellow Input numbers in appropriate places
Red Critical: hardcoded values breaking formula patterns

Formula Map output grid with colour coded cells showing formula patterns and hardcoded values

Why modellers use it

Audit with precision and find hardcodes buried in helper tabs
Speed up reviews by focusing where it matters
Train junior analysts without cell by cell explanations
Presentation ready screenshots for stakeholders and boards

Get Formula Map

Free trial, then a licence for continued use. Compatible with Excel 2016 and newer, installed in under five minutes.

Request a trial

Free resource

AI prompts for building Excel financial models

A structured prompt library that walks a model from assumptions to a validated three statement output, following the Grey Beards model architecture.

Define inputs

Macroeconomics, operational assumptions, financing terms, master timeline and documentation.

Calculate workings

Revenue, cost of sales, opex, working capital, fixed assets, debt schedule and balance sheet steps.

Generate outputs

Monthly and annual three statement financials, dashboards and scenario views.

Validate and monitor

Covenant tracking, integrity checks and reasonableness tests on growth and margins.

Request the prompt pack

Also in the workshop

VBA toolkit

Financial Model Audit Toolkit

VBA toolkit that flags hard coded numbers, inconsistent formulas and circular references in your models.

Support

Need something bespoke?

We build and review models for transactions. Send us a message through the contact form and tell us what you are working on.

Excel is a trademark of Microsoft Corporation.