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
2
votes
0answers
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 ...
1
vote
0answers
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 ...
1
vote
0answers
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 ...
1
vote
0answers
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 ...
1
vote
0answers
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, ...
1
vote
0answers
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 ...
1
vote
0answers
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 ...
1
vote
0answers
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? ...
0
votes
0answers
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 ...
0
votes
0answers
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 ...
0
votes
1answer
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 ...
0
votes
0answers
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 ...
0
votes
0answers
53 views

How do analyst on Wall Street forecast whole balance sheet

I am always curious as to how people on wall street forecast every single item on a company's balance out up to 3 years. It seems to me just pure false accuracy in order to come up with a price target....
-1
votes
0answers
13 views

Fair value DCF by API

Simplywallstreet has this thing called fair value, where they do a 2 stage DCF according to cashflow estimations which they also publish,I'm wondering if there there's a SAS API for this? thanks