Answer:
the number of years taken to pay off the mortgage is 22 years
Explanation:
The computation of the number of years taken to pay off the mortgage is as follows;
= NPER (((1 + 9% ÷ 12)^(12 ÷ 26) - 1),0.5 × PMT(9% ÷ 12,12 × 30 ,100,000),100,000)
= 567.398762 biweeks or 21.82302931 years
= 22 years
hence, the number of years taken to pay off the mortgage is 22 years