ARGUS help

Hi,
Please excuse my ignorance in advance. I have been learning Argus, but haven't been able to figure out how to properly structure expense inputs/expense groups/etc to reflect the scenario below.

My primary question is: In Argus Enterprise, if a tenant that has an an expense cap on controllable expenses, but the expenses that make up controllable expenses have different recovery denominators, how do you create the structure to achieve this within Argus. My understanding is that you arent able to include the various expenses in one singular expense group due to the difference in denominators across recoverable expenses. Any help would be greatly appreciated. Example below.

Retail Tenant: 10,000 sf
Initial CAP on controllable CAM items: $3.50/sf (year 1 cap of $35,000)
Thereafter, CAP on controllable grows 3.5% non cumulative (Ie if expenses are 28,000 in year one, year 2 cap is 28,000 * (1+.035))

Controllable CAM consists of:

**Expense Group A **
Denominator: 135,000 sf
Multiple expenses
- Expense 1
- Expense 2
- Expense 3

Expense B:
Denominator: 122,000 sf
Single Expense

Expense C:
Denominator 107,000 sf
Single Expense

How do I input into Argus to reflect the CAP that applies against the aggregate total of Expense Group A, Expense B and Expense C, all of which have different denominators?

 

Thanks, that makes sense and I think I have done that.

I think the issue that I am experiencing when doing that is that I need the total expense CAP to apply to the aggregate of expense group A + expense item B + expense C, but cant find a way to do it. If i apply the cap to each one, or even try to prorate the cap it across categories it wouldnt necessarily achieve the end result of total cap vs sum of expense recovery from A, B and C.

Ie. is there a way to have the cap apply against the sum of the expenses?

If they were all grouped under one expense group it would be simple, but it appears that I cant create a group with different denominators without disrupting the pro- rata share?

Thanks again for the previous response.

 
Most Helpful

I have to model deals like this all the time. I'm actually working on 2 right now that have this type of structure. Here is the best way to work through it:

Create an expense group with all the expenses from Expense Group A, as well as expense B & C Within the expense group go to the percentage recoverable column. All of these default to 100%. Leave all the expenses within expense group A as 100%. For expense B, make the recoverable percentage 110.66% and for expense C, make it 126.17%. - This step accounts for the denominator discrepancies and can be calculated by dividing the the standard denominator (135,000) by the reduced denominators (122,000 and 107,000) Once you finish creating the expense group, make sure the area measure drop down on the recovery structure detail is set to 135,000 SF

 

Similique distinctio enim autem alias. Rem rem placeat dolorem delectus. Autem omnis odio et. Voluptas dolores et nulla dolorum nisi. Laudantium inventore molestias sed repellendus.

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 (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
kanon's picture
kanon
98.9
10
Jamoldo's picture
Jamoldo
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...”