Ask Experts Questions for FREE Help !
    challenge mather's Avatar
    challenge mather Posts: 19, Reputation: 1
    New Member

    Mar 31, 2008, 07:18 PM
    Monthly schedule of cash receipts/balance AR
    Ellis Sport Shop projects the following sales:

    Ninety percent of Ellis' sales are on credit with 60 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale. February sales were $60,000 and March sales were $70,000. In the past Ellis' bad debt percentage has been 0 and is expected to continue.
    (a) Prepare a monthly schedule of cash receipts for April-June.
    (b) What is the balance of Receivables at the end of June.

    Feb Mar April May June
    60,000 70,000
    60% collected 50,000 60,000

    I am stuck!
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member

    Apr 4, 2008, 03:45 PM
    I don't see where you're getting your "60% collected" numbers from. Those aren't 60% of anything that I can tell.

    You need to do these one step at a time, thinking very carefully about what each step is and finishing out that step. I commonly see people trying to read whole paragraphs and thinking they're going to figure out all at once what the answer is.

    Set yourself up two columns, one each for Feb & March. Follow the sales through for each month, as to where it will be collected. (If these get complicated, you may need to add a month or two before and a month or two after, but this one is not one of the complicated ones. And you don't want to see the complicated one, right? :D ) So you just need Feb & March really.

    List your sales for each month. (You may not need or want that on your final schedule, but I can't tell you that. Every book can have a different set-up for these, so you need an example from your book.) Now, what's the first thing it says? 90% of sales are on credit. "Credit" is receivables, right? So 90% goes into receivables and 10% of sales were for cash. That 10% cash is part of "cash receipts." So go to February and start this: figure the 10% for cash receipts and the other 90% goes into receivables. Since it wants a receivables balance at month-end, you need to be keeping track of that too. (That should not be on your schedule so keep track of that elsewhere.)

    Then what's it say? That 60% is collected in the month of the sale. Well, you're not collecting the 10% cause you already have that. You're collecting 60% of what went into receivables. If you've been writing these numbers down, you have that number. So figure 60% of it and that gets collected in the same month, i.e. February. So now you have the collections that's the 60%. (While you're at it, subtract it off receivables so you can have that end-of-month balance.)

    Then it says the remainder gets collected in the next month. What's the remainder? How much is left after collecting 60%? That gets collected in the next month. i.e. March. So go over to March's column and put that as part of March's collections.

    You have now completely finished February. And you have Feb's ending A/R balance. Don't forget to carry that balance over to March as a beginning balance. And then do the same process with March's sales. (The 'remainder' will end up into April, but you aren't including that so you just get forget it.)

    When you get done, add up all the cash collections. i.e. the sales isn't cash collections. The amount that went into A/R isn't cash collections. Which of these is cash? The 10% cash sales, the 60% of A/R collected in current month, and 40% leftovers collected for one month prior. That's your total cash receipts.

    This is much easier to explain live. But give it a try.

Not your question? Ask your question View similar questions


Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.

Check out some similar questions!

Preparing monthly cash statements [ 1 Answers ]

How do you computer prior month purchases (dec) to get total material payments for Jan? The Denver Corporation has forecast the following sales for the first seven months of the year: January $10,000 May $10,000 February 12,000 June 16,000 March 14,000 July ...

There does not seem to enough cash to cover the monthly expenses [ 3 Answers ]

There does not seem to enough cash to cover the monthly expenses. Zero balances and bounced checks (covered by bank) seem to be common. There are times when my checks are deposited (direct) and all it does is cover the checks already written. Our bank has charged us several hundred dollars in...

Cash receipts journal [ 2 Answers ]

OK.. i.m using a cash reciepts journal.. and the transaction is... "recieved cash on account from wayne miller for chairs purchased may 25on s147 for $157.50, less discount (2%)." OK.. i.m so confused.. where does everything go?? Please help..

Do I have to submit all receipts for expenses I claimed on 1040 Schedule C? [ 2 Answers ]

Do I have to submit all receipts for expenses I claimed on 1040 Schedule C? If the answer is yes, should I enclose them, along with 1040 Schedule C and 1040NR, in my tax envelope? Thank you. I am going to continue checking my shoebox of receipts...

View more questions Search