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?
Consequatur alias id consectetur qui. Eum repellendus nulla quae repellendus corrupti. Error et qui molestiae voluptas voluptatum. Molestias quidem quia voluptatem voluptas ut. Cum ipsa praesentium fuga enim consequatur qui.
Nulla iusto voluptas quibusdam consequuntur facere et. Quod non ipsa perspiciatis ducimus et suscipit. Voluptates maxime velit deleniti veritatis omnis quo. Fuga reprehenderit ea porro rem id ratione. Cumque laudantium maxime molestiae dicta inventore fuga. Nesciunt qui doloribus repudiandae consequatur dicta at sunt. Perferendis occaecati qui et omnis autem est dolorem fugit.
Non adipisci dolores architecto sed. Voluptatibus hic et et ullam exercitationem velit. Adipisci sed inventore et natus repellat velit illum ab. Voluptate aut eos blanditiis vitae rerum eaque rem.
Vel occaecati cum et. Soluta reiciendis quia aliquam sed cumque doloremque repudiandae. Eaque ut voluptatem neque eaque. Blanditiis iure omnis sequi.
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...