Cash Receipts for September = PHP 305,450; October = PHP 85,405; and November =PHP 375,195. Cash Disbursements for September = PHP 215,485; October = PHP 250,265; and November = PHP 310,525. Beginning Cash Balance (September) = PHP 35,975. Minimum Monthly Cash Balance Needed =PHP 34,425. The ending cash for September is PHP_ O 160,365 O 125,940 O 89,965 91,515

Cash Receipts for September = PHP 305,450; October = PHP 85,405; and November =PHP 375,195. Cash Disbursements for September = PHP 215,485; October = PHP 250,265; and November = PHP 310,525. Beginning Cash Balance (September) = PHP 35,975. Minimum Monthly Cash Balance Needed =PHP 34,425. The ending cash for September is PHP_ O 160,365 O 125,940 O 89,965 91,515

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

See similar textbooks

Similar questions

Harrah Company provided the following information for the month of October: Beginning cash balance $ 35,000 Cash receipts 460,000 Cash disbursements 485,000 Harrah's policy is to keep a minimum end of the month cash balance of $30,000. How much will Harrah's need to borrow during October?
f) The Cathy Specialist Corporation approached you to compile a cash disbursement schedule for the month of March, April and May. Use the following information. Sales: January-RMS20,000; February-RM540,000; March-RM550,000; April=RM600,000; May-RM660,000; June-RM670,000. Purchases: Purchases are calculated as 70% of the following month's sales, 50% of purchase are made in cash, 30% of purchases are settled one month after purchase, and the remaining 20% of purchase are settled two months after purchase. c) d) e) g) h) the firm's expected cash receipts for a) b) Rent: The firm pays rent of RM9,500 per month. Wages & salaries: the fixed wage and salary costs are RM7,500 per month plus a variable cost of 6.5% of the current month's sales. Taxes: the tax bill to be paid in May amount to RM57,500. Fixed asset outlay: new equipment will be acquired during March at a cost of RM85,000. Interest payment: an amount of RM32,000 for interest is due in March. Cash Dividend: Dividends of RM15,000…
Fernando Company developed the following data for the month of August:1. August 1 cash balance P123,000.2. Cash sales in August P800,000.3. Credit sales for August are P300,000; for July P400,000; and for June P400,000. 70% of credit sales are collected in the month of sale, 15% in thefollowing month, and 10% in the second month following the sale. 4. Purchases for July were P500,000 and for August are P400,000. One-fourth of purchases are paid in the month of purchase and the remaining three-quarters in the following month. 5. August salaries are P314,000, utilities are P32,200, and depreciation on the building and equipment is P100,000. Required:1. Anticipated cash receipts from accounts receivable in August.
what is the cash receipts for July if the cash balance is 26,590 and the totaled cash payment is 224,240 and the ending balance is 39,650
Fernando Company developed the following data for the month of August:1. August 1 cash balance P123,000.2. Cash sales in August P800,000.3. Credit sales for August are P300,000; for July P400,000; and for June P400,000. 70% of credit sales are collected in the month of sale, 15% in thefollowing month, and 10% in the second month following the sale. 4. Purchases for July were P500,000 and for August are P400,000. One-fourth of purchases are paid in the month of purchase and the remaining three-quarters in the following month. 5. August salaries are P314,000, utilities are P32,200, and depreciation on the building and equipment is P100,000. Required:2. Anticipated total cash available from all sources in August.3. August cash payments for purchases made in July and August.
Fernando Company developed the following data for the month of August:1. August 1 cash balance P123,000.2. Cash sales in August P800,000.3. Credit sales for August are P300,000; for July P400,000; and for June P400,000. 70% of credit sales are collected in the month of sale, 15% in thefollowing month, and 10% in the second month following the sale. 4. Purchases for July were P500,000 and for August are P400,000. One-fourth of purchases are paid in the month of purchase and the remaining three-quarters in the following month. 5. August salaries are P314,000, utilities are P32,200, and depreciation on the building and equipment is P100,000. Required:4. Anticipated cash balance on August 31.
1. An invoice dated June 27 for P20, 850 carried a cash discount of 5/30. If this invoice is paid on July 25, how much should be the payment?
Garden Gate, Inc. reported the following data in its August 31 annual report. Cash and cash equivalents $ 485,625 Cash flow from operations (630,000) Required: a. What is the company's "cash burn" per month? per month b. What is the company's ratio of cash to monthly cash expenses? Round your answer to one decimal place. months
4C. Draw up a cashbudget for Amal showing the balance at the end of each month, from the following information for the six months from July to December 2019: (a) Opening cash (including bank) balance on 1 July 2019 OMR 3600 (b) Production in units: Jan 500 Feb800 March 700 April 900 May1000 June850 July890 Aug1050 Sep650 Oct750 Nov 900 Dec800 (c) Raw materials used in production cost OMR 25 per unit. Of this, 75 per cent is paid in the month of production and remaining balance in the month after production. (d) Direct labour costs of OMR 20 per unit are payable in the month of production. (e) Variable expenses are OMR 10 per unit, payable 50 per cent in the same month as production and remaining balance in the month after production. (f) Sales at OMR 70 per unit: Jan 450 Feb 600 March 900 April 800 May 850 June 700 July 1,000 Aug 800 Sep 900 Oct 500 Nov 600 Dec 750 Debtors to pay their accounts one month after that in which sales is made (g) Fixed expenses of OMR 1,200 per month…
Help me please
Accounting has supplied the following information from our ERP system:Data: Sales over last 30 days 5 $1,020,000Accounts receivable at the end of the month 5 $200,000Inventory value at the end of the month 5 $400,000Cost of sales 5 60 percent of total salesAccounts payable at the end of the month 5 $160,000Calculate our current cash-to-cash cycle time.
Actual and projected sales of an entity for September and October are as follows September (actual) Cash sales= 20000 Credit sales= 50000 October (projected) Cash sales =30000 Credit sales =55000 All credit sales are collected in the month following the month in which the sales is made the September 30 cash balance is 23000 cash disbursement in October are projected to be 94000to maintain a minimum cash balance of 15000 on October 31 the entity will need to borrow A. 0 B. 6000 C. 11000 D. 16000