loan amortizations worksheets

[Guest]

I know I have pulled up prepared loan amortization funcitons in excel where
you enter the loan amount interest rate term etc and it will calculate the
payments - I cannot find it now - can someone remind me how to find them

 

[Morrigan]

PMT() and PPMT()?

I know I have pulled up prepared loan amortization funcitons in excel
where
you enter the loan amount interest rate term etc and it will calculate
the
payments - I cannot find it now - can someone remind me how to find
them

 

[spirosu]

Microsoft's site has some neat templates submitted by users...

'Loan ammortization'
(http://office.microsoft.com/en-gb/templates/TC010756581033.aspx)

'More here...'
(http://office.microsoft.com/en-gb/results.aspx?Scope=TC&Query=loan+ammortization)

'Main site...'
(http://office.microsoft.com/en-gb/templates/default.aspx)