# Finance questions

**sar.de**

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?

- 7 years ago
- 30

**Answer(2)**

Purchase the answer to view it

- finance_questions_returns.xlsx

Purchase the answer to view it

- 1279.xls
- 10__11.xlsx

**Bids(1)**

**other Questions(10)**

- Leadership
- BUSN311
- conference business law post
- Riskless Asset
- MGT 431 Week 1 DQ 1 and DQ 2
- Outsourcing work to other countries is problematic for organizations. You have taken on a new client that wants to outsource much of it customer care center to another country. The driving business need for the organization is that the current call center
- FIS 250 - Playing the Professional
- How and why did the United States escalate its involvement in the war in Vietnam in the 1960s
- phi455
- ACC 206 WEEK 1 EXERCISE ASSIGNMENTS

### Business finance Problems

NOT RATED1. From the information below, compute the average annual return, the variance, standard deviation, and coefficient of variation for each asset.

ASSET ANNUAL RETURNS

A 5%, 10%, 15%, 4%

B 2 6%, 20%, 2%, …7 years ago### 5 Problems Business Finance Course

NOT RATED1. From the information below, compute the average annual return,

the variance, standard deviation, and coefficient of variation for each

asset.

ASSET ANNUAL RETURNS

A 5%, 10%, 15%, 4%

B 2 6%, 20%, 2%, 2 …

7 years ago### BUSINESS FINANCE 1326

NOT RATED**Question**This is a business finance course. Using Excel, complete the following problems from chapter 12 in the textbook: Chapter 12 …

6 years ago