Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have a question that I must show work for and submit in Excel. The question (16.5) is in the revenue cycle and current accounts

I have a question that I must show work for and submit in Excel. The question (16.5) is in the revenue cycle and current accounts management chapter of my textbook. Thank you in advance for any assistance with the question!

image text in transcribed

16.5 Milwaukee Surgical Supplies, Inc., sells on terms of 3/10, net 30. Gross sales for the year are $1,200,000, and the collections department estimates that 30 percent of the customers pay on the tenth day and take discounts, 40 percent pay on the thirtieth day, and the remaining 30 percent pay, on average, 40 days after the purchase. (Assume 360 days per year.) a. What is the firm's average collection period? b. What is the firm's current receivables balance? c. What would be the firm's new receivables balance if Milwaukee Surgical toughened up on its collection policy, with the result that all nondiscount customers paid on the thirtieth day d. Suppose that the firm's cost of carrying receivables was 8 percent annually. How much would the toughened credit policy save the firm in annual receivables carrying expense? (Assume that the entire amount of receivables had to be financed.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

Customers have to repeat information they have already provided.

Answered: 1 week ago