We also offer courses and publications in: UK Flag London US Flag New York
  • Join us for the latest updates, tips and course dates!

Building a Financial Model from Scratch

CFA accreditation available in India.
Participants start with a blank Excel worksheet and learn an efficient way to input historical data from a pdf document. The financial statements of the case company are then analyzed, and the latest historical data is cleaned and prepared for the forecasting process. Ratios are calculated and assumptions for each line item in the financial statements are created. The full forecast model is then built. The forecasting techniques for several different items are examined separately, using dedicated Excel files, before being adapted for the case company.

Description

Participants start with a blank Excel worksheet and learn an efficient way to input historical data from a pdf document. The financial statements of the case company are then analyzed, and the latest historical data is cleaned and prepared for the forecasting process. Ratios are calculated and assumptions for each line item in the financial statements are created. The full forecast model is then built. The forecasting techniques for several different items are examined separately, using dedicated Excel files, before being adapted for the case company.

Who should attend?

Those working within the following functions:

  • Finance
  • Corporate Finance/Investment Banking
  • Equity Research
  • Fund/Asset Management
  • Consultancy
  • Private Equity

Duration: 1 day program

Course Objectives

  • Understand how to create a model template in Excel including styles
  • Learn how to efficiently input historicals from pdf documents
  • Learn how to build forecast assumptions
  • Learn the best practices for stress testing formulas as you construct the model

Course Content:

  • Identifying relevant information in the company’s financial statements, management discussion and analysis, and notes
  • Adjusting historical performance for acquisitions and divestitures
  • Analyzing and making reasonable projections for a company’s operating costs, non-recurring items, and other income and expense
  • Creating assumptions and forecasting balance sheet accounts
  • Revenues and costs
  • Fixed assets - capital expenditure and depreciation
  • Intangible assets
  • Operating working capital
  • Provisions
  • Effective tax rate, taxes payable and the various deferred tax items
  • Debt schedule
  • Equity and share repurchases
  • Building a cash flow statement from scratch
  • Documentation techniques and ratio analysis
  • Integrity checking

Prerequisites

Solid understanding of how to build a three statement model in Excel. Ideally you will have attended our 2 day Financial Modeling course - https://amttraining.arlo.co/hk/courses/44-financial-modeling

Please note:

This course is non-residential. The venue will provide light refreshments.

You need to bring a Windows-based laptop to the training with Excel, Winzip and Adobe to access the files. Our teaching materials are designed for PCs and not MAC based systems. Download details for the necessary files will be emailed a few days before the course.

AMT reserve the right to cancel or postpone sessions or change content if registrations are insufficient to continue 2 weeks prior to scheduled commencement date. Registrants will be given at least 5 business days’ notice of such changes.