Answer:
$1,586.87
Explanation:
Rate (I/Y) = 8.00%
Period (N) = 6
Amount (PV) = 1000
PMT = 80
Annual compounding type
Using the MSExcel function to solve for FV.
Future value = FV(Rate, Nper, Pmt, -Pv, 0)
Future value = FV(8%, 6, 80, 1000, 0)
Future value = $1586.87432294
Future value = $1,586.87
So, the value of the certificate when it matures will be $1,586.87.