I think this is straightforward, but I can't figure it out:
X principal is charged Y% daily compound interest at date Z.
What is the interest + principal at date A?
Beyond that, the amount of the principal is added to over time (the customer
adds to principal at Z date+something), and I need the same result, but I
assume I can do that as a separate calculation.
For example, Joe owes $100 on January 1 at 10%, compounded daily. What does
he owe, principal and interest, on December 31 of that year?
He owes an additional $50 on July 1 at 10%; what does he owe, principal and
interest, on December 31 of the year?
How can I set this up with each loanl as a record/row, with its start date
and end date and interest, and aggregate all like this:
principal/start_date/end_date/interest/principal/interest//interest+principa
l
Can I do this with absolute dates?
Thanx.
|
Similar Threads
