[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – Automate beyond importrange – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50462″ theme_builder_area=”post_content”]![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Add-on-sm_sheets-connected-new-connection.webp\")
<\/p>\n
![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\n
Automate data transfers beyond Importrange<\/span><\/p>\n Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n PPMT(rate, period, number_of_periods, present_value, [future_value, end_or_beginning])<\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that we know what the PPMT formula is used for along with its syntax, let\u2019s dive head-first into the practical application.\u00a0With the help of a few examples, that is. Please have a look at the following image.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/PPMT-formula-Illustration-Frame-2.webp” alt=”PPMT Formula in Google Sheets” title_text=”ppmt-formula” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n One thing we know about the\u00a0<\/span>amortization<\/a>\u00a0<\/span>schedule is that we start paying more interest in the initial months than the later months. And the principal repayment is the opposite \u2013 we pay more at the end of the overall period than we do in the initial months.<\/p>\n We can clearly identify this pattern in the first three formula examples. The 5th-period principal payment is less than the 10th-period payment, which in turn is much less than the 60th-period principal payment.<\/p>\n We\u2019d encourage you to try and understand the multiple variations of these formulas we\u2019ve illustrated as examples. Analyze how each and every parameter value is affecting the output values. While we are at this, the\u00a0<\/span>PMT<\/a>\u00a0<\/span>formula might interest you as well. It calculates the overall payment (principal + interest) amount for an\u00a0amortization<\/span>\u00a0<\/span>period.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – One tool – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_colors_info=”{}” global_module=”50458″ theme_builder_area=”post_content”] One tool to merge, split, and filter all your spreadsheet data<\/span><\/p>\n Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Almost all of us at some point in our lives may opt for loans, against a prevailing interest rate. And we\u2019d be interested to know the principal we pay over the course of the repayment\u00a0schedule. How do we calculate that? The\u00a0PPMT\u00a0formula in Google Sheets can help us here \u2013 it stands for Principal Payment. The […]<\/p>\n","protected":false},"author":40,"featured_media":8392,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Almost all of us at some point in our lives may opt for loans, against a prevailing interest rate. And we'd be interested to know the principal we pay over the course of the repayment\u00a0schedule. How do we calculate that? The PPMT<\/a> formula in Google Sheets can help\u00a0us here - it stands for Principal Payment. The investment in question is based on a constant interest rate and also a constant-amount periodic payment schedule.\nSyntax<\/h3>\n
\n
Usage: PPMT formula in Google Sheets<\/h3>\n
Note<\/h4>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\")
<\/p>\n<\/p>\nSyntax<\/h3>\nPPMT(rate, period, number_of_periods, present_value, [future_value, end_or_beginning])<\/strong>\n
\n \t
Usage: PPMT formula in Google Sheets<\/h3>\nNow that we know what the PPMT formula is used for along with its syntax, let's dive head-first into the practical application.\u00a0With the help of a few examples, that is. Please have a look at the following image.\n\n
![\"PPMT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/PPMT-formula-Illustration-Frame-2.png\")
\n\nOne thing we know about amortization schedule is that we start paying the more interest in the initial months than the later months. And the principal repayment is the opposite - we pay more at the end of the overall period than we do in the initial months.\n\nWe can clearly identify this pattern in the first three formula examples. The 5th-period principal payment is less than the 10th-period payment, which in turn is much less than the 60th-period principal payment.\nNote<\/h4>\nWe'd encourage you to try and understand the multiple variations of these formulas we've illustrated as examples. Analyze how each and every parameter value is affecting the output values. While we are at this, the PMT<\/a> formula might interest you as well. It calculates the overall payment (principal + interest) amount for an amortization period.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=8391"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/8392"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}