{"id":199361,"date":"2023-12-10T12:54:54","date_gmt":"2023-12-10T12:54:54","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/"},"modified":"2023-12-10T12:54:54","modified_gmt":"2023-12-10T12:54:54","slug":"how-to-calculate-discounted-value-in-excel","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/","title":{"rendered":"How to calculate discounted value in Excel?"},"content":{"rendered":"<p>When it comes to calculating discounted value in Excel, there are a few steps you need to follow. Discounted value is a financial term used to determine the present value of a future amount of money. This is useful for investment analysis and making informed financial decisions. Here&#8217;s how you can do it in Excel:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#How_to_calculate_discounted_value_in_Excel\" title=\"How to calculate discounted value in Excel?\">How to calculate discounted value in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#FAQs\" title=\"FAQs\">FAQs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#1_What_is_the_discounted_value\" title=\"1. What is the discounted value?\">1. What is the discounted value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#2_Why_is_calculating_discounted_value_important\" title=\"2. Why is calculating discounted value important?\">2. Why is calculating discounted value important?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#3_Can_I_calculate_discounted_value_for_multiple_cash_flows_in_Excel\" title=\"3. Can I calculate discounted value for multiple cash flows in Excel?\">3. Can I calculate discounted value for multiple cash flows in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#4_What_is_the_difference_between_discounted_value_and_net_present_value\" title=\"4. What is the difference between discounted value and net present value?\">4. What is the difference between discounted value and net present value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#5_How_do_I_calculate_the_rate_of_return_in_Excel\" title=\"5. How do I calculate the rate of return in Excel?\">5. How do I calculate the rate of return in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#6_Can_Excel_calculate_discounted_value_for_annuities\" title=\"6. Can Excel calculate discounted value for annuities?\">6. Can Excel calculate discounted value for annuities?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#7_What_is_the_significance_of_the_interest_rate_in_calculating_discounted_value\" title=\"7. What is the significance of the interest rate in calculating discounted value?\">7. What is the significance of the interest rate in calculating discounted value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#8_How_does_the_number_of_periods_affect_the_discounted_value\" title=\"8. How does the number of periods affect the discounted value?\">8. How does the number of periods affect the discounted value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#9_Can_I_calculate_discounted_value_for_a_loan_in_Excel\" title=\"9. Can I calculate discounted value for a loan in Excel?\">9. Can I calculate discounted value for a loan in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#10_What_is_the_future_value_and_how_does_it_impact_discounted_value_calculation\" title=\"10. What is the future value and how does it impact discounted value calculation?\">10. What is the future value and how does it impact discounted value calculation?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#11_How_do_I_interpret_the_discounted_value_result_in_Excel\" title=\"11. How do I interpret the discounted value result in Excel?\">11. How do I interpret the discounted value result in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#12_Can_I_use_Excel_to_perform_sensitivity_analysis_on_discounted_value\" title=\"12. Can I use Excel to perform sensitivity analysis on discounted value?\">12. Can I use Excel to perform sensitivity analysis on discounted value?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"How_to_calculate_discounted_value_in_Excel\"><\/span>How to calculate discounted value in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe formula to calculate discounted value in Excel is:<br \/>\n=PV(rate, nper, pmt, [fv], [type])<br \/>\nWhere:<br \/>\n&#8211; rate is the interest rate per period<br \/>\n&#8211; nper is the total number of periods<br \/>\n&#8211; pmt is the payment made each period<br \/>\n&#8211; fv is the future value of the investment<br \/>\n&#8211; type is when payments are due<\/p>\n<p>To use this formula, you need to input the appropriate values for rate, nper, pmt, and fv. Once you input these values into the formula, Excel will calculate the discounted value for you.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"1_What_is_the_discounted_value\"><\/span>1. What is the discounted value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe discounted value is the present value of a future amount of money, taking into account the time value of money.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Why_is_calculating_discounted_value_important\"><\/span>2. Why is calculating discounted value important?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nCalculating discounted value is important because it helps determine the current worth of future cash flows, assisting in making informed financial decisions.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Can_I_calculate_discounted_value_for_multiple_cash_flows_in_Excel\"><\/span>3. Can I calculate discounted value for multiple cash flows in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can calculate discounted value for multiple cash flows in Excel by using the NPV (Net Present Value) function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_What_is_the_difference_between_discounted_value_and_net_present_value\"><\/span>4. What is the difference between discounted value and net present value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nDiscounted value is the present value of a future amount, while net present value is the difference between the present value of cash inflows and the present value of cash outflows.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_How_do_I_calculate_the_rate_of_return_in_Excel\"><\/span>5. How do I calculate the rate of return in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can calculate the rate of return in Excel by using the IRR (Internal Rate of Return) function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Can_Excel_calculate_discounted_value_for_annuities\"><\/span>6. Can Excel calculate discounted value for annuities?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can calculate discounted value for annuities in Excel by using the PV (Present Value) function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_What_is_the_significance_of_the_interest_rate_in_calculating_discounted_value\"><\/span>7. What is the significance of the interest rate in calculating discounted value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe interest rate is significant as it accounts for the time value of money, determining the value of future cash flows in present terms.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_How_does_the_number_of_periods_affect_the_discounted_value\"><\/span>8. How does the number of periods affect the discounted value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe number of periods affects the discounted value by determining how long it will take for an investment to reach its present value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_calculate_discounted_value_for_a_loan_in_Excel\"><\/span>9. Can I calculate discounted value for a loan in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can calculate discounted value for a loan in Excel by using the PV function and inputting the loan amount, interest rate, and loan term.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_What_is_the_future_value_and_how_does_it_impact_discounted_value_calculation\"><\/span>10. What is the future value and how does it impact discounted value calculation?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe future value is the value of an investment at a specified future date, which impacts the discounted value calculation by considering the potential growth of the investment.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_How_do_I_interpret_the_discounted_value_result_in_Excel\"><\/span>11. How do I interpret the discounted value result in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe discounted value result in Excel represents the present value of a future amount of money, indicating the current worth of an investment or cash flow.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_I_use_Excel_to_perform_sensitivity_analysis_on_discounted_value\"><\/span>12. Can I use Excel to perform sensitivity analysis on discounted value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use Excel to perform sensitivity analysis on discounted value by changing input variables such as interest rate or number of periods to analyze their impact on the result.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When it comes to calculating discounted value in Excel, there are a few steps you need to follow. Discounted value is a financial term used to determine the present value of a future amount of money. This is useful for investment analysis and making informed financial decisions. Here&#8217;s how you can do it in Excel: &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to calculate discounted value in Excel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#more-199361\">Read more<span class=\"screen-reader-text\">How to calculate discounted value in Excel?<\/span><\/a><\/p>\n","protected":false},"author":51,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-199361","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to calculate discounted value in Excel?<\/title>\n<meta name=\"description\" content=\"When it comes to calculating discounted value in Excel, there are a few steps you need to follow. Discounted value is a financial term used to determine\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to calculate discounted value in Excel?\" \/>\n<meta property=\"og:description\" content=\"When it comes to calculating discounted value in Excel, there are a few steps you need to follow. Discounted value is a financial term used to determine\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-10T12:54:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"164\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Adam Forbes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adam Forbes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/\"},\"author\":{\"name\":\"Adam Forbes\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\"},\"headline\":\"How to calculate discounted value in Excel?\",\"datePublished\":\"2023-12-10T12:54:54+00:00\",\"dateModified\":\"2023-12-10T12:54:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/\"},\"wordCount\":562,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/\",\"name\":\"How to calculate discounted value in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-12-10T12:54:54+00:00\",\"dateModified\":\"2023-12-10T12:54:54+00:00\",\"description\":\"When it comes to calculating discounted value in Excel, there are a few steps you need to follow. Discounted value is a financial term used to determine\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to calculate discounted value in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\",\"name\":\"Adam Forbes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Adam Forbes\"},\"description\":\"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to calculate discounted value in Excel?","description":"When it comes to calculating discounted value in Excel, there are a few steps you need to follow. Discounted value is a financial term used to determine","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:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to calculate discounted value in Excel?","og_description":"When it comes to calculating discounted value in Excel, there are a few steps you need to follow. Discounted value is a financial term used to determine","og_url":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2023-12-10T12:54:54+00:00","og_image":[{"width":500,"height":164,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","type":"image\/png"}],"author":"Adam Forbes","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Adam Forbes","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/"},"author":{"name":"Adam Forbes","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060"},"headline":"How to calculate discounted value in Excel?","datePublished":"2023-12-10T12:54:54+00:00","dateModified":"2023-12-10T12:54:54+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/"},"wordCount":562,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/","url":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/","name":"How to calculate discounted value in Excel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-12-10T12:54:54+00:00","dateModified":"2023-12-10T12:54:54+00:00","description":"When it comes to calculating discounted value in Excel, there are a few steps you need to follow. Discounted value is a financial term used to determine","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-discounted-value-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to calculate discounted value in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060","name":"Adam Forbes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Adam Forbes"},"description":"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/199361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=199361"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/199361\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=199361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=199361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=199361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}