I have a question regarding a balance sheet I had to correct.
I'm using Financial Managerial Accounting by Williams, Kaka, Bettner & Carcello. Edition 15
I am having problems with question 2.9A on page 74.
I have to correct the given balance sheet.
Helen Berkeley is the founder and manager of Berkeley Playhouse. The business needs to obtain a bank loan to finance the production of its next play. As part of the loan application, Berkeley was asked to prepare a balance sheet for the business. She prepared the following balance sheet, which is arranged correctly but which contains several errors with respect to such concepts as the busi-ness entity and the valuation of assets, liabilities, and owner’s equity.
BERKELEY PLAYHOUSE Balance Sheet
September 30, 2009
Assets
Cash.. . $ 21,900
Accounts Receivable.. . 132,200
Props and Costumes.. . 3,000
Theater Building.. . 27,000
Lighting Equipment.. . 9,400
Automobile.. . 15,000
Total.. . $ 208,500
Liabilities & Owner’s Equity
Liabilities:
Accounts Payable.. . $ 6,000
Salaries Payable.. . 29,200
Total liabilities.. . $ 35,200
Owner’s equity:
Helen Berkeley,
Capital.. . 173,300
Total.. . $ 208,500
What I did was
1. given: breakdown of $21 900 cash: 15000 from company bank account, 1900 in company safe and 5000 from H. Berkeley's personal savings account. I subtracted 5000 since personal savings shouldn't be included. So the new cash total is $16900
2. given: accts receivable $132200 breakdown: $7200 from Artistic Tours and $125000 estimated future ticket sales from Sept 30 - Dec 31, 2005. I included both since it is what the company is expecting in future cash flow. 132,200
3. given: Props and costumes worth $18000 were purchased several days ago. She paid $3000 cash and wrote a note payable for the remaining $15000. She didn't include the note payable since it isn't due till January of the next year. I listed props and costumes as $3,000. I added a notes payable to liabilities of $15000
4. given: Berkeley Playhouse rents the theater building from Kievits International at $3000 per month. The $27000 in the bal sheet represents the rent paid through Sept 30 of the current year. I wasn't sure where to include the liability of $27,000 under notes payable or accounts payable.
5. given: the accounts payable include business debts of $3900 and $2100 balance of Berkeley's personal Visa card. I changed accounts payable to $3900
6. given: The automobile is Berkley's classic 1978 Jaguar which purchased two years ago for $9000. Value today is $15000 so that's the value she listed it as. She doesn't use it for the business. I took this asset out completely
7. given: Lighting equipment was purchased on September 26 at $9400 but the stage manager says that it isn't worth a dime. I kept it as it is
8. given: salaries payable include $25000 grand offered to an actor for a role in the December play and $4200 owed to the stagehands for work done though Sept 30. I kept it at a total of 29,200.
9. given: Berkeley invested $20 000 in the business when she started it years ago. Someone wants to buy it today for $50 000 so that's what she valued it as. I changed capital to $20 000
This is what my balance sheet looks like
Assets
Cash... 16,900
Accounts receivable... 132,200
Props and Costumes... 3,000
Lighting Equip... 9,400
Total... 161,500
Liablibities:
Notes payable... 15,000
Accounts payable... 3,900
Salaries payable... 29,200
Total liablilties... 48,100
Owners Equity
Helen Berkely, capital... 20,000
Total 68,100
What am I doing wrong? THank you so much.