Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted: Sales ....... Merchandise purchases Operating expenses: Payroll. Advertising Rent.... Depreciation. End of April balances: Cash.... Bank loan payable April May $150,000 $157,500 107,000 112,400 13,600 5,400 2,500 7,500 30,000 26,000 14,280 5,700 2,500 7,500 Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50% in the month following the sale and 50% in the month thereafter. Total sales in March were $125,000. (2) Purchases are all on credit, with 40% paid in the month of purchase and 60% paid in the following month. (3) Operating expenses are paid in the month they are incurred. (4) A minimum cash balance of $25,000 is required at the end of each month. (5) Loans are used to maintain the minimum cash balance. At the end of each month, interest of 1% per month is paid on the outstanding loan balance as of the beginning of the month. Repayments are made at the end of the month if the cash balance exceeds $25,000. Prepare the company's cash budget for May. Show the ending loan balance at May 31.

Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted: Sales ....... Merchandise purchases Operating expenses: Payroll. Advertising Rent.... Depreciation. End of April balances: Cash.... Bank loan payable April May $150,000 $157,500 107,000 112,400 13,600 5,400 2,500 7,500 30,000 26,000 14,280 5,700 2,500 7,500 Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50% in the month following the sale and 50% in the month thereafter. Total sales in March were $125,000. (2) Purchases are all on credit, with 40% paid in the month of purchase and 60% paid in the following month. (3) Operating expenses are paid in the month they are incurred. (4) A minimum cash balance of $25,000 is required at the end of each month. (5) Loans are used to maintain the minimum cash balance. At the end of each month, interest of 1% per month is paid on the outstanding loan balance as of the beginning of the month. Repayments are made at the end of the month if the cash balance exceeds $25,000. Prepare the company's cash budget for May. Show the ending loan balance at May 31.

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

Help please..
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
Surity Corporation is preparing its cash payments budget for next month. The following information pertains to the cash payments: 1 Click the icon to view the data.) How much cash will be paid out next month? Surity Corporation Cash Payments Budget Cash payments for direct materials: 45% of last month's purchases 55% of next month's purchases Cash payments for direct labor Cash payments for manufacturing overhead Cash payments for operating expenses Cash payment for taxes Total cash payments
Here are some important figures from the budget of Nashville Nougats, Inc., for the second quarter of 2018: Credit sales Credit purchases Cash disbursements Wages, taxes, and April May June $322,000 $302,000 $362,000 130,000 153,000 178,000 44,200 11,700 63,200 expenses Interest Equipment purchases 11,200 11,200 82,000 154,000 11,200 The company predicts that 5 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 55 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2018, credit sales were $192,000 and credit purchases were $132,000. Using this information, complete the following cash budget: (Do not round intermediate calculations. Leave no cells blank - be certain to enter "O" wherever required.) Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements Purchases Wages,…
Garden Depot is a retailer that provided the following budgeted cash flows for next year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $ 180,000 $330,000 $210,000 $230,000 Total cash disbursements $ 260,000 $230,000 $220,000 $240,000 The company's beginning cash balance for next year will be $20,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not compounded. Required: Prepare the company's cash budget for next year.
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of the year. (Receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1.) January February March Cash receipts. $260,000 $280,000 $250,000 Cash disbursements 240,000 320,000 260,000 The expected cash balance at January 1 is $42,000. Brewster wants to maintain a cash balance at the end of each month of at least $40,000. Short-term borrowings at 1% interest per month will be used to accomplish this, if necessary. Borrowings (in multiples of $1,000) will be made at the beginning of the month in which they are needed, with interest for that month paid at the end of the month. Prepare a cash budget for the quarter ended March 31. Brewster Corporation Cash Budget for the Quarter Ended March 31 January February Beginning cash balance Cash receipts $ Short-term borrowings Cash available Cash disbursements Interest…
Determine the anticipated total cash receipts for the month of January for Madison Co. in preparing a Cash Budget, given the following info: Accounts Receivable balance as of January 1 $296,000.00 Budgeted Sales for January = $860,000.00 Madison Co. assumes all monthly sales are on account. And that 75% of the sales on account will be collected in the month of the sale, and that the remainder will be collected the following month. $688,000.00 $812,000.00 $941,000.00 O $468,000.00
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $42,000 and $74,000, respectively. The company expects to collect 35% of its credit sales in the month of the sale and the remaining 65% in the following month. What amount of cash collections from credit sales would the company include in its cash budget for the second month?
I need the working solution for the cash balance at the beginning month. Cash Budget 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 Sales $130,000 $156,000 $205,000 Manufacturing costs 55,000 67,000 74,000 Selling and administrative expenses 46,000 47,000 78,000 Capital expenditures _ _ 49,000 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 $10,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…
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January February March $ 519,000 409,000 476,000 $ 459,200 349,200 532,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add: Cash receipts Total cash available Less: Cash payments for Interest on loan…
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects credit sales of $40,000 and $77,000, respectively. The company expects to collect 30% of its credit sales in the month of the sale and the remaining 70% in the following month. What is the expected cash collections from credit sales during the first month?
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,760,000 Quarter 2 5,620,000 Quarter 3 3,060,000 Quarter 4 7,720,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,310,000 and for the fourth quarter of the current year are $7,350,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year 4, current year 1, next year 2, next year 3. next vear 4, next year 2. Construct a cash receipts budget for…