|
a) Prepare a budgeted trading, profit and loss account for the three months ended 30 November
This company hires out equipment and does not par-take in the buying and selling of goods and services. Thus there is no requirement for a trading account and the profit and loss account is simply sales less expenses as follows. Note the direct costs amount to 10% of sales.
|
|
Budgeted Profit and Loss Account |
|
|
|
|
|
|
|
|
|
|
|
September |
October |
November |
Total |
|
|
|
€ |
€ |
€ |
|
€ |
|
|
|
|
|
|
|
|
Sales |
|
|
66000 |
72600 |
79860 |
|
218,460 |
|
|
|
|
|
|
|
|
Less Expenses |
|
|
|
|
|
|
|
Direct costs |
|
|
|
21,846 |
|
|
Labour costs |
|
|
|
54,615 |
|
|
Overheads |
|
|
|
43,030 |
|
|
Rent |
|
|
|
|
6,000 |
|
|
Loan Interest |
|
|
|
825 |
126,316 |
Net Profit |
|
|
|
|
|
|
92,144 |
|
|
|
|
|
|
|
|
b) Prepare a budgeted monthly cash budget for September, October and November
|
|
|
|
Cash Budget |
|
|
|
|
|
|
|
|
|
|
|
September |
October |
November |
Total |
|
|
|
€ |
€ |
€ |
€ |
Income |
|
|
|
|
|
|
Cash sales |
|
33000 |
36300 |
39930 |
109230 |
Cash received from credit sales |
|
22000 |
33000 |
36300 |
91300 |
|
|
|
|
|
|
|
Total income |
|
|
55000 |
69300 |
76230 |
200530 |
|
|
|
|
|
|
|
Expenditure |
|
|
|
|
|
Direct costs |
|
6,600 |
7,260 |
7,986 |
21,846 |
Rent |
|
|
|
12,000 |
|
12,000 |
Labour |
|
|
16,500 |
18,150 |
19,965 |
54,615 |
Overheads |
|
11,000 |
12300 |
13730 |
37030 |
Accruals |
|
|
|
15000 |
|
15000 |
B/S Creditors |
|
15,000 |
|
|
15000 |
Loan Interest |
|
|
|
825 |
825 |
Capital repayment on loan |
|
|
3000 |
3000 |
Total expenses |
|
49100 |
64710 |
45506 |
159316 |
|
|
|
|
|
|
|
Surplus |
|
|
5900 |
4590 |
30724 |
41214 |
|
|
|
|
|
|
|
O/balance |
|
|
3560 |
9460 |
14050 |
3560 |
|
|
|
|
|
|
|
C/balance |
|
|
9460 |
14050 |
44774 |
44774 |
|
|
|
|
|
|
|
Note: The cash received from credit sales in September relates to credit sales in August represented by the debtors figure in the opening balance sheet. Overheads figure excludes depreciation as it is a non-cash item
c) Prepare a forecast balance sheet as at 30 November
|
|
|
Balance Sheet as at 30th November |
|
|
|
|
|
€ |
€ |
€ |
|
|
|
|
|
Cost |
Accum Dep |
NBV |
Fixed Assets |
|
|
|
298,000 |
6,000 |
292,000 |
|
|
|
|
|
|
|
|
Current Assets |
|
|
|
|
|
|
Debtors |
|
|
|
|
|
39930 |
|
Bank |
|
|
|
|
|
44774 |
|
prepayment |
|
|
|
|
8,000 |
92,704 |
|
|
|
|
|
|
|
Current Liabilities |
|
|
|
|
|
|
Creditors for capital expenditure |
|
|
|
|
|
|
30,000 |
|
|
|
|
|
|
|
Long-term Liabilities |
|
|
|
|
|
|
Loan |
|
|
|
|
|
|
30,000 |
|
|
|
|
|
|
|
324,704 |
Financed By |
|
|
|
|
|
|
Share Capital |
|
|
|
|
|
205,000 |
Profit and loss (92,144 + 27,560) |
|
|
|
|
|
119,704 |
|
|
|
|
|
|
|
324,704 |
|
|
|
|
|
|
|
|
Note:
- The fixed assets at cost figure is €268,000 + €30,000
- The prepayment relates to rent prepaid for 4 months x €2000 per month
- Creditors for capital expenditure relates to the new fixed assets purchased. This is a current liability as it will be paid in December.
- The long term loan has been reduced by a repayment of €3,000
- The profit and loss balance in the balance sheet is made up of the profit and loss balance in the opening balance sheet of €27560 + the projected profit of €268,000.
|