Construct a business valuation model using Microsoft Excel.
Overview
Construct a business valuation model using Microsoft Excel. This recorded webinar will construct a valuation of a business based on the cash flow projections that are automatically compiled from a set of assumptions using Excel.
Using a practical exercise for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Common methods for company valuation
- Review example company, industry and distinctive characteristics
- Steps in creating a valuation for example company
- Performing the calculation to generate a free cash flow
- Discount the free cash flows to derive the value for the company based on a set of inputs
- Based on a set of cash flow projections, calculate the Internal Rate of Return (IRR) for the business
As part of this webinar you will receive,
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step by step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.
Course updated: 2020
Objectives
- Create a business valuation model using Excel
- Build in model flexibility which enables you to perform sensitivities on the projected cash flow and financing of a business
- Create a three and five year value for the business based on the assumptions
Audience
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.