Skip to main content
Project

Value a company in advance of a merger

In this project, you’ll develop a valuation model for a window and door retailer that is seeking a buyer. When the optimum buyer turns out to be a competitor company, you’ll then develop a model for this merger transaction that will help determine if the merger makes financial sense.

Excel        90 Minutes        1.5 CPD Credits
Start Today

Project Steps Involved

1. DoorCo open to seeking a buyer
2. Calculate the company’s unlevered free cash flow
3. Calculate the enterprise and equity value
4. Calculate market valuation multiples
5. Identify synergies for a possible merger
6. Determine funding options for the merger
7. Create a combined Income Statement
8. Analyze debt repayments
9. Determine when the deal makes sense

Prerequisite Courses

Advanced Financial Modeling

Mergers and Acquisitions

Essentials

Performing Your First Company Valuation

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.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Boost Your Career

Work smarter with full access to every course