Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help making an amortization schedule
Hi,
I tried to amortize my mortgage and was unable to get it to work right. I used this formula that I found in Excel's help screens: PMT(rate,nper,pv,fv,type) and I entered these values in it: =PMT((6%/365)*30,360,128000,0,0)*-1 It expresses: $767 for the mortage amt. Is this the right way to go about this? Thanks, Mike ps: if anyone can point me to a templete that would be much appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help making an amortization schedule
Try this link:
http://office.microsoft.com/en-us/te...CT101443641033 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "~Mike Hollywood" wrote in message ... Hi, I tried to amortize my mortgage and was unable to get it to work right. I used this formula that I found in Excel's help screens: PMT(rate,nper,pv,fv,type) and I entered these values in it: =PMT((6%/365)*30,360,128000,0,0)*-1 It expresses: $767 for the mortage amt. Is this the right way to go about this? Thanks, Mike ps: if anyone can point me to a templete that would be much appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help making an amortization schedule
Hey Ragdyer,
Thanks a million! That's just what I was trying to do. Mike "Ragdyer" wrote in message ... Try this link: http://office.microsoft.com/en-us/te...CT101443641033 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "~Mike Hollywood" wrote in message ... Hi, I tried to amortize my mortgage and was unable to get it to work right. I used this formula that I found in Excel's help screens: PMT(rate,nper,pv,fv,type) and I entered these values in it: =PMT((6%/365)*30,360,128000,0,0)*-1 It expresses: $767 for the mortage amt. Is this the right way to go about this? Thanks, Mike ps: if anyone can point me to a templete that would be much appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help making an amortization schedule
You're welcome, and thank you for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "~Mike Hollywood" wrote in message ... Hey Ragdyer, Thanks a million! That's just what I was trying to do. Mike "Ragdyer" wrote in message ... Try this link: http://office.microsoft.com/en-us/te...CT101443641033 -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "~Mike Hollywood" wrote in message ... Hi, I tried to amortize my mortgage and was unable to get it to work right. I used this formula that I found in Excel's help screens: PMT(rate,nper,pv,fv,type) and I entered these values in it: =PMT((6%/365)*30,360,128000,0,0)*-1 It expresses: $767 for the mortage amt. Is this the right way to go about this? Thanks, Mike ps: if anyone can point me to a templete that would be much appreciated. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help making an amortization schedule
thanks, that was exactly what I was looking for.
Mike "Ragdyer" wrote in message ... Try this link: http://office.microsoft.com/en-us/te...CT101443641033 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "~Mike Hollywood" wrote in message ... Hi, I tried to amortize my mortgage and was unable to get it to work right. I used this formula that I found in Excel's help screens: PMT(rate,nper,pv,fv,type) and I entered these values in it: =PMT((6%/365)*30,360,128000,0,0)*-1 It expresses: $767 for the mortage amt. Is this the right way to go about this? Thanks, Mike ps: if anyone can point me to a templete that would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
amortization schedule | Charts and Charting in Excel | |||
Amortization Schedule | Excel Worksheet Functions | |||
amortization schedule | Excel Discussion (Misc queries) | |||
Creating an Amortization schedule ? | Excel Discussion (Misc queries) | |||
Amortization Schedule | Excel Worksheet Functions |