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, ...
D Stanley's user avatar
  • 130k

Only top scored, non community-wiki answers of a minimum length are eligible