Hi,

I seem to have a problem with HTML maker so I can't paste my sheet

From your amortisation rate I'm guessing that you pay off the loan twice a month or therabouts. You can calculate what your total regular payment is using PMT, ie

=PMT(5.5%/(5*24),5*24,13744)

= 131.13

This means 120 bi monthly payments of $131.13 will pay off the original $13,744 loan at a 5.5% interest rate

This regular payment can be broken into its interest and principal components using IPMT and PPMT

Put the numbers from 1 to 60 into cells A1 to A60

In B1 put

=IPMT(5.5%/24,A1,5*24,13744)

In C1 put

=PPMT(5.5%/24,A1,5*24,13744)

and copy down to B120 and C120

The total of the Principle column (C1:C120) is 13,744

The total of the Interest column (B1:B120) is 1,992

And ignore the last comment I made in the previous post, it wasn't relevant to what you are after.

Cheers

Dave