[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content”][et_pb_column _builder_version=”4.27.2″ _module_preset=”default” type=”4_4″ theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – Automate between spreadsheets – 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=”50460″ theme_builder_area=”post_content”]![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/run-automatically-connect-sheet-icons.webp\"){kind=icon}
<\/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 between spreadsheets 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″ custom_margin=”||2px|||” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])<\/strong><\/p>\n <\/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 learned the syntax of the PV formula, let\u2019s try our\u00a0hands on it in practice on the Google Sheets application directly. Please consider the following snapshot.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/PV-formula-1.png” alt=”PV formula 1″ title_text=”PV formula 1″ _builder_version=”4.16″ _module_preset=”default” 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 In the first three formulas, we tried to calculate the present value of an investment that is spaced across 10 periods. The interest rate is 5% and the amount we are paying up is 750. While the first and third formulas are essentially representing the same thing, the second formula is a little interesting. All the parameter values in this formula are same, except the last one. So, the value 1 for the last parameter indicates that we are paying up at the end of the period, hence the difference in output.<\/p>\n Please note that this formula remains valid as long as the payment intervals remain spaced evenly. It doesn\u2019t matter if we make the payments monthly or even weekly. It is just that the interest rates vary accordingly. The fourth formula is an example of such calculation, for a monthly based investment series.<\/p>\n Functionality wise, we have a close sibling of the PV formula in Google Sheets \u2013 the\u00a0NPV<\/a>\u00a0<\/span>formula. While both of them return the present value of a series of investments, the PV formula is suitable for constant-amount future value cash flows. Whereas the NPV can handle the cash flows even if they are not of a consistent amount.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" All of us try and invest our money in some assets. So, we would definitely want to know how much value our future investments stand for, as of today. The\u00a0PVformula in Google Sheets helps us with just that. Given the periodic payment amount and the interest rate that doesn\u2019t change over time, it calculates\u00a0the present […]<\/p>\n","protected":false},"author":40,"featured_media":8380,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"All of us try and invest our money in some assets. So, we would definitely want to know how much value our future investments stand for, as of today. The PV<\/a> formula in Google Sheets helps us with just that. Given the periodic payment amount and the interest rate that doesn't change over time, it calculates the present value of an investment.\n
\n<\/span><\/p>\nSyntax<\/h3>\n
\n
Usage: PV formula in Google Sheets<\/h3>\n
Note<\/h4>\n
Syntax<\/h3>\nPV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])<\/strong>\n
\n \t
Usage: PV formula in Google Sheets<\/h3>\nNow that we learned the syntax of the PV formula, let's try our hands on it in practice on the Google Sheets application directly. Please consider the following snapshot.\n\n
![\"PV](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/PV-formula-Illustration-Frame-2.png\")
\n\nIn the first three formulas, we tried to calculate the present value of an investment that is spaced across 10 periods. The interest rate is 5% and the amount we are paying up is 750. While the first and third formulas are essentially representing the same thing, the second formula is a little interesting. All the parameter values in this formula are same, except the last one. So, the value 1 for the last parameter indicates that we are paying up at the end of the period, hence the difference in output.\n\nPlease note that this formula remains valid as long as the payment intervals remain spaced evenly. It doesn't matter if we make the payments monthly or even weekly. It is just that the interest rates vary accordingly. The fourth formula is an example of such calculation, for a monthly based investment series.\nNote<\/h4>\nFunctionality wise, we have a close sibling of the PV formula in Google Sheets - the NPV<\/a> formula. While both of them return the present value of a series of investments, the PV formula is suitable for constant-amount future value cash flows. Whereas the NPV can handle the cash flows even if they are not of a consistent amount.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8379","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\/8379","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=8379"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8379\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/8380"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}