Question
Cash Budget Aragon and Associates has found from past experience that 25% of its services are for cash. The remaining 75% are on credit. An
Cash Budget
Aragon and Associates has found from past experience that 25% of its services are for cash. The remaining 75% are on credit. An aging schedule for accounts receivable reveals the following pattern:
- Ten percent of fees on credit are collected in the month that service is rendered.
- Sixty percent of fees on credit are collected in the month following service.
- Twenty-six percent of fees on credit are collected in the second month following service.
- Four percent of fees on credit are never collected.
Fees (on credit) that have not been paid until the second month following performance of the legal service are considered overdue and are subject to a 3% late charge.
Aragon has developed the following forecast of fees:
May | $180,000 | ||
June | 200,000 | ||
July | 190,000 | ||
August | 194,000 | ||
September | 240,000 |
Required:
Prepare a schedule of cash receipts for August and September. If an amount box does not require an entry, leave it blank or enter "0". Round answers to the nearest dollar.
Aragon and Associates | ||
Schedule of Cash Receipts | ||
For August and September | ||
August | September | |
Cash fees | $ | $ |
Received from sales in: | ||
June | ||
July | ||
August | ||
September | ||
Total | $ | $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started