Ask Experts Questions for FREE Help !
Ask

Cash Collections Budget Problem

Asked Feb 21, 2006, 04:42 PM — 3 Answers
I would REALLY appreciate any help you could give me with this problem:

Sales
May 60,000
June 70,000
July 80,000
August 100,000
All sales are on credit. Records show that 60 percent of the customers pay during the month of the sale, 20 percent pay the month after the sale, and the remaining 15 percent pay the second month after the sale. 5% are uncollectable.

Prepare a cash collections budget for July and August.

Thanks so much!

Search this Thread
Share |
3 Answers
CaptainForest's Avatar
CaptainForest Posts: 3,684, Reputation: 2085
Ultra Member
  
#2

Feb 21, 2006, 07:47 PM
July Cash Collections
July sales = 80,000 * .6 = 48,000
June sales = 70,000 * .2 = 14,000
May sales = 60,000 * .15 = 9,000
TOTAL CASH COLLECTIONS IN JULY = 71,000

August Cash Collections
August sales = 100,000 * .6 = 60,000
July sales = 80,000 * .2 = 16,000
June sales = 70,000 * .15 = 10,500
TOTAL CASH COLLECTIONS IN AUGUST = 86,500
Helpful
yiyiioo's Avatar
yiyiioo Posts: 1, Reputation: 10
Junior Member
  
#3

Sep 28, 2011, 05:23 AM
why is it important to prepare cash budget?
Helpful
pready's Avatar
pready Posts: 2,662, Reputation: 882
Ultra Member
  
#4

Sep 28, 2011, 07:14 AM
Companies need to know how much cash is coming in and go out in a period, so they will know if they will have enough cash onhand to pay employees, make loan payments, take advantage of special purchases on merchandise, etc... Aslo they will know ahead of time when they will need to get a loan if needed to get a good interest rate, or when they might be able to take on a special project like renovations, equipment upgrades, etc...
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

Because collections [ 2 Answers ]

What is the longest that a debt collector has to collect on a loan in because? What kinds of bearing does the statute of limitations have on this?

Collections [ 1 Answers ]

What is the main difference between associative arrays and nested tables How to choose in pl/sql program satya:)

Collections [ 4 Answers ]

I live in Utah. I have a hospital debt that is large enough that I cannot pay what the hospital wants me to pay each month and they have advised me that it will go to a collection agency. My Question is: "If I make the monthly payments I can afford to the collection agency, can they still...

View more Accounting questions Search