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

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

something simple that may work for you. just test it to make sure.



a2 7.5%
a3 360
a4 392,000

b6 =(PMT($A$2/12, $A$3, $A$4))*-1
c6 =(IPMT($A$2/12, $A$3*3, $A$4/12, $A$4-D5))*-1
d6 =B6-C6
b7 =(PMT($A$2/12, $A$3, $A$4))*-1
c7 =(IPMT($A$2/12, $A$3*3, $A$4/12, $A$4-SUM($D$5:D6)))*-1
c8 =B7-C7

replicate b7:d7 down


--


Gary


"Pammy" wrote in message
...
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