Loan calculator

[Alli]

Hi,
I have a loan amount with a fixed interest rate. I have been making
payments fortnightly that are variable amounts. I would like to track what I
owe in excel but am not sure how to do this. I am new to using excel in this
manner.....

I would greatly appreciate someone helping me out!! I have looked at various
functions but just dont know which one to use!!

thank you
Alli

 

[Gary''s Student]

You may be able to adapt this to your needs:

http://office.microsoft.com/en-us/templates/TC062062831033.aspx?pid=CT101444811033

 

[Alli]

Thanks... I'll give it a go... I think I should be able to work it out from
that ..
Cheers
Alli