Question: Please use Excel to answer, showing all work along with the answer. Thank You! You have been asked to assess the expected financial impact of

Please use Excel to answer, showing all work along with the answer. Thank You!

Please use Excel to answer, showing all work along with the answer.

You have been asked to assess the expected financial impact of each of the following proposals to improve the profitability of credit sales made by your company. Each proposal is independent of the other. Answer all questions. Showing your work may earn you partial credit. Proposal #2 would establish local collection centers throughout the region to decrease the time it takes to convert credit payments that are mailed in by check to cash. It is estimated that establishing these collection centers would reduce the average collection time by 2 days. 1) If the company currently averages $50,000 in collections per day, how many dollars will this suggested cash management system free up? 2) If all freed up dollars would be used to pay down debt that has an interest rate of 6%, how much money could be saved each year in interest expense? 3) Do the numbers suggest that this new system should be implemented if its total annual cost is $8000? Explain

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!