Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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

10 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
584 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
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
56 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
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
216 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
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....