I was given this test for an acquisitions analyst role. My main concern is the assumptions for the real estate deal, particularly how to invest continuously in the same transaction. It seems too complex to do a debt/equity waterfall model when just comparing investment value after a certain amount of time. The IRA was a simple NPV cashflow model. Can anyone give me some input here?
1) Prepare a basic financial model comparing a standard 401k investment with a typical real estate transaction. You can make any assumptions you would like regarding the real estate transaction, but please be prepared to explain your logic. Use the following assumptions for the 401k: 100% match of up to 4% of a 60k per year salary Retire and withdraw 401k at age 65 You are able to invest in the same real estate transaction continuously over the allotted time
Don't overthink it, I think the people testing you are overthinking it.
Just use a standard pv,i,n,pmt, = fv for both.
IF you don't include debt for RE they may think you are lazy.
Is this for an acquisitions role for CRE or for equity for CRE?
Acquisitions at a developer.
Hahaha I know what company it’s for, I did the same test with the slides. It really annoys me that they ask you to take a test before speaking with you at all.
I’m not really sure what they are looking for in terms of assumptions but remember the debt, depreciation, and also reinvesting your cash flows from the rental property.
I know exactly...I also did the test. Haven’t heard anything back from them. Incredibly annoying due to time commitment. Have you heard back? Curious what they are looking for.
I didn't hear anything so I emailed the guy asking if he had a chance to look at it. He just said they decided to go in a different direction. I thought my deck and assumptions were pretty good but didn't get any feedback. A waste of time really, considering almost no other company is going to ask for that before a phone interview.
Such BS. At least you got an email back.
It's really a douche move to ask someone to take a test/do a project and then not give any type of feedback if you don't get the gig. I give an assessment but I only do it after I've done a phone interview and met in person. Then I give constructive feedback, it's only fair. You probably don't want to work with that group anyway, if they are that inefficient during the hiring process (which is really straightforward) then who knows what goes on in their day to day/team.
Aut ut optio omnis earum autem non repellendus quis. Iure vel nulla praesentium est quia dignissimos. Et aperiam voluptas autem saepe voluptate voluptates repellat. Aliquam facilis est dolorum eveniet nostrum eaque tenetur.
Dolor cupiditate eius nulla eos cupiditate. Corporis perspiciatis quo maxime. Laudantium illo similique sapiente ipsa. Quam dicta odio culpa rerum atque perspiciatis exercitationem est.
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...