Everyone knows the drill. You open Excel, lay out Year 0 to N, start wiring investment and operating lines, then build a reversion and returns panel. Forty five minutes later you are still checking signs and links. The friction is not the math. It is the setup. Small inconsistencies creep in, and each new deal means repeating the same build before you can test a single assumption. Underwriting ~10 min to run Build a 10-Year DCF Model from Scratch Vic prompt Use Vic to build a 10-year DCF for a 120-unit multifamily acquisition. Purpose A human analyst needs about 60 minutes to build the same model. CRE Agents completes it in about 10 minutes so you can move straight to running scenarios on live deals. Inputs Property Type Optional Model Type Optional Levered Optional Hold Period Years Optional Deal Inputs Optional Outputs A ready-to-use .xlsx file with separate sections for investment, operating line items, and reversion, plus unlevered and levered cash flow lines and a returns and risk panel. Time saved Turns roughly an hour of manual work into about ten minutes. How it works Run the task with a simple command: Use Vic to build a 10-year DCF for a 120-unit multifamily acquisition. You can add inputs like property type, model type, whether to include debt, the hold period, and any deal details you already have. Keep it light and you still get a clean structure ready for assumptions. The output is a ready to use .xlsx file. It is organized into clear sections: investment, operating line items, and reversion from Year 0 through the hold. The model includes unlevered and levered cash flow lines, so you can see property level performance and the impact of debt without rebuilding anything. You also get a returns and risk panel. It shows IRR and equity multiple for the equity story, plus DSCR and debt yield for the credit side. These tie to the underlying cash flows, not static cells, so changes to rents, expenses, or exit assumptions flow through cleanly. Under the hood, the build follows a standard underwriting structure. Operating lines map to a consistent chart of accounts. The debt side includes amortization, so levered cash flows and coverage metrics move as you adjust terms. Number formatting and layout are consistent, which matters when you share models internally. The gain is time. A human analyst often spends an hour to stand up the same framework before any real thinking starts. This task produces it in about ten minutes. Use that gap to test rent growth, pressure expenses, and sanity check exit assumptions instead of aligning columns and fixing broken links. It also cuts the quiet risk from one off builds. When the structure stays the same across deals, you can compare outputs without wondering if a formula changed or a line item moved. You still own the assumptions and the judgment. The model stays out of the way. Use it as your default starting point. Drop in your deal inputs, run scenarios, and move on. The goal is not a fancier spreadsheet. It is getting to an answer you trust with less setup every time.