How to calculate periodic interest rate in excel

Example: Assume you have an APY or APR of 10%. What is your monthly interest rate, and how much would you pay or earn on $2,000? Convert the annual rate from a percent to a decimal by dividing by 100: 10/100 = 0.10 Now divide that number by 12 to get the monthly interest rate in decimal ................
................