Villa Development Financial Dashboard - Ghana

Comparative Analysis: 1.5 Acres (9 Villas) vs 2 Acres (14 Villas)

1.5 Acres - Low Land Cost
+$944K
1.5 Acres - High Land Cost
-$106K
2 Acres - Low Land Cost
+$3.32M
2 Acres - High Land Cost
+$1.92M
LINE ITEM 1.5 Acres
Low ($3.5M/acre)
1.5 Acres
High ($4.2M/acre)
2 Acres
Low ($3.5M/acre)
2 Acres
High ($4.2M/acre)
REVENUE
Large Villas @ $2,000,000 9 units 9 units 12 units 12 units
Executive Villas @ $1,800,000 - - 2 units 2 units
TOTAL REVENUE $18,000,000 $18,000,000 $27,600,000 $27,600,000
HARD COSTS
Land Acquisition
Land Purchase $5,250,000 $6,300,000 $7,000,000 $8,400,000
Construction Costs
Villa Construction $7,425,000 $7,425,000 $11,025,000 $11,025,000
1.5 Acres: 9 large × 550 sqm × $1,500 (9 villas) (9 villas) - -
2 Acres: 12 large + 2 executive - - (14 villas) (14 villas)
Infrastructure & Amenities
Internal Roads (24 ft width) $300,000 $300,000 $400,000 $400,000
Clubhouse (300 sqm @ $800/sqm) $240,000 $240,000 $240,000 $240,000
Security Gate $50,000 $50,000 $50,000 $50,000
Generator System $80,000 $80,000 $100,000 $100,000
Internal Lighting $120,000 $120,000 $150,000 $150,000
Underground Water Reservoir $150,000 $150,000 $200,000 $200,000
Landscaping $200,000 $200,000 $250,000 $250,000
Site Preparation & Grading $100,000 $100,000 $130,000 $130,000
Utilities Installation $180,000 $180,000 $240,000 $240,000
Subtotal Infrastructure $1,420,000 $1,420,000 $1,760,000 $1,760,000
TOTAL HARD COSTS $14,095,000 $15,145,000 $19,785,000 $21,185,000
SOFT COSTS
Marketing (3% of revenue) $540,000 $540,000 $828,000 $828,000
Professional Fees (2% of revenue) $360,000 $360,000 $552,000 $552,000
General & Admin (0.5% of revenue) $90,000 $90,000 $138,000 $138,000
Contingency (5% of revenue) $900,000 $900,000 $1,380,000 $1,380,000
Finance Costs (8% p.a. × 1.5 years × construction) $891,000 $891,000 $1,323,000 $1,323,000
Calculation: 12% × construction cost 12% × $7.43M 12% × $7.43M 12% × $11.03M 12% × $11.03M
Legal & Permitting (1% of revenue) $180,000 $180,000 $276,000 $276,000
TOTAL SOFT COSTS $2,961,000 $2,961,000 $4,497,000 $4,497,000
TOTAL COSTS $17,056,000 $18,106,000 $24,282,000 $25,682,000
NET PROFIT/(LOSS) $944,000 ($106,000) $3,318,000 $1,918,000
PROFIT MARGIN 5.2% -0.6% 12.0% 6.9%
Total Cost per Villa (Average) $1,895,111 $2,011,778 $1,734,429 $1,834,429
Profit per Villa (Average) $104,889 ($11,778) $237,000 $137,000
Revenue Mix (2 Acres) - - Large: $24M
Exec: $3.6M
Large: $24M
Exec: $3.6M

PROJECT VIABILITY ASSESSMENT

1.5 Acres - Low Land
$944K
VIABLE - 5.2%
1.5 Acres - High Land
($106K)
NOT VIABLE
2 Acres - Low Land
$3.32M
HIGHLY VIABLE - 12.0%
2 Acres - High Land
$1.92M
VIABLE - 6.9%