Trial Balance and Financial Statements Exercise

by Anonymous

The trial balance of Palicio Security Services Inc. as of January 1, 2016 had the following normal balances:

Cash 74,210
Accounts receivable 13,500
Supplies 200
Prepaid rent 3,200
Merchandise inventory (24 $265; 1 $260) 6,620
Land 4000
Accounts payable 1,950
Unearned revenue 980
Salaries payable 1,000
Common stock 50,000
Retained earnings 47,800

The following transactions took place during 2016 for Palicio Security Services:
1. Paid the salaries payable from 2015.
2. On March 1, 2016, Palicio established a $100 petty cash fund to handle small expenditures.
3. Paid $4,800 on May 1, 2016, for one year's lease on the company van in advance.
4. Paid $7,200 on May 2,2016 for one year's office rent in advance.
5. Purchased $400 of supplies on account.
6. Purchased 100 alarm systems for $28,000 cash during the year.
7. Sold 102 alarm systems for $57,120. All sales were on account.
(Compute cost of goods sold using the FIFO cost flow method)
8. Paid $2,100 on accounts payable during the year.
9. Replenished the petty cash fund on August 1. At this time, the petty cash fund had only $7 of currency left. It contained the following receipts: office supplies expense $23, cutting grass $55, and miscellaneous $14.
10. Billed $52,000 of monitoring services for the year.
11. Paid installers and other employees a total of $25,000 cash for salaries.
12. Collected $89,300 of accounts receivable during the year.
13. Paid $3,600 of advertising expense during the year.
14. Paid $2,500 of utilities expense for the year.
15. Paid a dividend of $10,000 to the shareholders.

1. Prepare the trial balance as at Dec 31, 2016 for Palicio Security Services Inc.
2. Prepare the income statement, statement of changes in equity and balance sheet for Palicio Security Services Inc.

A: This is actually a pretty tricky and advanced accounting exercise. I would recommend not to try it unless you have a pretty good understanding of the trial balance , financial statements and inventory (including the FIFO method and cost of goods sold ).

prepaid income and expenses Additionally, this exercise also deals with prepaid expenses and income received in advance , which are concepts I don’t go into detail about on this website (I only cover these topics in detail in my basic accounting books ). Here are some brief explanations though: Prepaid expenses are expenses you paid too early. Because it is paid too early it is as if you are owed the amount you paid, and the prepaid expense essentially is a debtor/receivable (an asset account). In a similar way, income earned in advance means you have been paid money before delivering the services/products, and so it is as if you owe this amount. Thus, income earned in advance is a creditor/payable.

Note also that in this exercise we are dealing with a
corporation , not a simple sole proprietor. With a corporation there are some new terms and concepts. First of all there are many owners in a corporation and these owners are called shareholders . Secondly, each of the shareholders owns shares in the corporation, which is also known as common stock . And thirdly, instead of “drawings," we have dividends that are paid to all the shareholders from the accumulated profits (AKA retained earnings ).

Okay, so now that we’ve cleared up all those terms, here’s the solutions, starting with the trial balance:

trial balance


** Cash includes $100 petty cash. Calculation of cash balance:
74,210 - 1,000 - 4,800 - 7,200 - 28,000 - 2,100 - (100 - 7) - 25,000 + 89,300 - 3,600 - 2,500 - 10,000
= 79,217

The opening balance of prepaid rent ($3,200) has been expensed out during 2016 as we have assumed this rent (that was paid the previous year) applies to the 2016 year. This is a likely assumption as there was a new prepaid rent cash payment on 2 May, 2016.

It is not stated in the exercise whether the unearned revenue of $980 at the beginning of 2016 was actually earned during the year. In this solution we have assumed that the unearned revenue still remains unearned at the end of 2016. However, it is quite acceptable to treat this as having been earned during 2016. If treating it as earned during 2016 one would add $980 to revenue and remove the unearned revenue account ($980 - $980).

income statement

Calculation of Cost of Sales and Closing Inventory (FIFO Basis):

Opening Balance of Merchandise Inv. (24 Units $265 + 1 Unit $260) $6,620
Purchased during the year
100 Units $280 $28,000
Total available for sale
124 + 1 Units (125 Units) $34,620
Sold*(Cost of Sales)
102 Units $28,180
Closing Balance of Merchandise Inv.
23 Units $280 $6,440

*Cost of Sales
102 Units (24 Units $265) + (1 Unit $260) + (77 Units $280) = $28,180

statement of changes in equity

balance sheet

Note that the prepayments (prepaid office rent and prepaid motor lease) have been included under debtors/receivables. Likewise, the income received in advance (“unearned revenue" of $980) has been included under creditors/payables.

Hope you enjoyed the exercise and got some good practice with the trial balance and financial statements!


Comments for Trial Balance and Financial Statements Exercise

Click here to add your own comments

"Accounts receivable" doubt
by: Anonymous

This is a brilliant piece of example. However, shouldn't Accounts receivable of 33,320 be included as a credit entry?

Thank you
by: Iva


Useful exercise
by: Elisaphan

This is a very important exercise

Student Excelling
by: Eriau

I AM very happy for helping me now understand trial balance and financial statements. I am very sure of excelling so as to fit well in accounting profession. Thank you.

by: Elis

Tks very much. only one question, you use the formal format for the statements?

Financial Statements
by: Ana

This site is very helpful for the accounting students like me. And at last i got the solution from your site.

Good post
by: Annabell Jacobs

Thanks for your great article!

by: Renz

I have felt it very useful to me. You have helped me a lot to understand more about balance and financial statements. I am sure that this post will be very helpful for many people like me. Keep sharing such posts!

Accountant Adviser In Melbourne
by: Anonymous

Nice Post Thanks for sharing the blogs with us.

Journaling Queston
by: Anonymous

10. Billed $52,000 of monitoring services for the year. how do you journal this?

Question about journaling
by: Anonymous

3. Paid $4,800 on May 1, 2016, for one year's lease on the company van in advance. How do I journalize this?

Click here to add your own comments

Return to Ask a Question About This Lesson!.

Enjoying this Website?
Help Support it with a Donation


Advertise on

All the lessons on this site and much, much more...

Available Now On

Get Your Degree!

Find schools and get information on the program that’s right for you.

Powered by

Subscribe to
The Student Accountant newsletter

Enter Your E-mail Address
Enter Your First Name (optional)

Don't worry — your e-mail address is totally secure.
I promise to use it only to send you The Student Accountant.

© Copyright 2017

Related pages

basic accounting knowledge testhow to calculate vat on grossdefinition of trade payablesaccounts receivable ledger templatejournal entries depreciationwhat is furniture and fittings in accountingclosing entries accountingexamples of subsidiary ledgersliabilities synonymbookkeeping and accountancy 11thjournal entry for ending inventoryending inventory using fifocompute total manufacturing costsales and inventory system definitionrent college textbooks cheapsample balance sheet and income statement excelweighted average formula accountingsample cashflow statementvat equationaccounts receivable conceptsaccrued revenue entryjournal entries of depreciationreceived cash on account journal entryinventory purchases formuladouble entry bookkeeping meaninggeneral entries general ledger examplesbad debts and provision for doubtful debtsbank account statement generatorretained earnings debitbad debts entryrecording bad debt expense journal entrythe retained earnings statement should be preparedaccounting debits and credits chartwrite off bad debts meaningfifo vs lifo accountingsales returns and allowances accountstatement of partner's equityaccounting for unearned revenueaccounting income summaryjournal entry accumulated depreciationthe difference between perpetual and periodic inventory systemdefinition of cash outflowtrade and other receivables examplesmotor vehicle depreciationgaap bad debt expenseprovision for doubtful accounts journal entryaccounts payable meaningrestaurant p&l templateaccounting basics tutorial pdfkhan academy accounting basicspreparing income statement from trial balancecash flow statement indirect method in excelnatures inventorydebtor creditor definitionissuing stock journal entryjournal entry interest expensebank account debited meansjournal entry interest expensesundry accountsexample of a profit and loss statement excelthe journal entry to record a return of merchandiseexample of trial balance worksheetaccountancy textbookformula for fifoaccounting equation exercisesoutstanding transaction definitionindian accounting basicsjournalizing transactions in accountingmark up percentagejurnal account payablediscount allowed in income statementgeneral ledger explainedsole proprietorship accountingcalculate vat returnfifo lifo weighted average