I’m building out an office/ industrial model from scratch that feeds off an Argus dump of cash flows. Anyone willing to share examples? I have some dialed-in Multifamily models and I’m happy to do a swap.
Trending Content - Real Estate Forum
| +47 | What Is Your Backup Plan? | 21 | 12h |
| +39 | Where are free agents signing? | 21 | 2d |
| +36 | AvalonBay Equity Residential Merger discussion | 16 | 1d |
| +34 | Future of Real Estate | 9 | 2d |
| +28 | Extremely Slow Ramp Up | 5 | 23h |
| +17 | Most Correct Way to Grow Rents in MF Development Underwriting | 1 | 21h |
| +16 | In RE, what is the ONE software tool you couldn’t survive without? | 6 | 22h |
| +14 | CRE Banking @ Top 3 Bank or Asset Management at Public REIT | 9 | 54m |
| +10 | Dynex | 5 | 2d |
| +9 | PGIM investment analyst low pay | 8 | 1d |
Career Resources
Pm me
Array formula with INDEX / MATCH (Xlookup also possibility, but I’ve been too lazy to rebuild by old models to incorporate Xlookup), with EXACT / TEXT formulas that look to Argus “dates” in header row (which are exported as text).
SUMPRODUCT could also work if applied correctly.
A bit annoying to set up but once you do, you can literal copy/paste and Argus CF export forgetting about helper formulas and it will pull properly.
Looking for pointers here. How do y’all work around line item naming? Like different firms/models will use different naming conventions for various line items. I’ve seen it done where you manually code line items or alternatively you just index match the given line items and work with the model as is.
Is it typical to try and manually code to get items to match up with your firm’s naming or do you just use the cash flows as is and work around it? At some point I realize all you really need from an ARGUS dump is the net cash flow, but sometimes for specific calculations you need a consistent format to properly calculate things. Hence needing certain items in a consistent spot/row in the model.
My firm has a column to the left that lets us "classify" what each line item is, with the naming that we use. This said column is then SUMIFs to another CF tab that is ultimately used to calculate the returns
This is what we do as well
Would anyone be willing to share the office model with me?
I don't have any models or modeling wisdom to share BUT I am willing to receive your multifamily model and I will appreciate it.
Sint est sint dolorum quam eos corporis. Vero corrupti doloremque at omnis sed. Voluptas velit at molestias. Enim quos eaque perferendis dolorum ipsam eveniet placeat. Sed nobis quae dolores iure sint velit ea.
Culpa ipsam excepturi tenetur tempore. Et neque et corporis quia. Molestiae veritatis numquam quam labore. Ut molestiae unde necessitatibus. Recusandae impedit nihil perspiciatis non ad a nemo. Harum necessitatibus beatae vitae alias.
Voluptatum in non voluptatem quod deserunt. Delectus alias soluta possimus ut ut et modi eos. Quia consequatur quae laudantium quo. Omnis neque doloremque occaecati illo. Officiis consectetur quibusdam modi molestias omnis iure.
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...