Beacon
FinRecruit
FinConsult
Future of Finance
Linkedin

Beacon FinTrain

Provides an array of professional business and financial training services that stem from improving a corporate's treasury workflow —all the way to efficient, finance training programs.

Course Overview

This comprehensive training program is designed to equip participants with the essential skills and knowledge required for financial modeling and valuation in the dynamic world of finance. Through a combination of theoretical concepts and hands-on practical exercises, participants will gain proficiency in constructing robust financial models and conducting thorough valuations.

Learning Outcome

Build an interactive financial model of the company, including inter-related: Statement of Profit or Loss (Income Statement), Statement of Cash Flows (Cash Flow Statement), and Statement of Financial Position (Balance Sheet).

Design a modern model structure based on pre-determined model outputs & requirements.

Build a clear revenue schedule to forecast company sales

Recall the techniques for model auditing tax and deferred tax treatment, depreciation calculations, integrity & error checking, and more.

Identify the different valuation methodologies and discuss the pros and cons of each

Perform a valuation analysis using comparable company and precedent transactions analysis

Course Outline

  • Certification Overview
  • What Is Financial Modeling?
  • What is a Financial Model Used For?
  • What do you need to be competent at to be a financial modeler?
  • Best-Practice Principles & Model Planning & Architecting
  • Tips for creating a seamless Financial Model
  • Model Setup and Assumptions

  • Logical Functions
  • Lookup and Reference Functions
  • Working with Text and Dates
  • Macros in Financial Modelling

  • Clarifying the objectives of the financial model
  • Defining the scope of the model (e.g., forecasting, valuation, scenario analysis)
  • Gathering Data and Assumptions
  • Collecting historical financial data
  • Identifying key assumptions (e.g., revenue growth rates, cost drivers, inflation rates)

  • Forecast Revenues Down to EBITDA
  • Building Up the Engine
  • Scenarios
  • Revenue Schedule

  • All Different types of Costs
  • Repeat, Build and Link the approach

  • Why we need a depreciation schedule
  • Forecasting a company’s depreciation expense
  • Building the Depreciation Schedule
  • Capex with HLOOKUP
  • Capex with SUMIF
  • Capex with TRANSPOSE
  • Depreciation Schedule Waterfall
  • Fully Depreciating Assets
  • Using BASE analysis to reach the NPP&E.

  • Building the Tax Schedule

  • Setting up Working Capital Assumptions

  • Debt Definitions
  • Building the Debt Schedule
  • Forecasting Debt and Equity
  • Forecasting Cash
  • Long Term Debt
  • Revolving Credit Facility
  • Modeling the Revolver
  • The Equity Schedule

  • Model Troubleshooting
  • Summery Page Setup
  • Formatting and presentation
  • Model Printing

  • Understand relative valuation versus other valuation methodologies.
  • Valuation methodologies and its pros and cons of each
  • Determine how to pick comparable companies and precedent transactions.
  • Match enterprise value and equity value with appropriate metrics.
  • Weighted-average cost of capital and construct a DCF model in Excel

  • Understand how DCF Valuation compares to Comparable Trading Analysis and Precedent Transaction Analysis and the pros and cons of each valuation technique
  • Review the importance of upfront model design and the best layout for a DCF Valuation Model, which has been optimized for presentation and printing.
  • Understand the importance of pairing the right cash flows (UFCF) with the correct discount rate (WACC) and review the steps for calculating each of these in detail.
  • Build separate schedules for both the perpetuity method and the multiple methods for calculating the terminal value.
  • Design and build a dashboard for stakeholders using one and two-dimensional data tables to illustrate the model’s sensitivity to critical valuation inputs.

Who Should Attend

Investment professionals

Register Now