UAE Off-Plan ROI Calculator: A Template You Can Steal

Off-plan buyers in Dubai and Abu Dhabi often discover too late that headline ROI figures ignore payment schedules, opportunity cost of staged deposits, and the gap between purchase price and actual handover value. This template fixes the calculation by folding in RERA escrow timelines, current 2026 AED pricing across Marina, Business Bay and MBR City, and realistic post-handover yields reported on Bayut and Property Finder.

Why a simple percentage return misleads off-plan investors

Most online calculators treat the full purchase price as invested from day one. In practice, RERA-regulated projects release payments in five to seven tranches tied to construction milestones. A typical 60/40 payment plan on a 1.8 million AED two-bedroom in JLT spreads deposits over 36 months, leaving roughly 55 percent of capital free for other uses until handover.

Early payments are usually 10 percent on booking and another 10 percent within 60 days.
Subsequent 20 percent tranches align with foundation, superstructure and fit-out stages.
Final 10 percent is due on handover, often 36-48 months after launch.

Building the payment-timing schedule

Start with the project’s RERA escrow account number, published on the DLD portal. Enter each milestone date and the corresponding AED amount. The template then calculates the weighted average capital deployed, adjusting for the months each tranche sits in the project rather than in a 4.5-5.25 percent fixed deposit offered by local banks in 2026.

Column A: milestone description (booking, foundation, superstructure, etc.).
Column B: expected completion quarter (Q2 2027, Q4 2027, etc.).
Column C: percentage of total price due.
Column D: absolute AED figure.
Column E: months capital is committed.

Factoring opportunity cost and capital appreciation

Opportunity cost is calculated by applying the prevailing one-year fixed-deposit rate to the un-deployed balance each quarter. In our experience, investors who model this correctly reduce projected IRR by 180-240 basis points on a typical Marina off-plan purchase. Capital appreciation is entered as an annual percentage range (typically 4-7 percent) drawn from Bayut’s last 12-month median price movement for comparable ready units in the same community.

For Saadiyat Island and Aljada launches, appreciation assumptions should be tempered by limited transaction data. Use the lower end of the range unless the master developer publishes verified absorption rates above 70 percent within the first six months.

Post-handover net yield and service-charge drag

Once the unit is handed over, the template switches to a rental yield worksheet. Pull current asking rents from Property Finder and Dubizzle for similar units in the building, then subtract DEWA, Etisalat internet and chilled-water charges where applicable. Service fees in Business Bay towers commonly range between 18 and 24 AED per square foot per year; MBR City townhouses sit closer to 12-15 AED.

Expected gross rent: 110,000-125,000 AED for a 1,050 sq ft two-bedroom.
Annual service charge: 20,000-25,000 AED.
Net operating income after 5 percent agency and maintenance reserve.
Cap rate applied to residual equity after final 10 percent payment.

Using the template with live listings

Export the latest off-plan price list from the developer’s portal and paste unit numbers, sizes and payment schedules into the first tab. The second tab automatically recalculates weighted capital, opportunity cost and post-handover yield for every unit. Save the file with the project name and RERA number so future price revisions can be version-controlled. Cross-check final figures against DLD transaction data for the same master community to confirm your appreciation assumptions remain within observed market bands.

Stop typing. Start closing.

Generate property listings, follow-up emails, WhatsApp templates, and CMA reports in seconds. Free tier: 5 generations/month, no card needed. Try AgentsAI free →