please show me your work using excel so i understand. thank you!

You buy a TIPS at issue at par for $1,000. The bond has a 5% coupon. Inflation turns out to be 2%,8%,4%, and 4% over the next 4 years. The total annual coupon income you will receive in year 2 is Please note this question refers to monetary (cash) income, not the rate. (i.e. $48.00 ) Please round to the nearest two decimals. Please do not include the $ symbol