Loan Amortization Template
I am having trouble with the amount of payments per year cell. If I wish to pay 12 payments a year (monthly) the calculations are reasonably accurate, however if I wish to pay fortnightly or weekly, it still works out on 12 monthly payments, but dates of payments are spread over the 26 (fortnight) or 52 (weekly)payments. Even by doing calculations of monthly payments and then adding extra payments it still extrapolates it out further than 12 monthly payment (in time). Can anyone help how to fix the problem.