Question

In: Accounting

Pavone Corp. has prepared a preliminary cash budget for the third quarter as shown​ below: Cash...

Pavone Corp. has prepared a preliminary cash budget for the third quarter as shown​ below:

Cash Budget

Jul

Aug

Sep

Beginning cash balance

​$34,000

​$15,000

​$18,500

​Plus: Cash collections

​$56,000

​$52,000

​47,000

Cash available

​90,000

​$67,000

​$65,500

​Less: Cash​ payments:

Purchases of direct materials

​35,000

​9,000

​11,000

Operating expenses

​40,000

​30,500

​30,800

Capital expenditures

0

​9,000

​7,400

Ending cash balance

​$15,000

​$18,500

​$16,300

​Subsequently, the marketing department revised its figures for cash collections. New data are as​ follows: $53,000 in​ July, $56,000 in​ August, and​ $43,000 in September. Based on the new​ data, calculate the new projected cash balance at the end of September.

A.

​$16,300

B.

​$19,500

C.

​$13,300

D.

​$12,000

Solutions

Expert Solution


Related Solutions

Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 258941 265299 284380 Credit Purchases 97804 116018 135024 Wages, Taxes, and Expenses 26612 31353 33454 Interest 7193 7571 8062 Equipment Purchases 54213 61494 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 254958 266136 282816 Credit Purchases 97321 115536 137343 Wages, Taxes, and Expenses 26176 31560 33787 Interest 7124 7595 7934 Equipment Purchases 54316 61677 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 254849 266370 281008 Credit Purchases 97712 113113 131293 Wages, Taxes, and Expenses 26632 31305 33401 Interest 7166 7522 7997 Equipment Purchases 54127 61180 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below:
    Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below:   Beech CorporationBalance SheetJune 30 Assets     Cash $   91,000   Accounts receivable 133,000   Inventory 36,000   Plant and equipment, net of depreciation 213,000       Total assets $ 473,000     Liabilities and Stockholders’ Equity     Accounts payable $   74,000   Common stock 328,000   Retained earnings 71,000    ...
Swifty, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts,...
Swifty, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Swifty desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) October November December Quarter Beginning cash balance $ $15,100 $ $16,100 Collections from sales 55,980 242,380 Total cash...
Sheridan, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts,...
Sheridan, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Sheridan desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) October November December Quarter Beginning cash balance $ $15,930 $ $16,020 Collections from sales 55,850 241,890 Total cash...
Company A is preparing its budget for the third quarter. The following information has been compiled:...
Company A is preparing its budget for the third quarter. The following information has been compiled: Cash collections $50,000 $40,000 $48,000 Cash payments Purchases of inventory 31,000 22,000 18,000 Operating expenses 12,000 9,000 11,600 Capital expenditures 13,000 25,000 0 The cash balance at the end of the second quarter is projected to be $4,000. The company is required to maintain cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT