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’.