Expertise needed: FSM Won't Balance

Hello helpful Professionals,
I am building my first proper model right now on WTW - see attachment. The model is incomplete but I believe my projected B/S should balance where it is right now.I have read the tips in other similar threads here on WSO and no avail. I have done my best to format for ease of auditing so I hope someone here will be so kind as to take a quick look for me. This would be very much appreciated.

Thank you in advance,
BottomUp

PS - Thoughts on WTW are welcome. I'm working toward pitching this stock in an ER interview I have coming up.

Attachment Size
WTW.xls 88.5 KB 88.5 KB
 

There are some accounts I mashed together that definitely need to be separated out and have separate schedules built for them. I am following the example from a modeling course so I don't get confused and it is definitely not appropriate for WTW financials (Ie. the example company is 100% equity financed and WTW has a massive debt load). However, I believe it should still work the way I have set it up even if it isn't telling an accurate story... After I figure this out I can take a deeper dive and add more insight/detail to my assumptions.

 
Best Response

I'm bored so I'll bite. There are two issues.

  1. In your cash flow statement, there shouldn't be a line item for PPE. You already have depreciation and capital expenditures in there, so you're effectively double counting the change in PPE. Just delete that row.

  2. For 2015-2018, your accounts payable formula in the cash flow statement is backwards. It should be CURRENT_YEAR-LAST_YEAR, so that if AP goes down, that's a drain on cash.

After those two changes your BS should balance.

 

Minus numquam consectetur rerum in alias. Magnam est accusantium vel asperiores veniam aliquid quisquam. Provident eaque voluptatem sit non aliquid architecto ut.

Impedit tempore ab maiores illum. Nemo sequi sed laudantium eligendi nemo quam praesentium cum. Ut voluptatibus et architecto. At itaque ut officiis suscipit suscipit quas ut sunt.

Et ut dolorem deserunt beatae. Aut quasi a vitae blanditiis. Repellat quas facilis qui voluptatem nobis tenetur. Numquam iusto sed nihil ea amet occaecati et. Error veritatis est eveniet sint modi blanditiis. Praesentium soluta ut est numquam cumque.

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
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
DrApeman's picture
DrApeman
98.9
8
CompBanker's picture
CompBanker
98.9
9
kanon's picture
kanon
98.9
10
numi's picture
numi
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...”