Question

Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 Month of Sales Age of Percent of Amount Due Account Amounts April March February January 0-30 $ 120,540 31-60 61-90 86,100 103,320 34,440 $ 344,400 91-120 Total receivables 100% a. Calculate the percentage of amount due for each montlh Percent of Month of Sales Amount Due ri March February January Total receivables 100 1% b. If the firm had $1,476,000 in credit sales over the four-month period, compute the average collection period. Average daily sales should be based on a 120-day period Average collection days eriod

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Month Age of account Amount Percentage Percentage
Apr 0-30        120,540 120540*100/344400 35.00%
Mar 31-60           86,100 86100*100/344400 25.00%
Feb 61-90        103,320 103320*100/344400 30.00%
Jan 91-120           34,440 34440*100/344400 10.00%
       344,400 100.00%
4 month sale 1476000
Pending AR             344,400
Debtor turnover ratio 1476000/344400
Debtor turnover ratio                    4.29
Average collection period= 120/4.29
Average collection period=                  28.00
Add a comment
Know the answer?
Add Answer to:
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
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
  • Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...

    Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 253,750 _______ March 31–60 145,000 _______ February 61–90 217,500 _______ January 91–120 108,750 _______ Total receivables $ 725,000 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,740,000 in credit sales over the four-month period, compute...

  • Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...

    Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 131,760 _______ March 31–60 49,410 _______ February 61–90 115,290 _______ January 91–120 32,940 _______ Total receivables $ 329,400 100% a. Calculate the percentage of amount due for each month. a. Calculate the percentage of amount due for each month. b. If the firm...

  • Route Canal Shipping Company has the following schedule for aging of accounts receivable: (4) Percent of...

    Route Canal Shipping Company has the following schedule for aging of accounts receivable: (4) Percent of Amount Due (1) Month of Sales April March February January Total receivables Age of Receivables April 30, 20X1 (2) (3) Age of Account Amounts 0-30 $ 131,250 31-60 93,750 61-90 112.500 91-120 37,500 $ 375,000 100% a. Calculate the percentage of amount due for each month. Percent of Month of SalesAmount Due April March February January Total receivables 100 % b. If the firm...

  • Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...

    Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 161,820 _______ March 31–60 71,920 _______ February 61–90 107,880 _______ January 91–120 17,980 _______ Total receivables $ 359,600 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,488,000 in credit sales over the four-month period, compute...

  • Route Canal Shipping Company has the following schedule for aging of accounts receivable: (4) Percent of...

    Route Canal Shipping Company has the following schedule for aging of accounts receivable: (4) Percent of Amount Due Age of Receivables April 30, 20X1 (1) (2) (3) Month of Age of Sales Account Amounts April 0-30 $244,640 March 31-60 122,320 February 61-90 183,480 January 91-120 61,160 Total receivables $611,600 100% a. Calculate the percentage of amount due for each month. Percent of Amount Due Month of Sales April March February January Total receivables 100 b. If the firm had $1,668,000...

  • Route Canal Shipping Company has the following schedule for aging of accounts receivable: (4) Percent of...

    Route Canal Shipping Company has the following schedule for aging of accounts receivable: (4) Percent of Amount Due Age of Receivables April 30, 20X1 (1) (2) (3) Month of Age of Sales Account Amounts April 0-30 $ 201,390 March 31-60 115,080 February 61-90 172,620 January 91-120 86,310 Total receivables $ 575,400 100% a. Calculate the percentage of amount due for each month. Percent of Amount Due % % Month of Sales April March February January Total receivables % % 100...

  • Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...

    Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 2013 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April................................. 0–30 $ 131,250 ____ March............................... 31–60 93,750 ____ February........................... 61–90 112,500 ____ January............................. 91–120 37,500 ____    Total receivables............ $ 375,000 100%             a. Fill in column (4) for each month.             b. If the firm had $1,500,000 in credit sales over the four-month period,...

  • Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivable...

    Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivable ( 1) ( 2 ) ( 3 ) ( 4 ) Month of Sales Age of Account Amounts % of amount due April 0-30 $195,360 March 31-60 $97,680 February 61-90 $122,100 January 91-120 $73,260 Total receivables $488,400 100% a. Calculate the percentage of amount due for each month b. If the firm had $1,584,000 in credit sales over the four-month period, compute the average...

  • Laura Falk, Bramble & Hill Fabricators' accounts receivable manager, has just received the company's sales budget...

    Laura Falk, Bramble & Hill Fabricators' accounts receivable manager, has just received the company's sales budget for the first quarter. January February $254.800 $496.860 March Quarter $445.900 $1,197,560 Budgeted revenue The company makes all sales on credit. Laura recently reviewed the company's collection history and found that 70% of the sales are collected in the month of the sale, 26% of sales are collected in the month following the sale, and 4% of sales are uncollectible. The company expects to...

  • Kidz Incorporated reports the following aging schedule of its accounts receivable with the estimated percent uncollectible....

    Kidz Incorporated reports the following aging schedule of its accounts receivable with the estimated percent uncollectible. Estimated Amount Percent Age Group Receivable Uncollectible 0-60 days $20,000 28 61-90 days 6,000 158 More than 90 days past due 2,000 Total $28,000 503 At what amount would Allowance for Uncollectible Accounts be reported in the current year's balance sheet? At the beginning of the year, Dawnetta Fashions has total accounts receivable of $300,000. By the end of the year, Dawnetta reports total...

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