Print
Print
|
Introduction
This application-driven, hands-on practical 2-day program initially provides delegates with useful Excel tips & tricks to help speed up the building of their models, and then leads them through various financial modelling techniques, using Excel as the tool. It assumes that delegates are involved in the property sector, have a working background of the property industry and are familiar with commonly used industry terms. It focuses on the basic nuts & bolts of financial model preparation and structure, and provides the delegate with useful modelling techniques than can be immediately applied in the work place in a real estate environment. The two days will be spent on demonstrating various techniques, interspersed with short hands-on exercises for certain of the more useful areas to reinforce the examples presented. Participants will build a complete real estate model, from first principles, in various stages over the two days. 
Who Should Attend
Pre Requisite(s)
Outcomes
By the end of this course delegates will know how to structure models correctly, and will appreciate the necessity for so doing. They will have gone through the process of building a real estate model, completing the required sheets and financial statements. They will understand the interaction between Income Statements, Balance Sheets, and Cash Flow statements in financial models, and the necessity for having them. They will enhance considerably their knowledge of Excel so far as it pertains to financial models, e.g. they will understand how to perform sensitivity analyses, create scenarios and data tables, etc. They will also benefit from the discussions and exercises on the Weighted Average Cost of Capital (WACC), Net Present Values (NPVs) and Internal Rates of Return (IRR), and will learn the importance of these measurements. Knowledge gained in setting up "switches" in their models, allowing them to investigate the effect of different alternatives, will be of great value to them.
Course Content
Day 1Useful Excel tips & tricksProtecting & unprotecting ranges in spreadsheets Creating names for ranges in your spreadsheet Creating your own formats (e.g. to display millions in thousands) Logical tests - using IF statements Structuring your model Maintaining the integrity of the model Accumulating data Date functions Inflation calculations Real Estate Development model - overview Data tables - preparing a table of results based on changing assumptions Data validation techniques - producing drop-down lists, and validating input data Creating and comparing scenarios - e.g. Base case, Best case, Worst case
Day 2Discounted cash flow - NPV & IRRDiscounted cash flow over unequal periods Real Estate project model - Overview Trunc and Int Extracting positive & negative balances Match Sensitivity analysis Calculating the loan limit - a "quick & dirty" model The Choose function Appendix 1 - Uses of the Ctrl key in Excel Appendix 2 - Equivalents in Excel 2003 Appendix 3 - Equivalents in Excel 2007
|