{"id":279,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/ispmt\/"},"modified":"2021-02-13T11:34:52","modified_gmt":"2021-02-13T11:34:52","slug":"ispmt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/ispmt\/","title":{"rendered":"ISPMT"},"content":{"rendered":"

Today, we’ll explore a valuable financial function known as ISPMT, which is available in both Microsoft Excel and Google Sheets. The ISPMT function is primarily utilized to calculate the interest portion of a payment for a given period in a loan or an investment, assuming fixed, periodic payments and a constant interest rate.<\/p>\n

Syntax<\/h2>\n

The syntax for the ISPMT function is consistent across both Excel and Google Sheets:<\/p>\n

ISPMT(interest_rate, period, number_of_periods, present_value)<\/code><\/pre>\n
    \n
  • interest_rate<\/code>: The interest rate per period.<\/li>\n
  • period<\/code>: The specific period for which the interest is being calculated.<\/li>\n
  • number_of_periods<\/code>: The total number of payment periods in the investment or loan.<\/li>\n
  • present_value<\/code>: The current value of the investment or loan.<\/li>\n<\/ul>\n
    Examples<\/h2>\n
    Let’s go through some examples to clarify how the ISPMT function operates:<\/p>\n
    Calculating Interest Payment for a Loan<\/h2>\n
    Imagine you have taken a loan of $10,000 at an annual interest rate of 5%, which you plan to repay over 5 years with monthly payments. You are interested in determining the interest portion of your first monthly payment.<\/p>\n\n\n\n\n\n\n\n
    Loan Details<\/th>\nCalculation<\/th>\n<\/tr>\n
    Loan Amount<\/td>\n$10,000.00<\/td>\n<\/tr>\n
    Interest Rate (Annual)<\/td>\n5%<\/td>\n<\/tr>\n
    Period<\/td>\n1<\/td>\n<\/tr>\n
    Number of Periods<\/td>\n5 * 12 = 60 (5 years with monthly payments)<\/td>\n<\/tr>\n
    Interest Payment (First Month)<\/td>\n=ISPMT(5%\/12, 1, 60, 10000)<\/code><\/td>\n<\/tr>\n<\/table>\n
    In this example, the ISPMT function calculates the interest portion of the first monthly payment.<\/p>\n
    Calculating Interest Income from an Investment<\/h2>\n
    Consider an investment of $50,000 in a bond that yields an annual interest rate of 3%, paid semi-annually over 3 years. You want to find out how much interest income will be earned in the second year.<\/p>\n\n\n\n\n\n\n\n
    Investment Details<\/th>\nCalculation<\/th>\n<\/tr>\n
    Investment Amount<\/td>\n$50,000.00<\/td>\n<\/tr>\n
    Interest Rate (Annual)<\/td>\n3%<\/td>\n<\/tr>\n
    Period<\/td>\n2<\/td>\n<\/tr>\n
    Number of Periods<\/td>\n3 * 2 = 6 (3 years with semi-annual payments)<\/td>\n<\/tr>\n
    Interest Income (Second Year)<\/td>\n=ISPMT(3%\/2, 2, 6, 50000)<\/code><\/td>\n<\/tr>\n<\/table>\n
    In this scenario, the ISPMT function helps in determining the interest income for the second year of the investment.<\/p>\n
    Utilizing the ISPMT function in Excel and Google Sheets can significantly streamline the process of calculating interest payments and income for various financial scenarios, thereby enhancing your ability to perform precise financial analysis and planning.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Calculates the interest paid during a specific period of an investment<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[199],"tags":[],"class_list":["post-279","post","type-post","status-publish","format-standard","hentry","category-financial"],"acf":[],"yoast_head":"\nExcel ISPMT Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel ISPMT function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/ispmt\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel ISPMT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel ISPMT function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/ispmt\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:34:52+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel ISPMT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/ispmt\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/ispmt\/\",\"name\":\"Excel ISPMT Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:34:52+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel ISPMT function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/ispmt\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/ispmt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/ispmt\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financial\",\"item\":\"https:\/\/functiontranslator.com\/en\/financial\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ISPMT\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel ISPMT Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel ISPMT function does. Clear syntax explanation and useful formula examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/en\/ispmt\/","og_locale":"en_US","og_type":"article","og_title":"Excel ISPMT Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel ISPMT function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/ispmt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:34:52+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel ISPMT Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/ispmt\/","url":"https:\/\/functiontranslator.com\/en\/ispmt\/","name":"Excel ISPMT Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:34:52+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel ISPMT function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/ispmt\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/ispmt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/ispmt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Financial","item":"https:\/\/functiontranslator.com\/en\/financial\/"},{"@type":"ListItem","position":3,"name":"ISPMT"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/279\/revisions"}],"predecessor-version":[{"id":3170,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/279\/revisions\/3170"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}