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

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
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…
Lexi Company budgets unit sales of 1,510,000 in April, 1,210,000 in May, 320,000 in June, and 1,940,000 in July. Beginning inventory on April 1 is 604,000 units, and the company wants to have 40% of next month's unit sales in inventory at the end of each month. The merchandise cost per unit is $0.50. Prepare a merchandise purchases budget for the months of April, May, and June. LEXI COMPANY Merchandise Purchases Budget April May June Next period budgeted sales units Ratio of inventory to future sales Total required units Units to purchase Cost per unit Cost of merchandise purchases $ $ $
Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: Budgeted sales (all on account) April $300,000 May $500,000 June $200,000 Total $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: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. Schedule of Expected Cash Collections February sales March sales April sales May sales June…