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.

 

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).

Array
 

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.).

 
Best Response
Dances with Dachshunds:
williamthesnake:
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.

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.

I come from down in the valley, where mister when you're young, they bring you up to do like your daddy done
 

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.

 

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.

Array

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (85) $262
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (65) $168
  • 1st Year Analyst (198) $159
  • Intern/Summer Analyst (143) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
kanon's picture
kanon
98.9
5
Secyh62's picture
Secyh62
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
bolo up's picture
bolo up
98.8
10
DrApeman's picture
DrApeman
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”