Question

*Please show how to do the problem in excel with references showing* You purchased shares of...

*Please show how to do the problem in excel with references showing*

You purchased shares of a stock one year ago at a price of $64.79 per share. During the year you received dividend payments of $2.21 and sold the stock for $71.91 per share.

If the inflation rate during that year was 2.95%, what was your real rate of return?

Homework Answers

Answer #1

Below are Excel calculations. But just for the sake of it providing the formulas.

Return on share = (Sale Price - Buy Price + Dividend)/Buy Price

This return is nominal return.

Based on Fischer relation,

(1 + Nominal rate) = (1 + Real rate) * (1 + Inflation)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You purchased shares of stock one year ago at a price of $64.46 per share. During...
You purchased shares of stock one year ago at a price of $64.46 per share. During the year, you received dividend payments of $2.15 and sold the stock for $71.58 per share. If the inflation rate during the year was 2.83 percent, what was your real return
8. You purchased shares of stock one year ago at a price of $63.80 per share....
8. You purchased shares of stock one year ago at a price of $63.80 per share. During the year, you received dividend payments of $2.03 and sold the stock for $70.92 per share. If the inflation rate during the year was 2.59 percent, what was your real return?
You purchased shares of stock one year ago at a price of $63.47 per share. During...
You purchased shares of stock one year ago at a price of $63.47 per share. During the year, you received dividend payments of $1.97 and sold the stock for $70.59 per share. If the inflation rate during the year was 2.47 percent, what was your real return? Multiple Choice 10.35% 11.57% 17.15% 14.36% 8.54%
Please don't solve using excel. Please solve by hand or type it out. You purchased 300...
Please don't solve using excel. Please solve by hand or type it out. You purchased 300 shares of common stock for $30 per share. The initial margin is 60% and the stock pays no dividend. Your rate of return on equity would be … if you sell the stock at $40 per share. The call loan rate is 5%
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc....
Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc. Practice question 14: Calculate the company’s w.a.c.c. using the info below. ***assume this is a corporate bond that pays 2x annually when calculating the PV of the bond Harvey LLC’s capital structure consists of a 25-year bond issued 5 years ago with a coupon of 6% and a par value of $14,000,000. The company’s main competitor just issued a similar bond paying 5%. The...
please show me how to do this using excel you do not expect there to be...
please show me how to do this using excel you do not expect there to be a dividend paid on a share of common stock next year. after that you expect a $2 dividend that will grow at a constant rate of 6% there after. how much would you pay for the stock assuming a cost of equity of 10%
1) A) At the beginning of last year, you invested $4000 in 80 shares of the...
1) A) At the beginning of last year, you invested $4000 in 80 shares of the Chang Corp. During the year, chang paid dividends of $5 per share. At the end of the year, you sold the 80 shares for $59 a share. Compute your total HPY on these shares and indicate how much was due to the price change and how much was due to the dividend income ANSWER FOR A: =[ $5 + (59 - 50)] / 50...
Four months ago, you purchased 1,200 shares of City Stream stock for $19.08 a share. You...
Four months ago, you purchased 1,200 shares of City Stream stock for $19.08 a share. You have received dividend payments equal to $.60 a share. Today, you sold all of your shares for $20.08 a share. What is your total dollar return on this investment? $720 $3,840 $1,440 $1,200 $1,920
You purchased 200 shares of Frozen Foods stock for $42 a share eight months ago. Today,...
You purchased 200 shares of Frozen Foods stock for $42 a share eight months ago. Today, you received a dividend of $0.40 a share and also sold the shares for $46 each. What was your effective annualized rate of return on this investment?
You purchased 100 shares of General Motors stock at a price of $106.82 one year ago....
You purchased 100 shares of General Motors stock at a price of $106.82 one year ago. You sold all stocks today for $106.94. During the year, the stock paid dividends of $5.88 per share. What is your holding period return? You are considering the purchase of Crown Bakery, inc. common stock that just paid a dividend of $15.15 per share. You expect the dividend to grow at a rate of 5.34 percent per year, indefinitely. You estimate that a required...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT