Answer:
a. $1,024.74
Step-by-step explanation:
In this question, we use the present value formula which is shown in the spreadsheet. 
The NPER represents the time period. 
Given that, 
Future value or par value = $1,000 
Rate of interest = 6.1% 
NPER = 8 years 
PMT = $65
The formula is shown below: 
= -PV(Rate;NPER;PMT;FV;type) 
So, after solving this, the answer would be $1,024.74