fortnightly payments problem in Excel Amortization tables?

T

tonyboy

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.
 
F

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top