Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20     Percent paid in the month after the sale 55     Percent paid in the second month after the sale 23     To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April $199,500   May 260,400   June 273,000   July 252,000   August 315,000   Required: 1.  Prepare a schedule of cash receipts for July. Be sure to enter percentages as whole numbers. Payments on account:         From May credit sales:         $ ×  %       $ From June credit sales:         $ ×  %         From July credit sales:         $ ×  %         Less: July cash discount         $ ×  %

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 17E
icon
Related questions
Question

Schedule of Cash Collections on Accounts Receivable and Cash Budget

Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience:

Percent paid in the month of sale 20    
Percent paid in the month after the sale 55    
Percent paid in the second month after the sale 23    

To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows:

April $199,500  
May 260,400  
June 273,000  
July 252,000  
August 315,000  

Required:

1.  Prepare a schedule of cash receipts for July. Be sure to enter percentages as whole numbers.

Payments on account:        
From May credit sales:        
$ ×  %       $
From June credit sales:        
$ ×  %        
From July credit sales:        
$ ×  %        
Less: July cash discount        
$ ×  %
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Receivables Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage