PDA

View Full Version : Preparing corrected balance sheet


asami
Apr 2, 2010, 10:03 PM
Hi I have this question which I have been trying to resolve using the accounting equation i.e. A =L+OE
I have eliminated items that are not meant to be in the balance sheet however it still does not balance. Any help would be appreciated

Helga has opened a fashion boutique in a new shopping centre. She has decided to prepare her own balance sheet after six months of trading to see whether it has been a profitable venture for her. As you are a friend of hers (who knows something about accounting) she has asked you to help her as she realizes that her accounting knowledge is limited to understanding the cash flows which she obtains from her bank statements. Helga has prepared and provides the following “balance sheet” for
her boutique. She has become a bit confused with the figures and thinks that she has made more profit than the balance sheet shows. Helga asks you to take a look at this balance sheet and help her out.

Helga’s Fashions
Balance Sheet
For six months ended December 31, 2009

Assets
Cash 18,000
Cash sales 120,000
Inventory 60,000
Inventory sold (at cost price) 102,000
Prepaid Insurance 2,500
Deposit paid in cash in advance from customer 1,000
Fittings and fixtures 52,000
Less Loan (40,000)
Total Assets $315,500

Less
Liabilities

Amounts owing from credit sales $115,000
Accounts Payable 75,000
Depreciation 3,000
Rent paid 8,000
Rent payable 4,000
Total liabilities $205,000

Equals
Owner’s Equity

Helga’s own capital 100,000
Retained profit/loss 10,000
Owner’s Equity $110,000

Question: Prepare a corrected balance sheet

asami
Apr 2, 2010, 10:14 PM
Assets
Cash 18,000
Accounts Receivable 115,000
Inventory 60,000
Prepaid Insurance 2,500
Total Current Assets 195,500
Fittings and fixtures (this question ignores depreciation) 52,000
Total Assets 247,500

Liabilities

Accounts Payable 75,000
Loan Payable 40,000
Rent Payable 4,000
Customer Deposit 1,000
Total Liabilities 120,000

Owners’ Equity

Share Capital 100,000
Retained Earnings:* 10,000
Total Owner’s equity 110,000
Total Liabilities and owners’ equity 230,000

asami
Apr 3, 2010, 12:01 AM
Hi I have this question which I have been trying to resolve using the accounting equation i.e. A =L+OE
I have eliminated items that are not meant to be in the balance sheet however it still does not balance. Any help would be appreciated

Helga has opened a fashion boutique in a new shopping centre. She has decided to prepare her own balance sheet after six months of trading to see whether it has been a profitable venture for her. As you are a friend of hers (who knows something about accounting) she has asked you to help her as she realizes that her accounting knowledge is limited to understanding the cash flows which she obtains from her bank statements. Helga has prepared and provides the following “balance sheet” for
her boutique. She has become a bit confused with the figures and thinks that she has made more profit than the balance sheet shows. Helga asks you to take a look at this balance sheet and help her out.

Helga’s Fashions
Balance Sheet
For six months ended December 31, 2009

Assets
Cash 18,000
Cash sales 120,000
Inventory 60,000
Inventory sold (at cost price) 102,000
Prepaid Insurance 2,500
Deposit paid in cash in advance from customer 1,000
Fittings and fixtures 52,000
Less Loan (40,000)
Total Assets $315,500

Less
Liabilities

Amounts owing from credit sales $115,000
Accounts Payable 75,000
Depreciation 3,000
Rent paid 8,000
Rent payable 4,000
Total liabilities $205,000

Equals
Owner’s Equity

Helga’s own capital 100,000
Retained profit/loss 10,000
Owner’s Equity $110,000

Answer:

Assets
Cash 18,000
Accounts Receivable 115,000
Inventory 60,000
Prepaid Insurance 2,500
Total Current Assets 195,500
Fittings and fixtures (this question ignores depreciation) 52,000
Total Assets 247,500

Liabilities

Accounts Payable 75,000
Loan Payable 40,000
Rent Payable 4,000
Customer Deposit 1,000
Total Liabilities 120,000

Owners’ Equity

Share Capital 100,000
Retained Earnings:* 10,000
Total Owner’s equity 110,000
Total Liabilities and owners’ equity 230,000

morgaine300
Apr 5, 2010, 07:22 PM
I can't get it to balance either. As far as I can see, there is some missing information, like some things that are left a little "open" as to what is supposed to happen to them. I did it first just taking it at face value, but since it doesn't balance, then I have to assume there's some information you're leaving out which could shed some light on some of this.

I've got everything exactly like you do, with the exception that I took depreciation for accumulated depreciation that would come off the plant assets. I guess I didn't take that "at face value," but it doesn't say depreciation expense OR accumulated depreciation, but since accumulated would be over on the credit side, I could see the "error" of sticking it under liabilities. You're commenting that it's to be ignored for this problem -- but where are you getting that from? (Ignoring it just makes your assets that much bigger.)

What strikes me first is that she may not have updated the current retained earnings with current net income. However, I don't see enough figures to think I could come up with a proper net income. After all, only sales, COGS and rent paid are mentioned. Maybe the depreciation was meant to be an expense as well, but still, that's a little short on expenses. But even accounting for that, I can't make it balance.

So the questions that come to mind... is the rent payable supposed to be added to the amount paid in order to get a rent expense? (That's only important if we try to get some type of net income.) Is the prepaid insurance a correct figure? Etc. Many times these "fix the balance sheet" problems list some additional information and not just the list of numbers.

morgaine300
Apr 6, 2010, 10:23 PM
Please do not double post like that. It's extremely confusing. It's not much fun to go through a problem like this, answer it, just to discover someone else has answered the same question elsewhere. I'm just glad it was me and I recognized the question. I've merged this in with your other thread.