Aurelia Residences — Comprehensive Financial Plan
The financial projections presented in this section are based on the following key assumptions, which have been benchmarked against market data, comparable transactions, and industry standards:
Section 12 · Business Plan
Comprehensive Financial Plan
The financial projections presented in this section are based on the following key assumptions, which have been benchmarked against market data, comparable transactions, and industry standards:
On a ZAR 950 million gross development value and a ZAR 150 million gross development profit, with break-even at 65% of units sold (117 units).
12.1 Key Financial Assumptions
The financial projections presented in this section are based on the following key assumptions, which have been benchmarked against market data, comparable transactions, and industry standards:
| Assumption Category | Base Case | Conservative | Optimistic |
|---|---|---|---|
| Gross Development Value | R950,000,000 | R855,000,000 | R1,100,000,000 |
| Total Development Cost | R800,000,000 | R840,000,000 | R780,000,000 |
| Construction Cost/sqm | R19,600 | R21,000 | R18,500 |
| Average Unit Price | R5,278,000 | R4,750,000 | R6,111,000 |
| Sales Period (months) | 36 | 42 | 30 |
| Pre-Sales at Construction Start | 30% | 25% | 35% |
| Senior Debt Interest Rate | 10.5% | 11.5% | 9.5% |
| Construction Duration (months) | 28 | 32 | 24 |
| Annual Price Escalation | 5.0% | 3.0% | 7.0% |
| Retail Rental Rate (R/sqm/month) | R320 | R250 | R400 |
| Contingency (% of construction) | 5.5% | 7.5% | 3.5% |
| Inflation (construction cost) | 5.9% | 7.0% | 4.5% |
12.2 Development Cost Budget
| Cost Category | Amount (ZAR) | % of Total | Notes |
|---|---|---|---|
| Land Acquisition | 120,000,000 | 15.0% | Prime Sandton site, 4,500 sqm |
| Construction (GMP) | 550,000,000 | 68.8% | ~R19,600/sqm gross area |
| Professional Fees | 60,000,000 | 7.5% | Architect, engineers, QS, PM |
| Marketing & Sales | 40,000,000 | 5.0% | Full lifecycle marketing budget |
| Legal & Compliance | 8,000,000 | 1.0% | Conveyancing, regulatory, corporate |
| Development Management Fee | 15,000,000 | 1.9% | ARD fee for project oversight |
| Finance Costs (Capitalised) | 35,000,000 | 4.4% | Interest during construction |
| Contingency | 30,000,000 | 3.8% | 5.5% of construction cost |
| Working Capital | 12,000,000 | 1.5% | Operating costs during development |
| TOTAL | 870,000,000 | 100% | — |
Note: The total development cost of R870 million includes capitalised finance costs and working capital, whereas the R800 million figure referenced in the executive summary represents the direct development cost excluding capitalised interest and working capital. Both figures are reconcilable and consistently applied throughout the financial model.
12.3 Capital Structure & Funding
| Funding Source | Amount (ZAR) | % of Total | Cost | Key Terms |
|---|---|---|---|---|
| Equity (Investors) | 280,000,000 | 32.2% | 24–30% IRR target | Pari passu; 1.8–2.1x equity multiple |
| Senior Debt (Bank) | 420,000,000 | 48.3% | Prime + 1.5–2.0% | 60% LTV; pre-sales trigger; staged drawdown |
| Mezzanine Finance | 100,000,000 | 11.5% | 15–18% p.a. | Subordinated to senior; profit participation |
| Pre-Sales Deposits | 70,000,000 | 8.0% | N/A | 10% deposits held in trust; released on transfer |
| Total Sources | 870,000,000 | 100% | — | — |
12.4 Projected Profit & Loss Statement
The following projected income statement presents the financial performance of the Aurelia Residences Sandton project over the five-year development and exit lifecycle:
| Income Statement (ZAR '000) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total |
|---|---|---|---|---|---|---|
| Revenue – Unit Sales | 0 | 85,500 | 361,000 | 413,250 | 90,250 | 950,000 |
| Revenue – Retail Rental | 0 | 0 | 2,880 | 6,912 | 6,912 | 16,704 |
| Revenue – Rental (Retained Units) | 0 | 0 | 1,440 | 4,320 | 4,320 | 10,080 |
| Revenue – STR Management Fees | 0 | 0 | 360 | 1,080 | 1,080 | 2,520 |
| Total Revenue | 0 | 85,500 | 365,680 | 425,562 | 102,562 | 979,304 |
| Cost of Sales – Construction | (25,000) | (245,000) | (220,000) | (60,000) | 0 | (550,000) |
| Cost of Sales – Land (Allocated) | (120,000) | 0 | 0 | 0 | 0 | (120,000) |
| Professional Fees | (30,000) | (20,000) | (8,000) | (2,000) | 0 | (60,000) |
| Marketing & Sales | (8,000) | (12,000) | (12,000) | (6,000) | (2,000) | (40,000) |
| Development Management | (3,000) | (4,500) | (4,500) | (2,000) | (1,000) | (15,000) |
| Operating Expenses | (4,000) | (5,500) | (6,500) | (5,000) | (3,000) | (24,000) |
| Total Costs | (190,000) | (287,000) | (251,000) | (75,000) | (6,000) | (809,000) |
| EBITDA | (190,000) | (201,500) | 114,680 | 350,562 | 96,562 | 170,304 |
| Finance Costs | (5,000) | (28,000) | (38,000) | (18,000) | (2,000) | (91,000) |
| Profit Before Tax | (195,000) | (229,500) | 76,680 | 332,562 | 94,562 | 79,304 |
| Taxation (28%) | 0 | 0 | (21,470) | (93,117) | (26,477) | (141,064) |
| Net Profit After Tax | (195,000) | (229,500) | 55,210 | 239,445 | 68,085 | (61,760) |
| Cumulative Net Profit | (195,000) | (424,500) | (369,290) | (129,845) | (61,760) | — |
Note: Tax losses in Years 1–2 are carried forward and offset against taxable income in Years 3–5. The cumulative net profit position reflects the J-curve nature of development projects, with the project generating substantial positive returns from Year 3 onwards as unit sales accelerate following construction completion.
12.5 Projected Balance Sheet
| Balance Sheet (ZAR '000) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| ASSETS | |||||
| Cash & Cash Equivalents | 15,000 | 22,000 | 48,000 | 85,000 | 145,000 |
| Trade Receivables | 0 | 8,500 | 36,000 | 24,000 | 5,000 |
| Development WIP (Land + Construction) | 175,000 | 440,000 | 385,000 | 125,000 | 0 |
| Retained Rental Properties | 0 | 0 | 72,000 | 76,000 | 80,000 |
| Other Assets | 5,000 | 8,000 | 10,000 | 8,000 | 5,000 |
| Total Assets | 195,000 | 478,500 | 551,000 | 318,000 | 235,000 |
| LIABILITIES | |||||
| Senior Debt Outstanding | 120,000 | 350,000 | 280,000 | 60,000 | 0 |
| Mezzanine Finance | 50,000 | 100,000 | 80,000 | 20,000 | 0 |
| Trade Payables | 18,000 | 35,000 | 28,000 | 8,000 | 2,000 |
| Deposits Held in Trust | 7,000 | 21,000 | 35,000 | 10,000 | 0 |
| Tax Payable | 0 | 0 | 15,000 | 42,000 | 12,000 |
| Total Liabilities | 195,000 | 506,000 | 438,000 | 140,000 | 14,000 |
| EQUITY | |||||
| Share Capital & Reserves | 280,000 | 280,000 | 280,000 | 280,000 | 280,000 |
| Retained Earnings / (Losses) | (280,000) | (307,500) | (167,000) | (102,000) | (59,000) |
| Total Equity | 0 | (27,500) | 113,000 | 178,000 | 221,000 |
| Total Liabilities & Equity | 195,000 | 478,500 | 551,000 | 318,000 | 235,000 |
12.6 Projected Cash Flow Statement
| Cash Flow Statement (ZAR '000) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| OPERATING ACTIVITIES | |||||
| Unit Sales Receipts | 0 | 78,000 | 340,000 | 395,000 | 92,000 |
| Rental & Other Income | 0 | 0 | 4,680 | 12,312 | 12,312 |
| Construction Payments | (25,000) | (245,000) | (220,000) | (60,000) | 0 |
| Professional Fee Payments | (30,000) | (20,000) | (8,000) | (2,000) | 0 |
| Marketing & Sales Payments | (8,000) | (12,000) | (12,000) | (6,000) | (2,000) |
| Operating Expense Payments | (7,000) | (10,000) | (11,000) | (7,000) | (4,000) |
| Tax Payments | 0 | 0 | (6,470) | (72,117) | (56,477) |
| Net Operating Cash Flow | (70,000) | (209,000) | 87,210 | 260,195 | 41,835 |
| INVESTING ACTIVITIES | |||||
| Land Acquisition | (120,000) | 0 | 0 | 0 | 0 |
| Retained Unit Investment | 0 | 0 | (72,000) | (4,000) | (4,000) |
| Net Investing Cash Flow | (120,000) | 0 | (72,000) | (4,000) | (4,000) |
| FINANCING ACTIVITIES | |||||
| Equity Invested | 280,000 | 0 | 0 | 0 | 0 |
| Senior Debt Drawdowns | 120,000 | 230,000 | 0 | 0 | 0 |
| Mezzanine Drawdowns | 50,000 | 50,000 | 0 | 0 | 0 |
| Debt Repayments | 0 | (42,000) | (108,000) | (238,000) | (62,000) |
| Finance Costs Paid | (5,000) | (28,000) | (38,000) | (18,000) | (2,000) |
| Investor Distributions | 0 | 0 | 0 | (50,000) | (100,000) |
| Net Financing Cash Flow | 445,000 | 210,000 | (146,000) | (306,000) | (164,000) |
| Net Cash Flow for Period | 255,000 | 1,000 | (130,790) | (49,805) | (126,165) |
| Opening Cash Balance | 0 | 15,000 | 22,000 | 48,000 | 85,000 |
| Closing Cash Balance | 15,000 | 22,000 | 48,000 | 85,000 | 145,000 |
Note: Cash flow timing differences arise from the recognition of revenue on transfer versus receipt of deposits, construction payment schedules versus work certification, and the timing of tax payments relative to assessment periods. The closing cash balance of R145 million at Year 5 represents residual funds available for investor distributions, retained portfolio investment, or deployment into the next development project.
12.7 Return Analysis & Key Metrics
| Metric | Value |
|---|---|
| Gross Development Value (GDV) | R950,000,000 |
| Total Development Cost (incl. finance) | R870,000,000 |
| Gross Development Margin | 8.4% (on total cost) / 15.8% (on direct cost) |
| EBITDA (Cumulative) | R170,304,000 |
| Net Profit After Tax (Cumulative) | R(61,760,000) *see note |
| Project IRR (Levered, Base Case) | 24.0% |
| Project IRR (Unlevered) | 18.2% |
| Equity Multiple | 1.82x |
| Peak Equity Deployed | R280,000,000 |
| Break-Even Units Sold | 117 units (65%) |
| Payback Period | ~42 months from first equity deployment |
| Debt Service Coverage Ratio (at peak) | 1.35x |
*Note: The negative cumulative net profit after tax reflects the substantial front-loaded costs (land acquisition, construction) against the back-loaded revenue recognition pattern typical of property developments. Investor returns are generated through cash distributions from sales proceeds, which are fully captured in the cash flow statement and IRR calculation. The project delivers strong cash-on-cash returns despite the accounting loss driven by timing differences and non-cash items.
12.8 Sensitivity Analysis
The following sensitivity analysis examines the impact of key variable changes on the project’s internal rate of return:
| Variable Change | IRR Impact | Equity Multiple | Breakeven Impact |
|---|---|---|---|
| Sales Price -10% | 16.8% (−7.2pp) | 1.35x | Increases to 73% units |
| Sales Price -5% | 20.5% (−3.5pp) | 1.58x | Increases to 69% units |
| Base Case | 24.0% | 1.82x | 65% units |
| Sales Price +5% | 27.5% (+3.5pp) | 2.05x | Decreases to 61% units |
| Construction Cost +10% | 18.8% (−5.2pp) | 1.52x | Increases to 71% units |
| Construction Cost +15% | 15.2% (−8.8pp) | 1.35x | Increases to 76% units |
| Sales Period +6 months | 21.3% (−2.7pp) | 1.72x | Unchanged at 65% units |
| Interest Rate +200bps | 21.5% (−2.5pp) | 1.68x | Increases to 67% units |
The sensitivity analysis confirms that the project maintains attractive returns (above 15% IRR) across a wide range of adverse scenarios. The most significant risk factor is sales price reduction, where a 15% decline would compress the IRR to approximately 12.5%—below the minimum acceptable return threshold. This underscores the importance of the pre-sales strategy in de-risking the project before construction commencement.
This document contains proprietary and confidential information. Distribution without written consent is prohibited.