Please prepare a
-Estimated cash balance at the end of March was $ 200,000
-April’s
-Taxes which will be paid in June are $175,000
-April’s payroll will be $90,000
-April had insurance expense in April of $40,000 while insurance costs for the entire year were prepaid in January.
-April’s operating expense are $75,000
-Collections of sales are as follows: 50% in the month of the sale, 30% in the following month, and 20% in the next month.
-Receivables balance as of the end of March is $400,000 ( $300,000 relating to March, $100,000 relating to February ).
-Sales for the month of April are
-Merchandise purchases are paid as follows: 50% in the month of the purchase, 25% in the next month, and 25% one month later.
-Purchases for March and February were $300,000 and $250,000 respectively and April’s purchases are estimated to be $200,000
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 2 images
- Develop a cash budget for the next three months using the information provided below. Monthly sales forecasts are $150,000, $180,000, and $60,000 (June, July, August) The current month's sales are $120,000 (May) Cost of goods sold equals 65% of sales Lease payment= 22,000 per month The company is required to pay an installment of $120,000 for a note (debt) The cash position at the end of the current month is $80,000 The target cash balance is $50,000 Assume that 60% of sales are collected in the month sold and the remaining collected in the following month.arrow_forwardCrane Company expects to have a cash balance of $36,000 on January 1,2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $68,000, February $120,000.Payments for direct materials: January $40,000, February $60,000.Direct labor: January $24,000, February $36,000. Wages are paid in the month they are incurred.Manufacturing overhead: January $16,800, February $20,000. These costs include depreciation of $1,200 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $12,000, February $16,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $9,600 in cash. Crane Company has a line of credit at a local bank that enables it to borrow up to $20,000. The company wants to maintain a minimum monthly cash balance of $16,000. Prepare a cash budget for January and February. ReceiptsCollections from…arrow_forwardCheddar's Café is preparing its cash budget for August. At the beginning of the month, the café expects to have $17,500 in total available cash. Over the course of the month, it expects to make $12,250 in cash disbursements and obtain $3,750 in financing. What is Cheddar's anticipated ending cash balance for August? O $9,000 O $5,250 O $26,000 O $1,500arrow_forward
- Wala Incorporated bases its selling and administrative expense budget on the number of units sold. The variable selling and administrative expense is $3.70 per unit. The budgeted fixed selling and administrative expense is $30,360 per month, which includes depreciation of $3,630. The remainder of the fixed selling and administrative expense represents current cash flows. The sales budget shows 3,100 units are planned to be sold in July. Required: Prepare the selling and administrative expense budget for July.arrow_forwardTomo, Inc. has prepared its third quarter budget and provided the following data: Jul $49,000 Aug $39,800 Sep $47,900 Cash collections Cash payments: Purchases of direct materials Operating expenses Capital expenditures 17,900 11,100 0 The cash balance on June 30 is projected to be $4,600. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 5%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash. Calculate the final projected cash balance at the end of August taking into consideration all the financing transactions. 31,000 12,100 13,700 O A. $46600 OB. $-8842 OC. $15000 O D. $6158 21,800 8,700 24,900arrow_forwardThe treasurer of U Co. has accumulated the budget information presented in the table for the months of March and April pertaining to cash payments. Forty percent of the merchandise costs are expected to be paid in the month they are incurred and the remaining sixty percent in the following month. All of the operating expenses are paid for by cash in the month they are incurred. The accounts payable balance on March 1 is $60,000. What is the amount to include in the Cash Budget for the month of April for the Merchandise Costs (which does include the balance from March + Cost for April)? MARCH APRIL Merchandise costs $120,000 $132,000 Operating expenses 100,000 110,000arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education