fortnightly payments problem in Excel Amortization tables?

[Guest]

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.

 

[David Biddulph]

Perhaps you ought to look at the formulae in the relevant cells?

 

[Fred Smith]

I suspect that the template was set up to handle a 30-year mortgage with monthly
payments, hence it stops after period 360. What happens if you just extend the
table yourself? (ie, highlight the last row, grab the fill handle and copy down)