Hey Guys,
As the title says - rate my CRE models. The first is for standard acquisitions while the second is for development projects (also contains a residual appraisal on the first sheet).
I've been lazy in the first and simply used the additional costs tab as I didn't have the time to think of individual costings - but aside from that I'm pretty happy with it!
Standard Acquisition Link Development Projects Link
Thanks
| +43 | Being a 100% Disabled Military Vet Pays as Much as RE Analyst Seat | 36 | 5h |
| +22 | Rate Hikes | 14 | 1d |
| +16 | Senior Living Modeling Help | 5 | 5d |
| +14 | ~$1M saved/invested at age 27 | 7 | 1h |
| +12 | Launching a Development Platform in Greece | 2 | 11h |
| +9 | REPE Analyst Firm Advice | 3 | 2d |
| +9 | What are the best undergrad schools for placing in real estate finance? | 16 | 2d |
| +8 | Hard Money Lenders? | 1 | 1d |
| +3 | BGO REPE LDN | 1 | 5d |
| +3 | LIHTC Syndicator Comp | 1 | 5d |
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.
take it next step and add GP and LP cash flow distribution
try do add an amort. table, have a sources and uses section and sensitivity tables in your assumptions tab. maybe add metrics on cash flows tab such as yield on costs, cap rate on basis, unlevered yield, investor yield (pre-am. and post am.), annual debt yield, debt service coverage ratio, etc.
Depends on your experience. If you have 1-5 years experience, it's not great. If you are in undergrad, kudos.
One funny thing 1.1m pounds for burial compensation? I hope that is a fee that is lost in translation.
One of my first markers I "test" for models is construction interest draw, the capitalized interest reserve. You are way off. You are computing the interest like a bridge loan, but given the interest rate it appears it is a construction loan, hence, you should be calculating off of the total culmulative loan outstanding. You need to add .6 or 60% to your interest calc formual, otherwise you are assuming your are drawing down the total loan in month 1
Much appreciated, I'll take your advice and adjust accordingly!
I had to teach myself how to do cash flow modelling unfortunately. In the UK we all use ARGUS at the big brokerages (Knight Frank etc) for acquisitions and development projects so hardcore modelling skills are pretty low compared to lots of people in the States
I've found a lot of the big brokerages don't even run Argus or DCF's but instead have basic Term and Reversion templates for acquisitions/sales. Definitely makes it more difficult to get the right modelling experience to make the jump in the principal side.
Buy the book by Staiger: Foundations for Real Estate Modeling.
It goes chapter by chapter adding complexity. Super clear, and has you create an institutional dashboard.
I'm here to help, ask away if you have any more questions.
And, while brokerages do you ARGUS, I have models where I build around getting an ARGUS run to get return metrics
Wait excel is used for something other than an Argus reformatting tool?
Soluta excepturi dolorum fuga. Cum voluptatem quis sequi non. Saepe eveniet dolorum vero omnis.
Ad quas cum illo. Quisquam nesciunt aut et officia. Doloremque accusamus sequi nobis fuga quam et. Nobis hic quibusdam molestias eos est adipisci quis. Temporibus doloribus nemo cupiditate deleniti et qui molestiae. Assumenda dignissimos tempora quia. Non consectetur quia molestiae provident voluptatem dignissimos.
Consequuntur incidunt iure sequi ut incidunt quam quos. Modi facere nostrum temporibus ratione quod ipsum.
Mollitia pariatur perspiciatis consequuntur corrupti. Debitis non debitis est eos. Nihil dolorum omnis quia dolorum fuga consequatur occaecati. Laudantium eos eum aut eligendi nisi reiciendis.
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...