Amortisation using Actuarial method

Imbuzi · Mar 24th 2005

Well chaps its been a while since ive been on here and asked a question.

Ive been asked to build a spreadsheet that is able to amortise a sum of money using the actuarial method.

Only one problem is I havent got a clue where to start. is there any finance peeps that would be able to get me started?

TIA

Graeme

Will Riley · Mar 24th 2005

Re: Amortisation using Actuarial method

I know Dave has a tool for sale that does it here

http://www.ozgrid.com/Services/apr-spread-calculator.htm

At $19.95 it doesn't seem too hefty a price to pay if it does what you want...

Unfortunately, I have never had a burning desire to read and digest Appendix J of 12 CFR Ch. II, Pt. 226, the portion of the United States Code of Federal Regulations known as "Regulation Z" :lol: So although I am technically a Finance Peep, I'm afraid I can't help you

Fin Fang Foom · Mar 25th 2005

Re: Amortisation using Actuarial method

I dont know this file could help you but it might get you started.

Imbuzi · Mar 25th 2005

Re: Amortisation using Actuarial method

Quote from Fin Fang Foom

I dont know this file could help you but it might get you started.

Thanks for the file but unfortunately the amortisation schedule that you posted isnt the actuarial method and isnt accurate enough. Thanks anyway though.

Amortisation using Actuarial method

Participate now!

Share

Users Viewing This Thread