Corporate Valuation Models in Excel - In-house

Bayfield Training
Course summary
2 days
Corporate Training for Teams
Next available date: Enquire for more information - Online courses
Course Dates
Online courses
Enquire for more information

Enquire for more information

Course description

Corporate Valuation Models in Excel - In-house

Anyone concerned with the success of a business needs to understand its financial accounts. Further, anyone involved with financing, buying or selling a company needs to understand the financial basis of the transaction. Learning how a company is valued will allow you to trace the drivers of performance, and sources of constraint, back through the company’s financial structure. What better way to understand this than by building a Corporate Valuation, in Excel, from scratch.

Using the Bayfield technique of modular, systematic and guided model building this course will give you a no-nonsense insight into the financial health of any company. It will also provide the financial modelling know-how to help you build your skills as an Analyst. Last, but not least, the skills learnt on this course will equip you to negotiate any corporate finance transaction from a position of strength.

Suitability - Who should attend?

Who will benefit from this course?

  • Anyone working at the Analyst or Associate level within the institutions or investment banking.
  • Those involved in the strategic or financial planning of a business
  • Business Owners or Project managers who need financial modelling skills
  • Audit Professionals and Legal Representatives
  • Real Estate Analysts who want to know how projects are recorded in corporate valuations



Outcome / Qualification etc.

On this course, you will:

  • Learn the motivations for preparing a Corporate Valuation (the course discusses all motivations but will focus on business planning)
  • Understand the different techniques Analysts use to assess value from a completed model
  • Discuss the relevance and importance of the three statements in a Corporate Valuation
  • Set up the structure for a Corporate Valuation Model in Excel
  • Build in the Corporate Valuation formula for each of the three statements line by line
  • Determine the value of the company
  • Trace and Analyse the model for sources of opportunity and risk
  • Review your model in the context of current corporate finance activity

Training Course Content

Day One

Understanding a Private Equity Fund Model

  • Layout and key elements of a PE Model
  • Private equity market and strategies
  • Understanding the deal structure and interested parties
  • Understanding the capital structure
  • Review of the key debt instruments
  • Review of the key equity instruments (special case of Management Buyout)

Fund valuation methods

  • The multiples approach to valuation
  • Discounted Cash Flow (DCF), modelling and core concepts
  • Private Equity performance metrics
  • Pre-money vs Post-money valuation
  • Special Cases

Review of accounting principles

  • Balance Sheet: Real Estate Valuations and Debt
  • Profit & Loss: Capital Allowances
  • Cash Flow statement: Escrow Accounts and Distributions

Day Two

Building the detail into Financial Statements

  • Profit & Loss
    • Understanding Business Drivers
    • Forecast Revenues
    • Applying the cost & Profit Structure
    • Calculation EBITDA
    • Handling interest Rates
    • Depreciation Schedules
  • Balance Sheet
    • Understanding Corporate Finance
    • Setting up the Debt & Equity Structure
    • Creditor and Debtor Assumptions
    • Forecast Capital Structure
    • Forecast Working Capital
    • Calculation Net Assets
  • Cash Flow
    • Understanding the importance of Cash Flow
    • Distinguishing between Cash & Non-Cash Items
    • Working Capital
    • Investment Cash Flows
    • Reconciling with cash in bank

Analysing the corporate valuation

  • Valuing the company using DCF, Ratio Analysis and Comparable Transactions
  • Calculating Equity Returns using EBITDA and Net Income
  • Calculating Debt & Coverage Ratios
  • Performing Sensitivity and Scenario Analysis
  • Case Study: Investing in a major project (demonstrated on built model)

Why choose Bayfield Training

Over 22 years in business

Original Content, Unique Delivery

+90% courses review rating from past delegates

Customer Outreach Award 2019


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

Bayfield Training - Real Estate Executive Education (Available in the classroom & online)

Bayfield Training is a prominent global supplier of investment grade Real Estate executive education. Having begun as pioneers in the field of Real Estate Financial Modelling, today Bayfield has a huge extended network of experts, specialists and professionals within this...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about Corporate Valuation Models in Excel - In-house.

  Contact the provider

  Get more information

  Register your interest

Contact info

Bayfield Training

71-75 Shelton Street
WC2H 9JQ Covent Garden, London

 Show phone number

Request information

Find out more about this Corporate Valuation Models in Excel - In-house course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here