MS Access 2000 application requires finishing touches. This application in divided in to Access front-end and a seperate Access back-end. Tables are linked. This project is only for a payment schedule generator that is 60% complete. A payment schedule must be generated based on amount financed with an interest rate of 0.0%. Payments can be made weekly, bi-weekly, monthly or semi-monthly (first and middle of the month). Typically, one would specify the financed amount, the start date and the montly payment amount. Based on that information, the program will add an entry to the database for each payment required to bring the balance to $0.00 (payoff), the date due, the balance of the loan and other pertinent information.
Please note, the module is 60% complete and you should look at the code to verify you understand. It is written in VBA.
Please contact me to view current code.
An example of a typical customer interaction:
After choosing the product they want (and the amount financed) they would chose how much they want to pay and how often they would like to pay it. The interest rate would always be 0% so this is not an issue. The customer would make their payment on the day they choose and for the amount we agree on. Based on this amount, repayment period and begining date, the payment schedule would outline how many payments they need to make, the date each payment is due and the balance after making each payment.
e.g. Joe finances $2000. He decides that he gets paid every Thursday so he would like to pay every two weeks on Thursdays. He would like to pay $100 every two weeks starting this Thursday the 8th. The payment schedule generator would calculate how long it would take hime to pay it off starting the 8th and schedule each payment.
1. Due on 1/8/2004 balance: 1900
2. Due on 1/15/2004 balance: 1800
1) Working payment schedule generator. Must insert records in database and calculate balance and payments correctly (mathematical erros are unacceptable).
2) All source code must be included. Work must be done in VBA (no macros).
Windows platforms that run MS Access 2000.