Answer:
$1,220
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 = 8.45% ÷ 2 = 4.225%
NPER = 30 years - 12 years  = 18 year × 2 = 36 years
PMT = $1,000 × 10.85% ÷ 2  = $54.25
The formula is shown below:
= -PV(Rate,NPER,PMT,FV,type)
So, after solving this, the answer would be $1,220