Excel provides functions to calculate a variety of numbers for mortgages
(when they have a monthly compounding interest rate) but I cannot find
functions to generate those numbers when the quoted annual rate is compounded
on a semi annual basis.