Hi W,

See the template below, it seems like it could meet your needs.

'SpreadsheetZONE - Free Excel Template Repository'
(http://www.spreadsheetzone.com/templateview.aspx?i=21)




W;515794 Wrote:
Does anyone make an Excel A for compound interest loans that will
A expand out the lines for additional payments, and which will
let you for a given payment specify an arbitrary amount of the
original
principal you are repaying?

Every compound interest application I have found so far calculates the
next
periods compound interest by adding the last period's interest into the
loan
amount. That's fine for purposes of calculating the next interest
payment,
but it's bad from the standpoint of keeping track of the original
principal.
Repayment of original principal is not taxable, whereas payment of
interest
due is taxable, so ideally you would like to have fine tuned control on
how
much of each payment is repaying principal.

Does any Excel template offer this flexibility?

--
W


--
suzzy
------------------------------------------------------------------------
suzzy's Profile: http://www.thecodecage.com/forumz/member.php?userid=435
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=141600