Em Andamento

Loan Repayment Calulator

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 !

Thanks.

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

Habilidades: Programação C, Javascript, Visual Basic

Ver mais: loan calulator, loan payment calulator, loan repayment calulator, repayment calulator, payment calulator, javascript repayment, due date calulator, interest payment calulator, int i, amount received, loan repayment program, loan payment, repaying loan, loan payment formula javascript, calulator loan, repayment 300000, excel interest calulator, additional monthly principal payment calulator, payment calulator interest start date, loan replayment foumla excel, loan repayment excel, payment calulator excel, repayment loan excel, extra payment calulator web, loan payment logic

Acerca do Empregador:
( 34 comentários ) George Town, Cayman Islands

ID do Projeto: #183760