Skip to content
CRE Agents LogoCRE Agents
All Posts
Underwriting

Stop rebuilding the same DCF from scratch

Spin up a clean 10-year model in minutes and move straight to pricing and scenarios.

VicVic
February 1, 20263 min read
Stop rebuilding the same DCF from scratch

You get a deal in your inbox and the first step is always the same. Open Excel, set up the timeline, lay out cash flow lines, wire returns, then check the math twice. None of that tells you what the deal is worth.

The drag is not the thinking. It is the repetition. Rebuilding a standard DCF takes time right when you want to test price, tweak assumptions, and decide whether to push.

Underwriting
~10 min to run
Build a 10-Year DCF Model in Excel
Vic prompt
Use Vic to build a 10-year DCF model in Excel for my deal inputs
Purpose
A completed model that normally requires 60 minutes of manual work is delivered in about 10 minutes, allowing faster iteration on pricing and scenario analysis before offers.
Inputs
Property TypeOptional
Model TypeOptional
LeveredOptional
Hold Period YearsOptional
Deal InputsOptional
Outputs
A single .xlsx file containing the complete DCF structure with cash flow lines and returns metrics. The file is formatted for direct entry of property-level assumptions.
Time saved
Turns roughly an hour of manual work into about ten minutes.

How it works

You give Vic a simple instruction with whatever detail you have. It can be as light as a property type and a headline number, or a fuller set of inputs. For example: Use Vic to build a 10-year DCF model in Excel for my deal inputs.

Vic returns a single .xlsx file with the structure in place. The model runs from Year 0 through the hold and includes the pieces you expect: upfront investment, annual operating cash flow, and an exit. Unlevered and levered views are both there, so you can see the deal with and without debt without reworking anything.

The cash flow section is mapped in a clean, consistent way. You are not hunting for where rent, expenses, or capital items go. Swap in your numbers and keep moving. You start from a working model, not a blank grid.

Debt follows the same approach. The file has the logic to produce levered cash flows and common credit metrics. Drop in loan terms and see the effect on DSCR and debt yield without building an amortization schedule.

On returns, the model calculates unlevered IRR, levered IRR, and equity multiple. They are tied to the cash flows already in the workbook, so changes to rent, expenses, capex, or exit assumptions flow through to returns. It is built for iteration, which is what you need when you are circling a price.

The output is ready to use. Numbers read cleanly, line items follow a standard order, and the structure is familiar to anyone who underwrites deals. You do not have to fix formatting before sharing it.

The gain is speed. A model that might take an hour to build is ready in about ten minutes. That shows up in how many scenarios you can run before a call, how fast you react to new information, and how often you check your own assumptions.

This does not replace judgment. It removes setup work so you can focus on rent, expenses, capital needs, and exit. If a deal moves, you have a model you trust and can adjust on the fly.

For teams, consistency helps. Starting from the same structure cuts noise when you compare deals or review someone else’s work. You are looking at the same lines and the same metrics each time, which makes discussions faster and more precise.

If your week includes more than one new deal, stop rebuilding the template. Start with a working DCF and get to a view on value while the opportunity is still fresh.

Vic

Written by

Vic

Vic is the seasoned CRE pro behind CRE Agents. He gives the AI you already use (Claude, ChatGPT, and more) the methods and data to do commercial real estate work well.