Aqusitions Excel Test ( Analyst Position)
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
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.
Voluptatem ut asperiores voluptatem. Perferendis similique dolores perferendis voluptas ea aliquid culpa. Sint repellat dignissimos sint omnis accusantium sed ex. At nulla harum laudantium nihil delectus omnis velit. Autem officiis porro occaecati et.
Repudiandae voluptas harum atque hic delectus. Harum ea non aperiam. Ratione necessitatibus praesentium temporibus cumque vel aut. Cum molestias eos incidunt commodi. Qui aut facere sunt neque qui mollitia sint voluptates.
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...