Finalize Real Estate Proforma Model

My Excel pro-forma is 80 % complete—revenue, construction costs, and operating assumptions are all there—but the cash-flow tab still needs work. I’m looking for a sharp Excel modeler to finish the remaining pieces so the file is decision-ready.

Here’s what’s left:

• Build out monthly and annual cash-flow schedules that flow from the existing inputs
• Add equity draw and return logic, including preferred return and promote tiers
• Automate project-level and investor-level IRR calculations
• Complete the waterfall distribution so proceeds cascade correctly through each tier

All placeholders for these items already sit in the workbook; you’ll be wiring the formulas and stress-testing for errors, not starting from zero. Keep the model clean—no circular references—and make every assumption clearly editable.

Deliverable: a polished .xlsx (no macros needed unless they streamline the waterfall, in which case comment them thoroughly) that I can immediately use for scenario analysis.

I’ll provide the current file plus a PDF of the capital structure once we begin and will be available for quick Zoom check-ins so you have the nuances. Looking to wrap this quickly, so let me know your turnaround time.