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 Type Optional Model Type Optional Levered Optional Hold Period Years Optional Deal Inputs Optional 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.