Answer:
$1,757.05
Step-by-step explanation:
In this question, we use the PV formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Future value = $2,000
PMT = 2000 × 7.1% = $142
NPER = 23 years
Rate of interest = 8.3%
The formula is shown below:
= -PV(Rate;NPER;PMT;FV;type)
So, after solving this, the present value would be $1,757.05