Helen Bowers, the new credit manager of the Muscarella Corporation, was alarmed to find that Muscarella sells on credit terms of net 50 days whereas industry-wide credit terms have recently been lowered to net 30 days.  On annual credit sales of $3 million, Muscarella currently averages 60 days' sales in accounts receivable.  Bowers estimates that tightening the credit terms to 30 days would reduce annual sales to $2.6 million, but accounts receivable would drop to 35 days of sales.  She also expects the level of bad debts to decrease from its current level of 5% to 3% with the change in credit terms, because the loss in sales will likely include many customers who are classified as having poorer credit than those who continue to purchase from Muscarella.  in addition, collection costs will increase from $150,000 to $175,000 because the collection department will put more effort into collecting delinquent accounts.  Muscarella's variable cost ratio is 70% and its marginal tax rate is 40%.  (This information is shown on the spreadsheet provided.) Bowers also believes that if she leaves the credit policy as it is, sales will increase to $3.4 million and the DSO-nondiscount customers will remain at 60 days.  Bad debts would be 5%.  Should Bowers leave the credit policy alone or tighten it as described in either Question 1 or 2?  Explain your answer. After comparing the credit policies of other firms, Helen is exploring whether Muscarella should offer a cash discount for early payment.  She estimates that if terms of 2/10 net 30 are offered sales will increase to $3.5 million and 15% of the customers wold take the cash discount by paying on Day 10 (DSO-discount customers).  The customers who do not take the cash discount are expected to pay on average on Day 50 (DSO-nondiscount customers).  Under this policy collection costs would increase to $200,000 and bad debts would decrease to 4.5%.  Should Muscarella offer cash discounts under these credit terms?  Why or why not?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Percentages need to be entered in decimal format, for instance 3% would be entered as .03.

Helen Bowers, the new credit manager of the Muscarella Corporation, was alarmed to find that Muscarella sells on credit terms of net 50 days whereas industry-wide credit terms have recently been lowered to net 30 days.  On annual credit sales of $3 million, Muscarella currently averages 60 days' sales in accounts receivable.  Bowers estimates that tightening the credit terms to 30 days would reduce annual sales to $2.6 million, but accounts receivable would drop to 35 days of sales.  She also expects the level of bad debts to decrease from its current level of 5% to 3% with the change in credit terms, because the loss in sales will likely include many customers who are classified as having poorer credit than those who continue to purchase from Muscarella.  in addition, collection costs will increase from $150,000 to $175,000 because the collection department will put more effort into collecting delinquent accounts.  Muscarella's variable cost ratio is 70% and its marginal tax rate is 40%.  (This information is shown on the spreadsheet provided.)

  1. Bowers also believes that if she leaves the credit policy as it is, sales will increase to $3.4 million and the DSO-nondiscount customers will remain at 60 days.  Bad debts would be 5%.  Should Bowers leave the credit policy alone or tighten it as described in either Question 1 or 2?  Explain your answer.
  2. After comparing the credit policies of other firms, Helen is exploring whether Muscarella should offer a cash discount for early payment.  She estimates that if terms of 2/10 net 30 are offered sales will increase to $3.5 million and 15% of the customers wold take the cash discount by paying on Day 10 (DSO-discount customers).  The customers who do not take the cash discount are expected to pay on average on Day 50 (DSO-nondiscount customers).  Under this policy collection costs would increase to $200,000 and bad debts would decrease to 4.5%.  Should Muscarella offer cash discounts under these credit terms?  Why or why not?
INPUT DATA:
Old
New
Annual Data:
Sales
$3,000,000
$2,600,000
Variable cost ratio
70.0%
70.0%
$2,100,000
$150,000
$1,820,000
$175,000
Variable cost
Collection costs
Bad debt percent
5.0%
3.0%
DSO--discount customers
DSO--nondiscount customers
60
35
Cash discount
0.0%
0.0%
% discount customers
0.0%
0.0%
% nondiscount customers
100.0%
100.0%
Required rate of return, r
11.0%
11.0%
Daily Data (360 days):
$8,333.33
$0.00
$7,916.67
($5,833.33)
($416.67)
$7,222.22
$0.00
$7,005.56
($5,055.56)
($486.11)
Sales
Collection--discount cust.
Collection--nondiscount cust.
Variable cost
Collection costs
Required rate of return, r/360
0.0306%
0.0306%
KEY OUTPUT:
Net present value
$1,522.87
$1,389.38
MODEL GENERATED DATA:
Cash Flows of Existing Policy:
Outflow on Day
Inflow on Day
Inflow on Day
($6,250.00)
$0.00
$7,916.67
60
Cash Flows of Proposed Policy:
Outflow on Day
Inflow on Day
Inflow on Day
($5,541.67)
$0.00
$7,005.56
35
Transcribed Image Text:INPUT DATA: Old New Annual Data: Sales $3,000,000 $2,600,000 Variable cost ratio 70.0% 70.0% $2,100,000 $150,000 $1,820,000 $175,000 Variable cost Collection costs Bad debt percent 5.0% 3.0% DSO--discount customers DSO--nondiscount customers 60 35 Cash discount 0.0% 0.0% % discount customers 0.0% 0.0% % nondiscount customers 100.0% 100.0% Required rate of return, r 11.0% 11.0% Daily Data (360 days): $8,333.33 $0.00 $7,916.67 ($5,833.33) ($416.67) $7,222.22 $0.00 $7,005.56 ($5,055.56) ($486.11) Sales Collection--discount cust. Collection--nondiscount cust. Variable cost Collection costs Required rate of return, r/360 0.0306% 0.0306% KEY OUTPUT: Net present value $1,522.87 $1,389.38 MODEL GENERATED DATA: Cash Flows of Existing Policy: Outflow on Day Inflow on Day Inflow on Day ($6,250.00) $0.00 $7,916.67 60 Cash Flows of Proposed Policy: Outflow on Day Inflow on Day Inflow on Day ($5,541.67) $0.00 $7,005.56 35
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 20 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Which credit policy produces the highest value for Muscarella Corporation?

 

Solution
Bartleby Expert
SEE SOLUTION
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
  • SEE MORE 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