In: Finance
Parramore Corp has $13 million of sales, $2 million of inventories, $2 million of receivables, and $2 million of payables. Its cost of goods sold is 85% of sales, and it finances working capital with bank loans at an 7% rate. Assume 365 days in year for your calculations. Do not round intermediate steps.
What is Parramore's cash conversion cycle (CCC)? Do not round
intermediate calculations. Round your answer to two decimal
places.
days
If Parramore could lower its inventories and
receivables by 7% each and increase its payables by 7%, all without
affecting sales or cost of goods sold, what would be the new CCC?
Do not round intermediate calculations. Round your answer to two
decimal places.
days
How much cash would be freed up, if Parramore could
lower its inventories and receivables by 7% each and
increase its payables by 7%, all without affecting sales or cost of
goods sold? Do not round intermediate calculations. Round your
answer to the nearest cent. Write out your answer completely. For
Example, 13.2 million should be entered as 13,200,000.
$
By how much would pretax profits change, if Parramore could lower its inventories and receivables by 7% each and increase its payables by 7%, all without affecting sales or cost of goods sold? Do not round intermediate calculations. Round your answer to the nearest cent. Write out your answer completely. For Example, 13.2 million should be entered as 13,200,000.
1) | Days sales outstanding (DSO) = Receivables*365/Net sales = 2*365/13 = | 56 | Days |
Days inventory outstanding (DIO) = Inventory*365/Cost of goods sold = 2*365/(13*85%) = | 66 | Days | |
Days payables outstanding (DPS) = Payables*365/Cost of goods sold = 2*365/(13*85%) = | 66 | Days | |
Cash Conversion Cycle = DSO+DIO-DPO = 56+66-66 = | 56 | Days | |
2) | Days sales outstanding (DSO) = Receivables*365/Net sales = 2*0.93*365/13 = | 52 | Days |
Days inventory outstanding (DIO) = Inventory*365/Cost of goods sold = 2*0.93*365/(13*85%) = | 61 | Days | |
Days payables outstanding (DPS) = Payables*365/Cost of goods sold = 2*1.07*365/(13*85%) = | 71 | Days | |
Cash Conversion Cycle = DSO+DIO-DPO = 52+61-71 = | 42 | Days | |
4) | Reduction in CCC = 56-42 = 14 Days. | ||
Amount locked up = 13000000*85%*14/365 = | $ 4,23,836 | ||
5) | Increase in pretax profits = Interest saved = 423836*7% = | $ 29,668 |