Question

Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products....

Cash Receipts Budget and Accounts Receivable Aging Schedule

Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales:

Quarter 1 $4,600,000
Quarter 2 5,100,000
Quarter 3 5,000,000
Quarter 4 7,600,000

In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $4,900,000 and for the fourth quarter of the current year are $6,850,000.

Required:

1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year.

Quarter Cash Sales Credit Sales
3, current year $ $
4, current year
1, next year
2, next year
3, next year
4, next year

2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. If an amount is zero, enter "0".

Shalimar Company
Cash Receipts Budget
For the Coming Year
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Cash sales $ $ $ $
Received on account from:
Quarter 3, current year
Quarter 4, current year
Quarter 1, next year
Quarter 2, next year
Quarter 3, next year
Quarter 4, next year
Total cash receipts $ $ $ $

3. What if the recession led Shalimar’s top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.

Shalimar Company
Cash Receipts Budget
For the Coming Year
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Cash sales $ $ $ $
Received on account from:
Quarter 4, current year
Quarter 1, next year
Quarter 2, next year
Quarter 3, next year
Quarter 4, next year
Total cash receipts $ $ $ $
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Quarter Cash Sales Credit Sales Total
3, current year                    490,000                 4,410,000        4,900,000
4, current year                    685,000                 6,165,000        6,850,000
1, next year                    460,000                 4,140,000        4,600,000
2, next year                    510,000                 4,590,000        5,100,000
3, next year                    500,000                 4,500,000        5,000,000
4, next year                    760,000                 6,840,000        7,600,000
Shalimar Company
Cash Receipts Budget
For the Coming Year
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Cash sales                    460,000                    510,000                    500,000                    760,000
Received on account from:
Quarter 3, current year                    308,700
Quarter 4, current year                 1,541,250                    431,550
Quarter 1, next year                 2,691,000                 1,035,000                    289,800
Quarter 2, next year                 2,983,500                 1,147,500                    321,300
Quarter 3, next year                 2,925,000                 1,125,000
Quarter 4, next year                 4,446,000
Total cash receipts                 5,000,950                 4,960,050                 4,862,300                 6,652,300
3
Shalimar Company
Cash Receipts Budget
For the Coming Year
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Cash sales            460,000            510,000            500,000            760,000
Received on account from:
Quarter 3, current year
Quarter 4, current year        1,541,250
Quarter 1, next year        2,691,000        1,035,000
Quarter 2, next year        2,983,500        1,147,500
Quarter 3, next year        2,925,000        1,125,000
Quarter 4, next year        4,446,000
Total cash receipts        4,692,250        4,528,500        4,572,500        6,331,000
Add a comment
Know the answer?
Add Answer to:
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products....
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
  • Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For...

    Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 Quarter 2 Quarter 3 Quarter 4 $4,600,000 5,100,000 5,000,000 7,600,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter...

  • Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For...

    Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,740,000 Quarter 2 5,600,000 Quarter 3 3,730,000 Quarter 4 8,220,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter...

  • Cornerstone Exercise 8.11 (Algorithmic) Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and...

    Cornerstone Exercise 8.11 (Algorithmic) Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,720,000 Quarter 2 6,030,000 Quarter 3 3,110,000 Quarter 4 8,450,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected...

  • 5. Shalimar Company manufactures and sells industrials products. For 2017, Shalimar has budgeted the following sales:...

    5. Shalimar Company manufactures and sells industrials products. For 2017, Shalimar has budgeted the following sales: Quarter 1 Quarter 2 Quarter 3 Quarter 4 $4,600,000 5,100,000 5,000,000 7,600,000 in Shalimar's experience regarding sales on account, 75% are collected in the quarter of sale, and 22% are collected in the quarter following the sales. 3% are never collected. Total sales for the current third quarter is $4,900,000 and for the current fourth quarter is $6,850,000. Construct a cash receipts budget for...

  • Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...

    Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...

  • 8 Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of...

    8 Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale Percent paid in the month after the sale Percent paid in the second month after the sale To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April $275,500 May...

  • Academic Learning had prepared the following sales​ budget, schedule of budgeted cash​ receipts, and cash budget...

    Academic Learning had prepared the following sales​ budget, schedule of budgeted cash​ receipts, and cash budget for 2019​: Academic Learning Sales Budget For the Year Ended December 31, 2019 First Second Third Fourth Quarter Quarter Quarter Quarter Total Budgeted tablets to be sold 550 350 1,600 500 3,000 Sales price per unit $550 $550 $550 $550 $550 Total sales $302,500 $192,500 $880,000 $275,000 $1,650,000 Schdule of Cash Receipts from Customers First Second Third Fourth Quarter Quarter Quarter Quarter Total Total...

  • Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 15%...

    Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 15% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August...

  • Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 30% of its sales...

    Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 30% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale Percent paid in the second month after the sale Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 300,000 August Required:...

  • 2 parts Exercise 14-3 Preparing a schedule of cash receipts LO 14-2 The budget director of...

    2 parts Exercise 14-3 Preparing a schedule of cash receipts LO 14-2 The budget director of Heather's Florist has prepared the following sales budget. The company had $370,000 in accounts receivable on July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required a. Complete the schedule of cash receipts by filling in the missing amounts. b. Determine the amount of accounts receivable the company will report on its third quarter...

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
ADVERTISEMENT