merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Financial Modeling - Fundamentals (1 day)

AMT Training
Course summary
1 day
650 GBP
Full time
Online courses
Next available date: Online delivery option may be available - Please contact provider - Online courses
Professional Training

Course description

Financial Modeling - Fundamentals Part 1

This session teaches participants how to build a three statement integrated financial model, comprising income statement, balance sheet and cash flow statement. Best-practice modelling techniques are demonstrated, to ensure maximum accuracy and efficiency. Participants also learn how to stress-test the assumptions used, to check the model for mistakes and to document it. This session uses simplified teaching models as well as a real company forecast model.

Financial Modeling - Fundamentals Part 2

Using a real company forecast model, we start the session by reviewing the structure and key components of an integrated three statement forecast model. We then focus on modeling operating cash (required cash) and separating it from excess cash. We then teach participants how to build a forecast cash flow statement from scratch, using income statement and balance sheet inputs. The last part of this session focuses on interest calculations and circularities, where we teach participants the difference between using beginning, ending or average debt/cash balances and how to work safely and effectively with or without circular formulae in a model.

Suitability - Who should attend?

  • New hires who have joined the firm late and missed the in-house program
  • Individuals looking to fill a knowledge gap
  • Experienced bankers looking to refresh their technical skills
  • Teams employed in financial strategy roles from non-banking corporations
  • Graduates preparing to interview for a role in the finance sector
  • Students at business school and looking for a career in finance

Outcome / Qualification etc.

Fundamentals Part 1 Learning Outcomes

  • Setting Excel up for maximum efficiency
  • Best-practice keyboard shortcuts for modelling
  • Key modeling formulas
  • Alternative model layouts
  • Structure of an integrated three statement forecast model
  • Constructing the income statement, balance sheet and cash flow statement
  • Balancing the forecast balance sheet using cash and revolver
  • Incorporating interest income and expense
  • Introduction to checking methodologies
  • Performing audit trails

Fundamentals Part 2 Learning Outcomes

  • Review of the structure and key components of a forecast model
  • Review of the modelling steps to build a three statement integrated model
  • Modeling operating cash (require cash) and excess cash
  • Building a forecast cash flow statement from scratch
  • Calculating interest on cash and debt balances
  • What is a circular formula?
  • Working with intentional circular references
  • Avoiding non-intentional circular references

About provider

AMT Training - Financial Modeling Courses

For over 20 years we have been equipping analysts and associates with core skills for banking and finance. Our clients include the top ten investment banks and some of the biggest private equity firms in the world. With offices in...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Financial Modeling - Fundamentals (1 day).

  Contact the provider

  Get more information

  Register your interest

Contact info

AMT Training

5th floor Whitechapel Building 10 Whitechapel High Street
E1 8QS London

 Show phone number
www.amttraining.com

Reviews

Average rating 4.8

Based on 28 reviews.

Sydney
They were a fantastic instructor. They were extremely knowledgeable and taught us the concepts very well.
Corinne
Really enjoyed doing the model alongside the demonstration today, felt I got a good understanding.
Beau
Fantastic overview of the basics of financial modeling.
Request Information

Find out more about this Financial Modeling - Fundamentals (1 day) course - simply fill out your details:

Reviews
Course rating
(4.8)
Based on 28 reviews.
Not sure where to start?