Help: Excel/Argus Test for RE Private Equity Interview
Hello All, 

I have made it through several rounds of interviews with a RE fund manager and have been asked to take an Excel/Argus test. I feel my skills are quite strong; however, I've never taken an Excel/Argus test before and I don't want to leave anything up to chance. 

Does anyone have any mock exercises or advice on how prepare for a test of this sort? I presume they will ask me to put together an Argus model (Core: office/industrial) to calculate the DCF at a certain discount rate, then input those cash flows into excel to calculate cash on cash returns. 

My background: I work for a large bank in a Capital Markets Real Estate Group. Been there about two years as both a junior relationship manager and portfolio manager. I've underwritten/managed over $1BN in loans across various asset types and stages of development throughout North and South America.  
[{"id": "d11h68d", "text": "Damn I do this type of financial modeling, but only on excel, all day. If you find something let me know, I would really enjoy seeing some different techniques than what I come up with on my own. ", "replies": [{"id": "d1298t5", "text": "once I take it, I'll do a follow up post to share what I was given. Hopefully someone else can benefit from it. ", "replies": [], "depth": 2}], "depth": 1}, {"id": "d12ec3n", "text": "I currently work for a smaller RE Private Equity company.  When I got tested during the interview, I had to change a couple of assumptions in Argus, export that to Excel, copy it in to their model template and use that to figure out what the cash on cash returns and IRR were for the investors after the promote.  I had to do it on a projector in front of the partners, the acquisitions team and the CFO.  It was terrifying.  I don't know of any good exercises to practice it, but one thing I would suggest would be to build a waterfall model from scratch.  Unless you already do, it would be helpful to have a thorough understanding of that type of model before you go in to the interview.  I was not familiar with it when I interviewed, but I was able to fool them in to thinking I understood everything.  /u/belascocre  dropped a pretty solid model the other week that you can download from his [website](http://www.adventuresincre.com/) if you need a template.", "replies": [], "depth": 1}]