Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Use Solver Tool in Excel
  • Managing Conditional Formatting Rules in Excel
  • Add Outline to Data in Excel
  • Randomize/ Shuffle List in Excel
  • Working With Tables in Excel

References

  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Multi-criteria lookup and transpose in Excel
  • How to use Excel FORMULATEXT function
  • Lookup entire row in Excel
  • Vlookup Examples in Excel

Data Validations

  • Excel Data validation require unique number
  • Excel Data validation allow uppercase only
  • Excel Data validation with conditional list
  • Excel Data validation number multiple 100
  • Excel Data validation date in next 30 days

ISPMT function: Description, Usage, Syntax, Examples and Explanation

by

What is ISPMT function in Excel?

ISPMT function is one of the Financial functions in Microsoft Excel that calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.

Syntax of ISPMT function

ISPMT(rate, per, nper, pv)

The ISPMT function syntax has the following arguments:

Argument Description
Rate Required. The interest rate for the investment.
Per Required. The period for which you want to find the interest, and must be between 1 and Nper.
Nper Required. The total number of payment periods for the investment.
Pv Required. The present value of the investment. For a loan, Pv is the loan amount.

ISPMT formula explanation

  • Make sure that you are consistent about the units you use for specifying Rate and Nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12/12 for Rate and 4*12 for Nper. If you make annual payments on the same loan, use 12% for Rate and 4 for Nper.
  • For all the arguments, the cash you pay out, such as deposits to savings or other withdrawals, is represented by negative numbers; the cash you receive, such as dividend checks and other deposits, is represented by positive numbers.
  • 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 function returns the interest payment for a given period for this type of loan.
  • To illustrate, the amortization table below uses an even-principal repayment schedule. The interest charge each period is equal to the Rate times the unpaid balance for the previous period. And the payment each period is equal to the even principal plus the interest for the period.
 

Post navigation

Previous Post:

MDURATION function: Description, Usage, Syntax, Examples and Explanation

Next Post:

IRR function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to return blank in place of #DIV/0! error in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • Return blank if in Excel
  • IF with wildcards in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • TODAY function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate next day of week in Excel
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Basic timesheet formula with breaks in Excel

Grouping

  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel
  • Running count group by n size in Excel

General

  • How to fill cell ranges with random text values in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • How to count total columns in range in Excel
  • Subtotal by color in Excel
  • How to choose page/paper size in Excel before Printing
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning