Answer:
C) $142,576
Explanation:
The computation of the maturity value of the CD is shown below:
We use the future value formula that is shown in the spreadsheet.
Given that,
Present value = $100,000
Rate of interest = 12% ÷ 4 quarters = 3%
NPER = 3 years × 4 quarters = 12 years
PMT = $0
The formula is shown below:
= -FV(Rate;NPER;PMT;FV;type)
The future value is $142,576