# Amortization

1. ## Amortization

HomeLoan computation:

By given loan amt(PV), % rate(rate), tenure(nper), we may compute the
instalment by using '=PMT' function.

If the tenure = 20 years and we wish to find the outstanding principal after
10 years, we may get it by using amortisation.

Question: is amortisation available in Excel 2003?

2. ## Re: Amortization

There is a CUMPRINC function that returns the cumulative principal paid
between 2 periods. If you subtract that from the initial loan amount, it
should give you the balance.

On Sun, 6 Mar 2005 19:33:02 -0800, Sam <Sam@discussions.microsoft.com> wrote:

>HomeLoan computation:
>
>By given loan amt(PV), % rate(rate), tenure(nper), we may compute the
>instalment by using '=PMT' function.
>
>If the tenure = 20 years and we wish to find the outstanding principal after
>10 years, we may get it by using amortisation.
>
>Question: is amortisation available in Excel 2003?

3. ## Re: Amortization

or simply using PV function for the remaining period for the PMT, rate% and
period = 10 years

"Myrna Larson" <anonymous@discussions.microsoft.com> wrote in message
news:d0cp21d4jfq79g5iusdti8mdeuro8v52ri@4ax.com...
> There is a CUMPRINC function that returns the cumulative principal paid
> between 2 periods. If you subtract that from the initial loan amount, it
> should give you the balance.
>
> On Sun, 6 Mar 2005 19:33:02 -0800, Sam <Sam@discussions.microsoft.com>
> wrote:
>
>>HomeLoan computation:
>>
>>By given loan amt(PV), % rate(rate), tenure(nper), we may compute the
>>instalment by using '=PMT' function.
>>
>>If the tenure = 20 years and we wish to find the outstanding principal
>>after
>>10 years, we may get it by using amortisation.
>>
>>Question: is amortisation available in Excel 2003?

>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1