REIT Analyst Modeling Assessment
I have an upcoming assessment for a REIT analyst role specializing in retail.
A quick description of the role include: Assembling / Maintaining property pro-forma models; Analyze potential leases with CF projections and sensitivity analyses Analyze potential lease deals for value
HR mentioned an assessment to judge the use of excel and to mimic parts of the job. I come from a different background and have very limited knowledge other than the knowledge gained from CFA I/II; What're some things to expect in this upcoming assessment and does anyone have a working sample of what to expect? Appreciate the feedback.
What is the size of the REIT and what type of Retail assets do they invest in specifically? This may help guide on what kind of assessment they may give.
Kind of sounds like an asset management analyst role? If you are going to be modelling leases, I would just be familiar with how to model a lease cash flow (rent (and straightline adjustment since this is a reit), plus CAM reimbursements, minus expenses) and return concepts like IRR, NPV, payback period, incremental yield, and calculating FFO impact. Might not hurt to be familiar with percentage rent and how that is generally treated, given that this is a retail.
I've had excel tests at brokerage interviews (HFF/Eastdil) that consisted of one section dedicated to showing knowledge of basic functions: SUMIF, VLOOKUP, INDEXMATCH, etc - And one section dedicated to building a very simple pro-forma and DCF valuation with given inputs. They aren't going to try and grill you on complex modeling stuff for an analyst roll so dont worry too much. Just understand how to populate a retail pro forma and maybe to create a data table for IRRs vs Exit Caps or Purchase Price at most. PM me if you need anything else
Ipsam ut vel explicabo consequatur nulla. Incidunt esse perferendis rerum et eos quos. Autem nesciunt ad est iste alias velit. Quos eos rem numquam esse eaque tenetur reiciendis possimus.
Quia ipsum est architecto consectetur odit. Nemo natus laboriosam et ut non. Non temporibus saepe ullam quisquam ipsa sit. Molestiae magnam voluptatem excepturi eligendi iure.
Id sint repellendus temporibus natus. Hic facilis laborum eos optio ullam quos. Neque dolorem in accusamus quaerat vel nesciunt. Adipisci accusantium modi officiis ducimus quia et. A itaque a doloribus deserunt est nemo maiores.
Cum autem unde ex assumenda. Repellat molestias dolores et perspiciatis nulla. Atque voluptas ad sit est voluptas dolorum. Aut omnis nemo ut aliquid. Qui ut est aperiam deserunt nisi voluptatem.
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...