Question

Dellvoe had expected a really strong market for office equipment for the year just ended, and...

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.)

Homework Answers

Answer #1
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%
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Dellvoe had expected a really strong market for office equipment for the year just ended, and...
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...
At the beginning of the year, a capital projects fund purchases $4 million in equipment for...
At the beginning of the year, a capital projects fund purchases $4 million in equipment for cash. The equipment has a 10-year life, straight-line. A year-end, this purchase reduces the capital projects fund's fund balance by Select one: A. $4 million. C. $3.6 million. D. No effect. A company uses futures to hedge a firm commitment to buy inventory. Which statement is true concerning the hedge? Select one: A. The company takes a short position in futures and records changes...
You work in the treasury department of a manufacturing company and have been tasked to prepare...
You work in the treasury department of a manufacturing company and have been tasked to prepare a short-term financial plan for the coming year. The projected sales forecasts for the next five quarters are, respectively, $210m, $180m, $245m, $280m, and $240m. The firm sells on credit and takes, on average, 30 days to collect from its customers; $68m in receivables are currently outstanding. Also, the firm orders a quarter in advance on credit—purchases in a given quarter is 60% of...
You work in the treasury department of a manufacturing company and have been tasked to prepare...
You work in the treasury department of a manufacturing company and have been tasked to prepare a short-term financial plan for the coming year. The projected sales forecasts for the next five quarters are, respectively, $210m, $180m, $245m, $280m, and $240m. The firm sells on credit and takes, on average, 30 days to collect from its customers; $68m in receivables are currently outstanding. Also, the firm orders a quarter in advance on credit—purchases in a given quarter is 60% of...
Potter Corporation sells office supplies to government agencies. At the beginning of the current quarter, the...
Potter Corporation sells office supplies to government agencies. At the beginning of the current quarter, the company reports the following selected account balances:   Current quarter account balances:   Cash 10,000   Accounts Receivables 200,000   Current Payable 85,000   Potter's management has made the following budget estimates regarding operations for the current quarter:   Sales (estimated) 500,000   Total cost and expenses (estimated) 400,000 (see breakdown below) Debt service payment (estimated) 145,000   Tax liability payment (estimated) 45,000   Of Potter's total costs and expenses, $30,000 is quarterly...
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer...
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer Prime Products has just approached the company’s bank with a request for a $51,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debit Credit Cash $ 46,000 Accounts receivable 204,800 Inventory 58,650 Buildings and equipment (net) 356,000 Accounts payable $ 86,925 Common stock 500,000 Retained earnings 78,525 $ 665,450 $ 665,450...
Only a Game Inc. Cash Budgeting This really is great! We’ve only been producing the “Sticky...
Only a Game Inc. Cash Budgeting This really is great! We’ve only been producing the “Sticky Fingers” for six months and look at the profits. Sales projections for the future go nowhere but up, up, up! I’m going to take my family on a well-deserved vacation. They’ve put up with a lot; I haven’t been home much at all getting this started. We need some quality time together. All this hectic activity has left me mighty tired, so a break...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 113,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 114,000 Expected unit sales for March 2020 117,000 Expected unit sales for April 2020 124,000...
Bobcat Coffee had sales of goods totaling $200,000, receiving $150,000 in cash and $50,000 on account....
Bobcat Coffee had sales of goods totaling $200,000, receiving $150,000 in cash and $50,000 on account. The cost of the goods sold were $60,000. Bobcat Coffee purchased $80,000 of inventory. All purchases were on account. Bobcat Coffee paid salaries of $50,000. This was payment for salaries of $35,000 and $15,000 that was payable from last year. Bobcat Coffee purchased $7,000 of supplies. All of these purchases were on account. Bobcat Coffee received $40,000 cash from customers who had been granted...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT