Site
GFA
NSA
Units
NSA/GFA %
GFA/GBA %
GBA
NSA/GBA %
Margin 0%
Project IRR 0%
Total Dev Cost $0
Peak Funding $0
Equity IRR 0%
Return on Equity 0%
NPV (10%) $0
Land Price $0
Project Timeline
Total: 18 months
Acquisition
M0-M0
DA/Approval
M1-M4
Construction
M4-M16
Settlement
M16-M18
Acquisition
M to M
DA / Approval
M to M
Construction
M to M
Settlement
M to M
Holding Period
M to M
Financing Structure
Equity Limit
$
Equity Rate
% p.a.
Debt Limit
$
Debt Rate
% p.a.
Project Cashflow
Cost Item Amount Metric Rate Start Span S Monthly Cashflow →
1. ACQUISITION
Purchase Price
Stamp Duty
Legal Fees
Other Acquisition
2. DEVELOPMENT
Construction Cost
Demolition
Professional Fees
Contingency
Authority Fees
Marketing Costs
Admin & O/H
Dev. Mgmt 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
Establishment: %
Line Fee: % p.a.
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