• 100% Satisfaction Guarantee

Manal Elkhoshkhany, Tutor
Category: Homework
Satisfied Customers: 9735
Experience:  More than 5000 online tutoring sessions.
3708793
Manal Elkhoshkhany is online now

# Schedule of Expected Cash Collections

### Resolved Question:

Schedule of Expected Cash Collections; Cash Budget [LO2, LO8] The president of the retailer Prime Products has just approached the company’s bank with a request for a \$30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some diff culty in paying off its loans in the past, the loan off cer has asked for a cash budget to help determine whether the loan should be made.  data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be \$24,000. Accounts receivable on April 1 will total \$140,000, of which \$120,000 will be collected during April and \$16,000 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% represents bad debts that are never collected. Budgeted sales and expenses for the three-month period follow: c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid during April, total \$140,000.

The following April May June

Sales (all on account) \$300,000 \$400,000 \$250,000

Merchandise purchases \$210,000 \$160,000 \$130,000

Payroll \$ 20,000 \$ 20,000 \$ 18,000

Lease payments \$ 22,000 \$ 22,000 \$ 22,000

Equipment purchases \$ ---------- ----------- 65,000

Depreciation \$ 15,000 \$ 15,000 \$ 15,000

d. In preparing the cash budget, assume that the \$30,000 loan will be made in April and repaid in June. Interest on the loan will total \$1,200.

Required:

1. Prepare a schedule of expected cash collections for April, May, and June, and for the three months in total.

2. Prepare a cash budget, by month and in total, for the three-month period.

3. If the company needs a minimum cash balance of \$20,000 to start each month, can the loan be repaid as planned? Explain in Excel spreadsheet.

Submitted: 4 years ago.
Category: Homework
Expert:  Manal Elkhoshkhany replied 4 years ago.

Thank you for requesting me, but for future posts, please remember to type "For BusinessTutor" at the beginning of the post.

Customer: replied 4 years ago.
Tomorrow if at all possible...sorry for such short notice.
Expert:  Manal Elkhoshkhany replied 4 years ago.
That is ok :) Working on it
Customer: replied 4 years ago.
Thanks so much.
Expert:  Manal Elkhoshkhany replied 4 years ago.
You are welcome :)
Expert:  Manal Elkhoshkhany replied 4 years ago.

You need to spend \$3 to view this post. Add Funds to your account and buy credits.
Manal Elkhoshkhany, Tutor
Category: Homework
Satisfied Customers: 9735
Experience: More than 5000 online tutoring sessions.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Previous | Next >
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
• Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
• He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX

• ### LogicPro

#### Satisfied Customers:

4925
Expert in Java C++ C C# VB Javascript Design SQL HTML
< Last | Next >

### LogicPro

#### Satisfied Customers:

4925
Expert in Java C++ C C# VB Javascript Design SQL HTML

### Manal Elkhoshkhany

#### Satisfied Customers:

4538
More than 5000 online tutoring sessions.

### Linda_us

#### Satisfied Customers:

3138
Post Graduate Diploma in Management (MBA)

### Chris M.

#### Satisfied Customers:

2602
Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

### F. Naz

#### Satisfied Customers:

2126
Experience with chartered accountancy

### Bizhelp

#### Satisfied Customers:

1887
Bachelors Degree and CPA with Accounting work experience