{"id":237480,"date":"2024-07-15T05:02:26","date_gmt":"2024-07-15T05:02:26","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=237480"},"modified":"2024-07-15T05:02:26","modified_gmt":"2024-07-15T05:02:26","slug":"how-to-calculate-present-value-of-a-perpetuity-in-excel","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/","title":{"rendered":"How to calculate present value of a perpetuity in Excel?"},"content":{"rendered":"<p>When it comes to investment analysis, calculating the present value of a perpetuity is an important concept. A perpetuity is a series of equal payments that continue indefinitely. Calculating the present value of a perpetuity allows you to determine the current value of these future payments in today&#8217;s dollars. Excel can be a handy tool for performing this calculation. Here&#8217;s how you can calculate the present value of a perpetuity 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-present-value-of-a-perpetuity-in-excel\/#How_to_calculate_present_value_of_a_perpetuity_in_Excel\" title=\"How to calculate present value of a perpetuity in Excel?\">How to calculate present value of a perpetuity 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-present-value-of-a-perpetuity-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-present-value-of-a-perpetuity-in-excel\/#1_What_is_a_perpetuity\" title=\"1. What is a perpetuity?\">1. What is a perpetuity?<\/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-present-value-of-a-perpetuity-in-excel\/#2_Why_is_it_important_to_calculate_the_present_value_of_a_perpetuity\" title=\"2. Why is it important to calculate the present value of a perpetuity?\">2. Why is it important to calculate the present value of a perpetuity?<\/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-present-value-of-a-perpetuity-in-excel\/#3_What_is_the_formula_for_calculating_the_present_value_of_a_perpetuity\" title=\"3. What is the formula for calculating the present value of a perpetuity?\">3. What is the formula for calculating the present value of a perpetuity?<\/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-present-value-of-a-perpetuity-in-excel\/#4_How_can_Excel_help_in_calculating_the_present_value_of_a_perpetuity\" title=\"4. How can Excel help in calculating the present value of a perpetuity?\">4. How can Excel help in calculating the present value of a perpetuity?<\/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-present-value-of-a-perpetuity-in-excel\/#5_Can_the_present_value_of_a_perpetuity_be_negative\" title=\"5. Can the present value of a perpetuity be negative?\">5. Can the present value of a perpetuity be negative?<\/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-present-value-of-a-perpetuity-in-excel\/#6_What_happens_to_the_present_value_of_a_perpetuity_if_the_discount_rate_increases\" title=\"6. What happens to the present value of a perpetuity if the discount rate increases?\">6. What happens to the present value of a perpetuity if the discount rate increases?<\/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-present-value-of-a-perpetuity-in-excel\/#7_How_does_the_annual_payment_affect_the_present_value_of_a_perpetuity\" title=\"7. How does the annual payment affect the present value of a perpetuity?\">7. How does the annual payment affect the present value of a perpetuity?<\/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-present-value-of-a-perpetuity-in-excel\/#8_Can_the_present_value_of_a_perpetuity_be_calculated_without_using_Excel\" title=\"8. Can the present value of a perpetuity be calculated without using Excel?\">8. Can the present value of a perpetuity be calculated without using Excel?<\/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-present-value-of-a-perpetuity-in-excel\/#9_What_is_the_relationship_between_the_discount_rate_and_the_present_value_of_a_perpetuity\" title=\"9. What is the relationship between the discount rate and the present value of a perpetuity?\">9. What is the relationship between the discount rate and the present value of a perpetuity?<\/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-present-value-of-a-perpetuity-in-excel\/#10_How_can_the_present_value_of_a_perpetuity_be_used_in_financial_decision-making\" title=\"10. How can the present value of a perpetuity be used in financial decision-making?\">10. How can the present value of a perpetuity be used in financial decision-making?<\/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-present-value-of-a-perpetuity-in-excel\/#11_Can_the_present_value_of_a_perpetuity_be_calculated_for_uneven_cash_flows\" title=\"11. Can the present value of a perpetuity be calculated for uneven cash flows?\">11. Can the present value of a perpetuity be calculated for uneven cash flows?<\/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-present-value-of-a-perpetuity-in-excel\/#12_What_are_some_real-world_examples_of_perpetuities\" title=\"12. What are some real-world examples of perpetuities?\">12. What are some real-world examples of perpetuities?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"How_to_calculate_present_value_of_a_perpetuity_in_Excel\"><\/span>How to calculate present value of a perpetuity in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>To calculate the present value of a perpetuity in Excel, you can use the formula PV = PMT \/ r, where PV is the present value, PMT is the annual payment, and r is the discount rate. In Excel, you can use the PV function to calculate the present value of a perpetuity. Here&#8217;s an example:<\/b><\/p>\n<p>Suppose you have an annual payment of $1000 and a discount rate of 5%. You can use the formula =PV(5%,0,-1000) in Excel to calculate the present value of this perpetuity, which would be $20,000.<\/p>\n<p>Now that you know how to calculate the present value of a perpetuity in Excel, let&#8217;s address some common questions related to this topic:<\/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_a_perpetuity\"><\/span>1. What is a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nA perpetuity is a stream of equal payments that continues indefinitely.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Why_is_it_important_to_calculate_the_present_value_of_a_perpetuity\"><\/span>2. Why is it important to calculate the present value of a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nCalculating the present value of a perpetuity helps investors understand the current value of future cash flows and make informed investment decisions.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_What_is_the_formula_for_calculating_the_present_value_of_a_perpetuity\"><\/span>3. What is the formula for calculating the present value of a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe formula for calculating the present value of a perpetuity is PV = PMT \/ r, where PV is the present value, PMT is the annual payment, and r is the discount rate.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_How_can_Excel_help_in_calculating_the_present_value_of_a_perpetuity\"><\/span>4. How can Excel help in calculating the present value of a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nExcel provides functions such as PV, which can be used to easily calculate the present value of a perpetuity.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Can_the_present_value_of_a_perpetuity_be_negative\"><\/span>5. Can the present value of a perpetuity be negative?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the present value of a perpetuity cannot be negative as it represents the current value of future cash flows.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_What_happens_to_the_present_value_of_a_perpetuity_if_the_discount_rate_increases\"><\/span>6. What happens to the present value of a perpetuity if the discount rate increases?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nAs the discount rate increases, the present value of a perpetuity decreases, reflecting the higher opportunity cost of capital.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_How_does_the_annual_payment_affect_the_present_value_of_a_perpetuity\"><\/span>7. How does the annual payment affect the present value of a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nA higher annual payment will result in a higher present value of a perpetuity, all else being equal.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Can_the_present_value_of_a_perpetuity_be_calculated_without_using_Excel\"><\/span>8. Can the present value of a perpetuity be calculated without using Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, the present value of a perpetuity can be calculated manually using the formula PV = PMT \/ r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_What_is_the_relationship_between_the_discount_rate_and_the_present_value_of_a_perpetuity\"><\/span>9. What is the relationship between the discount rate and the present value of a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThere is an inverse relationship between the discount rate and the present value of a perpetuity &#8211; as the discount rate increases, the present value decreases.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_How_can_the_present_value_of_a_perpetuity_be_used_in_financial_decision-making\"><\/span>10. How can the present value of a perpetuity be used in financial decision-making?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe present value of a perpetuity can be used to analyze investment opportunities, determine the fair value of assets, and assess the profitability of projects.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Can_the_present_value_of_a_perpetuity_be_calculated_for_uneven_cash_flows\"><\/span>11. Can the present value of a perpetuity be calculated for uneven cash flows?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the present value of a perpetuity is specifically for equal, recurring payments.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_What_are_some_real-world_examples_of_perpetuities\"><\/span>12. What are some real-world examples of perpetuities?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nExamples of perpetuities include government bonds that pay fixed interest indefinitely and certain types of preferred stocks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When it comes to investment analysis, calculating the present value of a perpetuity is an important concept. A perpetuity is a series of equal payments that continue indefinitely. Calculating the present value of a perpetuity allows you to determine the current value of these future payments in today&#8217;s dollars. Excel can be a handy tool &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to calculate present value of a perpetuity in Excel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/#more-237480\">Read more<span class=\"screen-reader-text\">How to calculate present value of a perpetuity in Excel?<\/span><\/a><\/p>\n","protected":false},"author":59,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-237480","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 present value of a perpetuity in Excel?<\/title>\n<meta name=\"description\" content=\"When it comes to investment analysis, calculating the present value of a perpetuity is an important concept. A perpetuity is a series of equal payments\" \/>\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-present-value-of-a-perpetuity-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 present value of a perpetuity in Excel?\" \/>\n<meta property=\"og:description\" content=\"When it comes to investment analysis, calculating the present value of a perpetuity is an important concept. A perpetuity is a series of equal payments\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-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=\"2024-07-15T05:02:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Francis French\" \/>\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=\"Francis French\" \/>\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-present-value-of-a-perpetuity-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/\"},\"author\":{\"name\":\"Francis French\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\"},\"headline\":\"How to calculate present value of a perpetuity in Excel?\",\"datePublished\":\"2024-07-15T05:02:26+00:00\",\"dateModified\":\"2024-07-15T05:02:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/\"},\"wordCount\":576,\"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-present-value-of-a-perpetuity-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/\",\"name\":\"How to calculate present value of a perpetuity in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-07-15T05:02:26+00:00\",\"dateModified\":\"2024-07-15T05:02:26+00:00\",\"description\":\"When it comes to investment analysis, calculating the present value of a perpetuity is an important concept. A perpetuity is a series of equal payments\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to calculate present value of a perpetuity 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\/1622769be52c41a10d83bee2c48a8c48\",\"name\":\"Francis French\",\"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\":\"Francis French\"},\"description\":\"Guest author Francis French 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 present value of a perpetuity in Excel?","description":"When it comes to investment analysis, calculating the present value of a perpetuity is an important concept. A perpetuity is a series of equal payments","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-present-value-of-a-perpetuity-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to calculate present value of a perpetuity in Excel?","og_description":"When it comes to investment analysis, calculating the present value of a perpetuity is an important concept. A perpetuity is a series of equal payments","og_url":"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-07-15T05:02:26+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Francis French","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Francis French","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/"},"author":{"name":"Francis French","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48"},"headline":"How to calculate present value of a perpetuity in Excel?","datePublished":"2024-07-15T05:02:26+00:00","dateModified":"2024-07-15T05:02:26+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/"},"wordCount":576,"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-present-value-of-a-perpetuity-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/","url":"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/","name":"How to calculate present value of a perpetuity in Excel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-07-15T05:02:26+00:00","dateModified":"2024-07-15T05:02:26+00:00","description":"When it comes to investment analysis, calculating the present value of a perpetuity is an important concept. A perpetuity is a series of equal payments","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-calculate-present-value-of-a-perpetuity-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to calculate present value of a perpetuity 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\/1622769be52c41a10d83bee2c48a8c48","name":"Francis French","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":"Francis French"},"description":"Guest author Francis French 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\/237480","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\/59"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=237480"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/237480\/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=237480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=237480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=237480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}