[\/et_pb_text][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_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.16″ border_width_left=”4px” global_colors_info=”{}” theme_builder_area=”post_content”]=NPV(discount, cashflow1, [cashflow2, \u2026])[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n NPV stands for Net Present Value. The concept of NPV is all about the time value of money \u2013 in short, money today is worth more than money in the future. That\u2019s not a complicated concept: if someone offered you a choice between $100 today and $100 a year from now, you\u2019d probably choose to get the money today. The degree to which the value of money changes over time is the discount rate. The higher the discount rate, the less valuable money is in the future.<\/p>\n NPV takes a series of cash flows and discounts them back to the present value (i.e. what they\u2019re worth today). The further in the future the cash flow is, the lower its present value. When you discount each cash flow and add them all up, you get the overall NPV.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that you\u2019ve seen the syntax of the NPV function, and understand what NPV actually means, I\u2019ll show an example to reinforce how the function is used.<\/p>\n Please take a look at the snapshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/04\/1.-NPV-example.png” alt=”npv formula google sheets” title_text=”1. NPV example” align=”center” _builder_version=”4.16″ _module_preset=”default” 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″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In this example, you have a $500 investment up front (denoted by the negative sign), and then a series of payments. At a discount rate of 8%, the NPV of this series of cash flows is $712.29.<\/p>\n You can either type the values into the function (as done in the first example) or just input the cell references and ranges that contain the values. The last method is generally easier.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/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":" Google Sheets is a great tool to perform financial calculations and analysis with. A typical example of this is that you might want to find the today’s value of an investment that will pay off in the future. The NPV formula in Google Sheets helps with just that. All you need to have is a […]<\/p>\n","protected":false},"author":40,"featured_media":33462,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"At some point in time, we get curious as to what is the today's value of an investment we are committing to. The NPV<\/a> formula in Google Sheets helps us with just that. All we need to have with us is a series of periodic investments and the discount rate for input values.\nSyntax<\/h3>\n
\n
What is NPV?<\/h3>\n
Usage: NPV formula in Google Sheets<\/h3>\n
Things to keep in mind<\/h3>\n
\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\")
<\/p>\n<\/p>\nSyntax<\/h3>\nNPV(discount, cashflow1, [cashflow2, ...])<\/strong>\n
\n \t
Usage: NPV formula in Google Sheets<\/h3>\nLet us now get our hands dirty with a practical application of this formula. Because we get a hang of a concept much better with the help of examples and practice. And as we'll observe, it is a pretty much straightforward application of the formula.\n\n
![\"NPV](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/NPV-formula-Illustration-Frame-1.png\")
\nHere are a few things to consider:<\/h6>\nLike any other usual Google Sheets formulas, the NPV formula accepts numeric values as well as range references. Please note that the NPV formula considers the cash flows in the order they are referenced.\n\nOne might be wondering what could be the difference between the PV<\/a> and the NPV formula in Google Sheets, as both returns the present value of an investment series. 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.\n\nA negative value of a cash flow usually indicates the payment from the investor. While a positive value usually means that the investor is receiving the income.\n\n ","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8313","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\/8313","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=8313"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8313\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/33462"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}