{"id":267121,"date":"2024-03-13T20:08:19","date_gmt":"2024-03-13T19:08:19","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=267121"},"modified":"2026-11-19T15:53:21","modified_gmt":"2026-11-19T14:53:21","slug":"analisis-flujo-de-caja-descontado","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/finance-processes\/discounted-cash-flow-analysis\/","title":{"rendered":"An\u00e1lisis del flujo de caja descontado (DCF) (gu\u00eda completa)"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>When it comes to investment opportunities, everyone wants an answer to the same question: is it worth it? Unfortunately, there\u2019s no way to be certain. However, there are many financial formulas and analyses that can help you make an educated guess and not just flip a coin to decide.<\/p>\n<p>Given the amount of historical data available on different industries, companies, and markets, it\u2019s possible to make some very educated guesses. However, depending on the type of investment you\u2019re considering, you may not have access to much historical information &#8211; for example, investing in a startup in a new market.<\/p>\n<p>In this article, you will learn about one of the most widely used valuation methods: discounted cash flow (DCF) analysis. In addition to learning about the steps involved in DCF analysis, you\u2019ll also learn about the main limitations of this method and how to minimize them. Finally, you\u2019ll learn how to use this valuation method in Microsoft Excel or Google Sheets and how <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo&#8217;s AI automations<\/a> can help you manage and automate the process. To learn more about business valuation methods, check out this article on <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/company-valuation\/\">How to Calculate the Value of a Company<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-a-discounted-cash-flow-dcf-analy&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is a discounted cash flow (DCF) analysis?<\/h2>\n<p>Discounted cash flow analysis is a popular valuation method that estimates the value of the investment based on predicted cash flows. The DCF formula provides the present value of the investment, also known as the maximum amount you should pay given the expected growth and interest rates, as well as the duration of the investment.<\/p>\n<p>This method relies on the time value of money, which assumes that the dollar you have today is worth more than the one you will receive tomorrow. The reasoning behind this is that if you have the dollar today, you can invest it and make more money. While the DCF formula can theoretically be used for any kind of investment, it makes some crucial assumptions that may not be acceptable in every situation.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-perform-a-discounted-cash-flow-an&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to perform a discounted cash flow analysis?<\/h2>\n<p>Discounted cash flow refers to the sum of all future discounted cash flows. In other words, you need to estimate the discounted value for all future cash flows for the investment period. Many possible methods are available to estimate these values, but none can guarantee results.<\/p>\n<p>This is why it\u2019s important to understand the process and the assumptions behind the calculations. If possible, it\u2019s best to get estimates from different analysts for both the expected cash flows and rates, particularly when you don\u2019t have a lot of historical data to work with.<\/p>\n<h3>DCF formula syntax<\/h3>\n<p>The formula used to calculate discounted cash flow is the following:<\/p>\n<blockquote>\n<p>discounted cash flow = cf1 \/ (1+r)^1 + cf2 \/ (1+r)^2 + \u2026cfn \/ (1+r)^n<\/p>\n<\/blockquote>\n<p>Where,<\/p>\n<ul>\n<li><strong>cfn =<\/strong> cash flow projection for the year<\/li>\n<li><strong>r =<\/strong> discount rate in decimal form<\/li>\n<li><strong>n =<\/strong> investment period in years<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-calculate-discounted-cash-flow&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to calculate discounted cash flow?<\/h2>\n<p>Follow the steps below to find the value for discounted cash flow.<\/p>\n<h3>Step 1. Cash flows<\/h3>\n<p>The first step is to get estimates for projected cash flows. Our guide to <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/financial-modeling-forecasting\/\">financial modeling and forecasting<\/a> covers common ways to build them. It\u2019s important to remember that these are projections, so it\u2019s not an exact science. The more information you have, the better, but there are no guarantees.<\/p>\n<h3>Step 2. Discount rate<\/h3>\n<p>The second step is to determine an appropriate discount rate. Again, this is an estimate, so it might be worth exploring different options. Very often, the value used for the discount rate is the company\u2019s Weighted Average Cost of Capital (WACC).<\/p>\n<h3>Step 3. Calculate discounted cash flow<\/h3>\n<p>Once you have the cash flows and discount rate estimates, use the formula to calculate the discounted cash flow value. If you\u2019re considering multiple scenarios, calculate the value for each one.<\/p>\n<h3>Step 4. Evaluate the results<\/h3>\n<p>Generally speaking, if the DCF value is higher than the cost of the investment, it\u2019s worth considering. If the value is lower, it\u2019s a less attractive investment. However, it may still be worth doing further research and using other valuation methods.<\/p>\n<p>To keep your past and projected cash flows in one place, you can start from our <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/cash-flow-template\/\">cash flow template in Google Sheets<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;discounted-cash-flow-valuation-in-excel&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Discounted cash flow valuation in Excel or Google Sheets<\/h2>\n<p>As mentioned above, DCF analysis deals with cash flow and discount rate estimates, not actual values, so it\u2019s always a good idea to gather different estimates to conduct a <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/what-if-analysis-google-sheets\/\">what-if analysis<\/a>. Additionally, different valuation methods can help you get a more complete picture of the potential investment.<\/p>\n<p>In other words, a thorough analysis requires the use of spreadsheet software to avoid mistakes and save time. You can use tools like Microsoft Excel and Google Sheets to automate the calculations, so you can evaluate different scenarios and run multiple calculations simultaneously. For a ready-made model with these steps already set up, use our <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/dcf-model-google-sheets\/\">DCF template in Google Sheets<\/a>.<\/p>\n<p>However, data management and synchronization are especially important in these cases. The data you need is usually stored in different locations and formats, and various people need to access and analyze that data. Once the results are ready, the reports need to be shared with the interested parties. <a href=\"https:\/\/www.sheetgo.com\/virtual-employees\/finance\/\">Sheetgo&#8217;s AI finance virtual employee<\/a> can take on this work, from collecting the data to sharing the final reports.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;discounted-cash-flow-analysis-example&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Discounted cash flow analysis example<\/h2>\n<p>Imagine you are currently considering investing in a project. The investment has a cost of $150,000 and a duration of 5 years.<\/p>\n<p>For the sake of simplicity, let\u2019s assume that the cash flows have been carefully calculated using available historical data and the discount rate is reasonable. Follow the steps below to find the DCF value.<\/p>\n<h3>Step 1. Cash flows<\/h3>\n<p>In Google Sheets, create a table like the one below. The first row has the year number, and the second has the projected cash flows for those years.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/dcf-analysis-google-sheets-projected-cash-flows.webp&#8221; alt=&#8221;DCF analysis in Google Sheets \u2014 year 1 to 5 in row 2 and projected cash flows from $53,786.00 to $96,814.80 in row 3&#8243; title_text=&#8221;Year 1 to 5 in row 2 and projected cash flows from $53,786.00 to $96,814.80 in row 3&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 2. Discount rate<\/h3>\n<p>Add the discount rate, as a decimal, below the projected cash flows.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/dcf-analysis-google-sheets-discount-rate.webp&#8221; alt=&#8221;DCF analysis in Google Sheets \u2014 discount rate of 0.15 added in row 4 under each year&#8217;s projected cash flow&#8221; title_text=&#8221;Discount rate of 0.15 added in row 4 under each year&#8217;s projected cash flow&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 3. Calculate DCF<\/h3>\n<p>In a new row, type in the formula to discount the first cash flow projection. In this example, the formula in cell B5 is =(B3\/(1+B4)^B2).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/dcf-analysis-formula-google-sheets-discounted-value.webp&#8221; alt=&#8221;DCF analysis formula in Google Sheets \u2014 =(B3\/(1+B4)^B2) typed in cell B5 in the discounted cf values row&#8221; title_text=&#8221;=(B3\/(1+B4)^B2) typed in cell B5 in the discounted cf values row&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Drag the formula to the right to get the discounted cash flow projections.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/dcf-analysis-google-sheets-discounted-cash-flows.webp&#8221; alt=&#8221;DCF analysis in Google Sheets \u2014 formula dragged right, giving discounted values from $46,770.43 to $48,134.07 in row 5&#8243; title_text=&#8221;Formula dragged right, giving discounted values from $46,770.43 to $48,134.07 in row 5&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Add the discounted cash flow values to get the final DCF value. In cell B6, the formula is =SUM(B5:F5).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/dcf-calculation-google-sheets-sum-formula.webp&#8221; alt=&#8221;DCF calculation in Google Sheets \u2014 =SUM(B5:F5) typed in cell B6 next to the DCF value label&#8221; title_text=&#8221;=SUM(B5:F5) typed in cell B6 next to the DCF value label&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 4. Evaluate results<\/h3>\n<p>As you can see, the value for DCF ($242,423.38) is higher than the cost of the investment ($150,000), so it might be worth considering.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/dcf-analysis-google-sheets-dcf-value-result.webp&#8221; alt=&#8221;DCF analysis in Google Sheets \u2014 DCF value of $242,423.38 highlighted in yellow in cell B6&#8243; title_text=&#8221;DCF value of $242,423.38 highlighted in yellow in cell B6&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Google Sheets can also do this in one step: =NPV(B4,B3:F3) returns the same $242,423.38. Learn more about <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/npv-formula-in-google-sheets\/\">how to use the NPV formula in Google Sheets<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;is-dcf-a-good-valuation-method&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Is DCF a good valuation method?<\/h2>\n<p>The discounted cash flow method is widely used as many believe it provides a fairer and more objective valuation. DCF analysis doesn\u2019t consider stock value or market sentiment, which can be volatile and sensitive to external factors. Instead, it focuses on the projected growth rates, annual cash flows, and discount rate.<\/p>\n<p>However, some assumptions inherent to the DCF method can limit its usefulness in specific circumstances. In any case, you should never rely on a single formula or method when it comes to forecasting values. Below, you have a summary of the main limitations, as well as some recommendations for use.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;limitations-of-dcf-analysis&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Limitations of DCF analysis<\/h2>\n<p>As mentioned above, there are limitations to any method, particularly those that aim to forecast values. Below, you have a summary of the main limitations of DCF analysis.<\/p>\n<h3>All estimates<\/h3>\n<p>The DCF relies on estimated values for all parameters. In other words, it doesn\u2019t use any real figures directly. The potential usefulness of the method is entirely dependent on how accurate the projections turn out to be.<\/p>\n<h3>Increasing uncertainty<\/h3>\n<p>This method can be used to calculate values for very long-term investments. However, as we get further away from the present time, the values become complete guesswork. With enough accurate historical and contextual data, it\u2019s possible to get well-informed estimates, but if you can\u2019t get reliable projections, you should consider alternative methods.<\/p>\n<h3>External factors<\/h3>\n<p>Many factors affect the value of cash flows but cannot be easily quantified. This includes, but is not limited to, changes in demand, competitor behavior, technological advances, and unexpected events.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;dcf-analysis-tips&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>DCF analysis tips<\/h2>\n<ul>\n<li><strong>Use multiple valuation methods:<\/strong> Don\u2019t rely on a single method to make your decision. When it comes to investments, there are many aspects to consider, and no single method covers them all.<\/li>\n<li><strong>Gather contextual information:<\/strong> Make sure you gather as much information as possible about whatever you\u2019re investing in, whether a project or a company.<\/li>\n<li><strong>Automate whatever you can:<\/strong> Use spreadsheet software to automate calculations and avoid mistakes. With Sheetgo&#8217;s AI automations, you can connect data across files and automate repetitive tasks.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>Many methods are available to help you evaluate a potential investment. Discounted cash flow analysis is a widely used valuation method that relies on the time value of money and the accuracy of cash flow projections. When dealing with predicted values, it\u2019s best to get multiple estimates and not rely on a single method.<\/p>\n<p>You now know about the benefits and limitations of this valuation method, the steps involved in discounted cash flow analysis, and how to use the DCF formula. You also know how to calculate DCF using Microsoft Excel or Google Sheets and how Sheetgo&#8217;s AI can help you manage and automate the process.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>El an\u00e1lisis DCF estima cu\u00e1nto vale una inversi\u00f3n a partir de sus flujos de caja previstos. Aprende la f\u00f3rmula, los pasos, un ejemplo en Google Sheets y sus l\u00edmites.<\/p>","protected":false},"author":2,"featured_media":267128,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[36],"tags":[],"class_list":["post-267121","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance-processes"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/267121","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=267121"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/267121\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/267128"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=267121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=267121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=267121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}