What to do when Balance Sheet does not balance?

After 3 hours of anxiety, cursing (under the breath) and a pair of strained eyes, I have finally 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, I would like to share my personal steps to folks new to full modelling who have a hard time balancing B/S:

1) Find the net difference of Net Assets and Equity.
2) Eyeball the figure with every line item to see if they are exact match (most encounter would be the lack of cumulative effect in the b/s)
3) If exact match found, you should pat yourself at the back and go rectify the mistake.
4) If Step 2 is unsuccessful, start simplifying your model in steps – take out complex assumptions, eliminate different tax/debt structure, and observe how the net difference changes.
5) Once net difference is eliminated when an item/assumption is removed – Voila! You hit the jackpot and you can go home on time (hopefully).

As said, I find these steps useful for amateurs. If you have a better methodology of balancing the B/S in general, do share!

 

in an internal model i onced received from a very large utility player in Germany, the balance sheet also did not balance, and who ever did that just created a line item called "magic balancing number" to make it work.

I'm talking about liquid. Rich enough to have your own jet. Rich enough not to waste time. Fifty, a hundred million dollars, buddy. A player. Or nothing. See my Blog & AMA
 

If the difference doubles each year, its usually a flipped sign. Thats my first check.

You can also start deleting all lines (through all statements) relating to the same account to see if that makes it balance.

 

Unfortunately, there are a million things that could have gone wrong. Adding a few things as I referenced this post within the last day or two. Here are a few checks that helped me:

  1. Check the Deferred tax liability / Intangible Assets / PP&E and other formulas that depend on the previous year. I have definitely made the mistake of linking to the change on the cash flow statement without adding that number to the previous year (referencing deferred tax liability specifically here). You probably already know these (PP&E = Beginning PP&E + Capex - Depreciation) and (Intangible assets = Beginning IA - Amortization of IA)

  2. Another solid check is making sure you hit Ctrl+R on all of your formulas. I've gone back to change a formula in the initial projection year and forgot to drag it over to later years. You can eyeball for figures that don't necessarily make sense or have a logical trend. If you find any, you can use Ctrl+` to show the formulas and make sure they are correct

  3. Don't waste too much time on checking growth, etc. assumptions as those wouldn't impact whether the balance sheet balanced. Typically, there is either a formula error in the balance sheet itself or on the cash flow statement

I hope this helps someone out. A few of the other comments defintely helped me. Happy balancing.

 

New question. Anyone can help me please. Sorry for being a noob.

Is it possible that even if the links between balance sheet and cash flow statement are done properly but from cash flow statement, the ending cash flow (after adding to beginning cash flow), which will flow back to balance sheet is still negative?

Can this be resulted from assumptions (drivers)? After I increase values for drivers, no more negative cash.

Big thanks to whoever help.

 
Nobodythere:
New question. Anyone can help me please. Sorry for being a noob.

Is it possible that even if the links between balance sheet and cash flow statement are done properly but from cash flow statement, the ending cash flow (after adding to beginning cash flow), which will flow back to balance sheet is still negative?

Can this be resulted from assumptions (drivers)? After I increase values for drivers, no more negative cash.

Big thanks to whoever help.

Does the ending cash balance on the SCF tie to whats on the balance sheet?

 

If it is a small error - less than 0.02 - I consider it a rounding error and either ignore or add a couple cents to the other side to make it balance. After that I divide the error by 9. If the result is a whole number it is likely a transposition error. From there it is just a line-by-line check to see what digits were switched.

 

Cum dolorum sed qui laboriosam debitis quia tempora molestiae. Voluptatibus ut mollitia reprehenderit labore repellendus architecto. Atque qui cumque amet labore. Corporis placeat sint aut et possimus sequi voluptas.

Molestiae quaerat quia consequatur sed asperiores. Reprehenderit enim voluptate earum. Porro nobis accusantium repellat sit officia at atque. Aut aut molestiae nulla quia ut iste. Tempore quibusdam qui impedit ad.

Debitis placeat quos voluptatum dolorem quae nostrum. Suscipit libero occaecati alias quisquam laboriosam autem. Quaerat suscipit incidunt laudantium modi rem temporibus enim.

 

Aliquam laboriosam et itaque eaque sed. Cum nesciunt delectus aliquam alias ad delectus. Possimus aut ipsum accusantium aspernatur veniam aut labore. Unde quia molestiae dolorem voluptas.

Provident vero quasi id temporibus rem. Et consequatur non dolorem reiciendis eveniet.

Nisi itaque magnam facere maiores. Sint alias quo doloremque voluptatum. Eaque aut eos atque provident nisi. Repellat sed dolores labore debitis sit qui. Sapiente aliquid adipisci modi odio. Iure voluptate quidem aspernatur ut quia.

Voluptatum deleniti eaque dolorem perferendis quos in. Eum nostrum deserunt est perspiciatis hic officia amet possimus.

 

Quasi inventore ut vero est sequi dolores non. Quia est sapiente ipsa quis. Unde harum placeat incidunt quae. Quibusdam sed consequatur qui cumque. Et et placeat tempore omnis est.

Nisi quaerat tempora vel vel repudiandae vitae quis. Perspiciatis est quis aut blanditiis ea aliquam quibusdam blanditiis. Facilis non natus praesentium accusantium et hic. Voluptas aut ut beatae molestiae praesentium amet. Nisi eaque qui aut ab dolor sed et.

Et ipsum minima sed alias dolorem corrupti. Perspiciatis sed eius repellat explicabo. Maiores culpa autem quia exercitationem provident omnis ipsa.

Reiciendis aut vel molestiae esse harum omnis. Enim ut veritatis explicabo sit et voluptatum. Alias voluptates corporis et atque. Rerum dolor ea est dolorem.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
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...”