Linpet Ltd is to be incorporated on 1 June. The opening statement of financial position of the

Question:

Linpet Ltd is to be incorporated on 1 June. The opening statement of financial position of the business will then be as follows:
Assets ..............................£
Cash at bank .............60,000
Share capital
£1 ordinary shares ...60,000
During June, the business intends to make payments of £40,000 for a leasehold property, £10,000 for equipment and £6,000 for a motor vehicle. The business will also purchase initial trading inventories costing £22,000 on credit.
The business has produced the following estimates:
1 Sales revenue for June will be £8,000 and will increase at the rate of £3,000 a month until, and including, September. In October, sales revenue will rise to £22,000 and in subsequent months will be maintained at this figure.
2 The gross profit percentage (that is, (gross profit/sales) * 100) on goods sold will be 25 per cent.
3 There is a risk that supplies of trading inventories will be interrupted towards the end of the accounting year. The business therefore intends to build up its initial level of inventories (£22,000) by purchasing £1,000 of inventories each month in addition to the monthly purchases necessary to satisfy monthly sales requirements. All purchases of inventories (including the initial inventories) will be on one month’s credit.
4 Sales revenue will be divided equally between cash and credit sales. Credit customers are expected to pay two months after the sale is agreed.
5 Wages and salaries will be £900 a month. Other overheads will be £500 a month for the first four months and £650 thereafter. Both types of expense will be payable when incurred.
6 80 per cent of sales revenue will be generated by salespeople who will receive 5 per cent commission on sales revenue. The commission is payable one month after the sale is agreed.
7 The business intends to purchase further equipment in November for £7,000 cash.
8 D epreciation will be provided at the rate of 5 per cent a year on property and 20 per cent a year on equipment. (Depreciation has not been included in the overheads mentioned in (5)).


Required:
(a) State why a cash budget is required for a business.
(b) Prepare a cash budget for Linpet Ltd for the six-month period to 30 November.

Cash Budget
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment.  Its primary purpose is to provide the...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Accounting and Finance An Introduction

ISBN: 978-1292088297

8th edition

Authors: Peter Atrill, Eddie McLaney

Question Posted: