A reader asked if I could help with a loan between family members that did not have specific payment requirements. Payments could be made on any date and any amount. The lender could increase or decrease the loan by any amount on any date. There was also no set maturity date for the loan. The loan would compound semiannually.
A normal amortization would have specific coupon payments expected on specific dates, with a payment that was calculated to amortize the loan to zero after a specific time. You can see how using a normal amortization would be too unwieldy.
After a few ideas, my final shot on such an unstructured loan can be downloaded below.
There naturally are certain basic rules that must be adhered to make the schedule work:
You must remember to enter the compounding dates. Your options are Monthly, Quarterly, Semiannually, or Annually.
I have not tested this amortization in the real world, so as usual, use at your own risk.