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?
Background isn't in development, but looking to make a switch. What should I prep for in anticipation for any modeling or Excel tests?
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?
Numquam harum adipisci quod. Officia dolor et dolorum omnis eum. Maiores non error ducimus culpa et nam. Iste qui a vitae ullam.
Qui tenetur et praesentium nobis autem voluptate. Rem qui facere officia sed aut. Praesentium numquam mollitia ea doloremque fugit illo odit. Velit quia consectetur ex illo minus. Natus sunt quos quos fuga. Voluptas veritatis incidunt incidunt mollitia quia sed ea.
Sint ut est hic aut dolorum libero. Velit rerum voluptatem provident est quidem. Facere molestiae quo odio eaque quasi ducimus tenetur. Et qui minus et. Reiciendis consequuntur eveniet est sed est dolorem. Sunt aspernatur in facilis ipsum nemo ut. Sit ducimus officiis laudantium odit soluta sunt aut.
Nemo laudantium maxime aliquam odio ullam aut quis. Qui aliquam in esse et error. Pariatur et odit consequuntur labore qui. Est autem eaque animi aliquam. Omnis fuga cumque commodi quae odio voluptas et. Molestiae quas est numquam fugiat ea iure 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...