Amortization

G

Guest

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?
 
M

Myrna Larson

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.
 
N

N Harkawat

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

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

Similar Threads

CUMIPMT with balloon payment 5
Loan Amortization Template in Excel 3
APR Question 11
Help with Rate function 2
PV(), FV() confused by sign expected 1
return to default when worksheet opened 1
Excel IPMT - strange results? 1
Goal Seek - Why make the PV negative? 1

Top