The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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).

Filter by
Sorted by
Tagged with
2
votes
2answers
639 views

Logic behind Gordon Growth Model in a DCF analysis?

Sorry, I wanted to ask this on the finance/money forum, but they don't support LaTeX there. Let's say we are valuing a company using the DCF methodology with a 5-year projection period. We project ...
2
votes
0answers
581 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
1answer
176 views

Using Gordon's Growth Model to find value of corporation

This is a question posed to us by my professor in my finance class. I was under the impression that the Gordon Growth Model was used to find the intrinsic value of a stock, but I am unsure how to plug ...
1
vote
0answers
27 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
43 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
55 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
66 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
41 views

estimate cost of equity (Re) / required rate of return using DCF [closed]

I'd like to estimate Amazon's after-tax cost of equity (Re) using both the DCF and CAPM approaches. Tons of info and resources on how to estimate Re using CAPM, but DCF, I see no relevant resources. ...
1
vote
0answers
106 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
85 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
53 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? ...
1
vote
2answers
215 views

How can you find change in working capital and capital expenditures without a balance sheet?

I'm working with the following information trying to work through a valuation exercise and I'm absolutely stuck. How can I find ∆WC and CAPX with this information?
0
votes
1answer
142 views

Possible to use diffusion equation(s) to price derivatives with non-zero boundary conditions?

One of the reason the Black-Scholes can be transformed into the heat equation is that calls and puts have a zero boundary condition on their contingent payoffs. Define the terminal payoff condition ...
0
votes
1answer
71 views

In DCF, why is the discount rate interpreted as the minimum rate of return?

Is there an intuitive explanation of why, in DCF modeling, the discount rate should be interpreted as the minimum rate of return? This doesn't make sense to me because I think of the NPV as "what all ...
0
votes
1answer
47 views

Valuing corporate EUR loan of US entity? Which discount rate to use? US or EU?

If a US entity borrows in EUR and I need to perform a DCF valuation on that borrowing, should I use USD based curve (for the appropriate rating) or EUR based curves? In other words do I use the ...
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....
0
votes
1answer
328 views

Net present value when cash flows accrue continuously and are stochastic

I am trying to find a closed form solution to a stochastic integral -- which is really just a generalized expression for the expected net present value, $E^*[V_t]$, of an annuity (or perpetuity if $T \...
-1
votes
1answer
64 views

DCF Valuation Models

Does anyone know of any websites that have sample models or mind sharing their DCF models? Trying to get started modeling and can't seem to find many great resources. I know of Damodaran, but his ...