Sunshine Ltd sells beach buckets and spades. The forecast information for the six months ending 31 October 2002 is: May June July August September October £000 £000 £000 £000 £000 £000 Sales (Revenue) 16 20 26 28 24 20 Purchases 12 16 18 14 12 10 Overheads 4 8 8 4 Additional information 1. On average 20% of each month's sales is expected to be for cash. A further 60% will be given one month's credit. The rest will be given two months' credit. All monies should be received when due. The increase in overheads arises from the employment of casual staff. The overheads are paid in the month in which they occur. 2. 3. Suppliers are expected to allow one month's credit. 4. The cash at bank balance as at 1 July 2002 is £7,200 overdrawn. REQUIRED (a) Prepare a detailed forecast month by month cash budget for the four months ending 31 October 2002.

Sunshine Ltd sells beach buckets and spades. The forecast information for the six months ending 31 October 2002 is: May June July August September October £000 £000 £000 £000 £000 £000 Sales (Revenue) 16 20 26 28 24 20 Purchases 12 16 18 14 12 10 Overheads 4 8 8 4 Additional information 1. On average 20% of each month's sales is expected to be for cash. A further 60% will be given one month's credit. The rest will be given two months' credit. All monies should be received when due. The increase in overheads arises from the employment of casual staff. The overheads are paid in the month in which they occur. 2. 3. Suppliers are expected to allow one month's credit. 4. The cash at bank balance as at 1 July 2002 is £7,200 overdrawn. REQUIRED (a) Prepare a detailed forecast month by month cash budget for the four months ending 31 October 2002.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

1. A company has a sales plan for 2020 based on the estimated end of the month as follows: Month Total sales July Rp 28.000,00 August 35.000,00 September 42.000,00 Payment terms are set: 3/20/net 30. Based on the experience of the customer's payment method as follows: 60% of sales every month is collected at 20 days after the month of pend. 30% accumulated in the time after 20 days in the same month, i.e. in the first month after the month of Dec. 10% collected in the second month after the month of Dec. Required: prepare a schedule/budget for collection of receivables (receivables collection budget)
what is the correct answer?
Neha Wholesalers supplied you with the following projected information:1. Expected sales are as follows:August R350 000September R280 000October R300 0002. Cash sales are expected to be 50% of total sales. The balance is on credit.3. Debtors are expected to settle their accounts as follows:40% in the month of the sale60% one month after the sale4. Expected purchases are as follows:August R100 000September R 40 000October R 50 0005. All purchases are on credit. Creditors are paid one month after the purchases less 10%discount.6. Rent expenses amount to R7 000 per month, Rent will increase by 15% from 1 October.7. Selling expenses are expected at 1% of total sales and are paid during the month of sales.8. Insurance amounts to R360 000 per annum, payable monthly.9. The owner intends making a cash drawings of R5 000 each month.10. Interest on fixed deposit of R2 000 is due on 1 September.11. The bank balance on 31 July is expected to be R25 000 favourable.Required:1.1 The Debtors…
The cost of product X is 30 percent of its selling price, and the carrying cost is 8 percent of selling price. Accounts are paid on average 60 days after sale. Sales per month average P25,000. What is the investment in accounts receivable? choose the letter of the correct answera. P8,000.00b. P9,000.00c. P19,000.00d. P29,000.00e. P39,000.00
The cost of product X is 30 percent of its selling price, and the carrying cost is 8 percent of selling price. Accounts are paid on average 60 days after sale. Sales per month average P35,000. What is the investment in accounts receivable? CHOOSE THE ANSWERA. P600.00B. P6,600.00C. P19,000.00D. P16,600.00E. P26,600.00
Data regarding a company's monthly sales for the last six months of the year and its projected collection patterns are shown below:Forecasated sales:July = P775,000August = P750,000September = P825,000October = P800,000November = P850,000December = P900,000Types of sales:Cash sales = 20%Credit sales = 80%Collection pattern for credit sales:In the month of sale = 40%In the first month following the sale = 57%Uncollectible = 3% The cost of merchandise averages 40% of its selling price. The company's policy is to maintain an inventory equal to 25% of the next month's forecasted sales. The inventory balance at cost is P80,000 as of June 30. How much is the total cash receipts that would be budgeted for the month of September?
X is a UK based company which has the following US $ Eransacto O ne month : Expected receipt of $240 000. One month : Expected payment of140 000. 3 months : Espected receipts of $300000, The tinanie manager has Collected the following information: Spot rate ( $per E):# 782010.0002 One month forw ard rate (4 per £): 1.7829 0.0003. 3 months forward rate ($per £):1:7846 ±o.0004 Borrowing Deposit 4.6.10 5.11 Moneyrates For x : One year sterling interest rate One year 4.9.%0 dollar interest rate Calculate the erpected stering receipts in 1month and in 3 months using the Foruward martcet. Calylate the enlpected sterling receipts in 3 months using a money market hedge and recommend whether a forwar market hedge or a money market hedge should be used. Dis cuss how Sterling curvency futures contracts could be used to hedge the 3 month dollar receipt when using currency futures, very of ten companies citunnnoi of an imperfect hedge. Explain, using Curhodae and
PT AWOL has sales projections (in million rupiahs) for the following four quarters: Q1 Q2 Q3 Q4 Q1* Sales 410 395 440 500 500(1+80%) Account receivables at the beginning of this year were IDR 150 million. PT AWOL has an average collection period of 45 days. PT AWOL purchases from suppliers on each quarter are 40% of the estimated sales of the next quarter, and the average account payable period is 30 days. Salaries, taxes, and other expenses for each quarter are 30% of sales. The dividend is IDR 20 million, paid quarterly. PT AWOL plans a capital expenditure in the second quarter of IDR 150 million. The company has an initial cash balance of Rp. 85 million with a minimum balance of Rp. 85 million. Assume that the company must borrow the funds needed in the short term at an interest rate of 5% per quarter and the interest is paid in the following quarter. Prepare a cash budget for PT AWOL! (Assuming 1 quarter = 90 days)
0. Swetres Company has the following sales forecast for the selected three-month period in 2018. April, P120,000; May, P70,000; June, P80,000. 70% of sales are collected in the month of sale, and the balance are collected in the following month. Accounts receivable balance in April 1, P100,000. Cash balance in April 1, P60,000. Minimum cash balance required is P50,000. Cash can be borrowed in the multiples of P10,000 from local bank (disregard the interest charges). What is the cash balance at the end of April assuming that cash is received only from customers and that P200,000 is the cash out during April? 11.Selected information from the accounting records of Roleg Co. is as follows: Net accounts receivable at Dec. 31, 2018, P900,000; Net accounts receivable at Dec. 31, 2019, P1,000,000; Inventories at Dec. 31, 2018, P1,100,000; Inventories at Dec. 31, 2019, P1,200,000; Accounts receivable turnover, 5 times; inventory turnover, 4 times. What is Roleg's gross margin for 2019? 12.…
Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of goods ($ millions) 37 33 30 27 25 25 a. Sixty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of 1 month. If Dynamic Futon starts the year with payables of $27 million, what is the forecasted level of payables for each month? (Do not round intermediate calculations. Enter your answers in millions of dollars rounded to 1 decimal place.) Jan. Feb. Mar. Apr. May Jun. Payables b. Suppose that, from the start of the year, the company stretches payables by paying 50% after 1 month and 20% after 2 months. (The remainder continue to be paid cash-on-delivery.) Recalculate payables for each month assuming that there are no cash penalties for late payment. Assume that Dynamic Futon didn't have any payable balance at the start of the year. (Do not round intermediate calculations. Enter your answers in millions of…
Use 360 days in a year. Solutions must be complete (including formulas). Present rates in percent and rounded off to five decimal places (e.g. 35.66667 for 35.666666%). Round off days to two decimal places. . DF has total forecasted gross purchases of P4,500,000 relating to a major supplier for the coming year. The supplier is offering a credit term of 3/15, n/45. 1. How much is the simple annual effective cost of paying on the 45th day?
An ovedraft interest of 15%per annum is negotiated on the overdrawn balance at the end of each month. There is an interest on cash surplus. Let's say the overdraft is R235 256 How do you make the calculation?