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.

Five-year investment verdict

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

Hold
5 years
Year-one expenses
$125,000
Five-year costs
$657,041
Cost inflation
+2.5%
Licence rate
+12.5%
Selling friction
+5.5%

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

Current entry
$6.82M all-in

$1,068/sq ft ask · $731,250 licence · $193,463 buyer duty

Modeled five-year exit
$7.47M gross

$1,363/sq ft · $6.80M net · -2.0% cash IRR

Target-return threshold
$10.36M gross

$1,892/sq ft required for +5.0% cash IRR

Cash break-even sale
$8.21M · $1,499/sq ft
Five-year carrying costs
$657,041
Nominal cash profit
$-679,010

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 ft

Structured field says 6,500 sq ft; narrative says over 5,500 interior sq ft.

Caper Collis

$1,150/sq ft

The 6,000 sq ft describes the main house; separate pool-house accommodation may be additional.

Bacardi on the Rocks

$1,068/sq ft

Advertised total area; measured interior area still needs reconciliation.

Glebe House

$915/sq ft

Larger, elevated, multi-level home near Tucker’s Town; a value-per-foot control, not a budget equivalent.

Walsingham

$779/sq ft

Listing also describes a 6,000 sq ft residence; at that area Bacardi’s premium is 29.4%.

Five-year schedule

YearGross valuePSFAnnual expenseCumulative 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
Evidence boundary. Price and area figures are printed asks and advertised denominators, not verified sale evidence or an appraisal. Slider outputs are ValueAtlas arithmetic using Astra’s fixed assumptions; they are not new Astra conclusions or investment advice.