# Questions tagged [dcf]

In finance, discounted cash flow (DCF) analysis is a method of valuing a project, company, or asset using the concepts of the time value of money. All future cash flows are estimated and discounted by using cost of capital to give their present values (PVs).

14 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
662 views

### Is there a difference between “regression toward the mean” vs “mean reversion”, in the context of financial time series and cash flow analysis?

I read the Wikipedia articles, and it implied that it was different: https://en.wikipedia.org/wiki/Regression_toward_the_mean In finance, the term mean reversion has a different meaning. Jeremy ...
33 views

### Free DCF model database

Over the years, I have accumulated quite a few DCF models (some are my own and some are from others). I am wondering if there is any website where I can upload mine and download those of others so ...
45 views

### Newbie question on Net Present Value with Constant Growth

Newbie here, trying wrap my head around on why this doesn't add up: Calculating the discounted cash flow of a perpetuity paying \$1000 per year, 15% discount rate and 5% growth. If I calculate from ...
130 views

### Alternatives to irr function in Matlab to calculate internal rate of return

I am trying to calculate an IRR with several dimensions in Matlab 2019a. My formula below works in theory (ignoring the "multiple rates of return" warning for now), but the problem is that for bigger ...
67 views

### Small difference in IRR, big difference in NPV?

I calculated the following in Matlab 2019a, see code below. I was surprised about the big difference in present values (DiffPV, DiffPVpercentage) for only a small difference (DiffIRR, ...
132 views

### DCF valuation and the constant WACC assumption

I have a question that has been on my mind ever since I learned about DCF. I was taught that for the DCF to be valid WACC should be constant. As a physicist by training this assumption is strange to ...
94 views

### Valuation of a company

Alpha Corp purchases Beta Sub. Alpha Corp finances the purchase price of € 100 million by raising € 50 million in debt and € 50 million in equity issued by Alpha. The debt is risk free and the ...
55 views

### Should cash-flows discounted at WACC be pre- or post-tax?

WACC in my mind is effectively a post-tax measure: $$\text{WACC} = \frac{E}{V} k_e+\frac{D}{V}k_d(1-t)$$ In this case should cash-flows, in particular loan cash-flows be adjusted for tax as well? ...
51 views

### Adapting a DCF valuation model for individual investors investing in a residential real estate asset and studying its implications

I am trying to better understand discounted cash flow (DCF) valuations to compute the net present value (NPV) of the collection of cash flows arising from the process of buying, holding, and selling a ...
34 views

### Discounted Cash Flows in Excel

I'm taking an online class on stock valuation. In my class, the instructor calculated stock intrinsic value using XNPV function in Excel. While I understand this part, I don't know why it gives a ...
71 views

### Find out the effective monthly discount rate for a 10% annual discount rate

First time posting. Apologies in advance if this is not the right question for this forum. If it is, please let me know if I should reformat this in a particular way. If it isn't, would it be more ...
36 views

### Valuing Acquisition Target Case Study - DCF and IRR?

Wondering how best to answer a case study I need to do. Case study info as follows: Given Selling company's P&L (3 years actual, 4 years forecast) - closing date on end of year 3 - and a PPT of ...