Orange Company has sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on 1 May and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. • The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale • The firm receives other income of $2,000 per month • The firm's actual or expected purchases, all made for cash, are $50,000, $70,000, and $80,000 for the months of May through July, respectively • Rent is $3,000 per month • Wages and salaries are 10% of the previous month's sales • Cash dividends of $3,000 will be paid in June • Payment of principal and interest of $4,000 is due in June • A cash purchase of equipment costing $6,000 is scheduled in July • Taxes of $6,000 are due in June

Orange Company has sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on 1 May and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. • The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale • The firm receives other income of $2,000 per month • The firm's actual or expected purchases, all made for cash, are $50,000, $70,000, and $80,000 for the months of May through July, respectively • Rent is $3,000 per month • Wages and salaries are 10% of the previous month's sales • Cash dividends of $3,000 will be paid in June • Payment of principal and interest of $4,000 is due in June • A cash purchase of equipment costing $6,000 is scheduled in July • Taxes of $6,000 are due in June

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

Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects cash sales of $32,500 and $48,500, respectively. It also expects credit sales of $58,500 and $68,500, respectively. The company expects to collect 30% of its credit sales in the month of the sale, 65% in the following month, and 5% is deemed uncollectible. What amount of cash collections would appear in the company’s cash budget for the first month? Multiple Choice $50,050 $17,550 $66,050 $48,500
ABC Company's budgeted sales for June, July, and August are 14,200, 18,200, and 16,200 units respectively. The selling price for each unit is $15. Based on past experience, ABC expects that 40% of a month's sales will be collected in the month of sale, 55% in the following month, and 2% in the second month following the sale. Required: Prepare an analysis of cash receipts from sales for ABC Company for August. Budgeted sales units Unit selling price Budgeted sales revenue August collections: Current month's sales. Prior month's sales. Second prior month's sales. Total collections June July August
I Rooney Company, which expects to start operations on January 1, year 2, will sell digital cameras in shopping malls. Rooney has budgeted sales as indicated in the following table. The company expects a 15 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Rooney will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required Required B Complete the sales budget by filling in the missing amounts. (Do not round intermediate calculations. Round final answers to two decimal places.) March Sales Cash sales Sales on account Total budgeted sales January February $45,000 115,000 160,000
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
Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $241,000, $211,000, and $202,000, respectively. Cash collections of credit sales are expected to be 75% in the month of sale and 25% in the month following the sale. The cost of goods sold is always 65% of sales. Each month’s ending inventory equals 20% of next month’s cost of goods sold. 40% of each month’s merchandise purchases are paid in the current month and the remainder is paid in the following month. Monthly selling and administrative expenses that are paid in cash in the month incurred total $21,500. Monthly depreciation expense is $21,000. The expected cash collections from customers in December are:
Help with cash budget. Please explain and show the work so i can understand. Grenoble Enterprises had sales of $49,700 in March and $59,900 in April. Forecast sales for May, June, and July are $70,300,$79,500, and $99,600,respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800.Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 22% of sales for cash, 63% are collected in the next month, and the remaining 15% are collected in the second month following sale. (2) The firm receives other income of $1,600 per month. (3) The firm's actual or expected purchases, all made for cash, are $49,600, $70,200, and $79,500 for the months of May through July, respectively. (4) Rent is $2,700 per month. (5) Wages and salaries are 9% of the previous month's sales. (6) Cash dividends of $3,500 will be paid in June. (7) Payment of principal…
The budgeted sales of Kelley, SA for the given months are as follows: Cash Sales Credit Sales April $38,000 $256,000 May $54,000 $250,000 June $36,000 $192,000 July $33,000 $190,000 August $35,000 $287,000 To prepare a cash budget, the company needs to determine the expected cash collections each month, and has provided the following additional information: The Accounts Receivable balance on April 1 was $82,015. Of this amount, $57,015 represented uncollected March sales and $25,000 represented uncollected February sales. Collections on Credit sales: 65% in month of sale 30% in month following sale 5% in second month following sale Part 1: What should the April cash collected be? $BLANK Part 2: For August 1, what is budgeted Accounts Receivable? (76,100, 100,300, 109,950, 144950, OR 79,700)
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
Corporation has projected sales in units for the third quarter of the coming year as follows: July 60,000 August September 50,000 80,000 All units are sold on account for $18 each. Cash collections from sales are budgeted at 75% in the month of sale, and 25% in the month following the month of sale. June sales were $1,500,000 Required: 1. Prepare a schedule for the third quarter, showing budgeted cash receipts for Ehrlich Corporation. 2. What are budgeted accounts receivable?
A company is preparing its cash budget for the upcoming quarter. The company's sales are expected to be $500,000 in January, $600,000 in February, and $700,000 in March. The company's cost of goods sold is 60% of sales. The company's beginning cash balance is $50,000, and the company desires to maintain a minimum cash balance of $25,000. How much financing does the company need in February? $25,000 $60,000 $0 $35,000
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…