In Argus, is there any way to make construction costs take a bell-curve shape?
I need to build a development model in Argus. Suppose there is a 24-month construction period. If there are $10 million in construction costs, my understanding is that in the real world, these wouldn't simply be flat over the 24-month construction period ($416,666 each month), but rather they would be proportionately less at the beginning, greatest around month 12, and then gradually ramping back down towards the end.
I've seen excel models that can emulate this, but I'm wondering if anyone knows how to do something similar in Argus.
Thanks for any insight!
Have you considered... using excel? Argus is so inefficient for anything other than forecasting commercial IPP cash flows...
This is for consulting work and the client expects us to use Argus. Is it generally not feasible to build development models in Argus?
I haven't seen it done often - I mostly see Argus used for cash flow projections and dropped into an Excel model. That doesn't mean it CAN'T be done, but perhaps it shouldn't be.
I believe you’re looking for a construction draw schedule.
You can manually input the capital costs by month under expenses
Yes, calculate it in Excel, then copy and paste the values into Argus on a monthly basis, under the "..." option
How did you convince someone to pay you for consulting work and not know excel is arguably the most efficient way to do this and there's simply zero need to do this in ARGUS / would likely not even be logical
Long story but it's for a bank and they require Argus to be used for anything involving a DCF... I agree that this is not what a developer would use.
Never seen it done in ARGUS. Excel only.
use Argus developer...
This! I am probably one of the few people who actually used the product but it serves it's purpose. Developer is fine, but like with any other ARGUS product, the cash distribution waterfall option never efficiently works.
Velit dolorem ut qui. Nihil occaecati qui nobis dolorum. Nam et autem ipsa assumenda consectetur. Qui quia quibusdam ea illo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...