2024 – Please show all work and complete in excel 1 From the information below compute the average annual

2024 – Please show all work and complete in excel 1 From the information below compute the average annual.

Please show all work and complete in excel.

<

 

1. From the information below, compute the average annual return,
the variance, standard deviation, and coeffi cient of variation for each
asset.
ASSET ANNUAL RETURNS
A 5%, 10%, 15%, 4%
B 2 6%, 20%, 2%, 2 5%, 10%
C 12%, 15%, 17%
D 10%, 2 10%, 20%, 2 15%, 8%, 2 7%

2. Based upon your answers to question 1, which asset appears riskiest
based on standard deviation? Based on coeffi cient of variation?

<

 

7. Find the real return, nominal after-tax return, and real after-tax
return on the following:
STOCK NOMINAL RETURN INFLATION TAX RATE
X 13.5% 5% 15%
Y 8.7% 4.7% 25%
Z 5.2% 2.5% 28%

<

 

9. Using the information below, compute the percentage returns for
the following securities:

SECURITY PRICE PRICE ONE DIVIDENDS INTEREST
TODAY YEAR AGO RECEIVED RECEIVED
RoadRunner $20.05 $18.67 $0.50
stock
Wiley Coyote $33.42 $45.79 $1.10
stock
Acme longterm
bonds $1,015.38 $991.78 $100.00
Acme shortterm
bonds $996.63 $989.84 $45.75
Xlingshot $5.43 $3.45 $0.02
stock

10. Given her evaluation of current economic conditions, Ima Nutt
believes there is a 20 percent probability of recession, a 50 percent
chance of continued steady growth, and a 30 percent probability of
infl ationary growth. For each possibility, Ima has developed an interest
rate forecast for long-term Treasury bond interest rates:
ECONOMIC INTEREST RATE
FORECAST FORECAST
Recession 6 percent
Constant growth 9 percent
Infl ation 14 percent
a. What is the expected interest rate under Ima’s forecast?
b. What is the variance and standard deviation of Ima’s interest
rate forecast?
c. What is the coeffi cient of variation of Ima’s interest rate forecast?
d. If the current long-term Treasury bond interest rate is 8
percent, should Ima consider purchasing a Treasury bond?
Why or why not?

11. Ima is considering a purchase of Wallnut Company stock. Using
the same scenarios and probabilities as in problem 10, she estimates
Wallnut’s return is 2 5 percent in a recession, 20 percent in constant
growth, and 10 percent in infl ation.
a. What is Ima’s expected return forecast for Wallnut stock?
b. What is the standard deviation of the forecast?
c. If Wallnut’s current price is $20 per share and Wallnut is
expected to pay a dividend of $0.80 per share next year, what
price will Ima expect Wallnut to sell for in one year?

12. Ima’s sister, Uma, has completed her own analysis of the economy
and Wallnut’s stock. Uma used recession, constant growth,
and infl ation scenarios, but with different probabilities and expected
stock returns. Uma believes the probability of recession is 60
percent, and that in a recession, Wallnut’s stock return will be 2 20
percent. Uma believes the scenarios of constant growth and infl ation
are equally likely and that Wallnut’s returns will be 15 percent
in the constant growth scenario and 10 percent under the infl ation
scenario.
a. What is Uma’s expected return forecast for Wallnut stock?
b. What is the standard deviation of the forecast?
c. If Wallnut’s current price is $20.00 per share and is expected to
pay a dividend of $0.80 per share next year, what price does
Uma expect Wallnut to sell for in one year?