The periodic rate is the nominal annual rate divided by the periods per year (r/ppy). The nominal annual rate is in cell B3 and the periods per year is recorded in cell B4. In cell B5, the periodic rate is given by this Excel formula:
=B3/B4
