Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The DCF can be used to estimate the value of future cash flows and the impact upon the current value of the stock price.As reported

The DCF can be used to estimate the value of future cash flows and the impact upon the current value of the stock price.As reported in Morningstar, Visa reported FCF of 11,995 (million) in 2018.To perform this calculation, we first calculate the Discounted Free Cash Flow using the model from Chapter 9 (figure 9.21).Using this information, we project the future cash flows based upon a fixed growth rate.n your initial response, critically analyze the assumptions, potential errors, and modifications you might make in your estimations for the valuation of Visa stock price using the provided MS Excel Module 5 Visa DCF.

Assumptions for CalculationsAssumptions

FCF Annual Growth

15%

Discount Rate

8.0%

Shares outstanding

2231

Debt

16630

Cash

11709

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Investment Analysis

Authors: Richard A. DeFusco, Dennis W. McLeavey, Jerald E. Pinto, David E. Runkle

3rd edition

111910422X, 978-1119104544, 1119104548, 978-1119104223

More Books

Students also viewed these Finance questions