Problem
You just purchased a home for $450,000 and put 20% down and obtained a mortgage for the balance. Based on a term of 30 years on a fully amortizing loan and a monthly mortgage payment of $1,770.98, what is your annual interest rate on this mortgage? Hint: solving for RATE in Excel.