Blog

Expert guides on financial modelling, valuation, and forecasting. Built for finance professionals, founders, and analysts.

How to Build a Cash Flow Forecast in Excel
Model Deep-Dives13 min

How to Build a Cash Flow Forecast in Excel

A complete, practical guide to building a cash flow forecast in Excel. Learn the direct and indirect methods, the operating/investing/financing structure, a fully worked monthly example, the Excel formulas that make it self-updating, and the mistakes to avoid.

Read article
Top Tools for Financial Modelling: The Complete Stack by Role
Tools & Software12 min

Top Tools for Financial Modelling: The Complete Stack by Role

The practical financial modelling tool stack - Excel, accelerators, data sources, FP&A platforms, Python automation, and AI copilots like Claude and ChatGPT. Recommended stacks for analysts, bankers, founders, and FP&A teams.

Read article
NPV vs IRR: Which Investment Metric Should You Trust?
Valuation9 min

NPV vs IRR: Which Investment Metric Should You Trust?

Master the classic PE/IB interview question. Learn why NPV and IRR can rank projects differently, when each metric fails, and how MIRR fixes both.

Read article
How to Build a DCF (Discounted Cash Flow) Model in Excel
Model Deep-Dives14 min

How to Build a DCF (Discounted Cash Flow) Model in Excel

Master the fundamentals of building a discounted cash flow (DCF) model in Excel. Learn to forecast free cash flows, calculate WACC, determine terminal value, and arrive at an enterprise and equity valuation.

Read article
LBO Model Tutorial: Excel Guide
Model Deep-Dives15 min

LBO Model Tutorial: Excel Guide

Learn how to build a leveraged buyout (LBO) model in Excel from scratch. A complete guide covering transaction structure, debt schedules, exit scenarios, and returns calculation (IRR, MOIC) with worked examples.

Read article
How to Calculate WACC: A Step-by-Step Guide
Valuation11 min

How to Calculate WACC: A Step-by-Step Guide

Learn to calculate the Weighted Average Cost of Capital, the discount rate used in DCF valuations and investment decisions. Includes worked examples and common pitfalls.

Read article
Common Financial Modelling Mistakes (and How to Avoid Them)
Best Practices10 min

Common Financial Modelling Mistakes (and How to Avoid Them)

Learn the 15 most common financial modelling errors that trip up professionals, and the exact fixes to implement in Excel today - from broken balance sheet checks to hardcoded formulas.

Read article
How to Build a SaaS Financial Model: ARR, Cohorts, and Unit Economics
Industry Models13 min

How to Build a SaaS Financial Model: ARR, Cohorts, and Unit Economics

Master SaaS unit economics, cohort analysis, and ARR builds. Learn revenue recognition, CAC payback, LTV, and the metrics investors use to value SaaS companies.

Read article
Sensitivity Analysis in Excel: Data Tables, Scenarios, and Goal Seek
Excel Techniques9 min

Sensitivity Analysis in Excel: Data Tables, Scenarios, and Goal Seek

Master sensitivity analysis techniques in Excel: one-variable data tables, two-variable data tables, scenario toggles, Goal Seek, and tornado charts. Includes worked examples and best practices for financial modeling.

Read article
How to Build a Startup Financial Model from Scratch
Founders12 min

How to Build a Startup Financial Model from Scratch

A comprehensive guide to building a startup financial model for fundraising, covering revenue forecasting, headcount planning, burn rate, and runway calculations.

Read article
DCF vs LBO vs 3-Statement: Which Financial Model Should You Use?
Model Deep-Dives10 min

DCF vs LBO vs 3-Statement: Which Financial Model Should You Use?

Compare DCF, LBO, and 3-statement financial models side-by-side. Learn the purpose, mechanics, and real-world use cases for each model to choose the right one for your analysis.

Read article
Excel Financial Modeling Best Practices: Structure, Formatting, and Conventions
Best Practices11 min

Excel Financial Modeling Best Practices: Structure, Formatting, and Conventions

Master the structure, color conventions, formula standards, and naming conventions that separate investment-bank-grade models from amateur spreadsheets. Learn FAST, error checks, and audit trail best practices.

Read article

Go further

Build the financial model you need with Fina AI

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview
Career Principles

Learn Financial Modelling Skills with industry-leading Career Principles

Breaking into the finance industry? Explore courses in Excel, financial modeling, valuation, data analytics, and AI for business and finance.

Career Principles lesson on preparing a cash flow statement in Excel
Career Principles Financial Analyst Program
Career Principles Python for Data Analysis
Career Principles AI for Business and Finance course