Discounted Cash Flow A ‘hands on’ 3 Day Introductory Course

Discounted Cash Flow A ‘hands on’ 3 Day Introductory Course

This course is aimed at those:

• With only a rudimentary knowledge of Excel Spreadsheets.
• With a limited understanding of DCF concepts and their implementation in investment valuation, investment analysis, and for valuing or assessing development properties.

The course does NOT require knowledge of financial or other complex formulas or an ability to enter and manipulate those formulas in an
Excel environment.

On completion, delegates will:

• Understand the key DCF concepts.
• Be able to implement DCF as part of the process of valuing investment properties, in investment analysis and in valuing an assessing developments.
• Understand and be able to implement cash flow approaches to income and outgoings schedules.
• Appreciate the impact and limitations of DCF and Cash Flow techniques.
• Be ready to move on to the construction of robust DCF and Cash Flow models for professional use.

Laptop Computers will be provided to give delegates hands on ability to build elementary models and to look into the base models that are developed for this module. On this occasion Excel 2003 will be the Version used. Materials developed are capable of uploading to Excel 2007 although that Version will not be used or covered in DCF Modules until later this year or next year.

Topics:

• Definitions and implications of definitions
• Using pre-developed advanced tools
• Following the DCF Guidance Notes
• Developing monthly DCF and Cash Flow Models
• DCF and Market Valuation and Valuation Reporting Standards
• Removing the need for memory of and ability to manipulate financial formulas
• NPV and IRR definitions
• Security and retained integrity issues
• Limitations and assumptions of NPV and IRR
• Date Based DCF and Cash Flow Models
• Excel Implementation basics of NPV and IRR concepts
• DCF and Hypothetical Development Method
• Error checking / avoidance of error processes
• Profitability Assessment
• Building basic DCF and Cash Flow models
• Basic Feasibility Models
• Excel implementation issues
• Setting up Excel for DCF and Cash Flow Models
• Excel Financial Functions without tears
• Key ancillary Excel skills
• Incorporating income and outgoing projections
• Incorporating Loan amortization schedules

Ample time is allowed for handling delegate questions and problems all the way through

Delegates will be provided with:

• Carefully designed and easily paced course text with extensive additional reference material for later use.
• A CD ROM containing all course materials and “live” copyable Excel Spreadsheets.
• Working and heavily annotated spreadsheets covering each stage of the course and explaining the “whys” and “hows” of techniques used.
• Custom designed copyright free spreadsheet tools to assist in building DCF and Cash Flow models without the need for ability to know or manipulate complex formulas or functions.
• Security, data checking & manipulation, & transmission tools.

Presenter: Norman Harker FAPI, Senior Lecturer, UWS
Norman is an internationally acknowledged expert in the use of Excel for financial purposes. A practising valuer biased academic, Norman
has been a leading & popular presenter of CPD programs for the API since their inception.

What delegates said about the first presentation of this CPD Module:

• The course notes (which included notes & spreadsheets on CD) provided were very good.
• Norman makes what would be a dry topic much more interesting than it otherwise would be.
• Very impressively organised & presented.
• Enjoyed learning from Norman, great practical approach.
• Very well presented.