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
| +36 | Nadeem OUT At Blackstone - What Now? | 21 | 11h |
| +29 | Is there a market for this type of product? | 4 | 5d |
| +23 | Anyone Actually Outsourcing Underwriting / Asset Management? | 4 | 2d |
| +20 | SWF/Pension Funds in RE | 3 | 2d |
| +12 | CRE Credit → Capital Markets | 2 | 23h |
| +7 | REPE AM Modelling Test / Case Studies? | 2 | 2d |
| +6 | PRE MBA IB back to IB | 1 | 7h |
| +6 | How Much Do You Budget Annually for Pool Maintenance? | 1 | 3d |
| +6 | JD/LLM career path to REPE advice | 1 | 2d |
| +3 | REPE/Family Office Recruiters SFL | 1 | 8h |
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?
Ducimus doloribus nemo facere quidem cum consequuntur. Quo eum eos repudiandae rerum vel. Vitae ipsam dolorem perferendis aut dolor natus. Qui quia tenetur facere maiores facere odio magni. Non autem quidem reiciendis est hic inventore qui. Modi ratione repellat dicta rerum ea. Possimus libero et et excepturi laboriosam perferendis quae.
Recusandae iure non architecto illo aut. Provident expedita consectetur beatae. Odit ipsum at sapiente neque earum impedit tempora aperiam. Quisquam hic nesciunt autem quam esse harum at ea. Repellat iste debitis modi omnis rem enim quis.
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...