0181: The Most Important Financial Document - The Balance Sheet, Part 2

Divorce and Your Money - #1 Divorce Podcast - A podcast by Shawn Leamon, MBA, CDFA

Categories:

Visit us at divorceandyourmoney.com for the #1 divorce resources in the USA and get personalized help. Learn about coaching services here.   Thank you for listening! Find a transcript of this episode below.   In the previous episode I gave you a high level overview of a balance sheet and if you haven't listened to that episode, be sure to go back and hear it because the balance sheet is one of the most important documents that exists in divorce, so I want to make sure that you get it and you understand the key details of the balance sheet. It's so important as I said in the previous episode that it's something that I update every month and have for many years and probably will continue to until, for the rest of my life. It's that important of a financial document to keep track of.   In this episode I want to discuss a little bit about specifically how you prepare a balance sheet and how you go about it. If you were going to prepare a balance sheet from scratch, how would you do that process? What do you need to know to prepare your balance sheet? Well, one thing I'll say is a balance sheet easier to produce when you ... it's easier to produce when you a computer specifically if you use Microsoft Excel. You don't need to be super fancy at Microsoft Excel, but if you know the basics of adding and summarizing columns, over the long term it's a much easier method to do. That said, you can do your balance sheet by hand on a couple of sheets of paper. If you have good handwriting and a calculator and you can keep things organized. That is a very legitimate method and people ... I'm a firm believer in doing things by hand.   I still have a lot of old schoolness in me, even though I run basically an online business, but some things like a balance sheet I still do by hand all the time. Particularly if I don't feel like updating every number, but just want to get a sensor if I'm in a meeting with a new person, I can just pull out a sheet of paper and say "Hey, let's just go through the balance sheet and we can put it together on a slider of paper just like that", but in even case you're going to want to have a calculator and what you should do if I were going to create a balance sheet from scratch is I would think about all of your most valuable things.   What are you most valuable things? Oh, I forgot to mention something important. One thing about a balance sheet is that a balance sheet is a snapshot in time, so the numbers on a balance sheet, you know I said I update it all the time, well whenever I update a balance sheet it's as of that particular day. In divorce situations usually you prepare your balance sheet as of the date of separation, but you can always update the time periods related to the balance sheet, so you have to pick a day. So that day might be June 1st. That day might by October 22nd of the previous year. That day might be today. Whatever day you pick is the day that you're going to value all of your accounts and all of your assets, that's what account balance you're going to use and when that's really important is if you have an investment account for example.   Let's just say you're listening to this towards the end of the year and let's just say at the beginning of the year the investment account had $100 in it, but later in the year that investment account made some money and now it's got $120 in it. Well if you got separated earlier in the year, you might have to use on the balance sheet the $100 number even though it's worth a $120. Depending upon your divorce situation, you have make the call as to whether you want to change that separation date. If that's even possible, like that's a big statement I just kind of slid in there, but you have to determine what day is most advantageous for you in terms of valuing assets like that, so you got to pick a day. For me I just pick you know whatever day of the month I decided to open and update my balance sheet, but something that you need to keep in mind.   Now when you're preparing a balance sheet, I was saying you need to think about all the stuff that you own. All of your assets, so if you own a house that's an easy one. Almost everyone has a bank account, so you put your bank accounts on there. If you have retirement accounts, you go through each one of your retirement accounts and list the total value of the retirement accounts and if you have a 41K, I usually write down on the line John Smith 41K, so I know what type of account it is and I'll say value, $237,556 and I will make a note as to what date I did it, so if it's June 1st, I'll just put the June 1st date on there and hopefully I said when you do it you keep every account on the same date, but you start with ... if I were to start with the assets.   Start with the house because everyone's going to have, most everyone's going to have a house. If you rent then you're not going to list it as an asset, but if you own a home of some kind, then you will put the home value and if you have a mortgage the home is a little bit tricky because you all have debt attached to it, but you have a mortgage also put the mortgage value on there and put if you have a second mortgage or something else, put that value on there as well and that way you can get a total home value minus mortgage and any other debt, so you can start there.   Then I say all right, well here's all my bank accounts, so I go through each one of my bank statements. I put in the amount of money that's in there, easy enough and I just list out each account, who's name is on it, so if you're doing it for you and your spouse, you should make a note as to who owns said account. So you do bank accounts. You do your house. You do any investment or retirement accounts, list every one of those.   Then you go to vehicles. You put all your vehicles. You can put ... oh other real estates, so I forgot, if you have a second home or you have a rental property or whatever else, don't forget to include that and then think about all of your other stuff. Could be furniture, collectibles, intellectual property, who knows what, but whatever that thing may be, you add it on and go from there and you add them all up. You put them nice and neat into a column. You group them by category and that way you know all of your assets. You take the sum total of all your assets. Maybe it's $100,000. Maybe it's $100 million, who knows. Likely somewhere in between there and you know the total value of your assets and who owns them.   Second thing you do is now you got to think about your debts. As I said some of you have debts. Some of you don't. It really just depends on your situation, but on the next side of the page, so if I split it down the middle. I have the left side with all my assets, the right side of the page with all my debts and so you list out every credit card you have or if you have a student loan, you list out a student loan. Or, if you have a personal loan that you have, you write that in there and you would go from that point and start working on your debts and you list them all out and you summarize your debts. I'm just going to use some basic examples. Let's just say on the left side of the page, I like using $100 because everyone hopefully can follow $100 math. Let's say you have $100 of assets in between your houses and cars and retirement accounts and everything else. Let's say you have $20 of debt, what does that make your net worth on your balance sheet? Well your net worth on your balance sheet is $80. You're going to take all of your assets subtract out your debts and you're going to end up with a net worth of $80 and then you're going to have your balance sheet.   Now one of the things that's very important is making sure you attach the right value to the different assets and debts that you have. What do I mean? Well one thing I ask everyone. I will ask 100% of you when we prepare a balance sheet, how did you come with the value for your home? If you went to Zillow and said "Hey I typed in my address and Zillow said it was worth $357,000", I will say "Okay, thanks" and we may use that value for now, but I will say we need to get an appraisal to figure out how much this house is actually worth or I'll say you need to talk to a real estate agent to determine a much better value for this house because Zillow is not the most accurate place to go.   If you have a car and you have a 1997 Mercedes E300, I don't know if they may an E300 in 1997, but if you had bought that car in 1997 that would have been a $60,000 car. If you list that asset as $60,000 in 2018 when I'm recording this, I will say "Hey, you know that car was worth $60,000 something then. It may sadly only be worth $3,500 now", so we need to make an adjustment there and so you need to be cognizant of the actual values for certain accounts. Bank accounts are easy. You'll align again, you'll get the number on your bank account and you're good to go.   Same with investment accounts, but for any assets that don't have a clear value like homes and cars and jewelry, we will need specific appraisals for those types of assets, so just something to think about in that regard and then as I said, once you prepare your balance sheet what happens next?   Well you have to understand the information. Look at it. Make sure it all makes sense. Ensure that it meets your expectations or maybe there are some surprising things in there, which happen. The second thing is you have to really internalize your balance sheet, particularly when you're going through divorce and you have to think and what assets are most valuable for me to keep, or what do I want to keep? What assets do I not want to keep? What do I want to give away? How do we handle the debt situation?   So I've worked on many a client who had debt and we had to write in the divorce agreement we're going to sell you know if I were just going to toss out an example. Let's just say "Hey we're going to sell the house, the proceeds are going first to pay off the outstanding credit card debt" and then second whatever remains after we're going to split between us 50/50. That something that we start thinking about, but we got to start thinking about "Hey, what's the best settlement that we can get for you in that situation?" I'll give you a case that I've been working on lately where there were a lot of real estate properties, but in this situation the person who was determining their settlement wanted all the real estate, but they were going to be left with zero dollars in cash, which is not a good position to be in and I said "Hey, I understand that you're going to have all this real assets, it's great, but you're going to need to have some cash in a bank account" and so, while you might want to keep all these real estate assets, maybe left's find a way for you to get either from a retirement account or something else, some day to day funds that you have so that you can live your life normally and plan for some expenses that you're going to have after the divorce process is over.   You don't want to be real estate rich and cash poor. That's not always the best position to be in depending upon your life goals and what your immediate needs are and this person had some tuition payments coming up and so they were going to need the cash one way or the other. Trying live off the cash from the rental income plus save up enough for tuition, it just didn't make financial sense and so, that's one of the listings that we can look at. If you remember the previous episode I mention that we split up the assets and we said there's $100 in assets total and one spouse is getting $80 in assets, the other is getting $20 in assets. Well if you look at the balance sheet you can start to figure out, well maybe that actually makes sense given their situation or maybe that's a terrible deal and we need to make some adjustments, but when you prepare your balance sheet correctly you can quickly and easily identify all of the things that you need to know in a very usable format.   The balance sheet is meant to be a very simple asset and simple analysis I should say for you to review and have a clear picture of how your finances will look and so you use it all the time to understand hey, if this scenario happens and we adjust the balance sheet, does that leave me in a good position? That's a lot. The balance sheet I could talk about for a lot of time and the ins and the outs and it's actually one of those things that differs so much between each individual person. It's hard to sometimes cover all the different nuances of a balance sheet, but you know if you Google balance sheet you'll find some details on it yourself, but I want to give you just an overview of kind of what it is and how to start thinking about it and how you can prepare yourself on a sheet of paper and it's something that should be at the forefront of taking control of your life both during the divorce process and afterwards as you go through this time and as I said, it's something that we work with with 100% of the clients that I get to work with as we prepare that balance sheet so you always know where you will stand financially during and after the divorce process.