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 - From Scratch (1 day)

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

London
650 GBP
Enquire for more information

Course description

Financial Modeling - From Scratch (1 day)

This session teaches participants how to build a three statement forecast model starting from a blank Excel spreadsheet. We begin by setting up a roadmap to guide us through the modelling process and then we proceed to build up a model template which we populate with historical financial information drawn from the case company’s financial statements. We analyse the company’s historical data by calculating financial ratios, which are then utilized as a basis to set the assumptions driving the financial forecasts. The full forecast model, comprising income statement, balance sheet and cash flow statement, is then built. As we build the model, we examine various forecasting techniques for the key elements of the financial statements. Once the model is complete, we test its integrity and we sanity-check the financial forecasts.

Suitability - Who should attend?

Prerequisite

Delegates will be taught how to build a fully integrated Model from a blank Excel spreadsheet. A solid understanding of Financial Statement Analysis and Financial Modeling using a template is required in order for this day to be beneficial:

  • Accounting Fundamentals, the Income Statement and Working Capital
  • Non-Current Assets, Cash Flow Statements, Debt and Equity

Financial Modeling from Scratch puts the skills developed in the courses below, into practice by building a new model from the beginning:

  • Financial Modeling - Fundamentals
  • Financial Modeling - Cash Sweep and Troubleshooting

Training Course Content

Learning Outcomes

  • Identifying relevant information in the company’s financial statements, management discussion and analysis, and notes
  • Isolating historical non-recurring income and expenses
    • Forecasting techniques
    • Revenues and operating costs
    • Operating working capital
    • Fixed assets - capital expenditure and depreciation
    • Intangible assets
    • Provisions
    • Effective tax rate, taxes payable and the various deferred tax items
    • Debt schedule
    • Equity and share repurchases
    • Balancing accounts (balance sheet plugs)
  • Building a cash flow statement from scratch
  • Documentation techniques
  • Integrity checking
  • Sanity-checking the financial forecasts

Course delivery details

While this is a face to face training course, a blended learning approach is taken and delegates will be provided with access to AMT Online. Our study materials contain both the knowledge and practice materials required to assist with the learning process and help you in your job role. Course materials include:

  • e-binder
  • laminated summary sheets
  • 24/7 access to DELTA online learning environment
  • class recordings
  • course notes
  • quizzes
  • electronic homework/study files

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 - From Scratch (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 18 reviews.

Sidney
Great session with many useful tips and tricks
Mathew
Perfect course and amazing instructor. Very knowledgeable! Keep up the good work. Extremely satisfied.
Rae
The trainer was fantastic, it is obvious they knows to perfection what they is doing and communicates great
Request Information

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

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