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.
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
Learning 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 3 and 5 year value for the business based on the assumptions
- Work through the detailed tasks accompanying the webinar to test your knowledgeÂ
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.
