Mixed-Use Tower Financial Model
Budget: $250 – $750 USD
I need a detailed yet user-friendly financial model for a mixed-use tower in Riyadh that will be structured through a CMA-licensed real estate investment fund. The building combines office, residential, commercial and hotel space, and I want to see clearly how each of these streams shapes the numbers.
Your model must:
• Walk from land acquisition and construction costs through stabilisation and eventual exit, then flow into a complete cash-flow schedule.
• Calculate IRR, ROI and ROE automatically once key variables are entered.
• Separate results for the four uses (office, residential, commercial, hotel) while still rolling them up into an overall project view.
• Allow quick scenario toggling—lease rates, occupancy, cap-rates, financing terms—so I can stress-test assumptions on the fly.
• Present summary dashboards and graphs that help me brief the Capital Market Authority investment committee quickly.
I work mainly in Excel, so please build the model there and keep formulas transparent; no hidden sheets or hard-coded cells. If you prefer Power BI for visual outputs, link it back to the Excel spine so updates flow automatically.
Deliver the working spreadsheet, a concise write-up of core assumptions, and a one-page sensitivity table highlighting break-even points. I’ll supply any missing market data once we start.
Your model must:
• Walk from land acquisition and construction costs through stabilisation and eventual exit, then flow into a complete cash-flow schedule.
• Calculate IRR, ROI and ROE automatically once key variables are entered.
• Separate results for the four uses (office, residential, commercial, hotel) while still rolling them up into an overall project view.
• Allow quick scenario toggling—lease rates, occupancy, cap-rates, financing terms—so I can stress-test assumptions on the fly.
• Present summary dashboards and graphs that help me brief the Capital Market Authority investment committee quickly.
I work mainly in Excel, so please build the model there and keep formulas transparent; no hidden sheets or hard-coded cells. If you prefer Power BI for visual outputs, link it back to the Excel spine so updates flow automatically.
Deliver the working spreadsheet, a concise write-up of core assumptions, and a one-page sensitivity table highlighting break-even points. I’ll supply any missing market data once we start.