G
Guest
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
500k with 108 down, 12 pymts a year. 7.5 rate
G
Guest
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
=PMT(0.075/12, 12*30, -500000+108000, 0)
The answer is $2,740.92
G
Gary Keramidas
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
6)))*-1
c8 =B7-C7
replicate b7:d7 down
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
6)))*-1c8 =B7-C7
replicate b7:d7 down