Best Practice Financial Modelling

Description

Building an Excel spreadsheet model that forecast profits and cash flows across a regular series of future dates is a common requirement for the financial analyst and professional modeller. Modellers undertaking such assignments require sound commercial and accounting knowledge, and need to make important design and construction decisions in relation to their models.

Modellers using the FAST Standard will have made the task considerably easier for themselves by following a standard approach that is recognised by others. Financial Statement Modelling reminds you of the basic construction and design skills you need and applies them to the complexities that arise from a case study - in this instance the acquisition of a concession to run an airport over a 30 year period.

The financial statements - income statement, balance sheet and cash flow statement - form the core content around which the course fits. In addition, you will cover valuation techniques, sensitivities and scenario managers.

On completing the course and its assessments, you will be in a position to start building models that are FAST compliant and meet all the requirements of a financial statement forecast model.

Videos are ordered in such a way as to build up your learning in layers. By all means ignore the videos where you have the knowledge already. Here is a quick guide to the different categories:

QUICK REMINDERS - knowledge that you should have picked up from our introductory courses. Quick Reminder videos are there just in case you need them.

HOW TO - knowledge that is specific to Excel and - in particular - Excel functions. How To videos are there to build up your spreadsheet engineering abilities.

ROUGH WORK - knowledge that is specific to the case study being modelled. In Rough Work videos look out for heavy use of placeholders and template coding.

CASE STUDY - in Case Study videos, an experienced FAST modeller will model the case study solution. There is no audio accompaniment to Case Study videos.

ANALYSIS - knowledge that is specific to reviewing models and obtaining insight. In Analysis videos expect lots of charting and lots of talking.

To get started, please work through Excel Proficiency Skills and then Model Construction Skills if you are new to F1F9 training. Then you'll be ready to start the Financial Statement Modelling sub-courses. Do remember we're here to support you - you can use the "Discuss" tab to post in the forums, the "Feedback" button to send us questions, or simply email us at support@f1f9.com.