Payment Calculator not working correctly

S

SwimBob

Recently I tried to program an Excel spreadsheet to calculate a mortgage
Payment using the =PMT(Rate/12,Term,Loan Amount)*-1 formula that I have used
on many other spreadsheets. These older spreadsheets all work properly, but
they were all written on another computer and imported into the one I am now
using. The formula “=PMT(10/12, 360,100000)*-1†should give me a payment of
$877.57, but it gives me $83,333.33 instead! Is their a flaw in the newer
Excel versions, or a patch I don’t have? Any help would be appreciated.
 
N

Niek Otten

No doubt you meant

=PMT(0.1/12,360,100000)*-1

(10% is .1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
¡

*¡¸ My-Ricky ¡¸*

it would certainly be a terrible world if the interest rate climb to 1000% pa!
HAHA
 

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

APR calculation for Mortgages with a balloon payment. 8
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
Interest and Payment Calculations 6
Payment calculator 1
Calculating interest due on late loan payments 1
payment calculation 3
APR Fee Calculation 1
PMT function question 2

Top