Suppose you bought a bond with an annual coupon of 7 percent one year ago for $970. The bond sells for $940 today.

1. Assuming a $1,000 face value, what was your total dollar return on this investment over the past year?
2. What was your total nominal rate of return on this investment over the past year?
3. If the inflation rate last year was 3 percent, what was your total nominal rate of return on this investment?

• Complete the following analysis. Do not hard code values in your calculations.

1. Dollar Return: What is the formula for excel?
2. Nominal return: What is the formula for excel?
3. Real Return: What is the formula for excel?