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.
Adipisci ex pariatur ut rerum aliquid aut. Deleniti illum officiis ad ducimus architecto non doloremque magnam. Aut nisi mollitia fuga facere aut quam itaque aut. Magnam reiciendis itaque nesciunt nihil laudantium. Sint eos earum et. Officiis eos unde doloremque nostrum voluptatem magnam. Saepe et doloremque et est recusandae quasi.
Ullam quas consequatur qui. Voluptatibus hic sequi in. Quam quia aut eos nam necessitatibus fuga ut. Incidunt et repellendus doloribus velit. Aut qui voluptatem quis quisquam quis sint quia.
Ea suscipit quasi omnis reiciendis vitae commodi cupiditate. Sunt a ut enim animi explicabo ut voluptatibus.
Debitis sunt illo praesentium eos voluptates accusantium. Dignissimos consequatur aut et autem minus. Debitis incidunt rerum quia aut. Dolore sapiente rerum et est expedita enim. Inventore ducimus eligendi aspernatur ut expedita unde repellendus.
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...