present value

J

Joe

I'm using the PMT function to calculate the yearly payment
I have to make to a savings bank with interest. This is
not a loan.
TxtFutureAPR = 0.06
TxtYears = 20
TxtGoal = 50,000
TxtTotalInvesment = 5,000
TztTotalVal = 7,000
TxtDiffToAdd = 43,000

If I use =Pmt([txtFutureAPR],[txtYears],0,
[txtDiffToAdd])
The answer is -1168.93

If I use =Pmt([txtFutureAPR],[txtYears], [txtTotalVal] ,
[txtDiffToAdd])
The answer is -1779.23

How can this be?
If the present value is 7,000 I have to pay more?

Thanks
Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
PMT function question 2
APR calculation for Mortgages with a balloon payment. 8
FV function as an algebraic expression 4
financial function 1
Excel function calculations used in MS Access query 1
table doesn't work in 2007 1
different result with excel and calculator 1

Top