Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Return statistics for Visa stock, the S&P 500 and the risk-free asset, Treasury bills, are given below: A B C D 1 Year Visa S&P

Return statistics for Visa stock, the S&P 500 and the risk-free asset, Treasury bills, are given below:

A B C D
1 Year Visa S&P 500 T-bill
2 2013 0.06 0.13 0.033
3 2014 -0.22 -0.14 0.022
4 2015 -0.06 -0.05 0.015
5 2016 0.05 0.28 0.022
6 2017 0.14 0.08 0.028
7 2018 0.05 0.07 0.031
8 2019 0.04 0.05 0.03
9 2020 0.02 0.1 0.032

In addition, you have gathered the following data:

A B C
1 Current rf 0.038
2 Debt in 2019 15,820 million
3 Debt in 2020 16,650 million
4 Interest 2020 807 million
5 Stock price 31.21
6 # of shares 1,770 million
7 Tax rate 0.21

1. Calculate the excess returns for the stock and the S&P 500. What is the arithmetic average excess return for the S&P 500?

2.Regress the excess return on the stock on the excess return on the S&P 500. What is Visa's beta?

3. What is the cost of equity?

4. What is the cost of debt?

5. What is the company's weighted average cost of capital?

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

Handbook Of Financial Intermediation And Banking

Authors: Anjan V. Thakor, Arnoud Boot

1st Edition

0444515585, 978-0444515582

More Books

Students also viewed these Finance questions

Question

Using Language That Works

Answered: 1 week ago

Question

4. Are my sources relevant?

Answered: 1 week ago