Answered step by step
Verified Expert Solution
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
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 belowStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started