Financial Modeling Essentials
Performing Your First Company Valuation
There are many questions to ask your data when it comes time to perform a company valuation. In this course, you’ll learn how to use Excel to ensure your final figures can be backed with integrity.
Advanced    13 Lessons    150 Minutes    CPD Credits
About This Course
Valuing companies is a common business activity and very useful skill for analysts to learn. In this course, you’ll discover how to use your data to build a comprehensive estimation of worth.
Across 13 lessons, you’ll learn how to estimate a company’s value using several valuation techniques, including enterprise and equity value, capital asset pricing model and terminal value.
By the end of the course, you’ll understand the foundations of every valuation and how to use Excel to support your analysis, building confidence that your figures can be relied upon.
Learning Outcomes
-
Explain the different methods of valuing a company
-
Calculate the enterprise value and equity value
-
Calculate the cost of equity and the cost of capital
-
Calculate unlevered free cashflows
-
Determine the terminal value of a company
-
Run a sensitivity analysis for a company valuation
-
Value a company using market multiples
-
Calculate the return on investment when buying a company
Lessons
1. Why and When Are Companies Valued?
2. The Different Methods of Valuing a Company
4. The Cost of Capital Part 1
5. The Cost of Capital Part 2
6. Unlevered Free Cashflow
Read More
7. Calculating the Discounted Cashflows
8. The Terminal Value Part 1
9. The Terminal Value Part 2
10. Re-Cap on Equity Value Calculation
11. Scenarios and Sensitivity Analysis
12. Market-Based Valuation with Multiples
13. Return on Investment
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.