View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wen22222 wen22222 is offline
external usenet poster
 
Posts: 1
Default financial function

Hello. I just bought a house and used the PMT and PPMT function to
calcualate payments, interest, principal on my loan. Is there a function to
calculate the effect of paying additional principal? For instance, the PMT
function calculates a monthly payment of 878.23. I want to be able to figure
out how much time will be cut off if I paid 950 per month.

Thanks.
Wendy