Question

1. Prepare a monthly cash budget for the first quarter of the fiscal year beginning July...

1. Prepare a monthly cash budget for the first quarter of the fiscal year beginning July 1, assuming the following facts:
a. Cash collections typically average 50% of charges. Cash is received, on average, 40% in the month of service, 30% in the next month, 15% in the second month after service, 5% each in the next two months and 5% is uncollectible.
b.​Charges for February, March, April, May, and June were $300.000, $400,000, $400,000, $200,000 and $500,000, respectively. Charges for July, August and September are expected to be $400,000, $200,000 and $300,000.
c.​The cash balance at June 30 is expected to be $100,000. Monthly interest is expected to be .1% on the end of month cash balance.
d.​Cash outflows are anticipated to be 90% of average receipts for the quarter.

Homework Answers

Answer #1
Month Charges July August September
Cash collection 200000 100000 150000
February 150000
March 200000 10000
April 200000 10000 10000
May 100000 15000 5000 5000
June 250000 75000 37500 12500
July 200000 80000 60000 30000
August 100000 40000 30000
September 150000 60000
Total receipt for the quarter 390000 252500 287500
Beginning Balance 100000 140000 166650
Monthly Interest 1000 1400 1666.5
Total Cash available 491000 393900 455816.5
Cash disbursement(outflow) 351000 227250 258750
Ending Balance 140000 166650 197066.5
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget...
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company’s sales are made on account. The following information has been provided by Spicer’s management.    Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 428,000 (estimated) April 805,000 (estimated) May 800,000 (estimated)    The company’s collection activity on credit sales historically has been as follows.    Collections in the month of the sale...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
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 Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 140,000 Inventory 66,500 Plant and equipment, net of depreciation 227,000 Total assets $ 508,500 Liabilities and Stockholders’ Equity Accounts payable $ 88,000 Common stock 311,000 Retained earnings 109,500 Total liabilities and stockholders’ equity $ 508,500 Exercise 8-12...
Problem 1 – Cash Collections Week 3 Providence City acquired its power plant from a private...
Problem 1 – Cash Collections Week 3 Providence City acquired its power plant from a private company on June 1. No receivables were acquired with the purchase. Therefore, total accounts receivable on June 1 had a zero balance. Providence plans to bill customers in the month following the month of sale, and 70% of the resulting billings will be collected during the billing month. 95% of the remaining balance should be collectable in the next following month. The remaining uncollectible...
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget...
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company’s sales are made on account. The following information has been provided by Spicer’s management.    Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 559,000 (estimated) April 584,000 (estimated) May 800,000 (estimated)    The company’s collection activity on credit sales historically has been as follows.    Collections in the month of the sale...
In March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget...
In March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company’s sales are made on account. The following information has been provided by Spicer’s management.    Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 593,000 (estimated) April 503,000 (estimated) May 800,000 (estimated)    The company’s collection activity on credit sales historically has been as follows.    Collections in the month of the sale...
Use the following information to prepare the July cash budget for Acco Co. It should show...
Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. Beginning cash balance on July 1: $65,000. Cash receipts from sales: 25% is collected in the month of sale, 50% in the next month, and 25% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are May (actual), $1,880,000; June...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
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 $101,000 $126,000 $169,000 Manufacturing costs 42,000 54,000 61,000 Selling and administrative expenses 35,000 38,000 64,000 Capital expenditures _ _ 41,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...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from sales: 24% is collected in the month of sale, 50% in the next month, and 26% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,548,000; June (actual), $1,080,000; and July (budgeted), $1,260,000. Payments on merchandise purchases: 48% in the month of purchase and 52% in the month following purchase. Purchases amounts are: June...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600 Total cash available Preliminary cash balance Ending cash balance Loan balance Loan balance - Beginning of month $0 Additional loan (loan repayment) Loan balance - End of month Karim Corp. requires a minimum $8,200 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). Any excess cash is used to repay loans at...
Little Flower Establishment would like to prepare a cash budget for July and August. The following...
Little Flower Establishment would like to prepare a cash budget for July and August. The following information has been gathered:        (i) Cash balance as of July 1: $ 1,440,000        (ii) Forecasted sales are as follows:                                                       May                June               July             August Cash sales............................ $1,600,000    $ 1,920,000    $ 1,920,000    $ 1,920,000 Credit sales..........................  1,280,000      1,440,000       1,600,000       1,920,000 Total..................................... $ 2,880,000    $ 3,360,000     $ 3,520,000     $ 3,840,000        (iii) Credit sales are collected 40% in the month of the sale, 35%...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT