To solve this problem, at least 2 common TVM formulae will be used repeatedly:
1 - PV=P{[1 + R]^N - 1.[1 + R]^-N} R^-1=PV OF $1 PER PERIOD
This formula will find the PV of $1 per period, or $12 for each year at their respective interest rates.
Then these PV's will be brought forward to the present, discounting them each year at their respective rates using this 2nd and very common TVM formula:
2- PV=FV[1 + R]^-N=PV OF $1 IN THE FUTURE.
Then these PV's for the 5 years will be added together to give us the PV of all 60 payments.
Then we simply divide $1,000,000(I'm taking it as $1,000,000. If it is $10,000,000, then just multiply everything by 10).
Doing it by hand will involve about a dozen calculations. However, my computer is already programmed with all these financial formulae and will arrive at the answer very rapidly. Plugging in all numbers, the computer gives the accumulated PV as=54.0611975224. Now we simply divide $1,000,000 by this number and we get the even monthly payment of:$1,000,000/54.0611975224
=$18,497.56. Sixty payments of this amount will be made to pay off the entire $1,000,000 loan in 5 years.
Total interest paid will be: $18,497.56 x 60 - $1,000,000=$109,853.31.
The overall cost to the Company, or the combined interest rate, will be=4.17932032174%.
Finally, amortization of this loan confirms that all these numbers are accurate.