QUESTION 2In the late June of each year, BOS Global Ltd prepares a cash budget for the next 6 months. The entity's managementwishes to prepare a cash budget in order to assess its likely requirements for short-term funds.Actual sales for May, and estimated sales for June, and for the next 7 months are as follows:Months Sales Revenues (Actual and Estimates) [GHS]MonthsSales Revenues (Actual and Estimates) [GHS]20,00028,000July 24,000August 26,000September 50,000October 94,000November74,000December52,000January40,000Approximately 25 per cent of sales are for cash and 75 per cent are on credit. Past experience has shown that two-third ofall credit sales are collected in the month immediately following the month of sale, and the remaining one-third iscollected in the second month following the sales. No discount is given.MayJuneBOS Global Ltd follows a policy of basing its purchase on estimated sales. Purchases are 70 per cent of the followingmonth's estimated sales. The policy of the company is to ensure that the goods needed in each month are acquired andpaid for in that same month. Other cash outflows in connection with monthly salaries are expected to be:MonthsMonthly Salaries (Estimates) [GHS]MonthsMonthly Salaries (Estimates) [GHS]7,40011,000OctoberJulyAugust7,450September 9,100December 7,150At the beginning of July, the company is expected to have GHS 8,400 credit balance in its bank account.Required:Prepare a monthly cash budget for BOS Global Ltd for the six (6) months period, ending December.November 7,800

Details needed to draft the budget: > Sales are realised as - 25% in the month of sale - 50% in…

Answered: Required: Prepare a monthly cash budget…

Business

Accounting

Required: Prepare a monthly cash budget for BOS Global Ltd for the six (6) months period, ending December.

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

Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the company's costs: Fixed Cost Cost per per Month Car Washed Cleaning supplies Electricity Maintenance $ 0.80 $ 0.09 $ 0.20 $ 0.40 $ 1,400 $ 4,700 $ 8,000 $ 1,900 $ 1,600 Wages and salaries Depreciation Rent Administrative expenses $ 0.03 For example, electricity costs should be $1,400 per month plus $0.09 per car washed. The company expects to wash 8,000 carg in August and to collect an average of $6.30 per car washed. Required: Prepare the company's planning budget for August. Lavage Rapide Planning Budget
ABC company Bhd provides the following infor mation in respect of its 3 month cash budget for the year 2019 as showr in the table bel ow. • ABC company Bhd currently has a cash balance of RM40,000 and intends to maintain a minimum cash balance of RM20,000 each month The company can barrow at the beginring of the month in which the funds are needed to maintain the minimun cash balance and the interest an loan is 24% per year. The interest an out standing loan is paid in the month that follows the month in which the loan is dot ained. You are requir ed to complete the 3-month (Oct ober, Novenber, and Decenber) cash budget table for ABC company. Note: Provide answers ONLY far cdaured baxes A to N Month Oct ober November December 1 Beginning cash balance RM40,000 E J Net Change in cash for the period (RM40,200) RV8,604 RM12,240 3 New financing needed A F K 4 Interest an loan В G L 5 Loan repayment H M 6 Ending cash balance 7 Minimumcash balance (RM20,000) (RM20,000) (RV20,000) 2.
An entity is budgeting its cash payments for the last quarter of 2020. All purchases are made on account with 2% discount for early payments. The October purchases is set at P150,000, and purchases increase by 20% based on the previous month. 50% of purchases are paid on the month of purchase, availing of the purchase discount; 45% are paid the next month; and 5% are paid after 2 months from date of purchase. How much is the total cash payment to be made in December 2020?
You are preparing a cash budget for the month of September. how would you use information about sales in the preceding July?
Mecca 4 Company, a retailer of specialty wall-papers, prepares a monthly master budget. Data for the September master budget are given below: a. The August 31st balance sheet (Actual): cash accounts receivable inventory building and equipment (net) $25,000 133,000 32,813 203,500 e. accounts payable August-Actual September-Projected October-Projected November-Projected capital stock retained earnings b. Actual sales for August and budgeted sales for September, October, and November are given below: $62,016 $190,000 375,000 405,000 310,000 295,372 36,925 C. Sales are 30% for cash and 70% on credit. All credit sales are collected in the month following the sale. There are no bad debts. d. The gross margin percentage is 65% of sales. The desired ending inventory is equal to 25% of the following month's COGS. One fourth of the purchases are paid for in the month of the purchase and the remaining 75% are purchased on account and paid in full the following month. The monthly operating…
Carmen Company sells jar candles. The sales forecast (units) for the coming months is: April May June July August 230 250 220 170 230 Each candle costs $12. The ending inventory policy is 40% of next month's sales needs. April 1 inventory will be as expected under the policy. Carmen pays for purchases 30% in the month of purchase and 70% the following month. Accounts payable on April 1 is $3,150. a. Prepare a purchases budget for the quarter ending June 30. Note: Deductible values must be indicated with a minus sign. Budgeted unit sales) Plus: Ending inventory Less: Beginning inventory Budgeted purchases (units) Cost of merchandise (per unit) Total cost of merchandise purchases Merchandise Purchases Budget (Candles) For the Quarter Ending June 30 April May b. Prepare a cash payments budget for the quarter ending June 30. June Total
Vaughn Manufacturing expects to purchase $280000 of materials in July and $308000 of materials in August. Three-fourths of all purchases are paid for in the month of purchase, and the other one-fourth are paid for in the month following the month of purchase. What are budgeted cash disbursements for materials purchases in August? O $308000 O $231000 O $210000 O $301000
On a separate sheet of paper, prepare a cash budget for the first four months of 2006, showing the amount of cumulative excess cash (loan balance). Basic company has planned a cash budget for the first four months. Estimates show that P60,000 should be collected in January and April for the dividends to be received from investments in stock of other companies. Each month, operating expenses for wages, rents, lights and others estimated to be P100,000 plus 10% of the preceding month sales. Sales and collections on accounts receivables are estimated as follows: 50% collected in the month of sale 30% collected in the month following the sale2 0% collected in the second month following the sale Payments for the merchandise purchased are scheduled so that 60% of the payments are made in the month of purchase with the balance paid the following month. The cash balance is estimated at P175,000 for January 1, 2006. Estimated net sales and purchases for the months are as follows:…
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. Cash Receipts Cash payments January $ 524,000 $ 465,300 February 412,500 353,800 March 475,000 526,000 Kayak requires a minimum cash balance of $40,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 $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March.
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…
Prepare a budgeted income statement for July. Please present your solution in a good form and income statement in good form.
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…