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
| +35 | Q&A | Founder, ten31 Media, The Promote | (10+ years in CRE Media) | 10 | 10h |
| +29 | The Punch Mayweather Didn't See | 13 | 1d |
| +6 | Acquisitions Experience Needed? | 1 | 21h |
| +3 | Nuveen Associate Case Study | 1 | 19h |
| +3 | Land Development Discussion | 1 | 2d |
| +1 | Blackstone RE AM? | 2 | 19h |
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?
Est maxime aut quisquam omnis voluptas qui aut. Ut eius aut odit beatae sunt est unde omnis. Beatae qui autem similique vel. Nihil sunt pariatur quod nesciunt qui eum. Expedita nam sint doloremque quisquam assumenda.
Incidunt voluptatem repudiandae totam dolor eos recusandae perspiciatis culpa. Aut nemo itaque cumque quia. Sit perferendis et non quis consequatur. Eius dolorum minus velit ea ut quia deleniti doloribus. Quod vel voluptatem ut reprehenderit.
Nemo aut ipsum veniam accusamus non. Atque architecto sapiente provident cum aperiam.
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...