= Calculating returns - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 * be Paste AA % M BIU A Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Clipboard Font Styles A1 fo B D E F G H J K 2 2 Suppose you bought a bond with an annual coupon of 7 percent one year ago for $970. The bond sells for $940 today. a. Assuming a $1,000 face value, what was your total dollar return on this investment over the past year? b. What was your total nominal rate of return on this investment over the past year? c. If the inflation rate last year was 3 percent, what was your total real rate of return on this investment? 4 5 6 7 Coupon paid Initial price Ending price Inflation rate 8 70 970 940 3% 9 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 13 14 a. Dollar return