ARGUS help

Subscribe

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?

Comments (4)

 
Jan 16, 2020 - 7:25pm

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.

Array
 
Most Helpful
Jan 17, 2020 - 9:47am

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

Start Discussion

Total Avg Compensation

September 2020 Investment Banking

  • Director/MD (17) $704
  • Vice President (45) $323
  • Associates (255) $228
  • 3rd+ Year Analyst (37) $203
  • 2nd Year Analyst (141) $153
  • Intern/Summer Associate (133) $141
  • 1st Year Analyst (561) $129
  • Intern/Summer Analyst (543) $82

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.3
2
Jamoldo's picture
Jamoldo
98.3
3
Secyh62's picture
Secyh62
98.2
4
CompBanker's picture
CompBanker
97.8
5
Addinator's picture
Addinator
97.6
6
redever's picture
redever
97.6
7
Edifice's picture
Edifice
97.6
8
frgna's picture
frgna
97.5
9
NuckFuts's picture
NuckFuts
97.5
10
bolo up's picture
bolo up
97.4