Effective annual interest rates
Bank A offers to lend $10,00 at a nominal rate of 7%, compounded monthly. The loan (principal plus interest) must be repaid at the end of the year. Bank B also offers to lend the $10,000, but it will charge 8%, with interest due at the end of the year. What is the difference in the effective annual rates charged by the two banks?
If there is an Excel formula for this I would appreciate to know it as well.
© BrainMass Inc. brainmass.com March 4, 2021, 8:23 pm ad1c9bdddfhttps://brainmass.com/economics/banking/effective-annual-interest-rates-164131
Solution Preview
See the attached file.
Bank A offers to lend $10,00 at a nominal rate of 7%, compounded monthly. The loan (principal plus interest) must be repaid at the end of the year. Bank B also offers to lend the $10,000, but it will charge 8%, with ...
Solution Summary
The difference in effective annual interest rates charged by two banks has been calculated. EXCEL worksheet function EFFECT that can be used for calculating the effective annual interest rate has also been explained.