Business, 15.02.2021 20:20 jetblackcap

Attached for this discussion is the MS 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 Calculations Assumptions FCF Annual Growth 15% Discount Rate 8.0% Shares outstanding 2231 Debt 16630 Cash 11709 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 MS Excel Module 5 Visa DCF. In your responses to peers, critically evaluate the limitations with the DCF model, analyze another method of stock valuation which could be used with potential advantages or disadvantages, or utilize the MS Excel Visa DCF model to calculate the stock price for Mastercard. Assumptions for Annual Growth 15%Discount Rate 8.0%Shares outstanding 2231Debt 16630Cash 11709In 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. In your responses to peers, critically evaluate the limitations with the DCF model, analyze another method of stock valuation which could be used with potential advantages or disadvantages, or utilize the MS Excel Visa DCF model to calculate the stock price for Mastercard. Students are to provide original and thoughtful contributions to the discussion questions and comments presented by instructor. Each student is to respond to the weekly discussion question and respond to at least TWO other students' posting during the unit. Participation assessment will be based on not only frequency, but also quality of content and use of course and outside-of-course resources to support your position or analysis.

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 12:50

Performance bicycle company makes steel and titanium handle bars for bicycles. it requires approximately 1 hour of labor to make one handle bar of either type. during the most recent accounting period, barr company made 7,700 steel bars and 2,300 titanium bars. setup costs amounted to $35,000. one batch of each type of bar was run each month. if a single company-wide overhead rate based on direct labor hours is used to allocate overhead costs to the two products, the amount of setup cost assigned to the steel bars will be:

Answers: 2

Answer

Business, 22.06.2019 15:40

Aprice control is: question 1 options: a)a tax on the sale of a good that controls the market price.b)an upper limit on the quantity of some good that can be bought or sold.c)a legal restriction on how high or low a price in a market may go.d)control of the price of a good by the firm that produces it.

Answers: 1

Answer

Business, 22.06.2019 20:00

If an investment has 35 percent more nondiversifiable risk than the market portfolio, its beta will be:

Answers: 1

Answer

Business, 22.06.2019 22:40

Southeastern oklahoma state university's business program has the facilities and faculty to handle an enrollment of 2,000 new students per semester. however, in an effort to limit class sizes to a "reasonable" level (under 200 generally), southeastern's dean, holly lutze, placed a ceiling on enrollment of 1,600 new students. although there was ample demand for business courses last semester, conflicting schedules allowed only 1,440 new students to take business courses.the utilization rate for southeastern=%the efficiency rate for southeastern=%

Answers: 3

Answer

You know the right answer?

Attached for this discussion is the MS Excel Visa Discounted Cash Flow model. The DCF can be used to...

Questions