MS Access Loan amortisation schedule creator

Concluído Postado Sep 2, 2008 Pago na entrega
Concluído 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

Engenharia Microsoft Access MySQL PHP Gestão de projetos Arquitetura de software Teste de Software

ID do Projeto: #3190909

Sobre o projeto

26 propostas Projeto remoto Ativo em Sep 12, 2008

Concedido a:

vw7027874vw

See private message.

$425 USD em 14 dias
(1 Comentário)
3.3

26 freelancers estão ofertando em média $253 nesse trabalho

fastudiovw

See private message.

$119 USD in 14 dias
(728 Comentários)
7.5
Prashantskin

See private message.

$255 USD in 14 dias
(505 Comentários)
7.0
debihammel

See private message.

$425 USD in 14 dias
(39 Comentários)
6.5
mrbraden

See private message.

$295.8 USD in 14 dias
(14 Comentários)
5.8
mrrcomputers

See private message.

$276.25 USD in 14 dias
(43 Comentários)
5.6
tootwotrue

See private message.

$297.5 USD in 14 dias
(6 Comentários)
5.4
madexpert

See private message.

$255 USD in 14 dias
(47 Comentários)
5.1
alekhine1962

See private message.

$127.5 USD in 14 dias
(21 Comentários)
4.3
abhaysinghb

See private message.

$212.5 USD in 14 dias
(9 Comentários)
3.8
tito1024vw

See private message.

$85 USD in 14 dias
(18 Comentários)
3.5
jag5x5vw

See private message.

$425 USD in 14 dias
(11 Comentários)
3.6
vibsworld

See private message.

$170 USD in 14 dias
(19 Comentários)
3.7
vw6937213vw

See private message.

$212.5 USD in 14 dias
(10 Comentários)
2.8
alekseymihalych

See private message.

$85 USD in 14 dias
(16 Comentários)
2.2
mahesh004

See private message.

$170 USD in 14 dias
(4 Comentários)
1.6
jon0jonlx

See private message.

$255 USD in 14 dias
(3 Comentários)
1.4
gcomputer

See private message.

$85 USD in 14 dias
(2 Comentários)
1.1
isrvw

See private message.

$1275 USD in 14 dias
(1 Comentário)
0.0
bigmike000vw

See private message.

$85 USD in 14 dias
(0 Comentários)
0.0
amolkale

See private message.

$212.5 USD in 14 dias
(0 Comentários)
0.0