|
a) Prepare a budgeted departmental trading, profit and loss account for the three months ended 31August
This question asks for a departmental trading, profit and loss account. That requires a separate trading account for the bar and restaurant. Unlike other questions you are given the purchases figures however you are not given any information on how to calculate closing stock. Thus closing stock is the balancing figure for each trading account. There is no need to prepare a monthly trading account as the monthly purchases figures are already given. The following are the steps in preparing the trading account
1. Outline the trading account and put in the figures given in the questions – sales, purchases and opening stock.
2. Calculate gross profit and cost of sales. This is done by using the gross profit percentage given in the question. The question expresses gross profit as a percentage of sales thus sales = 100%. For the bar, gross profit = 55% and hence cost of sales = 45%. For the restaurant, gross profit = 60% and thus cost of sales = 40%.
3. The balancing figure in the trading account is the closing stock for both the bar and restaurant.
Note: There is rental income in this question. The rental income earned for the period (3 months) should be added to gross profit. However the question does not tell us the monthly rental. This can be calculated by ascertaining how many months does the rent prepaid in the opening balance sheet represent. If the tenant pays every three months and his last payment before the opening balance sheet date was 1 may. Then the amount of the prepayment represents 2 months. Thus the monthly charge is €1,000 / 2 = €500
|
|
Departmental Trading, Profit and Loss Account |
|
|
|
|
Bar |
|
Rest |
|
Total |
|
|
|
|
€ |
|
€ |
|
€ |
|
Sales |
|
|
30,000 |
|
90,000 |
|
120,000 |
|
Less Cost of sales |
|
|
|
|
|
|
|
O/stock |
|
|
800 |
|
500 |
|
1300 |
|
Purchases |
|
13,400 |
|
44,000 |
|
57400 |
|
|
|
|
14,200 |
|
44,500 |
|
58700 |
|
C/stock |
Balancing figure |
700 |
|
8,500 |
|
9200 |
|
COGS |
|
|
13,500 |
|
36,000 |
|
49500 |
|
|
|
|
|
|
|
|
|
|
G.P. |
|
|
16500 |
|
54000 |
|
70500 |
|
Add rental income |
|
|
|
|
|
1500 |
|
|
|
|
|
|
|
|
72000 |
|
Less Expenses |
|
|
|
|
|
|
|
Wages |
|
|
|
|
|
34,500 |
|
|
Other Expenses (excluding insurance 20,500-3,000) |
|
17,500 |
|
|
Insurance |
(less prepayment of 9 months 3000-2250) |
|
750 |
|
|
Depreciation |
|
|
|
|
2550 |
|
|
Loan interest |
|
|
|
|
1350 |
|
|
|
|
|
|
|
|
|
56,650 |
|
Net Profit |
|
|
|
|
|
|
15,350 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
b) Prepare a monthly forecast cash budget for June, July and August
Cash Budget |
|
|
|
|
|
|
|
|
|
|
|
|
June |
July |
August |
Total |
|
|
€ |
€ |
€ |
€ |
Income |
|
|
|
|
Cash Sales |
|
29520 |
36000 |
42480 |
108000 |
Cash received from credit sales |
|
1000 |
3280 |
4000 |
8280 |
Rental Income received |
_____ |
______ |
1500 |
1500 |
Total income |
|
30520 |
39280 |
47980 |
117780 |
|
|
|
|
Less Expenditure |
|
|
|
Purchases |
2230 |
17,000 |
18,400 |
37,630 |
Cash Wages |
|
7000 |
8400 |
8750 |
24,150 |
PAYE/PRSI |
|
|
3000 |
3600 |
6,600 |
Expenses |
3000 |
7000 |
7500 |
17,500 |
Insurance |
3000 |
|
|
3,000 |
Loan repayment |
1200 |
1200 |
1200 |
3,600 |
Loan Interest |
450 |
450 |
450 |
1350 |
Preliminary tax |
|
|
10000 |
10000 |
Total expenditure |
|
16880 |
37050 |
49900 |
103,830 |
|
|
13640 |
2230 |
-1920 |
13950 |
Opening cash balance |
|
2360 |
16000 |
18230 |
2360 |
|
|
|
|
|
|
Closing cash balance |
|
16000 |
18230 |
16310 |
16310 |
|
|
|
|
|
|
|
|
c) Prepare a budgeted balance sheet as at 31 August
|
|
|
Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Fixed Assets |
|
Cost |
|
Depreciation |
N.B.V. |
|
|
Leaseholds |
|
200000 |
|
1800 |
|
198200 |
|
|
Equipment and Furniture |
50000 |
|
750 |
|
49250 |
|
|
|
|
|
250,000 |
|
2,550 |
|
247450 |
|
|
Current Assets |
|
|
|
|
|
|
|
|
|
Stock |
|
|
|
9200 |
|
|
|
|
|
Debtors |
|
|
|
4720 |
|
|
|
|
|
Bank |
|
|
|
16310 |
|
|
|
|
|
Insurance prepaid |
(9 months prepaid) |
2250 |
|
32480 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Creditors <12 months |
|
|
|
|
|
|
|
|
|
Trade Creditors |
|
|
|
22000 |
|
|
|
|
|
Wages due |
|
|
|
3750 |
|
|
|
|
|
Rent prepaid |
|
|
1,000 |
|
26,750 |
|
|
|
|
|
|
|
|
|
|
|
|
Creditors >12 months |
|
|
|
|
|
|
|
|
|
Loan capital |
|
|
|
|
39,830 |
|
|
|
|
|
|
|
|
|
213,350 |
|
|
Financed By |
|
|
|
|
|
|
|
|
|
Capital |
|
|
|
|
|
150000 |
|
|
|
Reserves |
|
|
|
|
|
48000 |
|
|
|
Retained profit |
|
|
|
|
15350 |
|
|
|
|
|
|
|
|
|
213350 |
|
|
|
|
|
|
|
|
|
|
|
Note:
- There were no new fixed assets purchased so the NBV of fixed assets is simply cost less depreciation.
- Debtors represent credit sales in August
- Trade creditors represents August credit purchases
- The rent prepaid is a prepayment on a revenue item and thus is a current liability. In effect the tenant has paid in advance and thus the business owes the tenant the amount of the prepayment. The prepayment represents 2 months rent namely September and October.
|