FIN200 Loan Scenarios
Loan Scenarios
Midland Chemical Co. is negotiating a loan from Manhattan Bank and Trust. The small chemical company needs to borrow $500,000.
The bank offers a rate of 8 ¼ percent with a 20 percent compensating balance requirement, or as an alternative, 9 ¾ percent with additional fees of $5,500 to cover services the bank is providing. In either case the rate on the loan is floating (changes as the prime interest rate changes). The loan would be for one year.
A. Which loan carries the lower effective rate? Consider fees to be the equivalent of other interest. Compensating Balance Loan
$500,000 at 8.25% = $ 41,250 Interest
$500,000 Loan - $100,000 (20% compensating balance requirement)
$400,000 Available funds
Fee-added Loan
$500,000 at 9.75%
$ 48,750 Interest plus fees
5,500 Fees
48,750+5,500= $54,250
The loan with the compensating requirement has the lower effective cost (10.312%/10.850%).
B. If the loan with a 20 percent compensating balance requirement were to be paid off in 12 monthly payments, what would the effective rate be? (Principal equals amount borrowed minus the compensating balance.)
Effective rate on installment loan (2 x annual no. payments x interest)/(total no. of payments + 1) x principal (2 x 12 x $41,250)/(12 + 1) x $400,000 $990,000/5,200,000 19.038%
C. Assume the proceeds from the loan with the compensating balance requirement will be used to take cash discounts. Disregard part b about installment payments and use the loan cost from part a.
If the terms of the cash discount are 1.5/10, net 50, should the firm borrow the funds to take the discount?
The cost of not taking the cash discount is greater than the cost of the loan (13.680% vs. 10.312%) so the firm should take the cash discount.
D. Assume the firm actually takes 80 days to pay its bills and would continue to do so in the future if it did not take the cash discount. Should the company take the cash discount?
Yes, the
Midland Chemical Co. is negotiating a loan from Manhattan Bank and Trust. The small chemical company needs to borrow $500,000.
The bank offers a rate of 8 ¼ percent with a 20 percent compensating balance requirement, or as an alternative, 9 ¾ percent with additional fees of $5,500 to cover services the bank is providing. In either case the rate on the loan is floating (changes as the prime interest rate changes). The loan would be for one year.
A. Which loan carries the lower effective rate? Consider fees to be the equivalent of other interest. Compensating Balance Loan
$500,000 at 8.25% = $ 41,250 Interest
$500,000 Loan - $100,000 (20% compensating balance requirement)
$400,000 Available funds
Fee-added Loan
$500,000 at 9.75%
$ 48,750 Interest plus fees
5,500 Fees
48,750+5,500= $54,250
The loan with the compensating requirement has the lower effective cost (10.312%/10.850%).
B. If the loan with a 20 percent compensating balance requirement were to be paid off in 12 monthly payments, what would the effective rate be? (Principal equals amount borrowed minus the compensating balance.)
Effective rate on installment loan (2 x annual no. payments x interest)/(total no. of payments + 1) x principal (2 x 12 x $41,250)/(12 + 1) x $400,000 $990,000/5,200,000 19.038%
C. Assume the proceeds from the loan with the compensating balance requirement will be used to take cash discounts. Disregard part b about installment payments and use the loan cost from part a.
If the terms of the cash discount are 1.5/10, net 50, should the firm borrow the funds to take the discount?
The cost of not taking the cash discount is greater than the cost of the loan (13.680% vs. 10.312%) so the firm should take the cash discount.
D. Assume the firm actually takes 80 days to pay its bills and would continue to do so in the future if it did not take the cash discount. Should the company take the cash discount?
Yes, the