This project is reposted as the person who won the last project has no idea how to do it - so I have given up.
Here is the project.
I am owed $[url removed, login to view]
currently at 10% p.a.
over 80 equal payments.
I have received payments on an infrquent basis.
I want a program building where I will enter the date and amount of payment received.
The program will calculate the interest that has accured to the date of payment and then deduct from that amount the principal and interest that was inherant in the paynent they made. i.e.
I.E. Amount Of Orignal Loan - say $2,000
monthly payment say $80. $50 principal $30 interest.
Date of Loan 1 Jan 2002.
First payment due 1 Feb 2002.
Say first payment received 1 Feb 2002.
We will have a schedule that shows.
Orignal Principal $1,0000
Payemnt 1 FEb 2002 Princpal 50 Int. $30 Net Due $1950
Then next payment is made 1 August 2002 ( really March payment)
Payment 1 Aug 2002 Accrued Interest ( say) + 240
Payment Principal 50 Int 30 - 50
Amount now due 2140
Next Payment received 1 Sept 2002 - now there is still
accrued interest to be calculated as the April, May, June, July Aug and Sept payments are due and accruing interest.
Then partway through the loan I lent the person some more money we see need to be able to adjust the principal and interest accrual for this, - not that the payments remained constant as per the first original amount, so the amount of P and I will shift after this date.
So I want a nice neat simple well layout program to do this.
Do not respond unless you fully understand how to do this - no I am not giving the formulas as if you don't know them you should not be bidding.
We will test the logic of the program with some example date, no more than 4 lines before I sign off and make payment, I am not going to be done again !
I have seen the bids so far. This is not a multi million or multi thousand dollar project.
This is extremely simple if you know what you are doing.I can do it with 3 calculations in Excel