Financial Modelling Using Excel

Rapid Skillz

Course

Online

£ 135.09 VAT inc.

*Indicative price

Original amount in USD:

$ 169

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

Gain an indepth understanding of Financial Modelling techniques like Forecasting Financial Statements,Company Valuation and Analyzing M&A transactions

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Analyze historical financial statement and evaluate the current value of an entity
Efficiently forecast Profit & Loss, Balance Sheet and Cash Flow statements
Learn to build a Project Finance Model
Analyse Mergers and Acquisitions (M&A)
Perform a Discounted Cash Flow (DCF) and Relative Valuation

MBAs, CFAs, CAs, FRMs, B-Tech and Commerce Graduates and students
Candidates looking to make career in equity research, valuation, private equity funds, investment banking or commercial banking, project management etc

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel
  • Using excel
  • Project
  • Finance
  • Forecasting
  • Cash Flow
  • Excel
  • Project Finance
  • Financial Modelling
  • Cost of Capital
  • Balance Sheet
  • Financial
  • Financial Training
  • Loss Statement
  • Flow Statement
  • DCF Modelling

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

Excel- Basics & Advanced
  • Basic Shortcuts & formulas in Excel (sumif, sumifs, nested if, vlookup, hlookup and many more)
  • Advanced formulas -Named Ranges, Index Match, Array Functions, Building Scenarios using Offset Functions, Index functions, Usage of Indirect Functions, Usage of Goal Seek and Solver Function
  • Array Functions
  • Pivot tables
Charts
  • Creating and formatting Basic Charts in Excel
  • Charting with two axis and chart type
  • Bubble Charts
  • Creating a Dynamic Range Chart
  • Creating Radar/Spider Charts
  • Creating Waterfall Charts
  • Creating a Football Field Chart
  • Creating Gantt Chart
Financial Statement Analysis
  • Building a financial model template
  • Gathering and organising the historical data
  • Understanding the Income Statement, Balance Sheet and Cash Flow statement of a company
  • Calculating Financial ratios
Forecasting Financial Statements
  • Understanding the Business Model – Identifying key Revenue & Cost Drivers
  • Forecasting the drivers
  • Preparing Balance Sheet schedules
  • Forecasting Profit & Loss Statement
  • Forecasting Balance Sheet
  • Linking the Cash Flow Statement
  • Ratio Analysis
DCF Modelling
  • Calculating Cost of Capital [Weighted Average Cost of Capital (WACC), Capital Asset Pricing Model (CAPM)]
  • Discounted Cash Flow (DCF) Model – Free Cash Flow to Firm (FCFF) v/s Free Cash Flow To Equity (FCFE) model
  • Relative Valuation
  • Performing Sensitivity / Scenario Analysis
Project Finance
  • Understanding Project Finance
  • Building the Project Finance Model
M&A Analysis
  • What is Mergers & Acquisitions (M&A) and why do companies need M&A
  • Payment Methods in M&A
  • Types of offer
  • Key Inputs into an M&A Analysis
  • Understanding & analysing accretion & dilution
  • Analysing the impact of different financing plans
  • Analysing the impact of different ownership structures
  • Analysing the impact of Transaction Price and Financing Structure through Sensitivity Analysis
  • Performing Contribution Analysis
  • Valuing a transaction
  • Valuation Analysis with different methods of valuation
Case Study (Application of everything done so far)
  • Analysing a Company
  • Gathering Historical Data
  • Building Business Model and revenue drivers
  • Calculating WACC (Weighted Average Cost of Capital) Cost of Equity, Terminal Value
  • Arriving at the value of a Company using DCF and Relative valuation
  • Doing a sensitivity analysis of your assumptions

Additional information

BENEFITS

Learn Financial Modelling for valuation of a company and determining whether it is undervalued or overvalued.Course covers financial modelling for specific sectors such as Real Estate and Banking.Learn different methods such as Discounted Cash Flow/ Dividend Discount Model/Relative Valuation etc.Building Financial Projections to help companies to plan their output and predict their performance.

See related categories

Financial Modelling Using Excel

£ 135.09 VAT inc.

*Indicative price

Original amount in USD:

$ 169

The best Excel courses

See all

See all