General Variable Naming Argus allows for variables across different sections, i.e., Area Measures and Expense Groups, to be named the same even if the contents of said metrics are different. This provides the opportunity for error across the model as variables can be incorrectly referenced by user(s). Expense Groups Argus allows for expenses to be…
Leasing Commissions-Pro Fee + Free Rent When calculating the Pro Fee, the software takes 1st Month’s NET of free rent; therefore, if a tenant has free rent during the first month of the term, Argus calculates $0 as the Pro Fee. Workaround: Model Free Rent beginning in Month 2 of Term to properly account for…
Base Year Caps Argus cannot calculate an annual cap any differently than a cumulative cap as the “Limits” function for a Percent of Other line item does not have this option. The calculations are always cumulative in Argus. This does NOT apply to net caps built within the reimbursement method. Workaround: NONE. Admin Fee w/…
Naming Conventions User should create habits of utilizing naming conventions that sorting/filtering functionality as well as communicating contents of the applicable variable. Such conventions increasing transparency of the model and ease of use for analysis/future updates. Examples: Reference Accounts While there are many uses for reference accounts, User has to be careful as to make…
Internships are almost twice as important as one’s major, three times as important as your GPA, and 5 times as important as the college reputation. This research comes as no surprise to ACG as our internship program is the best program in the industry. We have had 47 interns over the past 14 years, most…
If you are applying for an analyst, acquisitions, asset management, or brokerage position then you should make sure that you add as many numbers to your resume as possible. For example, don’t just state that you were involved with the closing, due diligence and structuring of numerous real estate transactions. Instead, write “involved in $1.2…
When you interview for a job, you most likely will be asked to describe your former employers. Make sure that you are positive about the job and about the person to whom you reported. I had one candidate tell me recently that his boss was having an affair and his supervisor was an idiot. No…
According to an article in Business Insider, there are some words that you should not use to describe yourself when you are interviewing. These include intelligent (versus quantitative and analytical), likable (versus high-energy, team-oriented) and successful (versus your specific value that you bring to the table). You want to be able to articulate why you are…
According to Dave Kerpen, CEO of Likeable Local, there comes a time in every job interview when the interviewer asks, “Now do you have any questions forme ?” This is a terrific opportunity to impress the interviewer. Kerpen addes that the most important question you can ask is, “How will the work I’ll be doing contribute to the…