Help need formula or logic for computing avg daily balance

I have a working knowledge of

Visual Basic, i took an

intermediate

level at a local community college.

I recently purchased a car for $7500 on my parents home equity

loan.

In order to easily and accurately calculate interest, I would

like to

build my custom VB program. My problem is that I don't know how

to

implement a formula for the Average Daily Balance.

The formula is:Avg Daily Balance= Beginning balance for each day,

+ loan advances -payments. Then add up all the daily balances and

divide by the number of days in the billing period.

Can someone please give me any suggestions.

Got questions? Get answers over the phone at Keen.com.

Up to 100 minutes free!

http://www.*-*-*.com/