{"id":262514,"date":"2024-06-14T16:16:56","date_gmt":"2024-06-14T16:16:56","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=262514"},"modified":"2024-06-14T16:16:56","modified_gmt":"2024-06-14T16:16:56","slug":"how-to-find-present-value-of-a-perpetuity-in-excel","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/","title":{"rendered":"How to find present value of a perpetuity in Excel?"},"content":{"rendered":"<p>A perpetuity is a type of investment that provides a never-ending stream of cash flows. Calculating the present value of a perpetuity is essential to determine its current worth, which is crucial for financial analysis and decision-making. Fortunately, Excel provides a straightforward method to calculate the present value of a perpetuity easily and accurately. In this article, we will walk you through the step-by-step process of finding 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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#The_Formula\" title=\"The Formula\">The Formula<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#Step_1_Open_Excel\" title=\"Step 1: Open Excel\">Step 1: Open Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#Step_2_Set_Up_the_Spreadsheet\" title=\"Step 2: Set Up the Spreadsheet\">Step 2: Set Up the Spreadsheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#Step_3_Enter_Values\" title=\"Step 3: Enter Values\">Step 3: Enter Values<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#Step_4_Calculate_Present_Value\" title=\"Step 4: Calculate Present Value\">Step 4: Calculate Present Value<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#Step_5_Format_the_Result\" title=\"Step 5: Format the Result\">Step 5: Format the Result<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#Frequently_Asked_Questions_FAQs\" title=\"Frequently Asked Questions (FAQs)\">Frequently Asked Questions (FAQs)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#1_Can_Excel_calculate_the_present_value_of_a_perpetuity_with_changing_payments\" title=\"1. Can Excel calculate the present value of a perpetuity with changing payments?\">1. Can Excel calculate the present value of a perpetuity with changing payments?<\/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-find-present-value-of-a-perpetuity-in-excel\/#2_How_does_the_discount_rate_affect_the_present_value_of_a_perpetuity\" title=\"2. How does the discount rate affect the present value of a perpetuity?\">2. How does the discount rate 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-find-present-value-of-a-perpetuity-in-excel\/#3_Can_I_use_Excel_to_calculate_the_present_value_of_a_perpetuity_with_monthly_payments\" title=\"3. Can I use Excel to calculate the present value of a perpetuity with monthly payments?\">3. Can I use Excel to calculate the present value of a perpetuity with monthly payments?<\/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-find-present-value-of-a-perpetuity-in-excel\/#4_What_if_the_discount_rate_is_0\" title=\"4. What if the discount rate is 0?\">4. What if the discount rate is 0?<\/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-find-present-value-of-a-perpetuity-in-excel\/#5_How_can_I_calculate_the_present_value_of_a_perpetuity_with_Excel_if_the_payment_frequency_is_irregular\" title=\"5. How can I calculate the present value of a perpetuity with Excel if the payment frequency is irregular?\">5. How can I calculate the present value of a perpetuity with Excel if the payment frequency is irregular?<\/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-find-present-value-of-a-perpetuity-in-excel\/#6_Can_Excel_calculate_the_future_value_of_a_perpetuity\" title=\"6. Can Excel calculate the future value of a perpetuity?\">6. Can Excel calculate the future 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-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#7_Are_there_any_limitations_in_using_Excel_to_calculate_the_present_value_of_a_perpetuity\" title=\"7. Are there any limitations in using Excel to calculate the present value of a perpetuity?\">7. Are there any limitations in using Excel 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-15\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#8_Can_I_calculate_the_present_value_of_a_growing_perpetuity_in_Excel\" title=\"8. Can I calculate the present value of a growing perpetuity in Excel?\">8. Can I calculate the present value of a growing perpetuity in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#9_Can_I_use_Excel_to_calculate_the_present_value_of_a_perpetuity_with_negative_payments\" title=\"9. Can I use Excel to calculate the present value of a perpetuity with negative payments?\">9. Can I use Excel to calculate the present value of a perpetuity with negative payments?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#10_How_can_I_handle_variations_in_the_discount_rate_using_Excel\" title=\"10. How can I handle variations in the discount rate using Excel?\">10. How can I handle variations in the discount rate using Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#11_Is_the_present_value_of_a_perpetuity_affected_by_inflation\" title=\"11. Is the present value of a perpetuity affected by inflation?\">11. Is the present value of a perpetuity affected by inflation?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#12_Can_I_use_Excels_NPV_function_to_calculate_the_present_value_of_a_perpetuity\" title=\"12. Can I use Excel&#8217;s NPV function to calculate the present value of a perpetuity?\">12. Can I use Excel&#8217;s NPV function to calculate the present value of a perpetuity?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"The_Formula\"><\/span>The Formula<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\nCalculating the present value of a perpetuity involves using a formula that takes into account the periodic payment and the discount rate. The formula is as follows:<\/p>\n<p><b>Present Value = Periodic Payment \/ Discount Rate<\/b><\/p>\n<p>Now, let&#8217;s break down the process into simple steps:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_1_Open_Excel\"><\/span>Step 1: Open Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\nLaunch Microsoft Excel on your computer and open a new or existing workbook.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_2_Set_Up_the_Spreadsheet\"><\/span>Step 2: Set Up the Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\nIn a blank worksheet, enter the following headers in columns A and B respectively: &#8220;Periodic Payment&#8221; and &#8220;Discount Rate&#8221;.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_3_Enter_Values\"><\/span>Step 3: Enter Values<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\nIn the second row under the &#8220;Periodic Payment&#8221; column (cell A2), enter the amount of the periodic payment associated with the perpetuity. If the payment is $100, for example, enter &#8220;100&#8221;.<\/p>\n<p>In the second row under the &#8220;Discount Rate&#8221; column (cell B2), enter the discount rate in decimal form. If the rate is 5%, enter &#8220;0.05&#8221;.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_4_Calculate_Present_Value\"><\/span>Step 4: Calculate Present Value<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\nIn an empty cell, let&#8217;s say cell C2, enter the following formula:<\/p>\n<p><b>=A2\/B2<\/b><\/p>\n<p>This formula divides the periodic payment by the discount rate, giving you the present value of the perpetuity.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_5_Format_the_Result\"><\/span>Step 5: Format the Result<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\nTo make the result more presentable, you can format the cell to display the value as currency. Select cell C2, right-click, choose &#8220;Format Cells,&#8221; and select the appropriate currency format.<\/p>\n<p><b>The present value of the perpetuity is now calculated and shown in cell C2.<\/b><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions_FAQs\"><\/span>Frequently Asked Questions (FAQs)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_Excel_calculate_the_present_value_of_a_perpetuity_with_changing_payments\"><\/span>1. Can Excel calculate the present value of a perpetuity with changing payments?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, Excel&#8217;s present value formula assumes a constant periodic payment. If the payments are not constant, you will need to use a different method or financial software.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_does_the_discount_rate_affect_the_present_value_of_a_perpetuity\"><\/span>2. How does the discount rate affect the present value of a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nA higher discount rate reduces the present value of a perpetuity, making it less valuable. Conversely, a lower discount rate increases its present value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Can_I_use_Excel_to_calculate_the_present_value_of_a_perpetuity_with_monthly_payments\"><\/span>3. Can I use Excel to calculate the present value of a perpetuity with monthly payments?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, Excel allows you to use any consistent time period for payments as long as you adjust the discount rate accordingly.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_What_if_the_discount_rate_is_0\"><\/span>4. What if the discount rate is 0?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf the discount rate is set to zero, the present value of the perpetuity will be infinite since no discounting occurs.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_How_can_I_calculate_the_present_value_of_a_perpetuity_with_Excel_if_the_payment_frequency_is_irregular\"><\/span>5. How can I calculate the present value of a perpetuity with Excel if the payment frequency is irregular?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf the payment frequency is irregular, you can calculate the present value of each individual payment separately and then sum them up to obtain the total present value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Can_Excel_calculate_the_future_value_of_a_perpetuity\"><\/span>6. Can Excel calculate the future value of a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, Excel&#8217;s present value formula calculates the current value of a perpetuity. To calculate the future value, you would need to consider the compounding effect using a different formula or tool.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Are_there_any_limitations_in_using_Excel_to_calculate_the_present_value_of_a_perpetuity\"><\/span>7. Are there any limitations in using Excel to calculate the present value of a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nExcel has limitations when it comes to extremely large or small numbers due to precision limitations imposed by its numerical representation. Therefore, it may not accurately handle very large or small values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Can_I_calculate_the_present_value_of_a_growing_perpetuity_in_Excel\"><\/span>8. Can I calculate the present value of a growing perpetuity in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe given formula calculates the present value of a perpetuity with constant payments. If the perpetuity has a growth rate, you will need to use different formulas or methods.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_use_Excel_to_calculate_the_present_value_of_a_perpetuity_with_negative_payments\"><\/span>9. Can I use Excel to calculate the present value of a perpetuity with negative payments?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can enter negative values for periodic payments. However, keep in mind that the result will also be negative since the present value represents the worth of the perpetuity.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_How_can_I_handle_variations_in_the_discount_rate_using_Excel\"><\/span>10. How can I handle variations in the discount rate using Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf the discount rate changes over time, you will need to calculate the present value for each period separately using the appropriate discount rate for that period.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Is_the_present_value_of_a_perpetuity_affected_by_inflation\"><\/span>11. Is the present value of a perpetuity affected by inflation?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the present value formula does not consider the effects of inflation. It assumes a constant discount rate regardless of the inflation rate.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_I_use_Excels_NPV_function_to_calculate_the_present_value_of_a_perpetuity\"><\/span>12. Can I use Excel&#8217;s NPV function to calculate the present value of a perpetuity?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, Excel&#8217;s NPV function is not suitable for calculating the present value of a perpetuity since it requires a finite time horizon for cash flows. The NPV function is used for discounted cash flow valuation with a specific period.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A perpetuity is a type of investment that provides a never-ending stream of cash flows. Calculating the present value of a perpetuity is essential to determine its current worth, which is crucial for financial analysis and decision-making. Fortunately, Excel provides a straightforward method to calculate the present value of a perpetuity easily and accurately. In &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to find present value of a perpetuity in Excel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#more-262514\">Read more<span class=\"screen-reader-text\">How to find present value of a perpetuity in Excel?<\/span><\/a><\/p>\n","protected":false},"author":66,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-262514","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 find present value of a perpetuity in Excel?<\/title>\n<meta name=\"description\" content=\"A perpetuity is a type of investment that provides a never-ending stream of cash flows. Calculating the present value of a perpetuity is essential to\" \/>\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-find-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 find present value of a perpetuity in Excel?\" \/>\n<meta property=\"og:description\" content=\"A perpetuity is a type of investment that provides a never-ending stream of cash flows. Calculating the present value of a perpetuity is essential to\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-find-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-06-14T16:16:56+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=\"Jamie Steele\" \/>\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=\"Jamie Steele\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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-find-present-value-of-a-perpetuity-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/\"},\"author\":{\"name\":\"Jamie Steele\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0\"},\"headline\":\"How to find present value of a perpetuity in Excel?\",\"datePublished\":\"2024-06-14T16:16:56+00:00\",\"dateModified\":\"2024-06-14T16:16:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/\"},\"wordCount\":793,\"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-find-present-value-of-a-perpetuity-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/\",\"name\":\"How to find present value of a perpetuity in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-06-14T16:16:56+00:00\",\"dateModified\":\"2024-06-14T16:16:56+00:00\",\"description\":\"A perpetuity is a type of investment that provides a never-ending stream of cash flows. Calculating the present value of a perpetuity is essential to\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-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 find 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\/4938663f06a1cff2dff5c1af38d151c0\",\"name\":\"Jamie Steele\",\"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\":\"Jamie Steele\"},\"description\":\"Guest author Jamie Steele 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 find present value of a perpetuity in Excel?","description":"A perpetuity is a type of investment that provides a never-ending stream of cash flows. Calculating the present value of a perpetuity is essential to","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-find-present-value-of-a-perpetuity-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to find present value of a perpetuity in Excel?","og_description":"A perpetuity is a type of investment that provides a never-ending stream of cash flows. Calculating the present value of a perpetuity is essential to","og_url":"https:\/\/namso-gen.co\/blog\/how-to-find-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-06-14T16:16:56+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":"Jamie Steele","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Jamie Steele","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/"},"author":{"name":"Jamie Steele","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0"},"headline":"How to find present value of a perpetuity in Excel?","datePublished":"2024-06-14T16:16:56+00:00","dateModified":"2024-06-14T16:16:56+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/"},"wordCount":793,"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-find-present-value-of-a-perpetuity-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/","url":"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/","name":"How to find present value of a perpetuity in Excel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-06-14T16:16:56+00:00","dateModified":"2024-06-14T16:16:56+00:00","description":"A perpetuity is a type of investment that provides a never-ending stream of cash flows. Calculating the present value of a perpetuity is essential to","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-find-present-value-of-a-perpetuity-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-find-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 find 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\/4938663f06a1cff2dff5c1af38d151c0","name":"Jamie Steele","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":"Jamie Steele"},"description":"Guest author Jamie Steele 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\/262514","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\/66"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=262514"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/262514\/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=262514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=262514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=262514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}