single sheet model

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?

Comments (9)

May 16, 2019

Hey earthwalker7, what a lonely thread. I'm here since nobody responded ...so maybe one of these discussions will help:

  • What to do when Balance Sheet does not balance? managed to balance my balance sheet. Background: I am required to do a valuation model for a single ... business segment based on a fully consolidated model- so I did the usual extraction, reference etc. Also ... required to conduct some analysis hence the full model of statements etc. Following my sweet success, ...
  • Reconciling Cash Flow Statement & Balance Sheet in Model Just a quick question regarding accounting/modeling. I have been learning to model with BIWS and ... recently tried to model two companies on my own from scratch. The place I'm having problems with is ... accounting class, so I'm a bit rusty. financial modeling accounting ...
  • Excel, Google Sheets, and other tools of the trade Specifically: Does anyone use Google Sheets? Awhile back I would have laughed if you suggested I use Google ... Sheets for spreadsheet work, but I've been using it for some ad-hoc analyses and it's actually ... building models, do you build most models from scratch, use templates, or some combination of both? ...
  • When building a model, do you prefer to have IS, BS, CF on one sheet or separately? To current analysts (or former summer analysts): When you build a model, do you personally prefer ... to have IS, CF, and BS all on one sheet (vertically listed) or separately on three different tabs? ... What are pros and cons to these approaches. Excel IBD Model ...
  • Not even close: NYC is the #1 city for single men for single men. Quick context. I have either lived in or spent considerable time in the following ... similarities and differences between these major cities. For single straight men, access to a large pool of ... calendar was jam packed. It has more single women than men, lot of the men are gay, and the women are eager ...
  • Where download the balance sheet in excel for the model Hi all, i'd like to delevopment my first model, but where i can free download the balance ... sheet and income statement in excel of 1-2-3-4-5 years ago? maybe even for quarterly ...
  • Learning How to Forecast Balance Sheet Accounts statement modeling, the balance sheet can sometimes be to confusing to project and there are two methods for ... modeling out the statement with the balance sheet driving projections or the statement cash flow driving ... modeling out the balance sheet. esbanker- Private Equity Analyst: Cash and Cash Equivalents: Flows in ...
  • More suggestions...

Fingers crossed that one of those helps you.

May 22, 2019

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

May 22, 2019

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-officeretailin...

May 23, 2019

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.

    • 1
May 24, 2019

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.

Learn More

Side-by-side comparison of top modeling training courses + exclusive discount through WSO here.

May 24, 2019

100%. Proceed with caution.

May 24, 2019

agree to disagree on that. Thank you though :) really appreciate it

May 24, 2019

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?

Jun 3, 2019
Comment