Donate SIGN UP

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

Avatar Image
MJAK | 08:59 Sat 17th Oct 2009 | Business & Finance
1 Answers
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.
Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by MJAK. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Use the help files for financial functions. something like PPMT might be useful

Only 1 answerrss feed

Do you know the answer?

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

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.