Question: Hi, I only need help with the last part of this problem which is highlighted in yellow and marked with a red "X". 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 Accounts Receivable Historical Estimate Classification Outstanding Balance of Non-Collection 0-30 days $17,600 4% 31-60 days 12,400 8% 61-90 days 8,800 12% 91-120 days 5,200 14% 121-150 days >150 days 3,600 20% 2,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 $1,080. 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 Accounts receivable No Yes ÷ ✓ Bad debt expense No = Cash No ÷ Accounts payable No Allowance for uncollectible accounts Yes ÷ These account(s) will decrease by $2,000 2. An aging of Kate's remaining accounts receivable is needed. 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 $ 4,200 What is Kate's new estimate for bad debt expense? $ 3,120 × 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 $16,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 $16,000 of "current" receivables on a recourse basis at a flat fee of 6% of the value of the receivables sold. Cost of Option A $ Cost of Option B $ 1,760 960 x

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
For factoring problem B, I also tried $15,040 by subtracting $960 from $16,000 but this wasn't correct.
Question:
Hi, I only need help with the last part of this problem which is highlighted in yellow and marked with a red "X".
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
Accounts Receivable Historical Estimate
Classification Outstanding Balance of Non-Collection
0-30 days
$17,600
4%
31-60 days
12,400
8%
61-90 days
8,800
12%
91-120 days
5,200
14%
121-150 days
>150 days
3,600
20%
2,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
$1,080.
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
Accounts receivable
No
Yes
÷ ✓
Bad debt expense
No
=
Cash
No
÷
Accounts payable
No
Allowance for uncollectible accounts Yes
÷
These account(s) will decrease
by $2,000
2. An aging of Kate's remaining accounts receivable is needed. 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
$ 4,200
What is Kate's new estimate for bad debt expense?
$ 3,120
×
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 $16,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 $16,000 of "current" receivables on a recourse basis at a flat fee of 6% of the value of the receivables sold.
Cost of Option A $
Cost of Option B $
1,760
960 x
Transcribed Image Text:Question: Hi, I only need help with the last part of this problem which is highlighted in yellow and marked with a red "X". 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 Accounts Receivable Historical Estimate Classification Outstanding Balance of Non-Collection 0-30 days $17,600 4% 31-60 days 12,400 8% 61-90 days 8,800 12% 91-120 days 5,200 14% 121-150 days >150 days 3,600 20% 2,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 $1,080. 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 Accounts receivable No Yes ÷ ✓ Bad debt expense No = Cash No ÷ Accounts payable No Allowance for uncollectible accounts Yes ÷ These account(s) will decrease by $2,000 2. An aging of Kate's remaining accounts receivable is needed. 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 $ 4,200 What is Kate's new estimate for bad debt expense? $ 3,120 × 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 $16,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 $16,000 of "current" receivables on a recourse basis at a flat fee of 6% of the value of the receivables sold. Cost of Option A $ Cost of Option B $ 1,760 960 x
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education