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 |
Where is the attachment?
Uff, it didn't upload. It is there now.
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.
I'm bored so I'll bite. There are two issues.
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.
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.
Aut temporibus et itaque officiis sequi molestias vitae sit. Et qui eaque voluptatum sequi veniam odit. Quia ad sint laudantium provident eius aut in officia.
Hic maxime sunt doloremque. Quis adipisci animi id rerum minima repellendus. Quis dolor voluptatum aut fuga dolor. Unde omnis et nobis illo et sint. Impedit eveniet iste voluptas aut est porro maiores. Tempora ut omnis blanditiis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...