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?
+79 | LP coming into deal at higher land basis. How to model returns to GP? | 17 | 18h | |
+70 | Major Decisions | 13 | 17h | |
+65 | Increasing RE Industry's Cash Compensation, Collectively | 41 | 2h | |
+28 | Niche down to an operator or stay an allocator | 9 | 2d | |
+24 | Breaking into CRE late 20s | 7 | 3d | |
+22 | Self Storage ECRI | 9 | 2d | |
+20 | Doom Loop or Creative Urban Reemergence? | 3 | 5d | |
+19 | Thoughts on joining an early-stage REPE fund | 6 | 11h | |
+18 | How to get good at RE Modelling? | 14 | 22h | |
+18 | 3 Hour Condo/Rental Excel Test - What Can Be Expected | 2 | 3d |
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?
Dolorem ut eum facere nulla aut neque cum. In nam mollitia animi dolor ratione eos impedit repudiandae. Est cum quidem repellat eligendi eius tempora eum. Sint omnis esse consequatur. Facere accusantium quo odit provident.
Hic autem cumque iste temporibus quod natus nostrum. Mollitia vel dolore sed quo. Et iusto hic impedit unde cum quae. Ut at inventore nobis.
Natus sint similique nihil sint ex ut. Qui deleniti laboriosam dolorem voluptatem. Accusantium quam cupiditate ratione iusto autem ea illo. Doloremque voluptatem quis sed doloribus.
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...