I am using the loan calculator (Amortization tables) in Excel (2002).
In inputting say a 30 year loan with fortnightly payments - i.e. 26 payments
per year as opposed to 12 monthly payments, the loan summary box at the top
shows scheduled number of payments as 780 - which is correct, but then shows
actual number of payments as 361. Why is this so?
In scrolling down the worksheet, at payment number 360, the calcs just stop
and there is a massive balance outstanding. What gives? Why doesn't it flow
through until a zero balance is reached, as it does if there a re 12 monthly
payments?

Any help would be appreciated.