Question

E22-26 Preparing a financial budget-schedule of cash receipts, sensitivity analysis Marcel Compaay projects the following sal
0 0
Add a comment Improve this question Transcribed image text
Answer #1
1) Schedule of cash receipts
Particulars January February March
Sales $ 11,200.00 $ 12,300.00 $ 11,100.00
Credit sales (40%) $   4,480.00 $   4,920.00 $   4,440.00
Collection for the month of:
January $   2,240.00 $   2,240.00 $               -  
February $   2,460.00 $   2,460.00
March $               -   $               -   $   2,220.00
Collection of credit sales $   2,240.00 $   4,700.00 $   4,680.00
Cash sales $   6,720.00 $   7,380.00 $   6,660.00
Total cash receipts $   8,960.00 $ 12,080.00 $ 11,340.00
Balance of Accounts Receivable on March 31 = $ 2220
2) Schedule of cash receipts
Particulars January February March
Sales $ 11,200.00 $ 12,300.00 $ 11,100.00
Credit sales (40%) $   4,480.00 $   4,920.00 $   4,440.00
Collection for the month of:
January $   2,688.00 $   1,344.00 $      448.00
February $               -   $   2,952.00 $   1,476.00
March $               -   $               -   $   2,664.00
Collection of credit sales $   2,688.00 $   4,296.00 $   4,588.00
Cash sales $   6,720.00 $   7,380.00 $   6,660.00
Total cash receipts $   9,408.00 $ 11,676.00 $ 11,248.00
Balance of Accounts Receivable on March 31 = $ 2268 [($ 4920 x 10%) + ($ 4440 x 40%)]
Add a comment
Know the answer?
Add Answer to:
E22-26 Preparing a financial budget-schedule of cash receipts, sensitivity analysis Marcel Compaay projects the following sales...
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
  • E22-26 (similar to) Question Help o Marlin Company projects the following sales for the first three...

    E22-26 (similar to) Question Help o Marlin Company projects the following sales for the first three months of the year: $12,600 in January: $10,100 in February; and $16,300 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read...

  • Requirement 2. Prepare a revised schedule of cash receipts from sales in account are 60% in...

    Requirement 2. Prepare a revised schedule of cash receipts from sales in account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31? Requirement 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale. 30 blank, do not enter "0".) Cash Receipts from Customers...

  • A) Need help with this chart B) Find March credit sales, collection of March sales in...

    A) Need help with this chart B) Find March credit sales, collection of March sales in April Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April Marcel Company projects the following sales for the first three months of the year: $12,600 in January: $10,200 in February; and $11,100 in March. The company expects 70% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the...

  • pelase do requirement 1 and 2 E22-27 (similar to) Question Help Carmen Company projects the following...

    pelase do requirement 1 and 2 E22-27 (similar to) Question Help Carmen Company projects the following sales for the first three months of the year: $13.500 in January: $16,100 in February, and $10.400 in March. The company expects 70% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round...

  • Chapter 22-3 3 of 3 (2 complete Score: 0 of 24 pts E22-26 (similar to) HW...

    Chapter 22-3 3 of 3 (2 complete Score: 0 of 24 pts E22-26 (similar to) HW Score: 33.33%, 12 of 36 pt Question Help Armand Company projects the following sales for the first three months of the year $15.500 in January $12 300 in February, and $12.900 in March. The company expects 80% of the sales to be cash and the remainder on account Sales on account are collected 50% in the men of the sale and 50 in the...

  • Martin Company projects the following sales for the first three months of the year: $14,300 in...

    Martin Company projects the following sales for the first three months of the year: $14,300 in January: $11,300 in February; and $15,800 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements Requirement 1. Prepare a...

  • Elwood Company projects the following sales for the first three months of the year: $12,400 in...

    Elwood Company projects the following sales for the first three months of the year: $12,400 in January; $10,200 in February; and $10,500 in March. The company expects 70% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements. Requirement 1. Prepare a...

  • Jayson Company projects the following sales for the first three months of the year: $11.200 in...

    Jayson Company projects the following sales for the first three months of the year: $11.200 in January: $10,200 in February; and $13,400 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collecled 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements Requirement 1. Prepare a...

  • Jayson Company projects the following sales for the first three months of the year: 512,600 in...

    Jayson Company projects the following sales for the first three months of the year: 512,600 in January, 512,200 in February, and $11,100 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements Requirement 1. Prepare a...

  • Help with requirement 2 please? Graham Company projects the following sales for the first three months...

    Help with requirement 2 please? Graham Company projects the following sales for the first three months of the​ year: $ 10,800 in January​; $ 11,600 in February​; and $ 16,300 in March. The company expects 60​% of the sales to be cash and the remainder on account. Sales on account are collected​ 50% in the month of the sale and​ 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest...

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