1
vote
Loan: calculate number of monthly payments with fixed annual interest, fixed montly payment, and 1 additional payment per year
There may not be a closed-form formula to determine the length due to the extra periodic payment, but the algorithm can be done fairly easily in a spreadsheet:
You need 5 columns: Month, Payment, ...
- 130k
Only top scored, non community-wiki answers of a minimum length are eligible