Question

You have the following information. Prepare and evaluate a cash budget for the months of October,...

You have the following information. Prepare and evaluate a cash budget for the months of October, November, and December based on the information shown below.

  Sales       Purchases

August    3,000,000    3,500,000

September       4,500,000       2,000,000

October       1,000,000    500,000

November    1,500,000   750,000

December   2,000,000   1,000,000

The firm collects 60 percent of sales for cash and 40 percent of its sales one month later.

∙     Interest income of $50,000 on marketable securities will be received in December.

∙     The firm pays cash for 40 percent of its purchases.

∙     The firm pays for 60 percent of its purchases the following month.

∙     Salaries and wages amount to 15 percent of the preceding month's sales.

∙     Sales commissions amount to 2 percent of the preceding month's sales.

∙     Lease payments of $100,000 must be made each month.

∙     A principal and interest payment on an outstanding loan is due in December of $150,000.

∙     The firm pays dividends of $50,000 at the end of the quarter.

∙     Fixed assets costing $600,000 will be purchased in December.

∙     Depreciation expense each month of $45,000.

∙     The firm has a beginning cash balance in October of $100,000 and maintains a minimum cash balance of $200,000.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

cash budget is prepared to find the excess cash required at the end of month and maintain desired cash balance.

it helps in maintaining liquidity and avoid financial crunch in firm.

cash budget

Month August September October November December
sales 3,000,000 4,500,000 1,000,000 1,500,000 2,000,000
cash (60%) 1,800,000[3,000,000*60%] 2,700,000[4,500,000*60%] 600,000[1,000,000*60%] 900,000[1,500,000*60%] 1,200,000[2,000,000*60%]
previous month receipts (40%)

1,200,000

[3,000,000*40%]

1,800,000

[4,500,000*40%]

400,000

[1,000,000*40%]

600,000

[1,500,000*40%]

Interest $50,000
Total receipts $3,900,000

$2,400,000

[600000+1800000]

$1,300,000 $1,850,000
Purchase 3,500,000 2,000,000 500,000 750,000 1,000,000
cash 40% $1,400,000[3,500,000*40%] $800,000[2,000,000*40%] $200,000[500,000*40%] $300,000[750,000*40%] $400,000[1,000,000*40%]
previous month 60% payment $2,100,000[3,500,000*60%] $1,200,000[2,000,000*60%] $300,000[500,000*60%] $450,000[750,000*60%]
salaries $ Wages $450,000[3,000,000*15%] $675,000[4,500,000*15%] $150,000[1,000,000*15%] $225,000[1,500,000*15%]
sales commission $60,000[3,000,000*2%] $90,000[4,500,000*2%] $20,000[1,000,000*2%] $30,000[1,500,000*2%]
lease payments $100,000 $100,000 $100,000 $100,000
Principle and interest payment $150,000
cash dividends $50,000
Fixed asset purchase $600,000
Total cash disbursement $3,510,000 [800000+2100000+450000+60000+100000] $2,265,000 $870,000 $2,005,000
Nt cash flow $390,000[3,900,000-3,510,000] $135,000[2,400,000-2,265,000] $430,000[1,300,000-870,000] -$155,000[1850000-2005000]
Add:beginning cash balance $100,000 $235,000 $665,000
Ending cash balance $235,000[135000+100000] $665,000[430,000+235000] $510,000[-155000+665000]
Less: Minimum cash balance $200,000 $200,000 $200,000
Required finance
excess cash $35,000 $465,000 [665000-200000] $310,000 [510,000-200,000]
Add a comment
Know the answer?
Add Answer to:
You have the following information. Prepare and evaluate a cash budget for the months of October,...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2) In the preparation of a quarterly cash budget, the following revenue and cost information have...

    2) In the preparation of a quarterly cash budget, the following revenue and cost information have been compiled. Month August (actual) September (actual) October (forecast) November (forecast) December (forecast) Sales $3,000,000 $4,500,000 $1,000,000 $1,500,000 $2,000,000 Purchases $3,500,000 $2,000,000 $ 500,000 $ 750,000 $1,000,000 To prepare and to evaluate a cash budget for the months of October, November, and December, the information shown below is used: • The firm collects 60 percent of sales for cash and 40 percent of its...

  • (5 points) In preparation for the quarterly cash budget, the following revenue and cost information have...

    (5 points) In preparation for the quarterly cash budget, the following revenue and cost information have been compiled. Prepare and evaluate a cash budget for the month of October based on the information shown below. Sales 53 (XXX) Month August (actual) September (actual) October (forecast) Purchases $3,500,000 $2,000,000 $ 500.000 $4.500.000 $1.000.000 • The firm collects 60 percent of sales for cash and 40 percent of its sales one month later. • The firm pays cash for 40 percent of...

  • Cash budget: Advanced The actual sales and purchases for Xenocore, Inc., for Sep- tember and October...

    Cash budget: Advanced The actual sales and purchases for Xenocore, Inc., for Sep- tember and October 2015, along with its forecast sales and purchases for the period November 2015 through April 2016, follow. The firm makes 20% of all sales for cash and collects on 40% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $12,000 in September and April, $15,000 in January and March, and $27,000 in February. The...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company’s operations: The cash balance on December 1 is $40,000. Actual sales for October

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company’s operations: The cash balance on December 1 is $40,000.Actual sales for October and November and expected sales for December are as follows:  OctoberNovemberDecemberCash sales$ 65,000$ 70,000$ 83,000Sales on account$ 400,000$ 525,000$ 600,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the...

  • ​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months...

    ​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months of 2016 as​ follows: January ​$140,000    April ​$300,000 July ​$200,000    February      $100,000 May   $255,000    August       $200,000 March   $170,000 June   $180,000 Lewis collects 30 percent of its sales in the month of the​sale, 40 percent in the month following the​ sale, and the remaining 30 percent 2 months following the sale. During November and December of​ 2015, Lewis's sales were...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $58,600. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 73,200 $ 78,000 $ 92,000 $ 485,000 $ 568,000 $ 663,000 Sales on account are collected over a three-month period...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company’s operations: The cash balance on December 1 is $40,000. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 65,000 $ 70,000 $ 83,000 Sales on account $ 400,000 $ 525,000 $ 600,000 Sales on account are collected over a three-month period as follows:...

  • Active Life Inc., a sports equipment retailer, needs to prepare a cash budget for the first...

    Active Life Inc., a sports equipment retailer, needs to prepare a cash budget for the first quarter of 2018. The financial staff at Active Life has forecasted the following sales figures: January February March April May $100,000 $150,000 $300,000 $250,000 $150,000 Actual sales in October, November, and December 2017 were $125,000, $146,000, and $125,000, respectively. Cash sales are 40% of the total, and the rest are on credit. Under the current credit policy the firm expects to collect 60% of...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $45,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 80,800 $ 74,000 $ 98,200 $525,000 $559,000 $643,000 Sales on account are collected over a three-month period as follows: 20%...

  • You have been asked to prepare a December cash budget for Ashton Company, a distributor of...

    You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $53,200. b. Actual sales for October and November and expected sales for December are shown below. Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT