FA6 – Sample Exercises on the Balance Sheet - Step-by-Step Guid

Coin Crunch
8 followers
AI Generated·May contain errors
Welcome back. We have
been working through problem 13A from my workbook. You can download
from tonybell.com. Just click the link below.
We have prepared an income statement. We've prepared
a statement of retained earnings,
and now we're going to prepare a balance sheet and we're going
to do these ratios.
But let's just remind ourselves the big picture here. An income
statement summarizes revenues and expenses,
tells us if we made any money, did we make profit,
And this company made $35,000 in profit.
Statement of retained earnings says how did
retained earnings change during the year and
did the company pay any dividends? If so, how much?
The final statement we're going to learn
now, we're not going to do a statement
of cash flow in this video. That's for chapter 11,
but we're going to learn the balance sheet.
Summary of assets, liabilities, and shareholders' equity.
And when I get my students prepare a balance sheet
for the first time, I encourage them
to turn their paper sideways, like portrait versus landscape.
I think it's called landscape.
You want to have a wide statement,
at least the way I format the balance sheet.
So if you're following along with me,
I'd advise you turn your paper sideways.
And let's start with a three-line title.
Name of our company, Sherry's Shuttles.
Name of our financial statement.
We are asked to prepare a balance sheet. And then the date. And a
balance sheet's interesting
because you don't date it for the year end, for the month end. It's not
for a time period. It is a specific date.
And the date here is December 31st.
2029. The reason we don't date the financial,
the balance sheet as for the year ended for the
month ended is because of the information
on the balance sheet. If you think of the income
statement, we're asking how much money did you make?
Well, if I ask how much money did you make
last month, that's different
from how much money did you make last year? If you made $10,000 last
month, that's a lot of money.
$10,000 last year. That's not a lot of money.
Now, the balance sheet is sort of what stuff do you have?
So if I said, hey, what is your mortgage balance, right?
Like how much do you owe on your house?
And I owe $200,000.
Well, it doesn't make sense.
How much do you owe for the year?
Well, at the start of the year, I owe 220,
and then I paid it down, and now it's 200,000.
It's just like on December 31st, what did you owe?
That's the question the balance sheet asks.
So it's a specific moment in time.
How much cash did you have on December 31st?
What did you owe on December 31st?
That's what the balance sheet answers.
And that's why it's simply dated.
So just reminding you, and we kind of just did,
the balance sheet is a summary of assets,
liabilities, and shareholders' equities.
So as we go back to the question,
when we identified all our accounts,
we're going to be interested in assets,
liabilities, and shareholders' equities,
What are you starting with?
the assets and actually starting with the current assets.
So we got current assets of accounts receivable, office supplies, cash.
Do we have anything else? Don't see anything else.
In terms of our long term assets, we got buildings.
And we got equipment, just seeing, are there any other assets?
No.
So we're going to list all of our assets,
total it, list our liabilities and equity,
total that.
And hopefully when we're done, assets equals liabilities plus equity.
That's what makes a balance sheet balance.
We will find out.
I'm nervous.
I hope it works.
Thanks
So let's start with our current assets.
Now, the order of the balance sheet is from the most
current to the most long term.
Like I said, it's kind of a wide statement. So I'm going to do
for
assets over here.
I'll do liabilities over here and somewhere down here.
having
I'm not really sure where
I'm going to do shareholders equity somewhere down there,
but I'm not sure where yet because
me.
don't know how long my liability section is going to go.
We'll start with the assets
and we'll start specifically with our current assets. We want
to list them from the most current to the most long-term.
I have three current assets. I've got
accounts receivable, I got office supplies, and I got cash.
The idea is it's order of liquidity,
they call it, the most liquid asset.
Liquid means cash-like. Cash is the most cash-like.
Cash will always come first on these things. Cash, $25,000 comes first.
Receivables will come, generally speaking, second.
So cash, then AR,
because AR is going to turn into cash in 30 days,
and office supplies are not a terribly liquid asset,
so they're going to come third.
25, 12, and 3.
Cash, AR, office supplies.
Current assets, cash, then accounts receivable,
then office supplies.
I've already forgotten the numbers.
Shame on me.
Uh,
$25,000, $12,000, and $3,000.
Adding them up, that adds to $40,000
as my total current assets.
Now, what about my long-term assets?
I'll categorize these as long-term assets. You will
often see this category called PPE, property, plant, and equipment.
That's a great name for
for the category as well.
For whatever reason, I like to call them long-term assets.
And we have two.
And again, we want to say the most short-term to the most long-term.
So buildings or equipment,
which one is shorter-term, which one is longer-term?
Well, buildings last 20 to 40 years.
Equipment tends to last 5 to 10 years.
Equipment is shorter-term.
Buildings are longer-term.
So we'll do equipment first.
So equipment, then buildings.
Equipment, net, $50,000,
and buildings, net.
And that was 100,000. So totaling it up, we're
at 150 for our total long-term assets. And we can,
in fact, do total assets now, because that's all the assets, right?
We've touched everything that
we highlighted. 40 plus 150, that's 190,000. That's a grand total.
So at this point, we've only done half the statement, right?
We've done the asset side.
We got to do liabilities and equity next.
I actually treat this as a moment to do some formatting.
So this total assets is a bottom line number.
It's a key number.
It gets double underlined and I can do dollar signs.
And remember my rule of thumb around dollar signs, top of each column.
So this is one.
This is another, so, and you wouldn't have to do this in greening.
I'm doing it in greening to make it stand out for you,
but same color ink, I'm just
making it stand out.
So top of each column, and one beside anything double underlined,
and that's it for my dollar
signs.
Sometimes the students have a desire to put one here,
I don't put one there, so I would
just have three dollar signs on the asset side.
Okay, so the asset side is done.
Let's move over to liabilities. Again, back to the question.
We'll highlight our liabilities.
This is what we need to be worried about now.
Where are we? We've got accounts payable.
We've got wages payable. We've got a bank loan payable.
And that looks like it. And in fact,
the bank loans long-term will highlight it a different color.
So now we've got to pick
which of the two of these is the most current, right?
So obviously, bank loan will come later
in the long-term liabilities, but in our current
liabilities section, we've got wages or accounts payable.
In my classes, I teach it.
I have my students do accounts payable first.
I've seen it done both ways.
I've seen wages payable at the top of the list.
I've seen accounts payable at the top of the list.
I'll just say, I'll be consistent here.
Accounts payable is going to be first.
Wages payable is going to be second every time.
And then there'll be other liabilities that we add
to this as we, you know, this is basic
as we move into more involved financial statements.
But accounts payable first, wages payable second in my class.
So accounts payable, let's do it.
Current liabilities, accounts
payable, and wages payable.
I do allow my students to use acronyms, abbreviations like APAR.
Be careful though, your professor may not.
Financial statements are things where formatting
matters, so if your professor doesn't want you to do that,
be careful, right? Accounts payable
$17,000, wages payable $3,000.
17 and 3 is 20, and that is our
total current liabilities.
On to long-term liabilities, and we just had the one,
I can remember it, it was the bank loan.
Payable. I don't remember for how much,
but I do remember it was a bank loan payable.
Now, because I just have one item in the category,
I write the number in the total column,
sort of like with sales way back here,
or sales with revenues. I only had one revenue,
so I wrote it as total revenue.
Remember, list on the left, total on the right.
If I had two different revenue streams,
I would list them and then total. If I had two different
long-term liabilities, list and then total.
List on the left, total on the right. Because I only
I only have one $30,000 bank loan.
I'm going to write the number.
On the right-hand side here, $30,000, 20 plus 30 is 50.
That is my total liabilities.
On to the final section here,
and the final section is shareholders' equity.
Under shareholders' equity,
just two accounts will be common here for us, common shares.
You'll also hear this called share capital,
capital stock, common stock.
Also, it's a lingo for the same thing.
Paid-in capital will be a part of common shares.
We treat it as one item common shares,
but you'll see paid-in capital in this section as well
in a lot of intro textbooks.
Okay, so anyway, common shares and the other one
that certainly will be consistent between the textbooks
will be retained earnings.
They'll have retained earnings
and they'll call it the same thing.
Common shares.
What were our common shares?
I know I've seen them.
Maybe I can highlight that.
Well, I'll just circle it when I see it.
There it is.
$30,000 of common shares.
$30,000
and retained
Earnings. Now, you'll notice retained earnings is $80,000,
but that's January 1st retained
earnings. We need December 31st retained earnings,
and that number comes from not the question,
but from the statement of retained earnings
that we prepared in the last part here.
The retained earnings is $110,000 on December 31st,
2029. That's the number we use, $110,000.
30 plus 110 is $140,000, and that is my total
Shareholders' equity.
So now we need a grand total,
because we've said at the start of this,
A equals L plus SE,
assets equals liabilities plus shareholders' equity.
We need a grand total,
oops, total liabilities and shareholders' equity.
liabilities and shareholders equity.
And what is it?
50 plus 140, it is 190.
And right now, at this moment.
The birds are singing. The sun is shining.
I am very, very happy ear to ear. Why am I so happy?
Why am I smiling ear to ear?
I hope you're seeing it, because our balance sheet balances. We'll talk
about what happens when your balance sheet doesn't balance,
and that can happen, but for now, just
know we've done it. Double underline,
because this is a bottom line, and to do some formatting here
And here on the right side.
Dollar sign at the top of each column.
Dollar sign there and dollar sign here.
And dollar sign beside anything double underlined.
So only three dollar signs.
There's a desire often to put a dollar sign there.
I do not encourage my students to do that.
Again, different professors will have different
dollar signing conventions, but that's the one I use.
And there we have it.
We've got a beautiful balance sheet.
Assets equals liabilities plus shareholders' equity.
We've done a terrific job.
So before we jump into the final part of the video,
which is ratios, I want to tell a quick
story about what not to do when your balance sheet doesn't balance
and some words of encouragement
from me. If you're not looking for that story,
I'm going to put a timestamp right here. You can
skip ahead and skip the story,
but this is hopefully some words of encouragement, especially
if you're the type of person
that accounting isn't really your thing. So
I thought accounting was my thing.
When I was a little, little boy, I wanted to be an accountant.
And from a very young age, whenever anyone asked,
what do you want to be when you grow
up?
I would say accountant, even though I
didn't know what an accountant really did.
And...
I hadn't ever taken an accounting class before.
I was a little kid all through high school,
all through my first year of university.
And then finally, in my second year of university,
I arrived in an accounting class and I thought, here it is.
I'm going to really devote myself.
I'm going to really do well in the class.
And on the first midterm, we had a set of financial
statements just like this. This was question number one
of four or five questions. But the
first question and the biggest was, give me an income statement.
Give me a statement of retained earnings and prepare a balance sheet.
And when I got to the end of my balance sheet, bad news, everybody.
The birds were not singing.
The sun was not shining.
My balance sheet was not balancing.
And at that moment, I made a terrible mistake.
And that's the point of this story
is you should not make the same mistake I made.
I erased everything.
I went back, I redid the income statement,
I redid the statement of retained earnings,
I redid the balance sheet, still didn't balance.
And then I made an even worse mistake.
I erased it all again and I did it again.
Well, by the time I'd done it a third time,
like this is an hour and 20 minute test,
I was an hour into the test,
I still hadn't completed question one.
I'm looking at the clock and I'm starting to sweat
and I had a very visceral reaction
and an unexpected reaction.
I started to cry.
In the seat, I was like, oh, no, I'm failing the test.
I've told everybody in my life I want to be an accountant.
Never had failed a test before.
I did fail that one.
But I was freaking out in the moment.
And I couldn't believe it.
I had this stress reaction that I've just never had before that.
And.
So what's the point of this story?
Well, the first thing is, you know, I have students that
hand in a balance sheet, and it's not balanced,
and it happens all the time. And it's often like
they just wrote a number down wrong.
Instead of $14,000, they might have written $15,000 here.
And then all of a sudden, their total expenses is off by $1,000.
Their net income is off by $1,000.
If your net income is off by $1,000, this is off by $1,000.
Therefore, your retained earnings is
going to be off by $1,000. And guess what?
Your balance sheet doesn't balance by $1,000. And so
So if a student did that in my class,
if this was out of 10 marks, that student would get
a 9 out of 10.
They made one mistake.
That's it.
Don't try to fudge the numbers.
Don't try to fake your way into a balanced balance sheet, right?
If you make a mistake up there,
don't make a second mistake to make the thing balanced.
No, no, no.
Leave it unbalanced, but just go, okay.
The advice would be, just move on to the next question.
Come back if you have time.
If you don't have time, it really isn't the end of the world.
As a professor who marks these things all the time,
don't lose your mind.
That's the small level feedback.
But I've got some big level encouragement.
If you're a student that knows you've struggled
with this or you've struggled with it in the
past.
I failed that test, right? I got, I remember the number, 27%.
I failed the test miserably.
I've never failed a test before or since that badly.
Thank
Well, I went on to an accounting degree.
I got a CPA.
I'm a college professor in accounting.
I'm an accounting YouTuber, for goodness sakes.
Failing a test is a setback.
Don't get me wrong.
It's a bummer.
It is not the end of the world.
And I know it feels like it in the moment.
It certainly felt that way to me.
you.
But I can just tell you I have a different perspective now.
It is not the end of the world.
And in fact, I have students that fail the class
and they come back and try again and
they do better the next time.
So please don't lose hope.
If you have done poorly, hopefully these videos help
and they're a bit of a lifeline for some of
you, but it really isn't the end of the world.
And it isn't like a judgment about you as a person.
You can struggle on these tests.
I'm living proof and you can get over that hurdle. And I hope you
do. And I hope these videos help you in doing that.
Okay. Onto the final part of our problem.
We got to do some ratios.
Ratios are little calculations you can do
to understand the company better.
Because you look at the numbers,
maybe they don't make a lot of sense to you
and a ratio can help you make some sense of the numbers.
So these are our ratios for the balance sheet,
the current ratio, the debt ratio, and the equity ratio.
I'll give you the formulas and then we'll solve.
So the current ratio
is current assets
divided by current liabilities.
The debt ratio.
is total liabilities divided by total assets,
not current now. And the equity ratio is total
shareholders equity divided by total assets.
So let's do these three and I'll talk about each of
them briefly. The current ratio of this company,
current assets divided by current liabilities,
it's $40,000. That's my current assets divided
by current liabilities, which is 20. Our current
Ratio.
is two. Now, normally, this will be a big long decimal
for a real company, like made-up company,
made-up numbers, everything worked out evenly.
The rule of thumb here is you want a ratio above
1.5 for most normal companies.
And let's think about what it's measuring. Current assets,
that's my short-term liquid assets,
divided by current liabilities, that's my short-term
liquid debts, that's what I got to pay off soon.
And it's saying, do I have enough short-term assets
to pay my bills.
Or is this company going to be in a crunch here?
Are they going to run out of money, essentially?
So 1.5 is thought of as safe, 1.5 or more.
So we're above 1.5, we would think of that as safe.
Debt ratio, total liabilities divided by total assets.
In this case, that's 50,000 divided by total assets.
So total liabilities, not current,
but total 50 and divided by total assets, which are
Our 190, 50 divided by 190 is 50.
Divided by 190,
0.2631, 26.3%.
That was 0.263.
Okay, we'll do the equity ratio, then we'll discuss both of these.
Equity ratio is 140 divided by 190.
What you'll notice is, because this one, because of the nature of...
The balance sheet, these two have to add up to 100%.
So this one's 26.3. The equity ratio is
going to be 73.7. I can tell you that already, but let's calculate it.
Our total shareholder's
equity was 140. Our total assets, 190.
And yeah, 73.68. So 73.7%.
What does this tell us? It says if the company stopped today
and I had to pay off all the debts,
it would take 26% of my assets to cover the debts.
It's a measure of how much debt I've taken on.
The general rule of thumb is smaller is,
we'll say better, smaller is safer. Less debt is
generally thought of as safer, more debt is riskier.
Is 26% a lot of debt or a little debt?
We don't know.
We have to learn more about the company and its industry.
We would want to compare the trend over time.
So we know that 26% of the assets,
if I sold off all my assets, paid off all my bills,
26% of that money would go to pay off debts,
and 74% of that money would go to pay shareholders.
And obviously, you're potentially a shareholder.
You'd be interested in that.
Okay, we've made it to the end of Sherry Shuttles.
For goodness sakes, if you made it to the end,
if you prepared with me the income statement,
the statement of retained earnings,
you sat through that long story about my sad balance
sheet not balancing, and you made it to the end of this video,
smash one of those buttons.
Thank you so much for being here.
I can't wait to join you in the next videos.
We learn more advanced financial statements,
and we move on to journal entries, one of
the most challenging and useful topics of our course.
Thanks for watching. See you in the next video. Bye-bye.
The next video in our series is right up here,
and if you want a supercut of
all of the videos in this series, that's the one down below.
