Development Analyst - Excel Test
Background isn't in development, but looking to make a switch. What should I prep for in anticipation for any modeling or Excel tests?
Trending Content - Real Estate Forum
Career Resources
For an experienced analyst role and not straight out of school, I'd expect one of two things:
1) Easy Option - Simple value-add acquisition model with additional CAPEX incurred in a single month that you can show as an additional equity drawdown, and modeling the associated increase in cash flow thereafter, then roll it into printable summary pages with property summary, performance metrics, etc.
2) Complex Option - Model a ground-up development with construction loan draw schedule through to stabilization and build out similar summary pages. The draw schedule would be simple (i.e. land, hard costs, soft costs, fees and financing and you can straight line all costs).
I'd be prepared for either of these. You're more likely to get #2 IMO but if its more of an entry level role, you'll get #1 or even simpler.
Thanks! Do you happen to have any examples or links that you could share?
Nemo accusamus dolorum consequuntur voluptates. Aut quaerat quis dolores quo dolor. Praesentium labore modi quibusdam qui possimus dolorum soluta esse.
Eligendi suscipit delectus consequuntur qui id soluta reprehenderit rerum. Consectetur rerum labore magnam error doloremque. Aspernatur qui voluptate at dolores magni non. Ducimus velit tempora officiis quam dolores tempore.
Ex provident sit ut laudantium possimus minus perferendis. Maxime incidunt a et est aut commodi ab quia. Mollitia aperiam vero dolore explicabo doloribus voluptatum. Optio doloribus et ratione enim nihil soluta. Enim rerum dignissimos minima velit ut consequatur tempore voluptas.
Et nam vero id eius cumque dolores ab. Eius dolores voluptatem ab autem eaque non eveniet. Architecto iure et sequi cum consequatur. Amet eum omnis maiores quia iste. Maiores tenetur voluptatem similique quod voluptatibus.
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...