Cash budget-Basic Grenoble Enterprises had sales of $49,600 in March and $60,300 in April. Forecast sales for May, June, and July are $69,900, $79,600, and $99,500, respectively. The firm has a cash balance of $5,500 on May 1 and wishes to maintain a minimum cash balance of $5,500. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 18% of sales for cash, 60% are collected in the next month, and the remaining 22% are collected in the second month following sale. (2) The firm receives other income of $1,700 per month. (3) The firm's actual or expected purchases, all made for cash, are $49,700, $70,200, and $80,400 for the months of May through July, respectively. (4) Rent is $2,500 per month. (5) Wages and salaries are 8% of the previous month's sales. (6) Cash dividends of $2,800 will be paid in June. (7) Payment of principal and interest of $4,300 is due in June. (8) A cash purchase of equipment costing $6,000 is scheduled in July. (9) Taxes of $5,600 are due in June.

Cash budget-Basic Grenoble Enterprises had sales of $49,600 in March and $60,300 in April. Forecast sales for May, June, and July are $69,900, $79,600, and $99,500, respectively. The firm has a cash balance of $5,500 on May 1 and wishes to maintain a minimum cash balance of $5,500. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 18% of sales for cash, 60% are collected in the next month, and the remaining 22% are collected in the second month following sale. (2) The firm receives other income of $1,700 per month. (3) The firm's actual or expected purchases, all made for cash, are $49,700, $70,200, and $80,400 for the months of May through July, respectively. (4) Rent is $2,500 per month. (5) Wages and salaries are 8% of the previous month's sales. (6) Cash dividends of $2,800 will be paid in June. (7) Payment of principal and interest of $4,300 is due in June. (8) A cash purchase of equipment costing $6,000 is scheduled in July. (9) Taxes of $5,600 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 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?
Kingston budgets total sales for June and July of $430,000 and $338,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 25% are collected in the month of sale, 65% are collected during the first month after the sale, and the remaining 10% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company’s budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. As of July 31 Sales month Total Sales Credit Sales Percent Uncollected Amount Uncollected June $430,000 July 338,000 Total
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?
Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $248,000, $218,000, and $209,000, respectively. • Cash collections related to credit sales are expected to be 70% in the month of sale, 30% in the month following the sale. • The cost of goods sold is 70% of sales. • Each month's ending inventory equals 20% of next month's cost of goods sold. • 30% 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 $25,000. • Monthly depreciation expense is $9.000. . The budgeted net operating income for December would be: Multiple Choice $40,400 $25,734 $16,734 $31,400
Cash budget-Basic Grenoble Enterprises had sales of $50,100 in March and $59,800 in April. Forecast sales for May, June, and July are $70,400, $79,700, and $99,800, 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 23% of sales for cash, 64% are collected in the next month, and the remaining 13% are collected in the second month following sale. (2) The firm receives other income of $2,100 per month. (3) The firm's actual or expected purchases, all made for cash, are $50,400, $69,900, and $79,800 for the months of May through July, respectively. (4) Rent is $3,000 per month. (5) Wages and salaries are 8% of the previous month's sales. (6) Cash dividends of $3,400 will be paid in June. (7) Payment of principal and interest of $3,600 is due in June. (8) A cash purchase of equipment costing $6,400 is…
Prepare a budgeted balance sheet at March 31 using the following information from Zimmer Company. a. The cash budget for March shows an ending loan balance of $20,000 and an ending cash balance of $75,000. b. The sales budget for March shows sales of $140,000. Accounts receivable at the end of March are budgeted to be 60% of March sales. c. The merchandise purchases budget shows that $91,000 in merchandise will be purchased on credit in March. Purchases on credit are paid 100% in the month following the purchase. d. Ending merchandise inventory for March is budgeted to be 800 units at a cost of $35 each. e. Income taxes payable of $28,000 are budgeted at the end of March. f. Accounting records at the end of March show budgeted equipment of $82,000 with accumulated depreciation of $35,000. g. Common stock of $35,000 and retained earnings of $60,000 are budgeted at the end of March. ZIMMER COMPANY Budgeted Balance Sheet As of March 31 $ 0 0 0
i need answer step by step
S ABC Company's raw materials purchases for June, July, and August are budgeted at $39,000, $29,000, and $54,000, respectively. Based on past experience, ABC expects that 70% of a month's raw material purchases will be paid in the month of purchase and 30% in the month following the purchase. Required: Prepare an analysis of cash disbursements from raw materials purchases for ABC Company for August. Budgeted raw material purchases August cash payments: Current month's purchases Prior month's purchases Total cash payments June July August $ 0
1. Prepare a budgeted income statement for the month ended July 31st. Use an absorption format. a. Calculate the estimated operating cycle for the month of July. (Hint: Use 30 days in the numerator to calculate the average collection period and the average sales period.)
Galina, Inc. has prepared the following direct materials purchases budget. Budgeted DM Purchases Month June July August $68,000 74,500 76,600 September October 79,600 70,600 All purchases are paid for as follows: 10% in the month of purchase, 40% in the following month, and 50% two months after purchase. Calculate the budgeted balance of accounts payable at the end of October. A. $63,540 B. $75,100 OC. $39,800 D. $103,340
Deschambault Inc. is working on its cash budget for December. The budgeted beginning cash balance is $14,000. Budgeted cash receipts total $127,000 and budgeted cash disbursements total $126,000. The desired ending cash balance is $40,000. To attain its desired ending cash balance for December, the company needs to borrow: A. $40,000 B. $55,000 C. $25,000 D. $0