FIN-450 Week 5 Chapter 16 Practice Problems
FIN-450 Week 5 Chapter 16 Practice Problems
Intermediate Finance - Capital Budgeting
Grand Canyon University
Complete the following problems from Chapter 16 in the textbook:
Follow these instructions for completing and submitting your assignment:
1. Do all work in Excel. Do not submit Word files or *.pdf files.
2. Submit a single spreadsheet file for this assignment. Do not submit multiple files.
3. Place each problem on a separate spreadsheet tab.
4. Label all inputs and outputs and highlight your final answer.
5. Follow the directions in "Guidelines for Developing Spreadsheets."
You are not required to submit this assignment to Turnitin.
1.P16-6 Cash discount decisions Prairie Manufacturing has four possible suppliers, all of which offer different credit terms. Except for the differences in credit terms, their products and services are virtually identical. The credit terms offered by these suppliers are shown in the following table. (Note: Assume a 365-day year.)
a. Calculate the approximate cost of giving up the cash discount from each supplier.
b. If the firm needs short-term funds, which are currently available from its commercial bank at 9%, and if each of the suppliers is viewed separately, which, if any, of the suppliers’ cash discounts should the firm give up? Explain why.
c. Now assume that the firm could stretch by 30 days its accounts payable (net period only) from supplier M. What impact, if any, would that have on your answer in part b relative to this supplier?
2. P16-13 Compensating balance versus discount loan Weathers Catering Supply, Inc., needs to borrow $150,000 for 6 months. State Bank has offered to lend the funds at a 9% annual rate subject to a 10% compensating balance. (Note: Weathers currently maintains $0 on deposit in State Bank.) Frost Finance Co. has offered to lend the funds at a 9% annual rate with discount-loan terms. The principal of both loans would be payable at maturity as a single sum.
a. Calculate the effective annual rate of interest on each loan.
b. What could Weathers do that would reduce the effective annual rate on the State Bank loan?
3. P16-15 Cost of commercial paper Commercial paper is usually sold at a discount. Fan Corporation has just sold an issue of 90-day commercial paper with a face value of $1 million. The firm has received initial proceeds of $978,000. (Note: Assume a 365-day year.)
a. What effective annual rate will the firm pay for financing with commercial paper, assuming that it is rolled over every 90 days throughout the year?
b. If a brokerage fee of $9,612 was paid from the initial proceeds to an investment banker for selling the issue, what effective annual rate will the firm pay, assuming that the paper is rolled over every 90 days throughout the year?
4. P16-20 Inventory financing Raymond Manufacturing faces a liquidity crisis: It needs a loan of $100,000 for 1 month. Having no source of additional unsecured borrowing, the firm must find a secured short-term lender. The firm’s accounts receivable are quite low, but its inventory is considered liquid and reasonably good collateral. The book value of the inventory is $300,000, of which $120,000 is finished goods. (Note: Assume a 365-day year.)
(1) City-Wide Bank will make a $100,000 trust receipt loan against the finished goods inventory. The annual interest rate on the loan is 12% on the outstanding loan balance plus a 0.25% administration fee levied against the $100,000 initial loan amount. Because it will be liquidated as inventory is sold, the average amount owed over the month is expected to be $75,000.
(2) Sun State Bank will lend $100,000 against a floating lien on the book value of inventory for the 1-month period at an annual interest rate of 13%.
(3) Citizens’ Bank and Trust will lend $100,000 against a warehouse receipt on the finished goods inventory and charge 15% annual interest on the outstanding loan balance. A 0.5% warehousing fee will be levied against the average amount borrowed. Because the loan will be liquidated as inventory is sold, the average loan balance is expected to be $60,000.
a. Calculate the dollar cost of each of the proposed plans for obtaining an initial loan amount of $100,000.
b. Which plan do you recommend? Why?
c. If the firm had made a purchase of $100,000 for which it had been given terms of 2/10 net 30, would it increase the firm’s profitability to give up the discount and not borrow as recommended in part b? Why or why not?