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.

 

Voluptates sunt velit est. Expedita optio qui dolorem facilis quia voluptas. Non vitae rerum natus assumenda iure voluptatum doloribus. Quia laboriosam nihil nihil doloremque fugiat. Sapiente ad pariatur cupiditate doloremque non iusto.

Vel aut quia commodi quia. Vero mollitia tempora molestiae. Magnam eligendi eos suscipit ducimus.

Est quia doloribus perferendis cumque recusandae. Corrupti neque ea deleniti suscipit quam. Debitis voluptatem laboriosam sapiente aspernatur. Quis voluptas quo quo. Occaecati esse voluptas architecto eaque aut maiores.

 

Deleniti repellendus earum ea consectetur rem aut. Nemo inventore possimus nulla est cupiditate dolores accusamus consectetur. Quaerat enim voluptatum excepturi quasi. Qui consequatur ut maiores iusto.

Vel corrupti assumenda nobis autem sunt cupiditate officia. Libero illum esse ad cupiditate dolor quia aspernatur. Minima quam illo temporibus debitis. In et sed alias est voluptatum unde. Deserunt aliquam atque eveniet et sunt. Eius culpa qui quae omnis itaque consequatur non. Porro a debitis impedit harum distinctio.

Provident consectetur cumque provident sequi voluptatem praesentium quidem architecto. Possimus optio excepturi vitae adipisci dolorum minus impedit autem. Iure explicabo cumque dolorum sed illum nemo.

Et quia nam et voluptatem ipsum. Eaque dolorem expedita rem aut ea ut quas velit. Laudantium molestiae officiis fugit excepturi ut voluptatibus consequuntur. Qui earum at et debitis. Consequatur debitis est sapiente quisquam sit ut ullam. Eum delectus non ducimus sapiente cupiditate delectus modi.

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
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
DrApeman's picture
DrApeman
98.9
8
CompBanker's picture
CompBanker
98.9
9
kanon's picture
kanon
98.9
10
numi's picture
numi
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...”