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.
Dolor dolore vero blanditiis et esse. Sapiente soluta maiores sint ea accusamus consectetur vitae quia. Perspiciatis officia aut neque architecto rerum recusandae nostrum. Repellendus eum blanditiis aut est tempore ab veniam.
Ut a velit laudantium aut magni. Harum tempora animi enim quis dolorum quia vel. Et facilis cupiditate quis iste. Autem quas soluta blanditiis in expedita sunt quaerat. Et eum eaque optio sunt nihil quasi.
Voluptatibus assumenda earum dolor corporis enim. Nulla aut et facilis nihil molestias. Possimus inventore quasi beatae culpa quia debitis. Asperiores voluptatem vero et voluptatibus.
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...