In: Finance
Parramore Corp has $17 million of sales, $3 million of inventories, $2 million of receivables, and $1 million of payables. Its cost of goods sold is 70% of sales, and it finances working capital with bank loans at an 9% rate. Assume 365 days in year for your calculations. Do not round intermediate steps.
| Particulars | In millions | First Part | |||
| Income Statement | Working Capital (current Assets-Current Liabilities) | 4 | |||
| sales | 17 | ||||
| cogs | 11.9 | Account Receivable turnover (Sales/AR) | 8.5 | ||
| EBITDA | 5.1 | Inventory Turnover (COGS/I) | 3.966667 | ||
| D&A | 0 | Account Payable turnover (Net credit purchase/AP) | 14.9 | ||
| Interest | 0.36 | ||||
| EBT | 4.74 | Days of Receivables | 42.94118 | ||
| Days of Inventory | 92.01681 | ||||
| Balance Sheet | Days of Payable | 24.49664 | |||
| Current Assets | In millions | ||||
| Account Receivables (AR) | 2 | CCC | 110.4613 | ||
| Inventories (I) | 3 | CCC | 110.46 | ||
| Current Liabilities | In millions | ||||
| Accounts Payables (AP) | 1 | ||||
| Net Credit Purchase= COGS+I-Opening Inventory | 14.9 | ||||
| Opening Inventory | 0 | ||||
| Second Question | Account Receivable turnover (Sales/AR) | 9.23913 | |||
| AR | 1.84 | Inventory Turnover (COGS/I) | 4.311594 | ||
| I | 2.76 | Account Payable turnover (Net credit purchase/AP) | 13.57407 | ||
| AP | 1.08 | ||||
| Days of Receivables | 39.50588 | ||||
| Net credit Purchase | 14.66 | Days of Inventory | 84.65546 | ||
| Days of Payable | 26.8895 | ||||
| CCC | 97.27185 | ||||
| CCC | 97.27 | ||||
| Third Question | |||||
| Decrease in AR | 0.16 | ||||
| Decrease in Inventories | 0.24 | ||||
| Increase in payables | 0.08 | ||||
| Cash freed up (in millions) | 0.48 | ||||
| Cash freed up (in millions) | 480000 | ||||
| Fourth Question | |||||
| So new working capital (Current assets- current liabilities) | 3.52 | ||||
| Interest expenses | 0.3168 | ||||
| EBITDA | 5.1 | ||||
| D&A | 0 | ||||
| Interest expenses | 0.3168 | ||||
| EBT | 4.7832 | ||||
| Change in EBT | 0.0432 | ||||
| Change in EBT | 43200 |