Current Forecast Input Assumptions
INPUT ASSUMPTIONS
Estate Master for Excel Designed by Hill PDA and Licensed to: Unlicensed
Code 1000
1002 1003 1007 1008 1009 1010 1011
Description Land Acquisition
Total Land Purchase Price Deposit in Trust Account Payment 1 Settlement (balance) Stamp Duty (NSW) Interest on Deposit in Trust Profit Share to Land Owner Legals and Valuation TOTAL
X
Input Mode
%
And/Or
No. Units
Current Base Rate / Unit
Term
Month Start
Month Span
Month Start
Month End
Escalate
DrawDown
GST
Pre-sales Exchanges Start Span
Land Use Code
O/G's & Vacancies $/unit/ann + %Rent
Tenancy Costs Letting Rent Free Fee% Months
Fitout Costs
Month Start
Residual Cap. Rate %
Terminal Capitalised Rent
GST on Cap. Value
Cash Flow / Input Variation
A A A A A A
10.00% of Total Land Purchase Price. 0.00%
(Assumes no GST on Stamp Duty)
16,000,000 14,400,000 865,490
Y 0 0 2 2 1 1 1 Sep-03 Sep-03 Oct-03 Oct-03 Sep-03 Sep-03 Oct-03 Oct-03 -
A
0.00% shared between seller and developer. 0.00% paid at project end. 4 1.00% of Total Land Purchase Price.
-
0
-
Sep-03
Sep-03
Y
-
% of Developer's purchase price spread evenly with land purchase payments.
2000 3000
3001 3002 3003 3004 3099
Project Contingency Professional Fees
. Pre-DA design Fees Documentation Project Mngmnt & Supervision Development Management TOTAL
X
A A A A A A
2.50% of construction, professional fees, contributions & misc. costs R 0.00% 2.50% 2.50% 3.00%
% of Construction Costs.
3
-
0 1 5 C C
4 3 -
Sep-03 Oct-03 Jan-04 Sep-03
Sep-03 Dec-03 Apr-04 Aug-05
-
Y Y Y Y Y
-
3.00% of Project Costs (exclude land & finance). ²
4000
4001 4002 4004 4005 4006 4007 4008 4009 4099
Construction Costs
. Demolition & Site clearing Residential Commercial Carparking - Residential Carparking - Commercial Landscaping (soft) Landscaping (hard) Construction Contingency TOTAL
X
A A A A A A A A A
1 15,000 5,000 195 57 3,000 3,000 5.00% of Construction Costs.
165,000 1,980 1,815 24,200 24,200 55 165
0 5 10 10 10 10 10 10
3 15 15 15 15 15 15
Sep-03 Jan-04 Jul-04 Jul-04 Jul-04 Jul-04 Jul-04 Jul-04
Sep-03 Apr-04 Aug-05 Aug-05 Aug-05 Aug-05 Aug-05 Aug-05 N
E E E E E E E
E S S S S S S
Y Y Y Y Y Y Y Y
-
5000
5001 5002 5003
Statutory Fees and Contributions
. Section 94 Charges - Residential Section 94 - Commercial Space TOTAL
X
R A A A 150 282 M 16,400 2,224 0 24 24 1 1 Sep-03 Aug-05 Aug-05 Sep-03 Aug-05 Aug-05 e e Y N N
6000
6001 6002 6004 6005 6007
Miscellaneous Costs
DA Fees CC Fees Project Legal Costs Completion Certification Accounting & Insurance TOTAL
X
A A A A A
0.00% 0.00% 0.00% 0.00% 0.00%
% of Construction Costs.
1 1 1 1 1 Q
27,500 27,500 33,000 22,000 110,000
4 7 8 24 8
1 1 2 1 17
Dec-03 Apr-04 May-04 Aug-05 May-04
Dec-03 Apr-04 May-04 Aug-05 Aug-05
-
Y Y Y Y Y
7000
7001 7002 7003 7005
Land Holding Costs
. Land Tax Rates Strata Levy TOTAL
X
A A A A S A A A A A A A A
1 1 150
270,213 9,360 450
Y Y Q Q
0 5 4 25
DS DS DS
Sep-03 Jan-04 Dec-03 Sep-05
Sep-03 Jun-06 Jun-06 Jun-06
R R R
Y N N N
8000
8001 8002 8003 8004 8002 8003 8004 8006
Selling Costs
Residential Sales Commission Retail Sales Commission Commercial Sales Commission Other Sales Commission . Pre-sales Marketing Marketing suite / sales office Legal costs on sales TOTAL
X
0.00% 0.00% 0.00% 0.25%
180 1 -
5,500 240,000 -
0 6 7 0
10 3 -
Sep-03 Mar-04 Apr-04 Sep-03
Sep-03 Nov-04 May-04 Sep-03
R E -
Y Y Y Y Y Y Y Y
% of Gross Sales Revenue Paid at Settlement.
File: Sample Management Model
Page 1 of 2 Pages
Date of Report: 15/07/2004 7:46 PM
Current Forecast Input Assumptions
INPUT ASSUMPTIONS
Estate Master for Excel Designed by Hill PDA and Licensed to: Unlicensed
Code 9000
9001 9002 9004 9005 9007 9008 9010 9011
Description Sales Revenue
. Commercial Levels 1 & 2 Residential Lvl 2-3 Presales Residential Lvl 2-3 Balance Residential Lvl 4 Presales Residential Lvl 4 Balance Residential Lvl 5-6 Presales Residential Lvl 5-6 Balance Capitalised Terminal Rent TOTAL
X
Input Mode
%
And/Or
No. Units
Current Base Rate / Unit
Term
Month Start
Month Span
Month Start
Month End
Escalate
DrawDown
GST
Pre-sales Exchanges Start Span
Land Use Code
O/G's & Vacancies $/unit/ann + %Rent
Tenancy Costs Letting Rent Free Fee% Months
Fitout Costs
Month Start
Residual Cap. Rate %
Terminal Capitalised Rent
GST on Cap. Value
Cash Flow / Input Variation
A A A A A A A A A
4,250 25 25 17 17 33 33
4,088 500,000 500,000 540,000 540,000 570,000 570,000
0 26 25 26 25 26 25 26
8 1 6 1 6 1 6
Sep-03 Oct-05 Sep-05 Oct-05 Sep-05 Oct-05 Sep-05 Oct-05
Sep-03 Jun-06 Sep-05 Apr-06 Sep-05 Apr-06 Sep-05 Apr-06
Y Y Y Y Y Y Y Y
0 0 6 0 6 0 6 0
12 12 12 -
C RS RS RS RS RS RS
0.00% 0.00% 0.00% Y 0.076892266
12000
12001
Rental Income
. TOTAL
X
A
-
-
0
-
Sep-03
Sep-03
0
Y
-
-
13000 10000
10009 10011 10012
Tenancy Costs
TOTAL
X
Financing Costs
Mezzanine Establishment Costs Stamp Duty on Mortgage Senior Loan establishment Costs TOTAL
X
A A A
X
32,500 212,000 185,500
5 11 11
1 1 1
Jan-04 Jul-04 Jul-04
Jan-04 Jul-04 Jul-04
N N N
-
11000
11001 11002 11003
Other
Interest Received on Deposits GST Input Credits GST Expense
Z
A A A
File: Sample Management Model
Page 2 of 2 Pages
Date of Report: 15/07/2004 7:46 PM