CCIM Business Forms  Click on a link below to download any version of the CCIM Business Forms and then pull directly into Excel (or Lotus, or QuattroPro).   You may need to use the right mouse button to get the file to download.  You may wish to print out these brief instructions for use: The CCIM business forms, used in all CCIM Designation courses, are tools top real estate professionals use to calculate property cash flows.  Included here is the Annual Property Operating form (APOD), Cash Flow Analysis form and the Alternative Cash Sales Worksheet, along with an IRR T-Bar presentation page.  These forms were originally developed in Excel, version 5  and will load into ver. 97 and 2000 & XP, as well as Lotus ver. 9.5 and QuattroPro 9.0.  All calculations and carries are done by the spreadsheet. You need to enter data on the Assumptions page (tax cap rates, escalation rates for expenses and income),  on the CashFlows page (amount, term, and rate of each mortgage;  class life of recoverable property;  date placed in service), and on the APOD (Price, size, assessed value, income, expenses).

Please direct all questions and comments regarding these templates to the
author: Gary G. Tharp, CCIM
Home: 2083 Biltmore Point Longwood, FL 32779   phone: (407) 862-9206    fax: (240)331-0676
Business: G T Commercial, Inc., 14 E. Washington St. #404, Orlando, FL  32801  (407) 206-2246    fax:(240) 331-0676
But the best way to reach me is: gary@orlando.com

Click on any of these to download:

CCIM Business Forms, 5 year forecast. (Excel)(US)
  (last revised 11/08/2001)
CCIM Business Forms, 5 year forecast. (Excel)(US), Highlighted
  (same as above, but with macros that highlight and help you fill out the forms)
   (last revised 11/08/2001)
CCIM Business Forms, 10 year forecast. (Excel)(US)
   (last revised 11/18/2001)
CCIM Business Forms, 10 year forecast (Excel)(US),Highlighted
  (contain macros that help you in filling in the data)
   (last revised 11/18/2001)
CANADIAN CCIM Business Forms, 5 year forecast. (Excel)(CAD)
  (properly treated mortgage interest, CCA schedules, etc.)
   (last revised  9/7/2001)
Apartment version, 5 year forecast. (Excel)(US)
   Modified  to be more multi-fam oriented
"Plain Paper" version, 5 year forecast. (Excel)(US)
   Not automated...for printing out blank forms
  (last revised 11/08/2001)
"APOD, Plain Paper" version. (PDF format)(US)
   Not automated...for printing out blank form
   (last revised 11/08/2001)
"CFAW, Plain Paper" version. (PDF format)(US)
    Not automated...for printing out blank form
   (last revised 11/08/2001)
"ACSW, Plain Paper" version. (PDF format)(US)
   Not automated...for printing out blank form
   (last revised 11/08/2001)

CCIM Business Forms, 5 year forecast. (Lotus)(US)

CCIM Business Forms, 5 year forecast. (QuattroPro 9.0)(US)
 

Samples:

Sample - 5 year forecast (Excel)
    Old version, being updated 
Sample - 5 year Apartment forecast (Excel)
    Old version, being updated 
Sample - 5 year "Park Plaza" forecast (Excel)
   from the CI Intro Case Study     Old version, being updated 

Sample - 5 year forecast (QuattroPro 9.0)

If you would like to be sent updates of the form you have    downloaded as soon as they become available, please respond below:

Email address:

Which template?

Comments:

Are you a CCIM ?YesNo

Return to Gary's Home Page

                                         If you have other comments or suggestions, email me at gary@orlando.com

Nedstat Counter