variable Interest rates, variable period in days, variable amount oustanding

[MJAK]

I want to calculate a formula in excel, whereby my loan amount is constantly changing, due to payments into the loan account, and draw down from the loan account. i want to calculate the interest that would be charged based on the increasing and reducing loan account. the calculation should be based upon interest based on the number of days the interest is charged on the outstanding amount.

[scotman]

Use the help files for financial functions. something like PPMT might be useful