You want the PMT Function. It will look like this...

=PMT(0.075/12, 12*30, -500000+108000, 0)
The answer is $2,740.92

--
HTH...

Jim Thomlinson


"Pammy" wrote:

I need to program a spreadsheet for a 30 year fixed mortgage on an amount of
500k with 108 down, 12 pymts a year. 7.5 rate