Valuing a Division of a Company (DCF)

Hello,

I have a question regarding a (uni) project I'm currently working on.
My task is to carry out a DCF valuation of ThyssenKrupp's elevator division.
Have created several DCF analyses in the past, but I'm kind of stuck at the moment. Reason is that most of the figures reported in their ARs are consolidated figures. How can I, for example, calculate historical and forecasted FCFs if I do not know some of the items that I need to calculate it?

They do report sales, EBIT, CapEx and D&A on division-level, among other things, but obviously not working capital (current assets and liabilities), leases, etc.
What kind of assumptions would be sensible to make in this case so that I can calculate the FCF?

Many thanks in advance for the help.

 
Rover-S:
You have all the elements for a DCF. Take leases as part of your WACC calc --> you can base this on peers.

The professor calculates FCF like this: EBIT * (1 - T) - Reinvestments And reinvestments consists of CapEx, Change in PV of Operating Leases, Change in Non-Cash Working Capital, minus D&A. How would you be able to derive the FCF if you only have the consolidated numbers for Non-Cash Working Capital and Operating Leases? Or am I missing something...

 
Rover-S:
Do they not capitalise operating leases? Mandatory under IFRS I believe. In that case it's in debt and you can ignore it as equity price will move with debt quantum buyer assumes from seller.

This is a fair point. I believe they adopt this rule as of FY2019-2020, so I could indeed do that. Any idea what to do with working capital? You said I have all items I need for FCF, but I'm not quite sure how to calculate it without that part. I was thinking, maybe calculate the change in working capital for the entire company for the forecast horizon, and then take a certain % of this... but seems very shortsighted to me.

Thanks a lot for your time

 
Most Helpful

^This. You (presumably) have comps for the business anyway, so do a quick spreadsheet showing those companies' working capital ratios, take the average, and apply it to the business you're valuing. Bankers routinely do this for client presentations, at least until they have better information, so if it's good enough to clear that pretty high bar, it should be more than sufficient for academic work,

It's unlikely that your business has substantially different WC ratios vs. the comps, so you're likely to end up with a pretty accurate FCF number.

 

Ullam dignissimos ex voluptas nihil laboriosam illo. Cupiditate blanditiis eos possimus. Nobis commodi minus quia numquam dolorum sint.

Est est temporibus et. Dolores eius repellat aliquam sit. Sint corporis quia qui sit aut. Nobis deserunt adipisci repudiandae est eum consectetur ab voluptatem. Itaque quisquam quo qui ipsam. Ut consequatur quam ipsa quas.

Voluptate corporis aut sed quas placeat. Velit vero qui provident quaerat aut voluptatem.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”