Argus Enterprise - Debt Modeling
Can anyone show or direct me to some text explaining how to model a stabilization loan for an unstabilized asset. Then, once stabilized, refi? (In Argus Enterprise)
Can anyone show or direct me to some text explaining how to model a stabilization loan for an unstabilized asset. Then, once stabilized, refi? (In Argus Enterprise)
+51 | Leave brokerage to be GP | 12 | 7h | |
+46 | New Comp Database - Google Form (Now with Data Validation) | 24 | 6h | |
+24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 1d | |
+23 | Going out on your own | 4 | 10h | |
+22 | REPE/Development GPA | 15 | 3d | |
+21 | Real Estate = complicated + underpaid | 15 | 10h | |
+17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 4d | |
+17 | Fisher Brothers | 6 | 8h | |
+16 | UC Berkeley MRED vs Columbia MSRED? | 2 | 6d | |
+15 | Spreads over SOFR/UST | 1 | 9h |
Career Resources
Hey m.mannina28, I'm the WSO Monkey Bot...do any of these help:
Fingers crossed that one of those helps you.
Don't believe you can without dumping into excel. I've tried for months to tinker, nothing has worked. Asked buddies at all the debt shops, nothing. Called ARGUS, nothing (SHOCKER!).
If you find out, please let me know.
Honestly, why would you even want to do this? Just make your amortization table in Excel and it will take you
AE keeps a lot in AE, unlike DCF. That's why we were first intrigued. Being able to adjust (good news $, TI allowance, ETC) in real time would save a ton of time, instead of jumping back and forth dumping and re-dumping. Saving 1 minute (which cmon is low) on something you do 30 times a day...
We used to build our CF’s in AE and then dump into Excel and model debt in excel. However, we’re required to model all debt in AE now. I got through to someone at Altus, so I’ll get back on my findings. Hopefully, it will be of some help. BTW, relatively new analyst, so I’m still trying to find my way here. Appreciate your comments and feedback.
Why are they requiring you to model debt in ARGUS?
I've heard a couple arguments, but none better than because you can and people expect that level now.
It saves VP/MD time to not have to jump back and forth between programs to see what the junior analysts mess up. No offense OP, we've all been there. Plus I suck at ARGUS now. Also, any excel that is programmed to receive an ARGUS output is very proprietary. Sharing between broker/debt team/buyer/seller and staying in AE saves a ton of time, and the model to model disputes are no longer relevant.
Lastly, you can see live exactly how debt is going to manipulate the model and make changes to timing, I/O, TIs while staying in the program. Make changes to the model to react, without the dump process.
Full candor, because everyone's corporate paid for the switch to AE and expect everyone to use it to it's full potential. RIP DCF.
Ut minus quod perferendis eos ratione voluptas quo. Natus molestias nesciunt explicabo occaecati voluptatem consequuntur. Nobis magnam sunt dolorem. Aperiam sed quasi non qui sed culpa exercitationem.
Qui dolorem optio doloremque iusto mollitia eius quia. Quidem est eos velit cum dicta ipsa. Commodi dolorem molestiae rerum.
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...