A firm needs to arrange financing for its expansion program. One bank offers to lend the required $1,000,000 on a loan which requires interest to be paid at the End of each Quarter. The quoted rate is 10 percent, and the principal must be repaid at the End of the year. A second lender offers 9 percent, daily compounding (365-day year), with interest and principal due at the end of the year. What is the difference in the effective annual rates (EFF%) charged by the two banks?
Please see the attached Excel file (you can see the formulas used in the cells; alternatively, computations could have been done using Excel function EFFECT).