MS Access Loan amortisation schedule creator
$100-500 USD
Pago na entrega
We are a small finance company. We use ms access to hold our customer data, loan data, transaction data etc. Data is displayed using forms/queries etc. To calculate loan balances, we currently take data from access and paste into excel where the loan amortisation schedule is calculated. e now have too many loans and customers for this to work effectively.
I need a program written so that it is all done in access. 1 click on a form takes loan information data(loan amt, start date, payment period, interest rate etc) from loans table and transactions data(linked by loan number - date, pymt amount, payment type) and creates a loan schedule using current transactions to date and projects future payments to end of loan.
## Deliverables
I have? added a sample zip file. It includes the databse, current excel file and requirements doc attached. Please read the doc it should explain most of our requirements
I want the schedule to be displayed in access by clicking a button on a form which is used to display the customer data.
The basic use is to tell customers their current loan balance and how many payments left, how many made, total int, fees, principal paid and projected end date.
The second use is to generate reports based on calculated data. See doc file. Thanks for viewing
ID do Projeto: #3190909