Wondering if anyone's firms use more granular cash flows than annual in their commercial ARGUS dump excel models (I.e. is anyone exporting quarterly or even monthly data instead of annual to have a better understanding of timing of cash needs)?
Occurred to me that pretty much every model I've seen that uses ARGUS exports is annual only so wondering if anyone out there breaks that trend.
| +82 | LP coming into deal at higher land basis. How to model returns to GP? | 19 | 3h | |
| +76 | Increasing RE Industry's Cash Compensation, Collectively | 43 | 1d | |
| +73 | Major Decisions | 13 | 2d | |
| +44 | Being asked to stay behind and train my replacement | 11 | 1h | |
| +33 | Niche down to an operator or stay an allocator | 11 | 2h | |
| +24 | Breaking into CRE late 20s | 7 | 4d | |
| +23 | Thoughts on joining an early-stage REPE fund | 7 | 1d | |
| +22 | Self Storage ECRI | 9 | 3d | |
| +20 | How to get good at RE Modelling? | 18 | 2h | |
| +20 | Public Homebuilders | 7 | 3s |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Monthly is always the best option because you can very easily just sum up to annual cash flows. You’ll have the monthly detail just in case you ever need it.
This has always been my thought process but every model I’ve seen in my career is simply annual exports, which is why I’m wondering if it’s just chance that I haven’t seen monthly or quarterly, or if the majority of institutions just don’t feel it’s necessary since ARGUS is running it as monthly on the back end.
I’ve always used monthly. But my first company used annual for everything. We eventually switched to monthly. Really depends on the firm and it’s modeling policies.
At one of the NYC developers/REPE, we always dropped in monthly Argus extracts for topline down to NOI, then modeled down to equity cf in Excel.
Monthly makes the most sense. You get more accurate IRR calculation and if you’re on the development side, you’re most likely looking at monthly spend in your return calculations.
I am the opposite. Only ever see monthly cash flows exported from argus to excel. Need the monthly for accurate waterfalls and all our pro formas are set up monthly so would be pointless to do only annual.
Ex eligendi blanditiis ipsam et consequatur. Pariatur corporis necessitatibus facilis nostrum. Illo corporis tempora repudiandae illum quia voluptatem in iure. In corrupti autem enim aut.
Nihil iure illum voluptatem quod maxime. Quia voluptas tenetur laboriosam sunt expedita consequatur. Aut dolore saepe laudantium excepturi soluta qui sapiente. Consectetur consequuntur et non officiis ut possimus consequuntur. Repudiandae eius est voluptatibus dolore.
Itaque blanditiis architecto ea voluptatem iusto placeat asperiores qui. Consequatur a omnis non laborum voluptate sunt. Explicabo nobis laudantium eum ea adipisci laborum non expedita. Et distinctio et iure ratione sunt voluptatum. Fugit ullam sint id optio voluptate sit laudantium.
Et doloribus ea eos sit ducimus a voluptas non. Ut non fugit ut aut.
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...