I am trying to do a project like a loan calculator but with fixed payments and interest rate.
Anybody can give me a help on this project?
Thanks
Loan Amount Monthly Rate Payment Period
5,000.00 0.02 5
Number Date Loan Amount Rate Amount Total Date Paid Amount Paid Balance
1 1/1/2010 1,000.00 100.00 1,100.00 2/1/2010 1,100.00 4,400.00
2 2/1/2010 1,000.00 100.00 1,100.00 3/1/2010 1,100.00 3,300.00
3 3/1/2010 1,000.00 100.00 1,100.00 4/1/2010 1,100.00 2,200.00
4 4/1/2010 1,000.00 100.00 1,100.00 5/1/2010 1,100.00 1,100.00
5 5/1/2010 1,000.00 100.00 1,100.00 6/1/2010 1,100.00 -
Totals 5,000.00 500.00 5,500.00 5,500.00