FIN 10 Pro Forma Financial Statements

In this video, we're going to work on a problem you can download from TonyBell.com. Go to the website, click the PDF link, and you'll notice there's no sign in, no sign up. The PDF just pops right up. You'll scroll down and find whatever problem it is that we're working on. As you scroll through the problems, you'll notice many are free and open like the one you're watching now, but some are members only. I think the free and open ones are enough for most people, but if you can't get enough of me and you'd like to join and get access to those members only videos, click the join button underneath the YouTube play box. All right. Thanks so much for watching. Let's get started. Let's take a look at problem 21A. This has us doing pro forma financial statements, just projected financial statements, a really useful skill to have, right, to be able to say, okay, next year, what happens if our sales are up by 10% or 20% or 15% or whatever? What will happen to the rest of our accounts? What will our financial statements look like then and what are the implications of it? So let's go through for 1A, Liam Company's financial statements are shown below. And there we have an income statement and a balance sheet. And it says, assuming sales are projected to increase by 20% and that all items on the income statement and balance sheet. So all items that we're seeing above will also increase by 20%, not the greatest assumption. You know, it's some things will go up by more or less than sales, but this is a good starting point, right? Just to learn what financial things look like with this type of change. Okay. So if our sales are going to go up by 20%, how do we make them increase from 5,000 to a, you know, plus 20%. What does that look like? Well, 5,000, you're going to add 20%. So you're going to add a thousand to that. The way you do that in terms of a calculator is you'd go 5,000 times 1.2, right? 120% is 1.2. They're going to be $6,000 next year. If they increase by 20% costs, if they're expected to move with sales, which is a pretty reasonable assumption for most companies, costs go up again by 1.2. They're going to be at 5,400. Sales minus costs and expenses gives us our income before tax, 6,000 minus 5,400 is 600. And you can see this is also a 20% increase from the year before. Taxes are 20% of that. They're going to be 120 and 600 minus 120 is 480. Okay. There we have it. Everything has gone up by 20%. Let's look at our balance sheet now. If everything goes up by 20%, current assets going up by 20%. What does that look like? Well, they're going to go up to 1,200, that's 20% more than 1,000. The fixed assets are going to go up to 3,600. And again, that's just 20% more, 3,000 times 1.2. So pretty straightforward what we're doing so far. I hope it is anyway. 1,200 plus 3,600 gives us 4,800. There we have it. Our current liabilities going up by 20%, 500 plus 20%, well, that's 600. Our long-term debt, 2,600 going up by 20%, so multiplied by 1.2 is 3,120 and 900 multiplied by 1.2 is 1,080. Adding this up, hopefully the assets equals liabilities plus equity, hopefully our balance sheet balances 600 plus 3,120 plus 1,080, that gives us 4,800. Yes, indeed. Good feeling. Our balance sheet does balance. Okay. So we've answered the first part, prepare pro forma statements. We did that. Now, again, how useful is this? How realistic is this? It's a good starting point for us, but in reality, we could be a lot more surgical about this. We could say, oh, our revenues are going to go up 20%, but maybe our costs are only going to go up 15%, right? Because there's a lot of fixed costs or whatever, right? And we could make various estimates, but it's a useful skill to have. So we get to the end and it says part two here to compute the amount of the dividend required to balance the statements if dividends are the plug variable. Okay. This is often confused by students who in their beginning, if I get students to project financial statements, they often will plug their shareholder's equity to make a balance sheet balance. Like they sort of go, okay, I know what assets are and I know how they're going to change. I know our liabilities change, but equity, I'm just going to plug and make it work. And that's essentially what we've done. We plug the equity by plugging dividends. So let's think about how equity works. And this is something you need to know. Our beginning equity plus net income, I'm going to say equals just a subtotal minus dividends. Now I don't need the subtotal. It's just going to help me discuss this equals our ending equity. So our beginning equity was $900. We're expecting it to go up to 1080. So our beginning equity was $900. We add net income. Our net income is 480. So 900 plus 480 gives us $1380. Now if we did not pay a dividend, then our ending equity should be 1380. But our ending equity isn't 1380, it's 1080. So we must have paid a dividend because we know our ending equity is 1080. That's known here. Our dividends are the plug variable. Well, what's the plug that makes this work? We must have paid under this scenario, a $300 dividend. Okay. So to answer the question, it says compute the amount of the dividend required to balance the statements if dividends are the plug variable. Well, 300 bucks, that would be the dividend. Now let's look at part three. It says, do the pro forma statements in part one make sense if the dividend payout was 30% and remains unchanged? So the company always pays a 30% dividend. Does this work? Well, what is a 30% dividend? It's 30% of net income, that's what we're talking about. So 480 times 30%, 480 times 0.3, it's 144 dividend. Does that work? Does that make our statement work? If we plugged in 144 here, would we match? No. We would have higher equity and our balance sheet would no longer balance. So the question is, do they make sense? No, they don't make sense. If the dividend is only $144, then the pro forma is no longer work. So that's a problem. Out of curiosity, what is our dividend payout ratio at 300? Well, it's a $300 dividend on $480 in net income, 300 divided by 480. That gives us a payout ratio of 62.5%, way higher, double, more than double the 30% payout ratio. So what does this mean in practical matters? It means probably our financial statements are going to look a little bit different from this because we probably won't pay out a 60% dividend. If we're going to be consistent and pay out a 30% dividend, it means we'll have more cash, more current assets with which to play, right? You can do something, invest in long-term assets, or you can do something else. But the bottom line is we'd likely have higher than $1,200 in current assets if we paid a smaller than 62% dividend. Okay, that's it for Part A, 1, 2, and 3 there. Let's move on to Part B. It has us looking at the sort of same set of statements, but doing different things here, slightly different. So it says, instead of Part A, assume a 20% increase in sales. So actually that was the same. A dividend rate payout ratio of 40%, so not the 62% or the 30% that we had in the previous version, so just the different scenario here. Costs, expenses, current assets, and current liabilities, and net fixed assets will vary directly with sales. Okay, so as we're projecting a 20% increase in sales, all of our costs and expenses, current assets, current liabilities, and fixed assets are going to just go up by 20%. Long-term debt, I can't cross that out, long-term debt and shareholders' equity don't vary directly with sales. Okay, so it's a different task we've been assigned here. Same task, but they've given us different information, I suppose. Let's see if we can solve it. So we'll start with the income statement, and the income statement is identical because sales, costs, and expenses, that's all that's on an income statement, all go up by 20% exactly as they did in this previous version, so we're going to prepare the same income statement. So sales up by 20%, so 20% increase here gives us $6,4500 times 1.2, $5,400, $500 times 1.2 is $600, and the math work's going down, $100 times 1.2 is $120, and $480 is our number here, $480. Okay, so we've done the income statement rather quickly. Let's just remember what else goes up. Current assets and current liabilities, current assets and current liabilities go up by 20%, so current assets goes to $1,200, current liabilities goes to $600 under this scenario. Net fixed assets also goes up by 20%, so $3,000 goes up to $3,600. Now, this is important. We now know our total assets is $4,800, and something you should be doing immediately, if you're pretty confident, and I am pretty confident in that total assets number, write it over here as well because the balance sheet has to balance, and that's going to become a key to sort of help us solve this problem, right? That's a piece of the puzzle that you might miss is that if you know your total assets or you know your total liabilities and equity, you know the other because the balance sheet's got to balance. Okay, so what are we left with? We don't know our debt and we don't know our equity, except we have the tools to figure out the equity because we know the dividend payout ratio is 40%. So let's figure out our equity. Our equity starts at $900. We're going to use the same formula as above. Let me just remind you of what it is. Beginning equity plus net income, we subtotal minus dividends to get ending equity. So beginning equity was $900 plus net income, add net income, and our net income is $480. $480, we subtotal. And $900 plus $480 is $1380. We deduct dividends. Now we know our dividends. Our dividend payout ratio is 40%, and our projected net income is $480. So $480 times 40% will give us our dividend amount. $480 times 0.4 is $192. That's our dividend, $192. So our ending equity is $1380 minus $192, $1380 minus $192. It's $1,188. Okay, so our ending equity is $1,188. Now I know, okay, I'm just missing one number, right? I know my total liabilities and equity is $4,800. I know my current liabilities are $600. I know my equity is $1,188. I just got to plug, my plug variable here is long-term debt. So let's figure it out. Now, the way we're going to get there is just go $4,800 minus $1,100 minus $600. So $4,800 minus $1,188 minus $600 to get that missing number. The missing number is $3012. So there we have it. This is harder to do. Part B was definitely harder to do, particularly if you've never done it before, but we did it. We need to have $3,000, roughly $3,000 in debt in order to make this thing work, $3,012. So prepare pro forma statements, done. Compute external financing needed. That's just saying how much new debt do we need? Well, we had $2,600. We're going to need $3,000. So $3012 minus $2,600. We're going to need $412. External financing needed. The new debt needed is $412, just the additional borrowing. And so again, that's a problem for real businesses, right? They go, wow, if we, everything goes according to plan, I need to borrow $400. You know, in this case, let's pretend it's all $1,000, $400,000. You better make sure you've got a bank willing to lend you the $400,000 or your plan goes poof up in smoke. So that's why EFN is really important because you run out of money and you're dead as a company, right? This company's getting crunches if they are unable to borrow when they need to borrow. Okay. I don't know what's just happened here. There we go. I was just going to click over to this screen to say, have you made it to the end of the video? I hope you liked it. I hope it was helpful. And if it was helpful, and if you did like it, please don't be shy. Hitting those buttons helps me out a whole heck of a lot. Have a great day. Thanks for watching. Bye for now.