Use the information below to answer question 1 to 22. The financial controller of BOE Ltd. is gathering data to prepare a cash budget for the second quarter of 2018. The following information is available. a) Sales for the first six months of the year are as follows: January February March 23,000 30,000 50,000 57,000 60,000 56,000 April May June a) 40% of all sales are cash sales. b) Of credit sales, 50% are collected in the month of sales and the remaining 50% collected the following month. c) The cost of raw materials equals 35% of each month's sales. 50% of raw materials are paid for in the month of purchase. The remaining 50% are paid in the following month. d) Wages total ¢5,500 per month and are paid for in the month incurred. e) Operating expenses per month totalled ¢16,800 of which ¢2,500 is depreciation and ¢300 is expiration of prepaid insurance premium (the annual premium of ¢3,600 paid in Jan 1). f) Dividend of ¢7,000 declared in March 31 will be paid on April 20. g) Old equipment will be sold in April 4 for ¢1,300. h) On April 13, new equipment will be purchased for ¢8,400. i) The company will maintain a minimum cash balance of¢10,000 from April. i) The cash balance on March 31 amounted to ¢1,350.

Use the information below to answer question 1 to 22. The financial controller of BOE Ltd. is gathering data to prepare a cash budget for the second quarter of 2018. The following information is available. a) Sales for the first six months of the year are as follows: January February March 23,000 30,000 50,000 57,000 60,000 56,000 April May June a) 40% of all sales are cash sales. b) Of credit sales, 50% are collected in the month of sales and the remaining 50% collected the following month. c) The cost of raw materials equals 35% of each month's sales. 50% of raw materials are paid for in the month of purchase. The remaining 50% are paid in the following month. d) Wages total ¢5,500 per month and are paid for in the month incurred. e) Operating expenses per month totalled ¢16,800 of which ¢2,500 is depreciation and ¢300 is expiration of prepaid insurance premium (the annual premium of ¢3,600 paid in Jan 1). f) Dividend of ¢7,000 declared in March 31 will be paid on April 20. g) Old equipment will be sold in April 4 for ¢1,300. h) On April 13, new equipment will be purchased for ¢8,400. i) The company will maintain a minimum cash balance of¢10,000 from April. i) The cash balance on March 31 amounted to ¢1,350.

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

Garden Depot is a retailer that provided the following budgeted cash flows for next year: 3rd Quarter $ 220,000 $ 227,000 Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter $ 190,000 $ 340,000 $ 267,000 $ 237,000 The company's beginning cash balance for next year will be $22,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash…
Use the information provided below to prepare the following for January and February 2023: 4.2)Cash Budget INFORMATION The following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 January 2023 February 2023R576 000 R540 000 R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 January 2023 February 2023R1 000 000 R800 000 R920 000 6. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the purchase.7. The monthly salaries amount to R150…
Dineshbhai
Please show all work.
NanaKay Company must maintain a minimum cash balance of GH¢25,000. At the beginning of June, the company’s cash balance was GH¢17,000. Budgeted cash receipts for June are GH¢150,000, and budgeted cash disbursements are GH¢201,000. Budgeted net income for July totals GH¢11,000. How much will NanaKay Company need to borrow by the end of June?
The following information is provided to assist in the preparation of the Cash Budget for Ding Ltd. for May 2020. The cash balance at 1 May 2020 is $30,000. Budgeted Sales ($) Budgeted Purchases ($) April 170,000 64,000 May 140,000 68,000 All sales are on cash basis and will be collected in the same month the sale is made. All purchases are made on credit and payments are made as follows: 60% of purchases are paid for in the month of purchase. 40% of purchases are paid for in the month following the purchase. The business plans to take out a small business loan of $50,000 at the end of May 2020 and will be repaying it back in July 2020. Selling and administrative expenses each month are $45,000. The selling and administrative expenses include monthly depreciation expense of $6,000. Sales commission is 15% of the total monthly sales, and paid to the staff at the end of every month. Equipment costing $35,000 is expected to be bought in May and paid in…
Kupa Ltd has approached to assist in preparing a cash budget. The annual and projected sales are provided below. date Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 April 2021 May 2021 June 2021 July 2021 Sales (in ‘000’) 2000 1970 1900 2100 2200 2240 2000 2160 2180 2200 45% of cash sales are on cash basis. Of credit sales, 35% is collected in the month of sale, 40% one month after sale and 20% two months from sales Gross profit margin is 20%. Goods purchased in a given month are sold in the following month after the month of purchase. Payment of purchases is as follows, 60% is paid one month after purchase and the remainder two months after purchase. Required Compute Cash collected from sales in month of January and February 2021 Cash paid to suppliers of goods in the months of January and February 2021
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: es Total cash receipts Total cash disbursements 1st Quarter $ 250,000 $ 309,000 2nd Quarter $ 400,000 3rd Quarter $ 280,000 4th Quarter $ 300,000 $ 279,000 $ 269,000 $ 289,000 The company's beginning cash balance for the upcoming fiscal year will be $34,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for the upcoming fiscal year. (Repayments, interest, and cash deficiencies should be indicated by a minus sign.)
Vishnu
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts $ 521,000 410,500 480,000 Cash payments $ 467,800 357,300 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add: Cash receipts Total cash available KAYAK COMPANY Cash Budget January $ 30,000…
The following information was taken from Trusted Care Company's cash budget for the month of April: Beginning cash balance Cash receipts Cash disbursements If the company has a policy of maintaining an end of the month minimum cash balance of $25,000, the amount the company would have to borrow is $10,000 $13,000 $11,000 $0 $27,000 62,000 75,000
In preparation for the quarterly cash budget, the revenue and cost information have been compiled as follows: Month Sales (RM) Purchases (RM) August 2018 (actual) 3,000,000 3,500,000 September 2018 (actual) 4,500,000 2,000,000 October 2018 (forecast) 1,000,000 500,000 November 2018 (forecast) 1,500,000 750,000 December 2018 (forecast) 2,000,000 1,000,000 The firm collect 60 percent of sales for cash and 40 percent of its sales one month later. Interest income of RM50,000 on marketable securities will be received in December. The firm pays the purchases of 40 percent in cash and 60 percent in following month. Salaries and wages are RM450,000 in September, RM200,000 in October, RM150,000 in November and RM225,000 in December. Sales commissions are 2 percent of the preceding month's sales. Lease payments of RM150,000 must be made each month. A principal and interest payment on an outstanding loan is due in December of RM150,000. The firm pays dividends of RM50,000 at the…