The PMT function can be useful here. PMT is short for Payment. On the Excel screen, this function can be found using the command fx and under the category ‘Financial’. Periodic investments ...

The formula for the Rate function is Rate(nper, pmt,pv, [fv], [type], [guess]). The syntax for the Rate function is below: Nper : The total number of payment periods in an annuity.