Hi Jacustomer, Just send the info over and I will take a look...Thanks!
Collins Office Supplies is considering a more liberal credit policy to increase sales, but expects that 9 percent of the new accounts will be uncollectible. Collection costs are 5 percent of new sales; production and selling costs are 78 percent; and accounts receivable turnover is five times. Assume income taxes of 30 percent and an increase in sales of $80,000. No other asset buildup will be required to service the new accounts.
a. What is the level of accounts receivable to support this sales expansion?
b. What would be Collin's incremental aftertax return on investment?
c. Should Collins liberalize credit if a 15 percent aftertax return on investment is required?
Assume that Collins also needs to increase its level of inventory to support new sales and that inventory turnover is four times.
d. What would be the total incremental investment in accounts receivable and inventory to support a $80,000 increase in sales?
e. Given the income determined in part b and the investment determined in part d, should Collins extend more liberal credit terms?
Here is the question I will upload what I have so far on my excel spreadsheet and let me know what you think.
here is what I have http://www.sendspace.com/file/fk5e8mI have done the work but need it double checked, and if need be we can discuss price
Hi Jacustomer, Is your stuff just the written answers and the yellow highlighted cells?
Hi Jacustomer, Here is your answer: Please click here I read the rubrics so didnt change anything but the written stuff in the box and the yellow cells.