Dellvoe had expected a really strong market for office equipment for the year just ended, and in anticipation of strong sales, the firm increased its inventory purchases. However, sales for the last quarter of the year did not meet its expectations, and now Dellvoe finds itself short on cash. The firm expects that its cash shortage will be temporary, only lasting 3 months. (The inventory has been paid for and cannot be returned to suppliers.) Dellvoe has decided to use inventory financing to meet its short-term cash needs. It estimates that it will require $800,000 for inventory financing during this three-month period. Dellvoe has negotiated with the bank for a three-month, $1,000,000 line of credit with terms of 10% annual interest on the used portion, a 1% commitment fee on the unused portion, and a $125,000 compensating balance at all times.
Expected inventory levels to be financed are as follows:
Month Amount
January $800,000
February 500,000
March 300,00
A. Calculate the cost of funds from this source, including interest charges and commitment fees. (Hint: Each month’s borrowings will be $125,000 greater than the inventory level to be financed because of the compensating balance requirement.)
January | February | March | |
Total Limit | 1000000 | 1000000 | 1000000 |
Used limit | 800000 | 500000 | 300000 |
Compensating Balance | 125000 | 125000 | 125000 |
Total Chargeable balance | 925000 | 625000 | 425000 |
Unused Balance | 75000 | 375000 | 575000 |
Interest (Chargeable Balance * (10%/12) | 7708.33 | 5208.33 | 3541.67 |
Commitment Fee (Unused Balance * (1%/12) | 62.5 | 312.5 | 479.17 |
Total (Interest + Commitment Fee) | 7770.83 | 5520.83 | 4020.84 |
Total Funding Cost (Sum of Total cost of 3 months) | 17312.5 |
Total Limit Utilized (Sum of Limit Utilized for 3 months) | 1600000 |
Finance Cost (Monthly) | 1.082% |
Finance Cost (Annually) | 12.984% |
Get Answers For Free
Most questions answered within 1 hours.