I want to calculate how much is amortization on a car lease with annuity.

We pay the same amount each month, so in the beginning a larger part is
interest and a smaller part is amortization. What I want to calculate is how
much have been amortized after for example one year.

Which function do I use for this?

Annika

Hi Annika,

There are many ways to do that. One is to download this Loan Amortization template:

http://office.microsoft.com/en-us/ex...346401033.aspx

Another is to use Excel's Financial functions, described he

http://office.microsoft.com/en-us/ex...117451033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Annika" wrote in message ...
|I want to calculate how much is amortization on a car lease with annuity.
|
| We pay the same amount each month, so in the beginning a larger part is
| interest and a smaller part is amortization. What I want to calculate is how
| much have been amortized after for example one year.
|
| Which function do I use for this?
|
| Annika

Thanks a lot Niek, I used the first option.
Kind regards,
Annika


"Annika" skrev:

I want to calculate how much is amortization on a car lease with annuity.

We pay the same amount each month, so in the beginning a larger part is
interest and a smaller part is amortization. What I want to calculate is how
much have been amortized after for example one year.

Which function do I use for this?

Annika