|
1. ACQUISITION
|
| Purchase Price |
|
|
|
|
|
|
|
Stamp Duty
|
|
|
|
|
|
|
| Legal Fees |
|
|
|
|
|
|
| Other Acquisition Costs |
|
|
|
|
|
|
|
2. DEVELOPMENT
|
| Construction Cost |
|
|
|
|
|
|
| Demolition |
|
|
|
|
|
|
| Professional Fees |
|
|
|
|
|
|
| Contingency |
|
|
|
|
|
|
| Authority Fees |
|
|
|
|
|
|
| Marketing Costs |
|
|
|
|
|
|
| Admin & O/H Costs |
|
|
|
|
|
|
| Development Management Fees |
|
|
|
|
|
|
| TOTAL DEVELOPMENT COST (TDC) |
$0 |
| 3. REVENUE |
| Gross Revenue (GDV) |
|
|
|
Static figure |
| Less: Selling Costs |
|
|
|
Applied to net revenue |
| Less: GST on Sale |
|
|
|
Applied to net revenue |
| Less: Agent Commissions |
|
|
|
Applied to net revenue |
| NET REVENUE |
$0 |
GDV - Deductions |
|
|
|
| PROJECT CASHFLOW |
Net Revenue - Costs (before financing) |
| 4. FINANCING |
| 4.1 EQUITY FACILITY |
| Facility Limit |
% of TDC =
$0
|
|
| Interest Rate |
% p.a. (capitalizing monthly)
|
|
| Opening Balance |
Calculated |
| Drawdown |
Auto-calculated from costs |
| Interest |
Balance × Rate / 12 |
| Repayment |
At project completion |
| Equity Cashflow (Monthly) |
Monthly: -Drawdown - Interest + Repayment |
| Equity Cashflow (Cumulative) |
Cumulative: -Drawdown - Interest + Repayment |
| 4.2 SENIOR DEBT FACILITY |
| Facility Limit |
=
$0
→
Max Limit:
|
|
| Interest Rate |
% p.a. (capitalizing monthly)
|
|
| Fees |
|
|
| Opening Balance |
Calculated |
| Drawdown |
Auto-calculated from costs |
| Establishment Fee |
One-time upfront fee |
| Line Fee |
Monthly commitment fee |
| Interest |
Balance × Rate / 12 |
| Repayment |
At project completion |
| Loan Cashflow (Cumulative) |
Cumulative: -Drawdown - Interest + Repayment |