Financial Modeling Fundamentals
A half day live webinar with experienced trainer
City Training UK
Summary
- Certificate of completion - Free
- Tutor is available to students
Overview
The participants will learn how to model and integrate the income statement, balance sheet and cash flow of a food manufacturer using Excel. In addition to learning the steps necessary to build a three-statement financial model, the participants will also cover how to build models accurately and efficiently through a series of best practice modelling rules. The participants also learn how to stress-test the assumptions used, to check their work efficiently and to document it.
Resources
- Financial Modeling Fundamentals - Outline - download
Description
Session 1
Financial Modelling Fundamentals
The participants will learn how to model and integrate the income statement, balance sheet and cash flow of a food manufacturer using Excel. In addition to learning the steps necessary to build a three-statement financial model, the participants will also cover how to build models accurately and efficiently through a series of best practice modelling rules. The participants also learn how to stress-test the assumptions used, to check their work efficiently and to document it.
- Using keyboard shortcuts
- Setting Excel up for maximum efficiency
- Working with key modelling formulas and structures
- Building 3-statement projections
- Modelling cash and revolver
- Addressing standards for good models
- Constructing the income statement, balance sheet and cash flow statement
- Introduction to checking methodologies
- Performing audit trails
- Incorporating interest income and expense
Case study: Basic modelling of a food manufacturer without depreciation, interest and revolver
Session 2
Three Statement Modelling
Through the process of building a more complex three statement model, the participants are taught how to model operating cash and calculate interest using average debt and average cash balances. We will address in detail how to work with intentional circular references. The issue of non-intentional circular references is covered and the participant is taught modelling rules that are designed to help avoid them. The session is designed to expose the participant to different three statement modelling styles: multi-sheet, tower, and different income statement layouts. Exposure to a mix of modelling styles will help prepare them to work on in-house models or models inherited from other finance professionals.
- Modelling operating cash, excess cash and the revolver
- Calculating interest on cash and debt balances
- Working with intentional circular references
- Avoiding non-intentional circular references
- Building models with different styles and layouts
- Calculating ratios
Case study: More complex modelling of a food manufacturer with depreciation, interest and revolver
Who is this course for?
This course is designed for participants who are:
- Financial analysts in investment banks
- Junior equity research
- Junior investment managers
- Finance functions at corporations
- All other interested Finance professionals
Requirements
Basic understanding of Excel
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.