Set your own assumptions and see how DISTRESS DEAL: 2-BR IN AGUA 2 behaves as a cash purchase, the same purchase mortgaged, or a capital-only resale.
Listed
3 August 2026
The date this listing was added to our records. The asking price below is the one published then, and was still 0 days old when we last checked this listing on 3 August 2026. It is not re-checked against the market automatically, so confirm it with us before relying on it.
Asking price per sq.ft
AED 2,283/sqft
The asking price divided by the stated size. Compare it against registered sales in the same building before deciding whether the asking price is competitive.
Total cash investediThe purchase price plus every cost of getting the keys. It is the denominator of the ROI, ROE and IRR figures.
AED 3.08M
Price plus every acquisition cost
Illustrative exit price
AED 2.90M
After 5 yr at 0.0% p.a.
Total profit, capital onlyiCapital movement over the hold, less every purchase and sale cost and the service charge. It carries no rental income at all, because no rent has been set.
—
Set service charge, maintenance & management, vacancy allowance above
Net yieldiNet operating income (rent collected less management, maintenance and service charge) divided by the purchase price. It cannot be calculated until a gross annual rent is set.
—
Set a gross annual rent
Cash out, and cash back over 5 years
Cash out at t0AED 3,076,900
Set service charge, maintenance & management, vacancy allowance above to see cash back — until then this figure would be assuming zero for them.
Cash required at completion
Purchase priceAED 2,900,000
DLD transfer fee (4%)AED 116,000
Agency fee (2%)AED 58,000
VAT on agency fee (5%)AED 2,900
Conveyancing, trustee & adminAED 0
Total cash investedAED 3,076,900
This is the ROI and IRR denominator: the price plus every cost of getting the keys, not the price alone.
No rental evidence is held for this unit. The rent figure is yours to set — we have not assumed one. Until you enter a gross annual rent, the yield, ROI/ROE and IRR figures reflect capital movement and costs only.
Annual operating position
Gross annual rentAED 0
Vacancy allowance (not set)—
Maintenance & management (not set)—
Service charge (1,270 sq ft at AED — not set)—
Net operating income—
Figures marked “—” need service charge, maintenance & management, vacancy allowance entered above — we do not compute them on an assumed zero.
Cash-flow schedule — the 5-year figures the IRR is solved from (incomplete — see note)
| Year | Net operating income | Sale proceeds, net | Net cash flow |
|---|
| 0 · today | — | — | −AED 3,076,900 |
| 1 | AED 0 | — | AED 0 |
| 2 | AED 0 | — | AED 0 |
| 3 | AED 0 | — | AED 0 |
| 4 | AED 0 | — | AED 0 |
| 5 | AED 0 | AED 2,839,100 | AED 2,839,100 |
| Years 1–5 | AED 0 | AED 2,839,100 | AED 2,839,100 |
Exit at year 5: illustrative sale price AED 2,900,000 less selling costs AED 60,900 = AED 2,839,100 net. The final column is the schedule the IRR is solved from. Rent is held flat in nominal terms — the rent-growth field is at 0% — as is the service charge, so no inflation is assumed on either side. This audit table is arithmetic, so every row must resolve to a number — but service charge, maintenance & management, vacancy allowance are not set above, and the figures here currently assume zero for them. Nothing on this table should be read as a result until you set them; the headline tiles above withhold theirs for exactly this reason.
Sensitivity — the same purchase at −5% to +5% exit growth
| Exit growth | Exit price | Total profit | ROI | IRR |
|---|
| −5% p.a. | AED 2.24M | — | — | — |
| −3% p.a. | AED 2.49M | — | — | — |
| 0% p.a.your figure | AED 2.90M | — | — | — |
| 3% p.a. | AED 3.36M | — | — | — |
| 5% p.a. | AED 3.70M | — | — | — |
Each row re-runs the whole model with only the exit growth rate changed, over the same 5-year hold. The 0% and negative rows are not a worst case — they are simply what the same purchase returns if prices do not rise. Dubai prices have fallen in the past and can fall again. The return columns are shown as “—” until a gross annual rent is set; the total profit column reflects capital movement, purchase and sale costs and the service charge only.
How each figure is calculated
- Handover
- The date the unit is handed over, set in quarters from purchase. Gross rent, the vacancy allowance, maintenance and management, and the service charge all start there and not before — an unbuilt unit cannot be let and is not billed. The year handover falls in gets the exact fraction it is entitled to, not a rounded whole year. Capital growth is not treated this way: it compounds from today across the whole hold, because an off-plan unit can be sold before it completes. Where the holding period ends before handover, there is no operating income anywhere in the schedule and the whole return is capital movement less costs.
- Gross yield
- Gross annual rent ÷ purchase price. Before every cost. Where handover is in the future this is a stabilised full year from handover — a rate on the price, not a figure reduced by the construction period. The schedule shows what each year actually books.
- Net yield
- (Rent collected after the vacancy allowance − maintenance and management − service charge) ÷ purchase price. Stabilised on the same basis as the gross yield.
- Rent growth
- Compound annual movement in gross rent, applied from handover and stepping at each anniversary of it, which is when a tenancy renews. It may be negative. It does not touch the service charge, which is held flat in nominal terms.
- ROI
- Total profit over the whole hold ÷ total cash invested (price + all acquisition costs). Unlevered. Not an annual rate.
- ROE
- Total profit over the whole hold ÷ equity contributed (deposit + all acquisition and finance costs), after debt service. Levered. Not an annual rate.
- Cash-on-cash return
- Year-one operating cash flow, after debt service where there is a mortgage, ÷ cash invested. Reported separately from ROI/ROE and never merged with it. Year one means the first year of the schedule as it stands: where that year falls before handover it carries no rent, so on a mortgaged off-plan purchase the figure is negative — that is the year you fund out of pocket, and it is shown rather than smoothed away.
- IRR
- The annualised rate that discounts the dated cash-flow schedule above to a net present value of zero, solved numerically. Where the schedule has no sign change, or the solver does not converge on a single meaningful rate, we print “—” rather than substitute a simpler annualised-return figure.
Email my results
We’ll send this scenario — your assumptions and the figures they produce — to your inbox.
Set service charge, maintenance & management, vacancy allowance above and we can email you this scenario. Until then every headline figure reads “—”, because the model would otherwise be assuming zero for them — and we publish no figure for them.
An illustrative model, not a forecast, a valuation, an offer or investment advice. Every figure is generated from the assumptions on this page — some yours, the rest stated defaults, not promises. Rents, service charges, fees, vacancy, handover dates, financing terms and sale prices vary by unit and over time; past prices are not a guide to future prices. Returns are not guaranteed and capital is at risk.
Mortgage availability, loan-to-value, rate and term are subject to lender criteria and underwriting; nothing here indicates that finance will be offered. Figures exclude any tax payable in your country of residence — take independent financial, tax and legal advice before committing. Mitchell's Commercial Real Estate is a trading brand; the RERA-licensed broker is Stephen James Mitchell, BRN 68593.