Annuity

A

Annika

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
 
N

Niek Otten

Hi Annika,

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

http://office.microsoft.com/en-us/excel/HA010346401033.aspx

Another is to use Excel's Financial functions, described here:

http://office.microsoft.com/en-us/excel/HA011117451033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 
A

Annika

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


"Annika" skrev:
 

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