REIT 3-statement Model
URGENT Will be given a REIT 3-statement model test at a large REPE shop at an interview in two days - anyone has a template that can be shared? Much appreciated!
Trending Content - Real Estate Forum
Career Resources
Hey I have one for a hotel REIT, but I’m trying to break in to the REIB / corporate real estate industry so I’d appreciate a little background from you first.
What work experience do you have and how’d you get the interview? Did they share any additional info on what the modeling test will entail? Will you just get a 10-k and build the projections from scratch without a template? Does the firm actually do entity level real estate acquisitions (buying RE operating companies)?
You can also PM me the info if you don’t want to share publicly. You’ll also need to PM me your email because I’m not sure how to upload excel files on WSO. Make an anonymous gmail if you’re not comfortable sharing one that has your name in it (that’s what I do).
If you have any doubts about whether I’ll deliver, check my post history I’ve done this before.
a 3 statement model in real estate is fairly simple and standard. Caveat, what guy above said about asset level vs entity level.
income, projected expenses usually using a given growth rate for both income and expenses. Then there is a financing component, make a debt table, then add the payments to the dashboard tab.
so lines in excel, PGI, -vacany = EGI. EGI-Expenses = NOI. NOI-Debt Service = Free Cash flow, and depending on test you get your return metrics from the equity amount in the acquisition and the free cash flows.
Usually a reversion(sale) is included in terminal year of hold with NOI/Cap Rate. Make sure NOI is the year after the hold.
They could ask for dcf which isn't that hard to add on, but doubtful.
no, he's talking about modeling a REIT/corporation
kinda thought so, but wasn't sure. I'll leave this here just
How did the modelling test go for you in the end?
Dolorem blanditiis itaque beatae neque. Inventore eveniet tempore totam sit deleniti cumque ipsam. Exercitationem molestias id qui quo modi deleniti illo tempora. Amet in ut officia aspernatur est quibusdam quas. Consequatur temporibus iste ea aut rerum vitae illo. Saepe quaerat autem sit non.
Eos itaque tempora totam aspernatur delectus vel a. Suscipit est minima deleniti et modi molestias deleniti. Rerum accusamus sunt eos omnis numquam adipisci officiis unde.
Dignissimos similique incidunt architecto non laudantium repellat nulla. Qui impedit nihil rem possimus quos. Ullam accusamus occaecati ut omnis velit omnis distinctio. Eum sunt et voluptates alias dolor aut 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...