Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve The DCF can be used to estimate the value of future cash flows and the impact upon the current value of the stock

Please solve

image text in transcribed

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. in millions Infinite Growth Rate 1% Assumptions for Calculations Assumptions FCF Annual Growth 15% Discount Rate 8.0% Shares outstanding 2231 Debt 16630 11709 Cash 2028 FCF FCF Terminal Value of Perpetuity 2018 11,995 o 2019 13,794 o 2020 15,863 o 2021 18,243 0 2022 20,979 0 2023 24,126 o 2024 27,745 o 2025 31,907 0 2026 36,693 o 2027 42,197 O 650,255 NPV(B5,D11:N11) NPV NPV of terminal value Total Value $149,729.49 $301,193.71 $450,923.20 Price 199.9113388 SUM((C15+B8-B7)/B6) In 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 Module 5 Visa DCF below

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

Students also viewed these Finance questions