The ispmt function is providing unexpected results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The ispmt funtion when calculating for period 1 should provide the same
answer as multiply the monthly interest rate times the principal balance
because no amortization has occured yet. The answer I'm getting is less than
what is correct. What wrong?
 
Hello:

The help file says that ISPMT is provided for compatibility with Lotus 1-2-3.
(in fact I don't think the later versions of Lotus had this function either,
version 9 has @ipaymt)
So unless you are using Lotus, IPMT function provides the answers you expected.

Pieter Vandenberg

: The ispmt funtion when calculating for period 1 should provide the same
: answer as multiply the monthly interest rate times the principal balance
: because no amortization has occured yet. The answer I'm getting is less than
: what is correct. What wrong?
 

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

ERRORS IN TVM FUNCTIONS IN EXCEL 2003? 1
mortgage ammortization schedule 7
Dynamic Sum Array Formula Input Help 3
Loan Principal Payments 1
sumproduct while number of added fields is changing? 2
mortgage payment calculation 12
Finding Cumulative Interest 2
date() function error 6

Back
Top