Hi. You can do the above calculation with in-built function "EFFECT" in Excel. Put the Nominal rate = 8.5% and Npery = 12 as one year has 12 months i.e. 12 times compounding in one year.
Sep 04 2012 02:31 PM
However, remembering the formula is a nice thing to do.