ISPMT counts each period beginning with zero, not with one. Most loans use a repayment schedule with even periodic payments. The IPMT function returns the interest payment for a given period for this type of loan. Some loans use a repayment schedule with even principal payments. The ISPMT func...