Answer:
$1,235.47
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 = $1,000
Rate of interest = 5% ÷ 2 = 2.5%
NPER = 15 years × 2 = 30 years
PMT = $1,000 × 7.25% ÷ 2 = $36.25
The formula is shown below:
= PV(Rate;NPER;PMT;FV;type)
So, after solving this, the answer would be $1,235.47