Mixed-Use Proforma (Fix Existing)

I’m looking for a real-estate analyst to help me fix & finalize a proforma for a mixed-use development (retail / residential). I already have a complete model, but I recently made some changes that caused some #REFs that I can't figure out.

The existing model includes project data, assumptions, rents, operating expenses, development costs, spending timeline, and a Cash Flow, which is where the #REFs appeared, affecting my ability to forecast income, financing & returns, derive metrics, etc.

I need this done as fast as possible. 1 week preferred. 2 weeks max. I will make myself available to answer any questions that come up and keep things moving.

Core objectives
• Fix existing #REFs; ensure the model clearly shows income, financing costs & investor returns
• Review my Cash Flow Analysis for errors and clarity; make any recommended changes
• Update Financing Costs
• If possible, add sensitivity toggles for rent, construction costs, debt structuring, equity waterfalls, so I can stress-test rents, vacancy, and exit cap rates.

Preferred structure
• Existing tabs: Project Data, Revenue & Expenses, Budget, Dev Spending, Cash Flow, Summary
• Dynamic formulas—no hard-coded numbers buried in the cells.

Deliverables
1. Editable Excel model.
2. Brief walkthrough video call explaining key inputs, links, and how to update scenarios.

Accuracy, transparency, and professional formatting are essential; I need to be able to rely on this proforma when pitching investors and lenders.