I will build dynamic real estate acquisition dcf model

About This Gig

Are you evaluating a commercial real estate deal, preparing a pro forma for investors, or needing a broken financial spreadsheet audited? I build clean, dynamic, institutional-grade financial models and real estate acquisition pro formas in Microsoft Excel and Google Sheets.

Whether you need a quick formula fix, a 5-year operating pro forma, or a full discounted cash flow (DCF) model with debt schedules and return metrics, I deliver ready-to-use tools tailored to your deal.

What I Provide:

• Dynamic Operating Pro Forma: Gross Potential Rent, Vacancy Loss, Effective Gross Income, and line-item OpEx schedules with custom annual growth rates.
• Debt Amortization Schedule: Automated debt service, LTV modeling, interest rates, and loan payoff calculations.
• Return & Valuation Metrics: Levered & Unlevered IRR, Equity Multiples, Cash-on-Cash returns, and Net Exit Proceeds using exit cap rate capitalization.
• Sensitivity Analysis: Dynamic multi-variable matrix tables analyzing returns across changing purchase prices and exit cap rates.
• Spreadsheet Audit & Repair: Diagnostic cleanup for formula errors, broken logic, or miscalculated cash flow schedules.

Why Work With Me?

• Clean Form