F. Tain is opening his first boutique on 1 July 2014. He is investing $ 30,000$ as
Question:
F. Tain is opening his first boutique on 1 July 2014. He is investing $£ 30,000$ as capital. His plans are as follows:
(i) On 1 July 2014 to buy and pay for premises $£ 60,000$; shop fixtures $£ 4,000$; motor van $£ 8,000$.
(ii) To employ two assistants, each to get a salary of $£ 130$ per month, to be paid at the end of each month. (PAYE tax, National Insurance contributions, etc., are to be ignored.)
(iii) To buy the following quantities of goods for resale (shown in units):
\begin{tabular}{ccccccc}
& July & Aug & Sep & Oct & Nov & Dec \\
Units & 600 & 660 & 840 & 1,050 & 1,200 & 990
\end{tabular}
(iv) To sell the following number of units of these goods:
\begin{tabular}{ccccccc}
& Jul & Aug & Sep & Oct & Nov & Dec \\
Units & 360 & 540 & 720 & 900 & 1,170 & 1,260
\end{tabular}
(v) Based on similar ventures in shops selling other products, he has decided to sell all goods at the same price $-£ 30$. Two-thirds of the sales are for cash, the other $1 / 3$ being on credit. These latter customers are expected to pay their accounts in the third month following that in which they received their goods.
(vi) The goods will cost $£ 7$ each for July to October inclusive, and $£ 8$ each thereafter. Creditors will be paid in the second month following purchase. (Value inventory on FIFO basis.)
(vii) The other expenses of the shop will be $£ 450$ per month payable in the month following that in which they were incurred.
(viii) Part of the premises will be sub-let as an office at a rent of $£ 8,000$ per annum. This is paid in equal instalments in March, June, September and December.
(ix) His cash drawings will be $£ 1,400$ per month.
(x) Depreciation is to be provided on premises at $5 \%$ per annum straight line; shop fixtures at $15 \%$ per annum and on the motor van at $25 \%$ per annum, both using the reducing balance method.
\section*{You are required to:}
(a) Draw up a cash budget for the six months ended 31 December 2014, showing the balance of cash at the end of each month.
(b) Draw up a forecast income statement for the six months ending 31 December 2014, and a forecast statement of financial position as at that date.
Step by Step Answer:
Frank Woods Business Accounting Volume 2
ISBN: 9780273767923
12th Edition
Authors: Frank Wood, Ph.D. Sangster, Alan