Video Tutorial: Sum of the Parts (SOTP) Valuation, With Excel Example

In this lesson, you’ll learn how to build a Sum of the Parts valuation based on the financial statements for two separate divisions at a company (SunPower) and a proposed spin-off of its Maxeon manufacturing segment.

Sum of the Parts Valuation Definition: In a Sum of the Parts Valuation (also called SOTP Valuation), you analyze each segment of a company’s business separately and add together each segment’s implied value to determine what the entire company should be worth.

Core Financial Modeling

Core Financial Modeling

Learn accounting, 3-statement modeling, valuation/DCF analysis, M&A and merger models, and LBOs and leveraged buyout models with 10+ global case studies.

Learn more

The Sum of the Parts Valuation is useful for answering several questions:

1) If a large company is considering a spin-off or divestiture of one division, how much might this division be worth? And could the large company’s market valuation increase after the sale?

2) Is a conglomerate-style company, such as Siemens or General Electric, currently being undervalued by the market because its segments are worth more separately than they are together?

3) Would it make sense for one company to split into two separate entities if shareholders of the original company could significantly increase the value of their shares?

This tutorial will cover a Sum of the Parts Valuation for SunPower’s spin-off of Maxeon.

SunPower and Maxeon: Rationale for the Sum of the Parts Valuation

Before the spin-off, SunPower was a solar manufacturing, installation, and services company, but it had always traded at a significant discount to pure-play solar installation/services companies.

Its valuation multiples were closer to those of solar manufacturing companies, such as Canadian Solar and First Solar:

SunPower Valuation Multiples

But solar manufacturing accounted for only about half of SunPower’s revenue, so management and investors felt the company was undervalued.

The logic for this spin-off was simple: after splitting into separate entities, SunPower’s manufacturing division might continue to trade at a 0.5 – 1.0x revenue multiple…

…but the installation and services segment could potentially trade at a much higher revenue multiple in the 4.0 – 5.0x range, in-line with comparable companies in that sector.

As a result, the company as separate entities could be worth more than the company as a single entity.

The Step-by-Step Process for a Sum of the Parts Valuation

To build a SOTP valuation, you complete the following steps:

Step 1: Find separate financial statements for each division and project them. This is often the most challenging part because not all companies break out their financials this way!

Step 2: Select separate sets of comparable public companies for each division (and sets of precedent transactions, if applicable).

Step 3: Build a DCF model or other intrinsic valuation, such as a NAV model or dividend discount model, for each division.

Step 4: Take the Implied Enterprise Values for all the divisions and add them together to determine the company’s Implied Enterprise Value.

Step 5: Move from the Implied Enterprise Value to the Implied Equity Value using the normal “bridge,” based on the entire company’s Balance Sheet.

Step 6: Then, divide by the company’s share count to get its Implied Share Price and compare this number to its Current Share Price (if the company is public).

In this SunPower / Maxeon example, a few steps are slightly different because it uses a real-life spin-off with proposed deal terms.

Step 1: Find Separate Financial Statements for Each Division and Project Them

This step was simple in this example because SunPower provided separate financial statements for Maxeon in its filings at the time of the spin-off.

We projected both companies’ financials based on drivers such as the Megawatts (MW) of power installed and the Price per Watt:

Maxeon Financial Projections

We also adjusted SunPower’s financial statements in the projected period by removing Maxeon’s revenue and expenses and reallocating some corporate overhead, interest, and D&A:

SunPower Adjusted Statements

Maxeon’s separate statements required fewer adjustments, but we modified them to reflect higher expenses following the separation:

Maxeon Adjusted Statements

Step 2: Select Comparable Public Companies for Each Division

For SunPower, we selected the two public, pure-play solar service/installation companies at the time of this transaction: Sunrun and Vivint Solar.

They traded at revenue multiples that were far higher than SunPower’s:

Sunrun and Vivint Revenue Multiples

For Maxeon, we selected a mix of Chinese and North American solar manufacturers, with median revenue multiples between 0.5x and 1.0x:

Maxeon Public Comps

We do not do anything with these multiples at this point.

There’s no point backing into an Implied Share Price based on this comparable company analysis because we want the Implied Share Price for the entire company.

Step 3: Build a DCF Model for Each Division

The DCF model for each company is standard: Revenue, EBIT, and NOPAT, add D&A, add/subtract the Change in Working Capital, and subtract CapEx in the Unlevered FCF calculations.

We calculate the Terminal Value with the Multiples Method and Perpetuity Growth Rate Method.

There are two differences worth noting;

1) Net Operating Losses – Since both companies have significant Net Operating Loss balances, we project the NOL creation and usage in the explicit forecast period and their possible contributions to the Implied Enterprise Values at the end.

2) 15-Year Projection Period – Since Maxeon, the lower-margin manufacturing company, will take years to become profitable, we extend the projections to 15 years rather than the normal period of 5-10 years.

You can see part of the DCF for Maxeon below:

Maxeon DCF Model

We build sensitivity tables based on the Discount Rate, Terminal Growth Rate, and Terminal Multiple to determine the range of Implied Enterprise Values for each division.

Putting Together the Segment Results in a Sum of the Parts Valuation

Once we have all these individual pieces, we can put them together to estimate the value to shareholders if this spin-off proceeds as planned.

Step 4: Determine the Entire Company’s Implied Enterprise Value

Since both divisions have negative EBIT and EBITDA currently, we focus on the revenue multiples and the DCF output in this part:

Sum of the Parts Revenue Multiples

In a normal Sum of the Parts Valuation, we might also make an adjustment for corporate overhead here.

One problem with analyzing the divisions separately is that they often need services that the larger parent company provides.

And if the expenses for these services are not included in the separate financial statements, each division’s profitability might be overstated.

For example, if neither division has an Accounting team but instead depends on “corporate headquarters” for this function, we need to subtract the capitalized version of that expense.

We skip this adjustment here because:

1) We’ve already re-allocated corporate overhead costs appropriately in the separate models.

2) We’ve assumed “dis-synergies” for Maxeon in the separate model, so its Operating Income is already lower as a result of having to pay for expenses that the parent previously covered.

3) SunPower is already a self-sufficient company, and it will keep all its non-Maxeon divisions after the spin-off. There are no additional expenses to subtract because SunPower already has teams to handle functions such as accounting, IT, and HR.

Step 5: Cross the Bridge to Implied Equity Value

Once we have the range of Implied Enterprise Value figures, we can add non-operating Assets and subtract Liability and Equity line items that represent other investor groups to get the range of Implied Equity Values:

Sum of the Parts Valuation - Enterprise Value Bridge

Even though the items in this bridge will change slightly following the spin-off, we’re still using the pre-spin-off numbers here because we’re looking at the entire company.

Step 6: Calculate the Implied Share Price (If Applicable)

You might skip this step for private companies because share prices are less meaningful there.

In a normal Sum of the Parts Valuation, this step would be a simple matter of dividing the Implied Equity Value by the company’s share count (with support for a circular calculation for the diluted shares, if required).

Here, we divide by the combined share count of SunPower and Maxeon:

Sum of the Parts Valuation - Implied Share Price Calculation

Since this is a spin-off that happened in real life, we want to reflect that SunPower shareholders received 0.125 Maxeon shares for each 1 SunPower share.

By completing this spin-off, in other words, the total share count increased.

Some would disagree with this adjustment and say that we should use only SunPower’s pre-spin-off share count.

If you changed the model to reflect that, the results wouldn’t change much (there’s a ~5-10% difference).

Sum of the Parts Valuation: Conclusions for SunPower and Maxeon

The overall conclusion is that if this spin-off is even slightly successful, the SunPower shareholders should see a big increase in the value of their shares.

The share price may not increase by 200-300%, as suggested above, but if the pure-play services/installation division (SunPower) trades at a revenue multiple that’s even slightly closer to the multiples of Sunrun and Vivint, it will be a win for the shareholders.

The operational logic is more difficult to justify because we don’t know the true benefits of spinning off the manufacturing division.

SunPower claims that it can reduce costs more effectively to compete with the Chinese solar PV companies that way, but we don’t have enough information to say for sure.

This tutorial is a small taste of the knowledge you’ll gain in our paid courses. Breaking Into Wall Street uses real-life modeling tests and interview case studies to prepare you for investment banking and private equity interviews – and a leg up once you win your offer and start working. Find out more about our advanced training by via the button below:

About Brian DeChesare

Brian DeChesare is the Founder of Mergers & Inquisitions and Breaking Into Wall Street. In his spare time, he enjoys lifting weights, running, traveling, obsessively watching TV shows, and defeating Sauron.