Company valuation using Excel

In this recorded webinar, you will learn how to construct a business valuation model using Microsoft Excel. You will be guided through the process of generating free cash flow projections and discounting them back to today's dollars, which will be used to evaluate the company's worth. The webinar will cover the basics of company valuation, including how to perform the necessary calculations and use financial information to project future cash flows of the business. By the end of the session, you will have a solid understanding of how to use Excel to construct a business valuation model.

Using a practical exercise and segmented into short lessons 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. Clickherefor Marcus' biography.

Course updated: May 2023