Patrick's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month January. February. Sales Revenue $250,000 350,000 Month March.... April All sales are on credit; 75% is collected during the month of sale, and 25% is collected during the next month. Cost of goods sold is 70% of sales. Payments for merchandise sold are made in the month fol- lowing the month of sale. Operating expenses total $125,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $55,000. Required Prepare monthly cash budgets for February, March, and April. Patrick's Retail Company Cash Budgets February, March, and April February March 55,000 $ 262,500 x 175,000 x 125,000 x 205,000 * $ Cash balance, beginning $ Total Cash receipts Cash available Total disbursements Cash balance, ending $ Sales Revenue $400,000 375,000 April 205,000 x $ 222,500 x 387,500✔ 381,250✔ 245,000 * 280,000 x 125,000 x 125,000 x 222,500 x 198,750 x $

Patrick's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month January. February. Sales Revenue $250,000 350,000 Month March.... April All sales are on credit; 75% is collected during the month of sale, and 25% is collected during the next month. Cost of goods sold is 70% of sales. Payments for merchandise sold are made in the month fol- lowing the month of sale. Operating expenses total $125,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $55,000. Required Prepare monthly cash budgets for February, March, and April. Patrick's Retail Company Cash Budgets February, March, and April February March 55,000 $ 262,500 x 175,000 x 125,000 x 205,000 * $ Cash balance, beginning $ Total Cash receipts Cash available Total disbursements Cash balance, ending $ Sales Revenue $400,000 375,000 April 205,000 x $ 222,500 x 387,500✔ 381,250✔ 245,000 * 280,000 x 125,000 x 125,000 x 222,500 x 198,750 x $

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

ABC Store. has budgeted sales for June and July at $690,000 and $720,000, respectively. Sales are 90% credit, of which 70% is collected in the month of sale and 30% is collected in the following month. What are the cash collections in July.
Vaibhav
Dhapa
Hunt Company's sales, based on past experience, are 30% cash and 70% credit. Credit sales are typically collected as follows: 40% in the month of sale, 50% in the month after the sale, and 10% in the second month following month of sale. On December 31, the accounts receivable balance is $69,000, of which $24,000 is from November sales. Total sales for January and February are budgeted to be $110,000 and $130,000, respectively. What are Hunt Company's budgeted cash receipts for January? Multiple Choice $79,500. $92,500. $95,800. $112,500. $125,300.
Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: April May June Total Budgeted sales (all on account) $300,000 $500,000 $200,000 $1,000,000 The company estimates 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230, 000, and March sales totaled $260,000. Required: Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. What is the accounts receivable balance on June 30th?
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November $89,000 $109,000 $146,000 37,000 47,000 31,000 33,000 Sales Manufacturing costs Selling and administrative expenses Capital expenditures The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of $34,000, marketable…
Spacely Sprockets' sales budget shows the following expected total sales: Month January February March April Sales $31,700 $41,700 $36,700 $31,700 The company expects 80% of its sales to be on account (credit sales). Credit sales are collected as follows: 30% In the month of sale and 68% In the month following the sale, with the remainder being uncollectible and written off in the month following the sale. Required: a. Calculate budgeted accounts receivable at the end of each month from February through April. b. Calculate budgeted cash Inflows from collection of receivables for each month from February through April. Note: Round your Intermediate calculations and final answers to the nearest whole dollar amount. a. Budgeted accounts receivable Answer is not complete. b. Budgeted cash inflows from collection of receivables February March April S 17,752 S 23,352 $ 20,552
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income First Quarter Second Quarter Third Quarter Fourth Quarter $ 174,000 $ 264,000 87,000 132,000 87,000 132,000 $ 214,000 107,000 107,000 21,400 17,400 26,400 $ 69,600 $ 85,600 $ 105,600 Historically, cost of goods sold is about 50 percent of sales revenue. Selling and administrative expenses are about 10 percent of sales revenue. Fred Arvada, the chief executive officer, told Mr. Long that he expected sales next year to be 10 percent for each respective quarter above last year's level. However, Rita Banks, the vice president of sales, told Mr. Long that she believed sales growth would be only 5 percent. Required a. Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. b. Prepare…