• For Property People
• Why For Property
• PCS Seminar

Cash Flow Models and Budgeting - Advanced Techniques for Property Professionals

Wednesday 19th Oct 2006 Theatre One 14.50 pm

• Tips and Guidelines. Range names, useful Excel features. Timebase consistent formulae - building models not number grids.
• Projecting Rent, Capital Costs, Operating Costs, and Loans. How to project. Use of formulae, array formulae, VBA array functions.
• Dealing with Actuals.
• Modularisation and Structure.

Uses Microsoft Excel.

Spreadsheet download (this was the contents of the seminar, and contains all the code and the formulas etc):

seminar.zip

Questions from the Seminar

Excel Books (property cashflows)

Practical Financial Modelling: A Guide to Current Practice, Jonathan Swan

Designing Flexible Cashflows, Scott Fawcett

Excel Books (general and VBA)

Anything by John Walkenbach

Web Resources

Best user Groups:

Excel-G List (recommended!)

Excel-L List (recommended!)

Help Boards

OzGrid

Mr Excel

Excel Tip

general Info/tutorials

Chip Pearson

John Walkenbach

Not forgetting our own board we've setup specially for UK property:www.PropertyModellers.com