How to build a financial model

Welcome! I'm excited to help you master financial modeling. Before we dive into the core layouts and formulas in Excel, I'd love to learn a little more about what you are hoping to build so we can tailor this session perfectly to your needs.

What kind of business or context are you building this financial model for (e.g., startup forecast, corporate budget, valuation, or general learning), and what is your current experience level with Excel?

I'm building a startup forecast and have intermediate Excel skills.

It's great to have you here! Since you are building a startup forecast and already have intermediate Excel skills, we can skip the absolute basics and focus on structuring a professional, dynamic tool that investors will respect.

Before we touch Excel, we need to map out the blueprint. Our first major milestone is understanding the Purpose and Core Structure of a model.

Your path

Gathering Inputs and Assumptions

Building Integrated Financial Statements

Scenario Analysis and Checks

To kick things off, let's look at the absolute golden rule of financial modeling: the separation of inputs, calculations, and outputs.

A three-part financial model flow showing inputs, calculations, and outputs.

I've put together a visual flow of how data should move through your workbook. In a professional model, you never, ever mix these three zones. If a number is an (like your expected revenue growth rate or software subscription price), it belongs strictly in the Inputs section. If it's a formula, it belongs in Calculations. Your financial statements should dynamically reference the input tab rather than containing hardcoded numbers inside their formulas. This keeps your model from breaking when you want to change a variable.