Daily Simple Interest.

Hello. I am needing to build a template to generate a report of daily interest on a loan. I need to be able to set the interest at the start along with a start date and have it calculate each days interest until the current date, what ever the current date maybe. I also need to be able to either may a payment or make another withdrawl on the same loan on any given day.

Here is a sample of what i am trying to do.

Loan Amount:
Annual Interest Rate:
Daily Interest Date:
Start Date:
Current Date:
Number of days since loan started:

Columns Needed: I need each day to print along with any additional Withdrawls or payments. There can be many years of interest, report needs to print each day in a full Ammortization Schedule. There is no set payment, it is strickly voluntary but additional withdrawls can be made.

Date: Beginning Daily Balance: Daily Interest: Additional Withdrawl Payment Made $: Current Balance$:

day1
day2
etc (Day should print date)

example:
Date: Beginning Daily Balance: Daily Interest: Additional Withdrawl Payment Made $: Current Balance$:

3-1-2012 $10,000.00 $20.00 $3000.00 $1000.00 $12020.00
3-2-2012 $20.00 $1000.00 $11040.00


Any help would be grately appreciated.
Thank you
Wyette