Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with the following question Attached for this discussion is theMS Excel Visa Discounted Cash Flow model.The DCF can be used to estimate

image text in transcribed

I need help with the following question

Attached for this discussion is theMS Excel Visa Discounted Cash Flow model.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.

Assumptions for CalculationsAssumptions

FCF Annual Growth

15%

Discount Rate

8.0%

Shares outstanding

2231

Debt

16630

Cash

11709

  1. Critically analyze the assumptions, potential errors, and modifications for the valuation of Visa stock price using the provided MS Excel Module 5 Visa DCF.
image text in transcribed

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

A First Course in Quantitative Finance

Authors: Thomas Mazzoni

1st edition

9781108411431, 978-1108419574

More Books

Students also viewed these Finance questions

Question

Arabica Highiand Coffee Cempany

Answered: 1 week ago