Course Templates
Ready-to-use financial worksheets for every course, preview and edit any template right here, then download it as a spreadsheet-ready CSV. Free-course templates are free for everyone; the rest unlock with the owning course or Premium.
Balance Sheet Balancer
A guided worksheet built around the accounting equation. List every account, tag it as an Asset, Liability, or Equity item, and instantly see whether your books balance.
Use it for:
- Learning the accounting equation (Assets = Liabilities + Equity) with real numbers instead of abstract theory.
- Doing a quick sanity check on a small business or personal balance sheet before a bank meeting.
- Practicing how everyday transactions (taking a loan, buying equipment) flow into the three account categories.
Monthly Cash Flow Tracker
A simple income-vs-expense tracker that shows exactly where money comes from and where it goes each month, ending in a single net cash flow number.
Use it for:
- Building your first personal or household budget and finding out whether you end each month positive or negative.
- Tracking a freelancer or side-business cash position without full bookkeeping software.
- Identifying the two or three expense lines that dominate spending so you know where cuts matter most.
Income Statement Builder
Assemble a clean single-period income statement from raw line items. Tag each line by section and the worksheet rolls up gross profit, operating income, and pre-tax income automatically.
Use it for:
- Converting a messy list of revenues and costs into a properly structured income statement.
- Understanding how gross profit differs from operating income and why the distinction matters to lenders and investors.
- Preparing a simple monthly P&L for a small business without accounting software.
Ratio Trend Worksheet
Compare this year against last year for any set of financial metrics. The change column is computed automatically, making deteriorating or improving trends impossible to miss.
Use it for:
- Running a year-over-year health check on a company using its published financial statements.
- Preparing the trend section of a credit or investment memo, the computed change column does the math for you.
- Benchmarking your own business metrics against last year before setting next year's targets.
Business Health Quick-Check Scorecard
A one-glance health check that turns a handful of numbers from the three financial statements into simple, colour-of-money ratios so a beginner can judge whether a business is on solid ground.
Use it for:
- Sizing up a small business or a company you are studying without wading through full financial statements.
- Practicing how raw figures like profit, sales, and debt combine into the ratios investors actually watch.
- Running a quick before-and-after check when a business changes its pricing, costs, or borrowing.
Simple Break-Even Calculator
Work out how many units you must sell to cover your costs. Enter the price, the variable cost per unit, and your fixed costs, and the sheet shows the contribution per unit and the break-even point.
Use it for:
- Deciding whether a product idea can ever cover its costs before you commit money to it.
- Understanding the difference between fixed and variable costs using your own figures.
- Setting a sales target that a team can rally around, the number needed just to break even.
5-Year Revenue Driver Forecast
A driver-based revenue build that projects sales from customer count, average revenue per customer, and a growth assumption, so every forecast number traces back to a clear operating driver.
Use it for:
- Building the top line of a financial model from real drivers instead of a single guessed growth rate.
- Showing investors or a board exactly what has to be true about customers and pricing for the plan to work.
- Stress-testing a plan by flexing the growth rate and instantly seeing the five-year revenue path change.
Mini DCF Valuation Worksheet
A compact discounted cash flow worksheet that takes projected free cash flows, discounts each year to present value, and sums them to an implied enterprise value.
Use it for:
- Learning the mechanics of discounting, why a euro next year is worth less than a euro today.
- Producing a first-pass valuation for a company or project from a handful of cash flow estimates.
- Seeing how sensitive value is to the discount rate by editing the rate and watching the total move.
Department Budget vs Actual Tracker
Line up each spending category's budget against what was actually spent. The worksheet computes the variance and the variance percentage so overspends and savings jump straight off the page.
Use it for:
- Running a monthly or quarterly budget review for a team or department without help from finance.
- Explaining to your own manager exactly where a budget came in over or under and by how much.
- Catching a category that is drifting off plan early, while there is still time to react.
Project ROI One-Pager
A single-screen business case that weighs a project's expected benefits against its costs and returns the net benefit, the ROI percentage, and a simple payback period.
Use it for:
- Pitching an initiative to leadership with a clear, numbers-backed case rather than a gut feeling.
- Comparing several competing project ideas on the same simple return measure.
- Deciding whether a proposed tool or hire will actually pay for itself, and how quickly.
Capital Allocation Scorecard
Rank competing uses of capital by combining the amount requested with the expected return, so leadership can see where each euro of investment works hardest.
Use it for:
- Choosing which projects, teams, or business units should receive the next round of investment.
- Bringing discipline to a budgeting round where every department is asking for more money.
- Showing the board how expected returns compare across very different investment options.
Strategic Initiative Business Case
Lay out the multi-year costs and benefits of a strategic initiative side by side to reveal the net value it creates and the year it turns cash-positive.
Use it for:
- Framing a long-term strategic bet where the payoff arrives only after several years of investment.
- Making the trade-off between near-term cost and long-term value explicit for decision-makers.
- Identifying the cross-over year when cumulative benefits finally overtake cumulative costs.
Make vs Buy Comparison Sheet
Compare the full cost of making something in-house against buying it from a supplier, line by line, and see the total cost of each path plus the saving from choosing the cheaper option.
Use it for:
- Deciding whether to produce a component, service, or capability internally or outsource it.
- Making sure hidden in-house costs like overhead and management time are not overlooked.
- Quantifying the annual saving from a sourcing decision to support a recommendation.
Weighted Decision Matrix
Score each option against weighted criteria to turn a fuzzy, multi-factor choice into a single comparable number, alongside the up-front cost of each option.
Use it for:
- Choosing between options where price is only one of several things that matter.
- Making a group decision transparent by agreeing weights and scores openly.
- Balancing cost against quality, risk, and fit in a single, defensible view.
Base / Best / Worst Scenario P&L
Model the profit outcome under three futures at once. Enter revenue and cost assumptions for the base, best, and worst cases and the sheet returns the operating profit for each.
Use it for:
- Planning for uncertainty by seeing profit under optimistic, realistic, and pessimistic assumptions together.
- Pressure-testing a budget so the downside is understood before it happens, not after.
- Communicating a range of outcomes to stakeholders instead of a single false-precision number.
Sensitivity Input-Output Grid
Vary one key input across a range and watch the resulting profit change. Each row flexes the unit price while volume and cost per unit stay fixed, exposing how sensitive profit is to price.
Use it for:
- Finding out which single assumption your profit depends on most before you finalize a plan.
- Building intuition for how a few percentage points on price ripple through to the bottom line.
- Setting a defensible price floor by seeing where profit turns negative.
Competitor Benchmarking Grid
Line up your company against its main rivals on the metrics that matter, revenue, growth, margins, and market share, to see exactly where you lead and where you lag.
Use it for:
- Building the competitive-landscape section of a market research report or investment memo.
- Spotting which competitor is growing fastest and which is most profitable before setting your own targets.
- Preparing a board or investor slide that compares your business to named peers on hard numbers.
Market Sizing Worksheet (TAM / SAM / SOM)
Estimate the size of an opportunity from the top down. Enter the total addressable market, the share you can realistically serve, and the slice you expect to capture, with the value of each layer computed for you.
Use it for:
- Sizing a new product or geographic market before committing budget to a launch.
- Writing the opportunity section of a business plan or fundraising deck with defensible numbers.
- Stress-testing an optimistic revenue projection by tracing it back to a realistic share of the market.
Acquisition Target Screening Scorecard
Rank potential acquisition targets on the criteria that drive deal success, strategic fit, financial health, valuation, and integration risk, using a weighted score that surfaces the best candidates.
Use it for:
- Narrowing a long list of potential targets down to the two or three worth serious diligence.
- Giving a deal committee an objective, apples-to-apples comparison instead of anecdotes.
- Documenting why one target was chosen over another for later review or audit.
Synergy & Deal-Value Worksheet
Quantify the sources of value in a deal. List each cost and revenue synergy, apply a realization probability, and see the risk-adjusted value that justifies (or undermines) the premium being paid.
Use it for:
- Testing whether projected synergies actually cover the acquisition premium before signing.
- Separating credible, high-probability synergies from optimistic ones during diligence.
- Building the value-creation case presented to the board or lenders.
Stock Comparison Dashboard
Compare candidate stocks side by side on valuation, profitability, and growth. An earnings yield column is computed from the P/E so you can rank ideas on value at a glance.
Use it for:
- Screening a shortlist of stocks before deciding which to research in depth.
- Explaining to a client or study group why one company looks cheaper or higher quality than another.
- Building the comparison table for an equity pitch or investment club presentation.
Portfolio Allocation & Return Tracker
Track each holding’s cost, current value, and weight in the portfolio. Gain and return are computed per position so winners and laggards are obvious.
Use it for:
- Keeping a running view of how a personal or model portfolio is performing position by position.
- Checking whether any single holding has grown into an over-concentrated, risky weight.
- Reviewing which positions to trim or add to during a rebalancing session.
Risk Register with Probability × Impact Scoring
Log every identified risk, rate its likelihood and impact, and let the worksheet compute a severity score that ranks which risks demand attention first.
Use it for:
- Building the core risk register for an enterprise risk management program.
- Prioritizing a long list of risks so limited mitigation budget goes to the most severe ones.
- Preparing a risk heat-map discussion for a board or audit committee.
Cash Runway Stress-Test Sheet
Project how long your cash lasts under different scenarios. Enter monthly inflows and outflows and the worksheet computes net burn and the runway in months for each case.
Use it for:
- Checking how many months of cash a business has left before it must raise funds or cut costs.
- Stress-testing survival under a revenue shock, a cost spike, or both at once.
- Preparing the liquidity section of a contingency or crisis-management plan.
Product Unit-Cost Breakdown Sheet
Build up the full cost of one unit from its components, materials, labor, and overhead, so you know your true cost floor before setting a price.
Use it for:
- Working out the real cost to make one unit before quoting a price to a customer.
- Finding which cost component dominates so you know where sourcing or process savings matter most.
- Comparing the cost of producing in-house versus the price of buying finished goods.
Pricing Strategy Margin Ladder
Test different price points against a fixed unit cost. The worksheet computes gross profit and margin per tier so you can see the trade-off between price, margin, and positioning.
Use it for:
- Choosing a launch price by comparing the margin at several candidate price points.
- Designing good-better-best tiers and checking each one clears your margin target.
- Showing sales or leadership the profit impact of discounting versus holding price.
Personal Net Worth Statement
List everything you own and everything you owe, tag each line as an asset or liability, and see your total net worth roll up automatically.
Use it for:
- Getting a clear, single-number picture of your financial position before setting goals.
- Tracking net worth over time to confirm you are actually building wealth, not just income.
- Preparing a financial snapshot for a mortgage, loan, or financial-advisor meeting.
Savings Goal & Compound Growth Planner
Plan progress toward multiple savings goals. Enter the target, what you have saved, and your monthly contribution, and the worksheet computes the shortfall and months remaining.
Use it for:
- Mapping several goals at once, emergency fund, home deposit, education, and seeing which needs more attention.
- Working out how long each goal will take at your current savings rate.
- Deciding how to split a monthly surplus across competing goals.
KPI Dashboard: Target vs Actual
Track key performance indicators against their targets. The worksheet computes the variance and the percentage of target achieved so under- and over-performers stand out instantly.
Use it for:
- Running a monthly or quarterly performance review across a set of business KPIs.
- Highlighting which metrics are off track so the discussion focuses on what matters.
- Building a one-page dashboard for leadership without a BI tool.
Team Scorecard with Weighted Objectives
Score a team or individual across weighted objectives. Each objective’s weighted contribution is computed and rolled up into a single overall performance score.
Use it for:
- Turning several objectives of differing importance into one fair, overall performance score.
- Making appraisal or bonus conversations objective by tying them to weighted results.
- Comparing teams or individuals consistently using the same weighted framework.
