Hey guys,
I'm looking for single-sheet models for evaluating rehab and development opportunities.
Our company uses a number of multi-tab/multi-sheet Excel models, but those are really hard to edit.
I'm looking for a single-sheet model instead.
Does anyone have any template?
| +48 | Anyone else being pushed to underwrite more aggressively (Multifamily)? | 14 | 4d |
| +30 | Uncertain of what To Do Next | 5 | 1d |
| +28 | Capital Restricted Developer | 2 | 1d |
| +28 | What should we be buying? | 22 | 22m |
| +27 | Basis play / value-add office in high-growth markets - value trap or generational buy? | 10 | 3d |
| +22 | Warning: J. Shaw Recruiters | 5 | 1d |
| +18 | Due Diligence - ALTA Survey | 3 | 1d |
| +17 | Laughable Job Posting | 3 | 15h |
| +15 | Seeking Advice: How Do You Get Value from ULI Membership? | 2 | 4d |
| +11 | PGIM Real Estate Equity vs. Private Credit | 3 | 4d |
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.
Hey earthwalker7, what a lonely thread. I'm here since nobody responded ...so maybe one of these discussions will help:
Fingers crossed that one of those helps you.
Single sheet models are even more difficult to interpret. Best approach is to audit multi tab with precedents and dependents, its a grind and tedious, but gold at the end. managing worksheet and workbooks is the unavoidable pain point for excel...its what makes it so flexible and necessarily granular.
Peace out
I'm working on a good back of the envelope model to to streamline deal screening (just to quickly solve for a cap rate). Anything more granular than that, and I'd rather just dump it all into our model and load it up quickly.
Maybe try this one pager from the Adventures in CRE guys... https://www.adventuresincre.com/new-officeretailindustrial-acquisition-…
Multi sheet models are cleaner I think. If you jam everything onto one sheet you're going to be constantly scrolling back and forth, but for a quick and dirty model this might work.
Depending on exactly what you're modeling, I've found a few formulas to be very helpful, especially if multiple sheets are laid out in the same format (consider multiple properties being rolled up into a consolidated model). If the data is in the same numbers and rows use: =INDIRECT(ADDRESS(row number, column number,,,reference text))
reference text is the tab name which you can put off to the side and anchor as a cell like $A$1.
This gets a little more difficult if you're aggregating things that aren't laid out in the exact same spots. For example, an amort table is going to be laid out differently than a P&L, which is different than a rent roll, etc.) The column and row numbers will surely be different. Not sure if that was at all helpful.
INDIRECT formula has its pluses and minuses. If you're purely using it for roll-ups, fine, but more than that and it becomes super tough to catch errors.
100%. Proceed with caution.
agree to disagree on that. Thank you though :) really appreciate it
I guess I'm really looking more for simple, back of the envelope models. I am not a believer in complex multi-sheet models. Real estate is pretty straightforward, so BOEs should be enough. Got any?
Et corporis ipsa velit molestias deserunt nihil soluta perspiciatis. Quis voluptates quis adipisci incidunt aperiam architecto iusto. At dolor totam distinctio.
Assumenda atque repellendus quos at iste. Saepe autem voluptate dignissimos aut. Illum voluptatum adipisci est. Pariatur quidem quae modi ut.
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...