File:zpreipfa Created by © Zeppelin Real Estate Analysis Limited 
Phone (852) 37576388, Fax (852) 37576399, E-mail stephenchung@zeppelin.com.hk
SIMPLE REAL ESTATE INVESTMENT CALCULATION PROFORMA
Based on Acquiring an Existing Investment Property and Selling it after an assumed number of years
============== ============== ============== ============== ============== ==============
Project / Subject : Lovely Garden
Date : 1-Nov-00 Updated on : Input if apply
Remarks : For simple illustration only. Further / Detail studies may be required.
Requires Microsoft Excel and complimentary computer equipment and operational capacity. 
Seek advice from appropriate consultants prior to usage if unsure.
Zeppelin or its associates, consultants, staff and the like do NOT take responsibility for losses 
or damages arising out of the use of these proformas or content.
Zeppelin or its associates, consultants, staff and the like do NOT take responsibility for
mistakes, virus or bugs contained in these proformas or content.
Input Cells are in GREEN Color.
============== ============== ============== ============== ============== ==============
INPUT AND ASSUMPTION PAGE : Input Currency used = HK$ Notes / Remarks
REVENUE ITEMS (There is no need to fill in all revenue components although there should be at least one)
a) Rental Income from Residential Per Annum = 8,122,500 Per Month =
    Input Quantity e.g. total Gross Floor Area (GFA) in ft2 = 50,000 ft2 or m2
    Input Quantity in terms of no. of units if applicable = 20 Average GFA / Unit :
    Input Rental Rate e.g. $ per ft2 or per m2 GFA per month = 15 $/ft2 or m2/month
    Input Rental Rate Increase / Decrease Rate % = 5.00%
    Input Vacancy Rate % = 5.00%
b) Rental Income from Retail Per Annum = 0 Per Month =
    Input Quantity e.g. total Gross Floor Area (GFA) in ft2 = 0 ft2 or m2
    Input Rental Rate e.g. $ per ft2 or per m2 GFA per month = 0 per ft2,m2/month
    Input Rental Rate Increase / Decrease Rate % = 5.00%
    Input Vacancy Rate % = 5.00%
c) Rental Income from Office Per Annum = 0 Per Month =
    Input Quantity e.g. total Gross Floor Area (GFA) in ft2 = 0 ft2 or m2
    Input Rental Rate e.g. $ per ft2 or per m2 GFA per month = 0 per ft2,m2/month
    Input Rental Rate Increase / Decrease Rate % = 5.00%
    Input Vacancy Rate % = 5.00%
d) Rental Income from Industrial Per Annum = 0 Per Month =
    Input Quantity e.g. total Gross Floor Area (GFA) in ft2 = 0 ft2 or m2
    Input Rental Rate e.g. $ per ft2 or per m2 GFA per month = 0 per ft2,m2/month
    Input Rental Rate Increase / Decrease Rate % = 5.00%
    Input Vacancy Rate % = 5.00%
e) Rental Income from Other Use(s) Per Annum = 0 Per Month =
    Input Quantity e.g. total Gross Floor Area (GFA) in ft2 = 0 ft2 or m2
    Input Rental Rate e.g. $ per ft2 or per m2 GFA per month = 0 per ft2,m2/month
    Input Rental Rate Increase / Decrease Rate % = 5.00%
    Input Vacancy Rate % = 5.00%
f) Rental Income from Parking Per Annum = 0 Per Month =
    Input Quantity e.g. no. of parking spaces = 0 No. of spaces
    Input Rental Rate e.g. $ per parking space per month = 0 $/space/month
    Input Rental Rate Increase / Decrease Rate % = 5.00%
    Input Vacancy Rate % = 5.00%
g) Rental Income from Miscellaneous Per Annum = 0 Lump Sum p.a.
    Input Rental Rate Increase / Decrease Rate % = 5.00%
i) Cap Rate Used at Disposition = 4.00%
j) Marketing or Leasing Cost as a % of total revenues = 5.00%
EXPENSE ITEMS
a) Acquisition Cost based on Actual/Estimated Price $ = 150,000,000 Purchase $/GFA :
    Input Stamp Duty % IF ANY = 2.75% Approx Yield % :
    Input Real Estate Agency Fee % IF ANY = 1.00%
    Input Legal and Transaction Fee % IF ANY = 1.00%
b) Estimated Building Maintenance Cost Per Annum = 1,800,000 Per Month =
    It is assumed that reserved funds for major renovations / repairs are included herewith.
    Construction Floor Area (total floor area above + % below)  = 50,000
    Input % allowance for Construction Floor Area = 0.00%
    Input Maintenance Cost per Construction Floor Area $/ft2 or m2/month =                       3.00 per ft2,m2/month
    Input Expected Inflation / Deflation Rate % = 5.00%
c) Estimated Property Management Cost Per Annum = 270,000 Per Month =
    Input % allowance for Soft Costs (based on total maintenance cost) = 15.00%
    Input Expected Inflation / Deflation Rate % = 5.00%
d) Input % Level of Financing for Acquistion Cost IF ANY = 50.00%
    Assumption : A simple "balloon payment" mortgage is used here.
    Input Estimated / Expected Overall Average Interest Rate % = 9.00%
    Input Investment Time in years =                           5 Years
e) Estimated Land Rent / Rates Cost Per Annum = 731,025
    Input % allowance for marketing (based on total rental income) = 3.00%
    Input % allowance for land rent (based on total rental income) = 3.00%
    Input % allowance for rates (based on total rental income) = 3.00%
    Input Expected Inflation / Deflation Rate % = 5.00%
f) Recoupment Rate % of (b), (c) and (e) from tenants IF ANY = 95.00%
Assuming typical circumstances, this would be roughly equal to the overall "Occupancy Rate%" i.e. 100% - Vacancy % used here.
Ref Only:Expense(b)+(c)/unit/month : 8,625 Discount Rate = 10.00%
============== ============== ============== ============== ============== ==============
Results : Net Present Internal Rate of
Investment Years Value Return Price +/-% p.a. Discount % used Cap Rate used
2 32,951,670 32.39% 18.19% 10.00% 4.00%
3 32,916,922 24.58% 13.62% 10.00% 4.00%
4 32,858,141 20.85% 11.40% 10.00% 4.00%
5 32,778,747 18.67% 10.09% 10.00% 4.00%
10 32,168,536 14.44% 7.51% 10.00% 4.00%
15 31,382,120 13.09% 6.67% 10.00% 4.00%
============== ============== ============== ============== ============== ==============