Answer:
$76,620.83
Step-by-step explanation:
According to the scenario, computation of the given data are as follows
Future Value (FV) = $100,000
Rate of interest = 10% yearly
Rate of interest (Rate) = 10%÷ 2 = 5% semiannually
Number of period (Nper) = 9 × 2 = 18
Face value = $100,000
Payment (pmt) = $100,000 × (6%÷2) = $3,000
By putting the value in excel present value formula, we get,
PV = $76,620.83
Attachment is attached below