Argus vs Excel which one is more common/better
i am a first year analyst in a brokerage firm. my current firm requires me to use Argus when i do the modelling but i found it is not as flexible as excel. and i cant learn much using Argus (don't understand the rationale behind it)
my previous job was in a buy side firm , everyone uses excel when do financial analysis. and i saw senior analysts build a model from scratch
what do you think? is excel better or Argus better? if i want to improve my modelling skill shall i use more excel?
It depends on the type of asset you're modeling and the complexity. It is often useful to use Argus to model out the cash flows for retail/office assets. These types of assets usually have uneven streams of cash flows due to different start dates/lease expiration dates. In addition, the complexity of the expense reimbursements can make it difficult to model out on Excel. For instance, if you have 30+ tenants in a building with different lease structures and different start/expiration dates. It would be very difficulty and tedious to model out.
Once you have figured out the cash flows from the asset. You can export it out to an Excel format (usually using your firm's template), and model out the rest and run different return analyses/promote analyses. But if you're working with multifamily or single-tenant assets, you might not need to use argus.
Hope that helps.
For a person who hasn't worked in this field but is entering into it (hopefully) as a first year analyst, would you say knowing argus is essential or will I learn that on the job?
Depends on the firm. But it shows a lot of initiative if you take the money out of your own pocket and take the course/get certified.
Agreed with the above. I don't have an Argus license so doing my office acquisitions modeling is a real bear. I f*cking hate not having Argus for doing my office modeling. I don't see a need for self-storage, multifamily, or hotels, but definitely see it as a near necessity for retail and office analysis (at least for granular analysis).
Do you have to have an Argus license to use the program?
Basically. I think you can get some less expensive scholastic license, possibly. I think the neat thing about Argus is that everything is negotiable.
Starting Argus overnight is probably a little too difficult. There is a lot of functionality to the program and it will help incrementally more once a) you know what you are doing, b) you know what you can do with it, and c) the asset (or the portfolio) is large enough to benefit from being modeled in Argus.
Yet again, I've understood that on the buy/ownership side, Argus outputs might get churned through another layer of modeling, for which Excel is used (complex financing, JV waterfalls, etc.).
Maybe Argus is an American thing but in London on the finance side nobody has even heard of that software. I do a lot of real estate modelling and it's always ever been in Excel.
How in the world do you model office and retail properties with multiple tenants in Excel? I tried creating an Excel template for that and it's nightmarish.
With a little bit of elbow grease and an overzealous junior analyst :)
Not saying it would be easy but I don't see why it couldn't be done. If necessary some of the underlying granularity might be lost but financial models are made up numbers anyway....
Plus models often have to go to many different parties which means it's got to be in a format that everyone knows and understands i.e Excel.
Doable with a detailed Inputs Summary tab at the beginning of the model.
It's doable, but more prone to error/omission with large retail/office assets than Argus.
Is it ARGUS AE?
I always start with my own Excel template and tweak it a bit in the process depending on my assumptions and strategy. I do this since each property has a unique upside we can capitalize on.
Usually brokers/owners would send in an AE file with their OMs. I run and tweak what they have, editing the assumptions and what not, to fit my assumptions. If there is more modelling needed not possible on AE, I export and tweak them in Excel again (maybe 1/3 of the properties I analyze).
Most of the time I think an Excel model is enough but the VPs would still ask for an AE model as it has become a standard.
There have been a number of these threads about Argus and Excel, but in general the two programs are used together. They're not competing products. Argus is a great way to export the cash flows section into your Excel investment returns model.
Also, I meant to add that if you're working for a brokerage, an Argus model should be something you're providing to prospective buyers so that they can easily see what assumptions you're using them and then tweak to their liking.
Exactly. Brokers' assumptions are pretty optimistic. Export the cash flow into your firm's template to figure out the property level IRRs/multiples and promote, etc.
Eum modi quae quia repellendus delectus. Ullam quaerat dolore aut dolore. Voluptas harum et consequatur cumque ut rem. Commodi illo blanditiis atque sunt expedita.
Id inventore inventore eligendi ad molestiae aperiam cupiditate velit. Assumenda rerum molestiae ipsam autem voluptatem placeat natus. Et recusandae fuga atque omnis voluptatem dolorem. Nostrum quasi rem incidunt quo sapiente. Sed ex ad impedit cum officiis dolor enim. Eos hic nemo aut rerum unde dignissimos.
Voluptates explicabo soluta distinctio. Ut id laborum rerum consequatur alias quia. Non est qui voluptatem consectetur.
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...