Loan Calculation Challenge

[Stephen Lynch]

Do anyone have a sample access database that can perform loan functions.

Here's what I am trying to do. I have 2 tables, 1 has the Loan info and the
other has the payments.

I want to run a query that shows balance due. For example:

If I have a loan that is $100,000 with monthly payments at 10% a start date
of 1/1/05 and the following payments

1/15/05 $500
2/03/05 $1500

Whats my balance. Its easy to do on a spreadsheet but I need the query to
output like this:

Period Start Balnce Date Paid Amount Interest Due Balance
1 $100,000 1/15/05 $500 $600
$100,100
2 $100,100 2/3/05 $1500 $900 $
99,400


I wish this could be done!!

Thanks in advance.

 

[[MVP] S.Clark]

In 'Access 2003 VBA Programmer's Reference' published by WROX, I wrote an
entire piece about calculating running balances.

Check it out.