Building Argus Export Excel model for office acquisitions?
I’m trying to create a new excel model for my company for underwriting office acquisitions. We have a decent one right now but it’s 10+ years old and the guy who created it is no longer with the company. Need to be able to export all the Argus data into it and roll it up into your standard model with a rent roll, leasing assumptions, proforma, returns tab, etc…
I have no idea how to program all the macros that are already in there. Are there any resources online where I can learn how to do this? I tried searching but it’s a pretty niche topic, so thought I’d ask here.
Based on the most helpful WSO content, here are some actionable steps and resources to help you build an Argus-export Excel model for office acquisitions:
Understand the Existing Model:
DIY Argus Training:
Excel Skills for Real Estate:
Financial Modeling Templates:
Collaborate with Senior Analysts:
Additional Resources:
By combining these resources and strategies, you can effectively build a robust Excel model for office acquisitions that integrates seamlessly with Argus data.
Sources: CRE Asset Management Learning Materials, New Analyst Struggling with Argus, Real Estate Development Modeling, Excel: Tools, Add-Ins, and Macros, Acquisitions Analyst Advice - New Analysts
What do you need to do beyond dumping in your Argus cash flows and running xlookups to your model cash flows?
It can be a little annoying but you'll just have to lineup xlookups (or whatever you prefer) to the name of the line item and run them into your model cash flows.
You can have tabs that are drop zones for the cash flows, MLAs, etc. and you can have simple coding to run sumifs off of. For example one property might have more detailed lines than another but if you standardize to categories like rental income, reimbursements, other income, its a good way to just sumif all the major sublines that drop into those categories so all your properties collapse into one clean output. If any questions asked of what is in those particular lines for particular deals you just chase down the sumif for respective property to find detail behind what is in other income, for example. Technically speaking you'd only have to check that you accurately captured those main sub-categories with your sumif formula which takes a few minutes, which epedites your scenario running and updates going forward rather than spending hours reinventing the wheel every time. happy to discuss further DM if any questions
I'll build you one for $
Tempora commodi dolorum deleniti ut debitis sed recusandae. Inventore quo aliquid cum et provident tempore quod. Vero velit facere excepturi possimus sed.
Asperiores autem officiis vitae. Ab illum quis ex minus delectus quaerat. Temporibus qui voluptatum ad quasi.
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...