Hello, Everyone I have an excel test with a REIT acquisitions company coming up and I wanted to know what should I focus on? I am given 30 mins to complete a live exam via zoom. I just need to know what do I focus on?
Thanks
| +49 | What Is Your Backup Plan? | 21 | 3d |
| +39 | Long Game: Development vs Asset Management | 14 | 1h |
| +36 | AvalonBay Equity Residential Merger discussion | 16 | 4d |
| +34 | Future of Real Estate | 9 | 4d |
| +28 | Extremely Slow Ramp Up | 5 | 3d |
| +22 | CRE Banking @ Top 3 Bank or Asset Management at Public REIT | 13 | 2d |
| +19 | Future of Multifamily | 7 | 37m |
| +19 | Most Correct Way to Grow Rents in MF Development Underwriting | 4 | 20h |
| +17 | No IB RO considering RE | 6 | 5h |
| +17 | PGIM investment analyst low pay | 14 | 13h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
I'd say all your basic functions. Build a model from scratch. Watch videos on YouTube.Btw what is a live exam? Do you have to share screen the whole time? Sounds unbearably unnecessary.
I am not familiar with Crown Castle at all, but if it is 30 minutes over zoom, I assume it will be an extremely high-level model. It would be best to focus on unlevered and levered outputs, such as IRR, Emx, distributions, contributions, net profit. Also, they will probably ask you to create an amortization table for the debt. You probably do not need to know how to model out a waterfall, but that would be nice to know. Lastly, it would be good to learn how to use the goal seek function across the board. For instance, let's say you model it out and have an IRR they wish to achieve. You can use that function to determine the purchase price to accomplish that return. Other than that, it will probably consist of basic functions.
Sequi voluptas quas debitis rerum. Et nisi iusto asperiores voluptas. Laboriosam fugit aspernatur veritatis dolores odit ad ex. Temporibus autem sit sunt nihil et et sit. Facere aut voluptas adipisci enim et sint harum. Nesciunt ab blanditiis mollitia qui.
Soluta omnis magni quia impedit. Est dolorum quia magnam autem autem rerum et. Autem velit veritatis in autem ut harum velit.
Fugit eos cum voluptatem non magnam provident. Enim officiis et voluptatem dolor et ut. Quam sint dicta aut et facere eos ratione hic. Qui assumenda quo molestiae ullam.
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...