On other sheet there is payment plan you print for further references.
There are some limitation in regarding of period (30 years), amount (350000 $), but this can be easy adopted on user interest. Also currency is set on $, but this can be easy changed.
This template can be adopted with specific requirements, but this should be discussed and agreed.
It is made so far for Windows, not tested for Mac.