Purchase Solution

Monthly Schedule of Cash Receipts: Diamond Beauty Supply

Not what you're looking for?

Ask Custom Question

Diamond Beauty supply Shop projects the following sales:

April - $75,000
May - $95,000
June - $100,000

Seventy percent of Diamond Beauty Supply shop 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 Diamond Beauty Supply shops' 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?

Purchase this Solution
Solution Summary

This solution illustrates how to prepare a schedule of cash receipts and how to compute a company's accounts receivable balance using that schedule.

Solution Preview

Please see the attached Excel 97-2003 spreadsheet for full solutions.

a) Prepare a monthly schedule of cash receipts for April-June.

April May June Quarter
February sales ...

Purchase this Solution
Free BrainMass Quizzes
SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

View More Free Quizzes
Related BrainMass Solutions

  • Cash Budget - Borrowings and Repayments

    This solution prepares a schedule of monthly cash receipts, monthly cash payments and a monthly cash budget.

  • Pirate Video Company - Prepare a monthly cash receipts schedule for the firm for March through August.

    Prepare a monthly cash receipts schedule for the firm for March through August. Of the sales expected to be made during the six months from March through August, how much will still be uncollected at the end of August?

  • Financial Plan for Juan's Taco Company

    For January, February, and March, prepare a schedule of monthly cash receipts, monthly cash payments, and a complete monthly cash budget with borrowings and repayments.

  • Cash Forecast; policies & procedures for gift shop

    These policies and procedures must address the cash receipts and cash payments. A monthly cash forecast must be prepared, for the first six months, showing the following: (1).

  • Receipts and Receivables

    a) Prepare a monthly schedule for cash receipts for April through June. b) What is the balance of Receivables at the end of June? a.

  • Journal Entries: Donovans, Rowenda Hotels, Wilson Company

    D) The petty cash fund of Diamond Electra Company contained the following items on September 30, 2009: Currency and coins $21.00 Receipts for the following expenditures: Delivery charges $39.00 Office Supplies $ 30.00

  • Cash Budget

    Prepare a schedule of monthly cash receipts, monthly cash payments, and a complete monthly cash budget with borrowing and repayments for June through September. The maximum desired cash balance is $50,000.

  • Cash flow schedule for collection of Accounts Receivable

    If April was $75,000 May was $95000 and June was 110,000 what would a monthly schedule for cash receipts for April through June and what is the balance of receivable at the end of June. Please see the attached file for clarity.

  • Schedule of budgeted cash receipts

    Prepare a schedule of budgeted cash receipts by month for the third quarter of 20X7. Please see the attachment. The solution explains how to prepare a schedule of budgeted cash receipts

View More Related Solutions