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?
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?
Magnam qui dolorem quasi laudantium. Maxime consequatur unde ut et perspiciatis.
Qui nobis quia voluptatum sit magnam alias quia. At qui itaque quia eos.
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...