Do acquisitions analysts build models from scratch?
Do acquisitions analysts at REIT's, REPE firms, etc. build acquisitions models from scratch or do they mostly use templates? Thanks
Do acquisitions analysts at REIT's, REPE firms, etc. build acquisitions models from scratch or do they mostly use templates? Thanks
| +11 | JLL - 1st Year Analyst (Am i underpaid) | 32 | 3d |
| +3 | 2027 internships | 1 | 2d |
| +2 | MF Acquisition UW | 3 | 1d |
Career Resources
WSO Virtual Bootcamps
Career Advancement Opportunities
November 2026 Investment Banking
Overall Employee Satisfaction
November 2026 Investment Banking
Professional Growth Opportunities
November 2026 Investment Banking
Total Avg Compensation
November 2026 Investment Banking
“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”
Leaderboard
| 1 | 99.2 | |
| 2 | 99.0 | |
| 3 | 99.0 | |
| 4 | 99.0 | |
| 5 | 98.9 | |
| 6 | 98.9 | |
| 7 | 98.9 | |
| 8 | 98.9 | |
| 9 | 98.9 | |
| 10 | 98.8 |
“... I believe it was the single biggest reason why I ended up with an offer...”
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.
I guess it depends on the shop but I would argue most use templates. Real Estate Investments are always similar so using a template and modelling in the specifics is a lot quicker and just as good vs. building from scratch. Also most of the time you will look at a lot more deals in real estate vs M&A etc. so building everything from scratch is impractical.
Work for a major fund. Will likely use one of my previous models from a similar acquisition (depending on asset class, jurisdiction, development/refurb/business plan) for a ball park figure. Will likely more or less build from scratch if we get exclusivity to fully tailor the model for all DD items.
Templates. Why reinvent the wheel?
Any free ones I can grab and utilize online?
http://lmgtfy.com/?q=real+estate+acquisition+model+template</a">There are some good ones here
Definitely templates. Even if you work for a small family office and you create it the first time, you're going to use that template the next time.
Definitely templates. I know big property owners in manhattan that even evaluate buildings on the back of a napkin. No need to build a model from scratch. Waste of time and not efficient.
Templates, a good one will handle all of the customization you should want.
Ain't nobody got time fo dat
Agree with consensus. Building models from scratch is mostly going to be for ad-hoc analysis (outside of the standard stuff you are doing repeatedly) and even then there might be templates
template but its good to build one every once and a while so you are prepared for other asset classes
Been interviewing for several acquisition roles repe firms and i've asked my interviewers this question and they all pretty much say there's a template that gets tweaked and modified to fit the current deal.
Templates generally, as others have said. But if you can create one in your own time and your manager likes it better, then that would be a great thing.
I'll say though, as a learning experience, the best thing I did was recreate the template my company was using from scratch. Really good for helping learn the ins and outs of the model, how it functions, can be improved etc.
Templates but if I have down time (usually around Christmas) I will build a basic model and see how fast I can do it. It is great practice and if you time yourself you'll be forced to focus on the key inputs / return drivers.
The toughest things to model from scratch in my opinion are: 1) Rent roll / lease up. 2) Equity / debt draw schedule and 3) JV waterfall. With some practice you'll have it down though and feel pretty damn good about yourself.
Also, forgot to add for the new folks out there the key to modeling is understanding what is going on in the transaction NOT using fancy excel functions. Once you get a basic model built then you start worrying about cute functions and formatting. Seems obvious but I always see young guys fall into the trap.
This is key. Whenever I have a timed excel test for an interview I keep the actual excel functions as simple as possible (like I'll create a 10 YR rent/expense schedule tab real quick and just hard code any values that aren't "Y1 is X grown by Y annually" to feed a cash flow statement.)
Some IF statements here and there but at the start definitely focus on getting the numbers correct and knowing how to calculate the shit that matters, while at least laying it out in a way where people can understand it.
I'll finish a modeling test the easiest way with least room for error first, and if I get it done 30 min early I'll go back in and find ways to make it look better / display higher level command of formulas.
Yes from scratch. Most places make you delete the previous models from your hard drive and memory every time
I don't follow.
he was being a smartass
95% of the time you will use an existing template. The only time you will create from scratch or heavily modify an existing template is when you are looking at a deal that is so unique and has so many nuances or idiosyncrasies that it's easier to build from scratch than use a template.
In my opinion, I think everyone should create all models from scratch in the beginning so you know how to do it, yet as others have stated it's highly impractical to always build from scratch.
I agree, and if your new firm prefers their exisiting template, i find it well worth the time to completely rebuild their template into a blank excel file to truly understand how everything ties together.
Ut blanditiis eveniet quos. Dignissimos officiis asperiores sit adipisci cupiditate. Sed ratione odit quibusdam laudantium incidunt cum. Sunt et aspernatur labore quia consequatur quae. Est aut eius sit consequuntur tenetur. Quo sunt blanditiis ut dolorem. Optio aperiam accusantium corrupti ut eum.
Aliquid non impedit amet magni. Rerum rerum cum iure nam.
Nam quos quia sunt sit eaque. Et ipsum repudiandae odio optio omnis alias. At eaque eaque doloremque. Ex porro id sed enim. Quod porro et quisquam ducimus. Quia animi quibusdam eligendi quibusdam.
Veniam laboriosam atque nesciunt. Saepe sequi rerum ut temporibus. Quo cupiditate provident consequatur in sed. Aperiam molestiae et ut neque tempora. Ab eius est qui doloribus ipsa est. Sapiente nesciunt ullam itaque corporis.
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...
Dolores nihil magni labore qui quas. Dolor nemo autem porro quo magnam et. Tenetur rerum ab quo facere. Quas quis omnis cumque sapiente quidem sed vel. Vitae et vero est hic.
Illum cupiditate atque et laboriosam. Molestiae et modi est quis.
Et et dolore ducimus. Aliquid recusandae aut voluptatem et vel. Eos consequuntur optio voluptas. Totam nihil voluptatem ad et.
Occaecati temporibus impedit voluptatem dolorem praesentium. Ut fugit numquam soluta. Consectetur sunt iste in vel. Cum voluptatem rerum dolores in deleniti.