Model won't balance.

Hey,

So for interviews I've ran into a slight problem. Some model case studies I am given have a model with NO HISTORICALS WHATSOEVER. Assumptions are included.

How would I go about building this? I know that I would have to make historical assumptions for some sections like the balance sheet, however when I do, my model sometimes doesn't balance unless I have and EXACT number in some sells (eg. constant equity at 76 and not 80, etc.)

Any advice would be great... I'm just not sure why a model won't balance in projected years if the historical year balances. For the projected years, it requires very specific numbers occasionally.

 

Firstly make sure that you actually need a full 3 statement model. In many cases, all you need to build out is cash, debt, and change in NWC assumption.

Secondly, if you really have to project things out, there's no reason why it won't balance. The issue you're describing just sounds like you haven't done enough 3 statement model practices.

 
BTbanker:

projecting a balance sheet is one of the shittiest things you'll do

Just throw the unbalanced amount into goodwill and you're all set. :P

JustADude:

Firstly make sure that you actually need a full 3 statement model. In many cases, all you need to build out is cash, debt, and change in NWC assumption.

Secondly, if you really have to project things out, there's no reason why it won't balance. The issue you're describing just sounds like you haven't done enough 3 statement model practices.

Can you explain this further? I've never actually done this before (build out a down and dirty projection vs. full statement projections). How do you project out your cash/debt/NWC if you don't project out your expenses and how they fall in line with the balance sheet?

 
Khayembii:
BTbanker:

projecting a balance sheet is one of the shittiest things you'll do

Just throw the unbalanced amount into goodwill and you're all set. :P

JustADude:

Firstly make sure that you actually need a full 3 statement model. In many cases, all you need to build out is cash, debt, and change in NWC assumption.

Secondly, if you really have to project things out, there's no reason why it won't balance. The issue you're describing just sounds like you haven't done enough 3 statement model practices.

Can you explain this further? I've never actually done this before (build out a down and dirty projection vs. full statement projections). How do you project out your cash/debt/NWC if you don't project out your expenses and how they fall in line with the balance sheet?

I just mean that, your cash balance and debt schedule can both be derived from the income statement and cash flow statement after just making a simple assumption for NWC (% sales). Obviously this is not as accurate but in most cases there isn't enough information to project out a full balance sheet anyway.

 
Best Response
Random Name:

Hey,

So for interviews I've ran into a slight problem. Some model case studies I am given have a model with NO HISTORICALS WHATSOEVER. Assumptions are included.

How would I go about building this? I know that I would have to make historical assumptions for some sections like the balance sheet, however when I do, my model sometimes doesn't balance unless I have and EXACT number in some sells (eg. constant equity at 76 and not 80, etc.)

Any advice would be great... I'm just not sure why a model won't balance in projected years if the historical year balances. For the projected years, it requires very specific numbers occasionally.

It sounds like you don't fully understand the offsetting adjustments to the balance sheet. If you're projecting your Accounts Receivable to grow based on DRO, for example, you need to link that growth to a corresponding decrease in an offsetting asset account or an increase in liabilities. You can't just grow line items independently because it won't balance.

Without a specific model we can't really tell you what your problem is. I'm fairly certain you're not linking the financial statements properly, though.

 

Vel velit dolore illum quae explicabo corporis minima autem. Assumenda rem maiores libero eveniet voluptate recusandae.

Ut esse iste et esse magni animi. Vero ea quis ipsam ipsam dolorum repudiandae quae. Placeat atque et doloribus eos labore. Error accusantium quo labore aspernatur facilis dolore consequatur. Ut quis assumenda nulla assumenda est voluptas.

Voluptatibus veniam et officiis fuga et ad iste. Modi esse natus optio voluptas commodi. Sunt voluptatem eum ut blanditiis dolores. Facilis enim et non. Sint corrupti commodi voluptatem aperiam consequatur error.

If you fall down, make sure you get back up with a vengeance!

Career Advancement Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Warburg Pincus 99.0%
  • Blackstone Group 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

March 2024 Private Equity

  • Principal (9) $653
  • Director/MD (21) $586
  • Vice President (92) $362
  • 3rd+ Year Associate (89) $280
  • 2nd Year Associate (204) $268
  • 1st Year Associate (386) $229
  • 3rd+ Year Analyst (28) $157
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (313) $59
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
kanon's picture
kanon
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”