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 P2,400,000 P1,850,000 D) P1,300,000

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 P2,400,000 P1,850,000 D) P1,300,000

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

Owe
Evergreen Furniture, a retailing company, is preparing the cash budget for August. The following inventory information available: Estimated payments in August for purchases in August Estimated purchases for August Estimated cost of goods sold for August Estimated payments in August for purchases in July Estimated payments in August for purchases prior to July Inventories at beginning of August Required: What are the estimated cash disbursements in August? Estimated cash disbursements 70% $ 2,444,000 2,600,000 696,000 176,000 674,000
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
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 budgeted units for sales in January, February and March are 25,000, 55,000 and 35,000 andselling price is $ 12, 15 and 20 per unit respectively. Please determine the total budgeted sales in unitsand dollars for the quarter ended March 31, 2021.
The following data are submitted relative to Pentagon Holdings Corp. and itssubsidiary, Slogan Generators Co., whose stocks it acquired on January 1, 2008. Pentagon SloganHoldings Co. Generators Co.Par value of stock outstanding P500,000 P 75,000Portion of stock owned by Pentagon 90%Retained Earnings, January 1, 2008 180,000 45,000Cost to Pentagon of stock acquired 110,000Net income from own operationsduring 2008 45,000 5,000Dividends paid during 2008 30,000 4,500The Pentagon Holdings Corp. has adopted the equity method of accounting for investment.Any excess is attributable to an asset with a 10 years life.1. The Consolidated Retained Earnings of Pentagon and Slogan as of December 31, 2008would bea. P195,000 c. P199,500b. P199,050 d. P199,300
Evergreen Furniture, a retailing company, is preparing the cash budget for August. The following inventory information is available: Estimated payments in August for purchases in August Estimated purchases for August Estimated cost of goods sold for August Estimated payments in August for purchases in July Estimated payments in August for purchases prior to July Inventories at beginning of August Required: What are the estimated cash disbursements in August? Estimated cash disbursements 70% $ 2,428,000 2,560,000 672,000 160,000 658,000
In May 2022, the budget committee of Blue Spruce, Inc. assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. Expected sales: June $725,000, July $970,000. 2. Cost of goods sold is expected to be 80% of sales. 3. Desired ending merchandise inventory is 30% of the following month's cost of goods sold. 4. The beginning inventory at June 1 will be the desired amount. (a) Compute the budgeted merchandise purchases for June. BLUE SPRUCE, INC. Merchandise Purchases Budget $
Mitchell Company had the following budgeted sales for the first half of next year: The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Assume that the accounts recelvable balance on January 1 was $76,000. Of this amount, $60,000 represented uncollected December sales and $16,000 represented uncollected November sales. Glven these data, the total cash collected during January would be: Multiple Choice $138.000 $100,000 $196,000 $197,000
Use the following information to prepare the September cash budget for PTO Company. Ignore the "Loan activity" section of the budget. a. Beginning cash balance, September 1, $44,000. b. Budgeted cash receipts from September sales, $261,000. c. Direct materials are purchased on credit. Purchase amounts are August (actual), $78,000; and September (budgeted), $106,000. Payments for direct materials follow: 65% in the month of purchase and 35% in the first month after purchase. d. Budgeted cash payments for direct labor in September, $34,000. e. Budgeted depreciation expense for September, $3,300. f. Budgeted cash payment for dividends in September, $54,000. g. Budgeted cash payment for income taxes in September, $10,200. h. Budgeted cash payment for loan interest in September, $1,200. PTO COMPANY Cash Budget September Beginning cash balance Total cash available 0 Total cash payments 0 Ending cash balance $ 0
ONLY ANSWER QUESTION (B) 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…