Let us now do a full question on final accounts.
Question
From the following Trial Balance, prepare a Profit and Loss Statement and Balance Sheet along with notes to accounts for the year ending December 31, 2007.
Dr. Balances |
Rs. |
Cr. Balances |
Rs. |
Opening Stock Land and Building Machinery Furniture and Fixtures Purchases Salaries General Expenses Rent Postage and Telegrams Stationery Wages Freight on Purchases Carriage on Sales Repairs Sundry Debtors Bad Debts Cash in Hand Cash at Bank Sales Returns |
15,500 35,000 50,000 5,000 1,06,000 11,000 2,500 3,000 1,400 1,300 26,000 2,800 4,000 4,500 30,000 600 100 6,400 5,100 |
Capital Loan From Mrs. Gurdeep Singh @ 9% Sundry Creditors Purchase Returns Sales Discount |
60,000 30,000 9,600 2,100 2,07,300 1,200 |
3,10,200 |
3,10,200 |
The following further information was given.
Answer
Step I
We will take each item one by one and segregate them according to whether they will be transferred to the Profit and Loss Statement or shown in the Balance Sheet.
Simultaneously, we will also see how their relating adjustments are treated.
Let us start from the Debit side of the Trial Balance.
It is not taken directly to the Profit and Loss Statement but shown as increase or decrease in the inventory to arrive at the operating profit; that is, if
closing stock > opening stock = increase in inventory
closing stock < opening stock = decrease in inventory
We can see in the adjustments that closing stock of Rs. 14,900 is given. Hence change in inventory to be taken to profit and loss account: opening stock − closing stock (15,500 − 14,900), which is Rs. 600 decrease in inventory.
Further, closing stock of Rs. 14,900 will be shown as inventories under current assets in the Balance Sheet.
It is given at Rs. 35,000 in the trial balance. But we can also see that depreciation @ 2 percent has to be provided as given in the adjustment. Hence, since Land and Building is fixed asset, it will be shown at the original cost in the Balance Sheet and accumulated depreciation pertaining to it—that is, 2 percent of Rs. 35,000—which is Rs. 700 will be shown separately as deduction from the original cost. Simultaneously, the depreciation amount will also be charged to the profit and loss account.
This is given at Rs. 50,000 in the Trial Balance, and the adjustment relating to it states that depreciation @ 10 percent will be charged on it. Hence machinery will be shown at the original cost in the Balance Sheet under Fixed Assets and Accumulated Depreciation of Rs. 5,000, that is, 10 percent of Rs. 50,000 will be shown as deduction from it. Moreover, depreciation will also be charged to the profit and loss account as loss in the value of asset.
Similar to Land and Building, Furniture and Fixtures too will be shown at the original cost as fixed asset in the Balance Sheet. As per the adjustment given, depreciation @ 15 percent will also be charged, that is, Rs. 750 will be charged to the profit and loss account and shown as accumulated depreciation in the Balance Sheet as deduction from the original cost.
Total purchases of Rs. 1,06,000 will be shown in the Profit and Loss Statement as the expense is related to the normal business activities of the company.
Since it is a revenue expense, it will be charged to the profit and loss account.
They are also operating expenses, and hence should be charged to the Profit and Loss Statement. But the adjustment says that out of Rs. 2,500, Rs. 600 is for the year ending March 31, 2008, that is, it is prepaid for three months from January to March 2008; this means Rs. 150 (600 × 3/12) is prepaid. Hence, only Rs. 2,350 (2,500 − 150) will be charged to the profit and loss account since only this much amount relates to the current period. We will not take expense that is not of the current year into account.
Further, the prepaid expense of Rs. 150 will be shown as current asset in the Balance Sheet as we have not yet incurred it but have made the payment.
These are also operating expenses incurred by the company in its normal course of business. Further, no additional information is given for these, so we will assume that they pertain to the current period. Hence, they too will be charged to the Profit and Loss Statement.
Wages are also revenue expenditure to be charged to the profit and loss account but in the adjustments, it is given that out of Rs. 26,000, Rs. 2,100 has not yet been paid—that is, it is still outstanding. We will report the total expenditure incurred in the current year whether it is paid or not. Hence, in the Profit and Loss Statement, the amount of Rs. 28,100 (26,000 + 2,100) will be charged irrespective of whether or not payment is made, as long as it pertains to the current year.
Further, outstanding wages of Rs. 2,100 will be shown under current liabilities in the Balance Sheet.
Since these expenses are also revenue and pertain to the current period, they will be charged to the profit and loss account.
These are receivables for the company and hence will be shown under current assets in the Balance Sheet.
Moreover, it has been provided in the adjustments that provision for doubtful debts should be made on the debtors @ 5 percent. This means that the company expects that the collection from 5 percent of debtors is uncertain. Hence provision of Rs. 1,500—that is 5 percent of 30,000—should be made by charging to the profit and loss account. Simultaneously, this provision will be shown under the head current liabilities in the Balance Sheet.
Bad debts are those receivables that cannot be recovered, that is, it is a loss for the company, and hence will be charged to the profit and loss account.
Being an asset, both cash in hand and cash at bank will be shown under current assets in the Balance Sheet.
It will be subtracted from total sales to arrive at net sales in the profit and loss account.
Let us now proceed to the Credit side of the Trial Balance.
It represents the owner’s funds and hence will be shown under Equities in the Balance Sheet.
Being a liability, it will be shown under Long Term Liabilities in the Balance Sheet. Moreover, its interest of Rs. 1,350—that is, 9 percent of 30,000 for half year (since loan is taken on July 1, 2007) will be charged to profit and loss account. The fact that it is not paid does not make a difference since it is already due and has become payable. This outstanding interest will be shown under current liabilities in the Balance Sheet.
They are payables for the company and hence will be classified under Current Liabilities in the Balance Sheet.
They are subtracted from purchases in the profit and loss account to arrive at net purchases.
This is shown under Revenue From Operations in the Profit and Loss Statement since it is the primary source of income for the company generated from its operations.
Since it is shown on the Credit side of the Balance Sheet, it is an income (credit all incomes), that is, discount received and hence will be shown as Other Income in the profit and loss account.
Step II
Now we just have to present it appropriately along with notes to accounts.
Balance Sheet
Balance Sheet of Y Ltd. |
|||||
for the year ending December 31, 2007 |
|||||
Particulars |
Note No. |
Note No. |
Figures at the end of current reporting period |
Figures at the end of previous reporting period |
|
I |
EQUITIES AND LIABILITIES |
||||
1 |
Shareholders’ Funds |
||||
(a) Share Capital |
60,000 |
||||
(b) Reserves and Surplus |
1 |
30,550 |
|||
2 |
Noncurrent Liabilities |
||||
(a) Long Term Borrowing |
2 |
30,000 |
|||
3 |
Current Liabilities |
||||
(a) Short Term Borrowings |
|||||
(b)Trade Payables |
9,600 |
||||
© Other Current Liabilities |
3 |
3,450 |
|||
© Short Term Provisions |
4 |
1,500 |
|||
TOTAL |
1,35,100 |
||||
II |
ASSETS |
||||
1 |
Non Current Assets |
||||
(a) Fixed Assets |
|||||
(i) Tangible assets |
5 |
83,550 |
|||
2 |
Current Assets |
||||
(a) Current Investments |
- |
||||
(b) Inventories |
14,900 |
||||
(c) Trade Receivables |
30,000 |
||||
(d) Cash and Cash Equivalents |
6 |
6,500 |
|||
(e) Short Term Loans and Advances |
- |
||||
(f) Other Current Assets |
7 |
150 |
|||
TOTAL |
1,35,100 |
Statement of Profit and Loss for the Year Ended December 31, 2007 |
|||
Particulars |
Note No. |
Figures at the end of current reporting period |
Figures at the end of previous reporting period |
(i) Revenue From Operations |
8 |
2,03,400 |
|
(ii) Other Income |
|||
(iii) Total Revenue (A) |
203,400 |
||
(iv) Expenses |
|||
Cost of Material Consumed |
9 |
1,06,700 |
|
Change in Inventory of Finished Goods |
10 |
600 |
|
Employee Benefit expenses |
11 |
39,100 |
|
Depreciation and Amortization Expenses |
12 |
6,450 |
|
Finance Cost |
13 |
1,350 |
|
Other expenses |
14 |
18,650 |
|
Total Expenses (B) |
1,72,850 |
||
(v) Profit before Tax (A−B) |
30,550 |
||
(vi) Less: Provision for Tax |
- |
||
(vii) Profit for the period |
30,550 |
Notes to Accounts |
||
1 |
Reserves and Surplus |
|
Profit and Loss A/c ( Current year profit) |
30,550 |
|
2 |
Long Term Borrowing |
|
Loan From Gurdeep Singh @ 9 % |
30,000 |
|
3 |
Other Current Liabilities |
|
Outstanding Wages |
2,100 |
|
Outstanding Interest |
1,350 |
|
3,450 |
||
4 |
Short Term Provision |
|
Provision for Doubtful Debts |
1,500 |
|
5 |
Fixed Assets |
|
Tangible |
||
Machinery |
50,000 |
|
Less: Accumulated Depreciation |
5,000 |
|
45,000 |
||
Land and Building |
35,000 |
|
Less: Accumulated Depreciation |
700 |
|
34,300 |
||
Furniture and Fixture |
5,000 |
|
Less: Accumulated Depreciation |
750 |
|
4,250 |
||
Total |
83,550 |
|
6 |
Cash and Cash Equivalents |
|
Cash in Hand |
100 |
|
Cash at Bank |
6,400 |
|
6,500 |
||
7 |
Other Current Assets |
|
Prepaid Expenses (Insurance Premium} |
150 |
|
8 |
Revenue From operations |
|
Sales |
207,300 |
|
(Less) Sales Return |
5,100 |
|
(Add) Cash Discount Received |
1,200 |
|
203,400 |
||
9 |
Cost of Material Consumed |
|
Add: Purchases |
106,000 |
|
Freight on Purchases |
2,800 |
|
Less: Purchase Return |
2,100 |
|
106,700 |
||
10 |
Change in Inventory of Finished Goods |
|
Opening Inventory |
15500 |
|
Closing Inventory |
14900 |
|
600 |
||
11 |
Employee Benefit expenses |
|
Wages |
26000 |
|
Add: Outstanding Wages |
2100 |
|
Salaries |
11000 |
|
39100 |
||
12 |
Depreciation and Amortization Expenses |
|
Machinery |
5000 |
|
Land and Building |
700 |
|
Furniture and Fixture |
750 |
|
6450 |
||
13 |
Finance Cost |
|
Interest on Bank Loan |
1350 |
|
14 |
Other Expenses |
|
General Expenses |
2500 |
|
Less: Prepaid |
−150 |
|
Rent |
3000 |
|
Postage and Telegrams |
1400 |
|
Stationery |
1300 |
|
Carriage on Sales |
4000 |
|
Repairs |
4500 |
|
Bad Debts |
500 |
|
Provision for Bad and Doubtful Debts |
1500 |
|
18650 |
Next, let us look into some other general topics.
3.21.76.0