In: Finance
A company borrowed $10 million for five years form Atlantic Bank. The company pays Atlantic Bank a fixed annual rate of 8 percent and must pay back the $10 million loan at the end of the borrowing period. A year has passed since the loan was made and Atlantic Bank wants to sell the loan to pacific bank.
a. If the interest rate is now 7 percent, what is the value of the loan?
b. What would be the value of the loan if the company is paying the bank 4 percent every 6 months instead of 8 percent per year?
Please list all steps
a. The value of the loan if the interest rate is now 7 percent:
| Principal Payment | Interest Payment | Total Payment | PVF @ 7% | Present Value | |
|---|---|---|---|---|---|
| Year 1 | 0 | 800000 | 800000 | 0.9346 | 747664 | 
| Year 2 | 0 | 800000 | 800000 | 0.8734 | 698751 | 
| Year 3 | 0 | 800000 | 800000 | 0.8163 | 653038 | 
| Year 4 | 0 | 800000 | 800000 | 0.7629 | 610316 | 
| Year 5 | 10000000 | 800000 | 10800000 | 0.7130 | 7700251 | 
| Value of Loan | 10410020 | ||||
b. The value of the loan if the company is paying the bank 4 percent every 6 months instead of 8 percent per year:
| Principal Payment | Interest Payment | Total Payment | PVF @ 3.5% | Present Value | |
|---|---|---|---|---|---|
| Year 0.5 | 0 | 400000 | 400000 | 0.9662 | 386473 | 
| Year 1 | 0 | 400000 | 400000 | 0.9335 | 373404 | 
| Year 1.5 | 0 | 400000 | 400000 | 0.9019 | 360777 | 
| Year 2 | 0 | 400000 | 400000 | 0.8714 | 348577 | 
| Year 2.5 | 0 | 400000 | 400000 | 0.8420 | 336789 | 
| Year 3 | 0 | 400000 | 400000 | 0.8135 | 325400 | 
| Year 3.5 | 0 | 400000 | 400000 | 0.7860 | 314396 | 
| Year 4 | 10000000 | 400000 | 10400000 | 0.7594 | 7897880 | 
| Value of Loan | 8874466 | ||||