Commercial Real Estate DCF Model

I want a robust, fully linked discounted-cash-flow model built in Excel (or Google Sheets if you prefer) for a single commercial property. The end goal is to guide my operational decision-making, so the workbook must let me play with leasing assumptions, expense schedules, cap-ex plans, debt structures, and exit timing and immediately see the impact on cash flow, IRR, equity multiple, and valuation. Key elements I need to see: • Detailed rent roll section that rolls into revenue, vacancy, and credit-loss lines • Separate operating-expense and capital-expenditure schedules with monthly or annual granularity that I can toggle • Debt module that accommodates interest-only, amortizing, or refinance scenarios and feeds correctly into the cash-flow waterfall • Sensitivity tables or data-table toggles for at least rental growth, exit cap rate, and interest rate • Clear, well-labeled summary dashboard pulling the key metrics I’ll use for day-to-day decisions Please keep the formulas transparent—no hard-coded numbers outside a clearly marked assumptions tab—and organise the workbook so I can later duplicate it for mixed-use deals that combine retail, office, and residential components without rebuilding from scratch. Send the model unlocked, along with a short read-me or loom walkthrough showing how to adjust the main drivers and where each metric is calculated. I’ll consider the work complete once the file passes a quick stress test (changing any single assumption shouldn’t break links) and all outputs reconcile.

Projektin tunnus (ID): 40307264