$1,068/sq ft ask · $731,250 licence · $193,463 buyer duty
Bermuda · Astra High Model 6
A five-year forecast, expressed in price per square foot.
This model keeps Astra’s fixed five-year expenses and printed comparable assumptions intact, then translates every entry, exit and return threshold into both total value and price per advertised square foot.
NO BUY
At +5.0% annual appreciation, the modeled cash IRR is -2.0% versus a +5.0% target. Astra’s report concluded NO BUY at the $5.85M ask for a high-confidence five-year return.
Forecast inputs
Fixed High Model 6 baseline
The expense schedule is locked. The displayed five-year total is Astra’s reported rounded figure; live annual rows use $125,000 in year one and 2.5% escalation.
Entry, exit and required PSF
$1,363/sq ft · $6.80M net · -2.0% cash IRR
$1,892/sq ft required for +5.0% cash IRR
Astra’s printed PSF comparison
Current and forecast Bacardi ratios are shown against Astra’s five asking-price comparisons. None is a qualified closed sale with verified consideration and consistently measured area.
Modeled five-year exit
$1,363/sq ft+5.0% annual appreciation; not an Astra prediction.
Te Koko
$1,346/sq ftStructured field says 6,500 sq ft; narrative says over 5,500 interior sq ft.
Caper Collis
$1,150/sq ftThe 6,000 sq ft describes the main house; separate pool-house accommodation may be additional.
Bacardi on the Rocks
$1,068/sq ftAdvertised total area; measured interior area still needs reconciliation.
Glebe House
$915/sq ftLarger, elevated, multi-level home near Tucker’s Town; a value-per-foot control, not a budget equivalent.
Walsingham
$779/sq ftListing also describes a 6,000 sq ft residence; at that area Bacardi’s premium is 29.4%.
Five-year schedule
| Year | Gross value | PSF | Annual expense | Cumulative expense |
|---|---|---|---|---|
| Year 1 · 2027 | $6,142,500 | $1,121 | $125,000 | $125,000 |
| Year 2 · 2028 | $6,449,625 | $1,177 | $128,125 | $253,125 |
| Year 3 · 2029 | $6,772,106 | $1,236 | $131,328 | $384,453 |
| Year 4 · 2030 | $7,110,712 | $1,298 | $134,611 | $519,064 |
| Year 5 · 2031 | $7,466,247 | $1,363 | $137,977 | $657,041 |