Video Walkthroughs

 

Welcome to the Financial Mechanics video walkthrough library. Please follow the links below for to view the relevant tutorial video.

 

Project Finance Tutorials

1a. Straight-line depreciation of ongoing capex.
This 30 minute tutorial covers the depreciation of ongoing capex using the HLOOKUP and OFFSET functions. Both structures are presented, explained and compared with reference to the design criteria set out in the FAST modeling standard



Pre course tutorials

2a. File management in Microsoft Windows XP
This walkthrough covers topics such as file and folder management in Windows XP and Zip file usage for archiving financial models.

2b. Microsoft Excel 2003 environment
This walkthrough covers topics such as changing the default Excel 2003 environment settings to increase modelling productivity and reduce errors and confirming Analysis Tool-Pak and Macro security settings.

2c. Microsoft Excel 2007 environment
This walkthrough covers topics such as changing the default Excel 2007 environment settings to increase modelling productivity and reduce errors, accessing the developer tab and working with the ‘ribbon’.