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?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

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)

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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...
You purchased shares of Apple (AAPL) on 31 August 2018 for $225.87 per share. Recently, the...
You purchased shares of Apple (AAPL) on 31 August 2018 for $225.87 per share. Recently, the stock sold for $203.86 per share. During the time you owned the stock, you received dividend payments of $0.73 per share twice (8 November 2018 and 8 February 2019). What is your percentage return on this investment?
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
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%
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?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT