Construct a spreadsheet to convert a nominal interest rate compounded m times per year i^(m) and convert it to an effective rate j_n per 1/n of a year. On the same spreadsheet, also start with an effective rate j_m per 1/m of a year and convert it to a nominal rate i⁽ⁿ⁾ compounded n times per year. Use your spreadsheet to solve the following two problems:

Given the nominal rate i⁽²⁾ = 8.125%, find the equivalent effective bi-weekly rate.

.

Given the effective bi-weekly rate j₂₆ = 0.307%, find the equivalent nominal rate i⁽²⁾.