In preparation for the quarterly cash budget, the following information have been compiled. Month Sales Purchases August (actual) P3,000,000.00 P3.500,000.00 September (actual) P4,500,000.00 P2,000,000.00 October (forecast) P1,000,000.00 P500,000.00 November (forecast) P1,500,000.00 P750,000.00 December (forecast) P2,000,000.00 P1,000,000.00 (a) Total cash receipt for the month of December is P1,850,000. (b) The firm pays cash for 40 percent of its purchases. (C) The firm pays for 60 percent of its purchases the following month. (d) Salaries and wages amount to 15 percent of the preceding month's sales. (e) Sales commissions amount to 2 percent of the preceding month's sales. (f) Rental payments of P100,000 must be made each month. (g) A principal and interest payment on an outstanding loan is due in December of P150,000. (h) The firm pays dividends of P50,000 at the end of the quarter. () Fixed assets costing P600,000 will be purchased in December. ) Depreciation expense each month of P45,000. How much is the net cash flows in December? A P390,000 B (P155,000) (c) (P430,000) D P135,000

In preparation for the quarterly cash budget, the following information have been compiled. Month Sales Purchases August (actual) P3,000,000.00 P3.500,000.00 September (actual) P4,500,000.00 P2,000,000.00 October (forecast) P1,000,000.00 P500,000.00 November (forecast) P1,500,000.00 P750,000.00 December (forecast) P2,000,000.00 P1,000,000.00 (a) Total cash receipt for the month of December is P1,850,000. (b) The firm pays cash for 40 percent of its purchases. (C) The firm pays for 60 percent of its purchases the following month. (d) Salaries and wages amount to 15 percent of the preceding month's sales. (e) Sales commissions amount to 2 percent of the preceding month's sales. (f) Rental payments of P100,000 must be made each month. (g) A principal and interest payment on an outstanding loan is due in December of P150,000. (h) The firm pays dividends of P50,000 at the end of the quarter. () Fixed assets costing P600,000 will be purchased in December. ) Depreciation expense each month of P45,000. How much is the net cash flows in December? A P390,000 B (P155,000) (c) (P430,000) D P135,000

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter13: Budgeting And Standard Costs

Section: Chapter Questions

Problem 14CDQ

See similar textbooks

Similar questions

A. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?
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…
Use the information provided below to prepare the Cash Budget for October, November, and December2021. Provide separate monetary columns for each month.INFORMATION1. The following data and estimates are available for a project of Fego Limited for September toDecember 2021:September October November DecemberR R R RSales 130 000 110 000 120 000 140 000Wages 40 000 34 000 38 000 39 000Fixed overheads 16 000 16 000 16 000 16 000Variable overheads 16 000 13 000 15 000 17 000Materials purchases 17 000 14 000 16 000 18 0002. Sixty percent (60%) of the sales are expected to be for cash and the balance on credit. Creditcustomers usually pay in the month after the sale.3. Labour costs are paid for in the month in which they are incurred.4. Fixed overheads include R5 000 each month for depreciation and payment is made monthly.5. Variable overheads are paid for in the month after they are incurred.6. Direct materials are purchased by electronic funds transfers each month.7. The cash balance on 01…
In preparation for the quarterly cash budget, the following revenue and cost information have been compiled. Prepare and evaluate a cash budget for the months of October, November, and December based on the given information: Month Sales Purchases August (actual) P3,000,000.00 P3,500,000.00 September (actual) P4,500,000.00 P2,000,000.00 October (forecast) P1,000,000.00 P500,000.00 November (forecast) P1,500,000.00 P750,000.00 December (forecast) P2,000,000.00 P1,000,000.00 (a) The firm collects 60 percent of sales for cash and 40 percent of its sales one month later. (b) Interest income of P50,000 on marketable securities will be received in December. How much is the total cash receipts in November? A P3,900,000 B) P2,400,000 c) P1,850,000 D) P1,300,000
The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is available:Actual BudgetedAugust RSeptember ROctober RNovember RDecember RSales:CashCredit194 500287 300235 700350 000275 000410 000250 500400 400368 000697 000Purchases 510 000 490 000 495 000 520 000 680 000Salaries & Wages 72 600 72 600 72 600 72 600 72 600Sundry Expenses 17 800 18 400 22 000 22 600 25 700 Required:Prepare a Cash Budget for the period 1 November and 31 December 2018
The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is available:Actual BudgetedAugust RSeptember ROctober RNovember RDecember RSales:CashCredit194 500287 300235 700350 000275 000410 000250 500400 400368 000697 000Purchases 510 000 490 000 495 000 520 000 680 000Salaries & Wages 72 600 72 600 72 600 72 600 72 600Sundry Expenses 17 800 18 400 22 000 22 600 25 700Additional information:1. Cash in respect of credit sales is collected as follows: 50% within 30 days 30% within 60 days 15% within 90 days The balance is written off as irrecoverable. BAD DEBT - IGNORE2. The following discounts are allowed on sales: 10% on cash sales 7.5% on credit sales if accounts are settled within 30 days.3. All salaries, wages and sundry expenses are paid in cash.4. Sundry expenses include depreciation of R4 200 per month. Exclude depreciation5. Seventy-five (75%) of all purchases are on credit and paid within 30 days. The balance is paid…
Budgeted cash payments. Would I begin with Cost of Direct materiasl purchase of April-3,010, May-3,650,June-4,015, 2nd Quarter -10,675?
A. Prepare Cash Budget for the period of 6 months from July to December 2020. B. Explain the advantages and disadvantages of cash budgeting.
the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade receivables (accounts receivable)…
Using a separate columnar worksheet or Excel worksheet, prepare a Cash Budget by month for the quarter ending September 30, 2021, from the following data obtained from the CONSCIOÜNESS Company. Support your solution with schedules of estimated receipts and payments. August P 16,000 150,000 July September Cash Sales P 12,000 P 18,000 Credit Sales Purchases 110,000 120,000 90,000 120,000 110,000 Operating expenses Interest expense 15,000 18,000 16,000 2,000 Credit sales are collected 50% in the month of sales, 40% on the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000, respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase and 40% in the month following. Purchases for June are estimated at P80,000. Expenses include depreciation of P2,000 monthly, and are paid in the month incurred. Cash balance on June 30, 2021.
Required to prepare Cash budget for first three months of 2020, cash inflows with supporting computations, cash outflow with supporting computation, cash budget total with supporting computation.
The following information pertains to Yoyo Projects for the three months ended 31 May 2020: Actual Budgeted March R April R May R Revenue (20% for cash and 80% on credit) 360 000 380 000 400 000 Purchases (10% for cash 90% on credit) 240 000 280 000 320 000 Salaries and wages paid 40 000 60 000 60 000 Cash expenses 24 000 28 000 32 000 Depreciation 2 000 2 000 2 000 Additional Information: It is expected that debtors will settle their accounts as follows: 20 % in the month of invoice 70% in the month after the month of invoice, and 5% in the second month after the month of invoice The remaining 5% is usually written off as bad Trade creditors are paid in the month after purchase at a discount of 5%. 50% of the salaries and wages are weekly wages. Since wages are paid weekly, usually 10% of the wages are paid in the month following the month in which they were Expenses are paid as they The favourable…