Skip to main content
I need to calculate the present value on mortgage amortization, and I'm having some trouble developing the formula for this calculation.  This is the calculation that I've got so far:

 

PV ((Discount Rate / 12), Number of Payments, -Payment, Future Value

 

I'm not sure what to use for the PV since it isn't an option in Saleforce.

 

Anyone have any ideas?
2 answers
  1. Aug 4, 2014, 3:45 PM
    Hey Sara,

     

    I'm not sure this is a SF question exactly, but I'm also a finance guy so I might be able to help you out!  I'm a little unclear on exactly what you need though.  In mortgage amortization the PV is usually the amount being financed (or the principal balance if you're somewhere within the repayment).

     

    Can you describe with some more detail exactly what you want calculated as well as what you have as known inputs (i.e. number of payments, etc)? 
0/9000