Answer:
$1,262.36
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 = $1,000
PMT = 1,000 × 10% = $100
NPER = 7 years
Rate of interest = 5.4%
The formula is shown below:
= -PV(Rate;NPER;PMT;FV;type)
So, after solving this, the present value would be $1,262.36