{"id":14149,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/pagoprin\/"},"modified":"2021-02-26T08:56:15","modified_gmt":"2021-02-26T08:56:15","slug":"ppmt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/ppmt\/","title":{"rendered":"PAGOPRIN"},"content":{"rendered":"

Descripci\u00f3n General<\/h2>\n

La funci\u00f3n PAGOPRIN en Microsoft Excel y PPMT en Google Sheets son esenciales para calcular el componente principal de los pagos de un pr\u00e9stamo para un per\u00edodo espec\u00edfico, asumiendo una tasa de inter\u00e9s constante durante la vida del pr\u00e9stamo. Son herramientas muy \u00fatiles para analizar la amortizaci\u00f3n de un pr\u00e9stamo, es decir, c\u00f3mo se reduce el saldo principal con cada pago efectuado.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis para estas funciones es:<\/p>\n

PAGOPRIN(tasa, per\u00edodo, nper, va, [vf], [tipo])<\/code><\/pre>\n
    \n
  • tasa<\/code>: La tasa de inter\u00e9s por per\u00edodo.<\/li>\n
  • per\u00edodo<\/code>: El per\u00edodo espec\u00edfico para el que se calcula el pago principal, debe ser un n\u00famero entero entre 1 y nper.<\/li>\n
  • nper<\/code>: El n\u00famero total de per\u00edodos de pago en la vida del pr\u00e9stamo.<\/li>\n
  • va<\/code>: El valor actual o el monto total del pr\u00e9stamo al inicio.<\/li>\n
  • vf<\/code> (opcional): El valor futuro o saldo deseado tras el \u00faltimo pago, cuyo valor por defecto es 0.<\/li>\n
  • tipo<\/code> (opcional): Indica el momento de los pagos dentro del per\u00edodo, donde 0 es al final y 1 al comienzo.<\/li>\n<\/ul>\n
    Ejemplo en Excel:<\/p>\n
    =PAGOPRIN(5%\/12, 1, 24, 10000)<\/code><\/pre>\n
    Este c\u00e1lculo muestra el pago del principal en el primer mes de un pr\u00e9stamo de $10,000, a ser pagado en 24 meses, con una tasa de inter\u00e9s anual de 5%.<\/p>\n
    Ejemplo en Google Sheets:<\/p>\n
    =PPMT(5%\/12, 1, 24, 10000)<\/code><\/pre>\n
    Este resulta en un pago principal id\u00e9ntico al del ejemplo de Excel para el primer mes bajo las mismas condiciones.<\/p>\n
    Escenarios Pr\u00e1cticos<\/h2>\n
    Este tipo de c\u00e1lculo es \u00fatil en diversas situaciones financieras:<\/p>\n
    1. C\u00e1lculo de pagos de un pr\u00e9stamo automotriz<\/h2>\n
    Si planeas comprar un autom\u00f3vil nuevo con un pr\u00e9stamo de $15,000 a 3 a\u00f1os y una tasa de inter\u00e9s anual del 6.5%, puedes calcular:<\/p>\n
    =PAGOPRIN(6.5%\/12, 1, 36, 15000)<\/code><\/pre>\n
    Este c\u00e1lculo mostrar\u00e1 cu\u00e1nto de tu primer pago mensual se destina al principal del pr\u00e9stamo automotriz.<\/p>\n
    2. Planificaci\u00f3n financiera personal<\/h2>\n
    Al considerar refinanciar tu vivienda, podr\u00edas querer saber c\u00f3mo afectar\u00eda a tu presupuesto mensual cambiar los t\u00e9rminos del pr\u00e9stamo. Por ejemplo, para un pr\u00e9stamo hipotecario de $200,000 a un inter\u00e9s del 4% y un plazo de 30 a\u00f1os, podr\u00edas calcular:<\/p>\n
    =PAGOPRIN(4%\/12, 1, 360, 200000)<\/code><\/pre>\n
    Este c\u00e1lculo te permite ver cu\u00e1nto de tu primer pago se aplicar\u00e1 al principal, lo cual ayuda a tomar decisiones informadas sobre el refinanciamiento, basadas en c\u00f3mo var\u00edan los componentes de los pagos con diferentes tasas de inter\u00e9s y plazos.<\/p>\n
    Al entender la aplicaci\u00f3n y los resultados de la funci\u00f3n PAGOPRIN o PPMT, los usuarios pueden gestionar sus finanzas de manera m\u00e1s eficaz y tomar decisiones conscientes sobre c\u00f3mo sus pagos impactan el saldo principal de sus deudas a largo plazo.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el pago de capital de una inversi\u00f3n durante un per\u00edodo determinado<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[536],"tags":[],"class_list":["post-14149","post","type-post","status-publish","format-standard","hentry","category-finanzas"],"acf":[],"yoast_head":"\nFunci\u00f3n PPMT (PAGOPRIN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PPMT (PAGOPRIN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\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\/es\/ppmt\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n PPMT (PAGOPRIN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PPMT (PAGOPRIN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/ppmt\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:56:15+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n PPMT (PAGOPRIN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/ppmt\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/ppmt\/\",\"name\":\"Funci\u00f3n PPMT (PAGOPRIN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:56:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n PPMT (PAGOPRIN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/ppmt\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/ppmt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/ppmt\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finanzas\",\"item\":\"https:\/\/functiontranslator.com\/es\/finanzas\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PAGOPRIN\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n PPMT (PAGOPRIN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n PPMT (PAGOPRIN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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\/es\/ppmt\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n PPMT (PAGOPRIN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n PPMT (PAGOPRIN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/ppmt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:56:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n PPMT (PAGOPRIN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/ppmt\/","url":"https:\/\/functiontranslator.com\/es\/ppmt\/","name":"Funci\u00f3n PPMT (PAGOPRIN) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:56:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n PPMT (PAGOPRIN) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/ppmt\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/ppmt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/ppmt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Finanzas","item":"https:\/\/functiontranslator.com\/es\/finanzas\/"},{"@type":"ListItem","position":3,"name":"PAGOPRIN"}]},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14149"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14149\/revisions"}],"predecessor-version":[{"id":30240,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14149\/revisions\/30240"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}