Question
Accounts Receivable Analysis Kate Miller owns a dance studio in Los Angeles, California. Students can buy access to the dance classes by paying a monthly
Accounts Receivable Analysis Kate Miller owns a dance studio in Los Angeles, California. Students can buy access to the dance classes by paying a monthly fee. Unfortunately, many of Kate's students are struggling actors and actresses who lack the ability to pay their bills in a timely manner. And, although the students were expected to pay for classes in advance, Kate began offering credit to many of her students to grow her business. This, however, put Kate in a serious liquidity problem as revealed by the growing balance in the studio's outstanding accounts receivable:
Age Classification | Accounts Receivable Outstanding Balance | Historical Estimate of Non-Collection |
---|---|---|
0-30 days | $8,800 | 4% |
31-60 days | 6,200 | 8% |
61-90 days | 4,400 | 12% |
91-120 days | 2,600 | 14% |
121-150 days | 1,800 | 20% |
> 150 days | 1,000 | 50% |
Kate's accountant, Matt Thomas, tried to help her get a handle on the studio's accounts receivable problem, but to little avail. One trick he successfully used in the past to make Kate realize the seriousness of the problem was to overestimate the extent of Kate's bad debt problem; consequently, there currently exists a balance in the allowance for uncollectible accounts totaling $540. Required 1. The first step to help get Kate's business back on track is to write off all receivables having a very low probability of collection (those accounts over 150 days). What balance sheet accounts will be affected, and in what amount, when Matt executes this action?
Indicate which balance sheet accounts will be affected by choosing Yes or No for each account:
Net revenue | YesNo |
Accounts receivable | YesNo |
Bad debt expense | YesNo |
Cash | YesNo |
Accounts payable | YesNo |
Allowance for uncollectible accounts | YesNo |
These account(s) will Answerincreasedecrease by $Answer
.
2. Prepare an aging of Kate's remaining accounts receivable. What balance should be in the Allowance for Uncollectible Accounts account? Hint - Remember that Kate has already written off all accounts greater than 150 days old. Balance in Allowance for Uncollectible Accounts $Answer
What is Kate's new estimate for bad debt expense? $Answer
3. Kate is in need of an immediate cash infusion and Matt has advised her to sell some of her receivables. A local bank has offered her two alternatives: a. Factor $8,000 of "current" receivables (0-30 days old) on a nonrecourse basis at a flat fee of 11% of the value of the receivables sold. b. Factor $8,000 of "current" receivables on a recourse basis at a flat fee of 6% of the value of the receivables sold. Which option should Kate choose? Why?
Cost of Option A | |
Cost of Option B |
Which option should Kate choose? AnswerOption AOption B
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