What is the calculation formula for future selling prices ($1,018, $982, and $1,037)? And what is the excel function?

LOS : Define, calculate, and interpret Macaulay, modified, and effective durations Duration O A measure of a fixed income security's weighted average time to maturity. For example, a nine-year bond with a 7% coupon rate and a 6% yield to maturity has a duration of approximately seven years (current price is $1,068). Illustration Cash Flows Year 1 - 8 Cash Flow Year 9 $70 $1,070 Yield to Reinvested Future Selling Terminal Value Maturity Coupons Price 6% $588 $1,018 $1,606 8% $624 $982 $1,606 5% $569 $1,037 $1,606