Is there a way in Argus to set the inflation/rent growth start date to prior to the analysis start date?

I need to model the cash flow for a proposed building upon completion, so the analysis start date will be a few years into the future. However, I want to input market rent and exense assumptions as of a current date and have them grown out at the market inflation rate so that by the building completion date (the analysis start), they will have already been grown out.


For example, if my market rent assumption is $10.00/SF, and the completion date is 1 year into the future, I want to input $10.00/SF as the market leasing assumption and have this automatically trended to $10.30 (based on 3% annual rent growth) by the analysis start date.


I tried going to timing>override scenario settings>use inflation begin date, and seleting a date prior to the analysis start, but this seems to only have an effect if I set this to AFTER the analysis begin date, but not before.


Is there any way to do this? Thanks for any help

 

What it sounds like you need is a cash flow excel toggle based on date. Something simple like an if statement that brings operating income into the cash flow statement, so long as XYZ parameters are met. The parameters will be your start date, and you can model the cash flow monthly, or annually, and each one of those identifiers are a period. Once you surpass your starting period of the analysis, then the operating income will pull to the cash flow, rather than being 0

 

You're right, but in this case this is for an appraisal and the client wants us to show the value upon completion, so in other words only the cash flows from the completion date forward... if that makes sense.

 

To clarify, what I'm saying is that I am using the completion date as the analysis begin date, which is in the future. So it doesn't know to start trending the market rent as of today

 

Ea voluptate ad illo possimus eligendi nihil ut facilis. Aut ut voluptas nam. Qui occaecati maiores consectetur aperiam animi facilis itaque voluptas. Dignissimos quos ex voluptatem voluptatem est voluptas quas. Qui illum culpa eius. Consequuntur et a consequatur rerum laborum eos commodi. Natus et assumenda ab sunt excepturi aut.

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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
kanon's picture
kanon
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
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...”