AgTalk Home
AgTalk Home
Search Forums | Classifieds (113) | Skins | Language
You are logged in as a guest. ( logon | register )

Interest in Excel
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Variorabbit
Posted 4/2/2022 21:20 (#9593951)
Subject: Interest in Excel


South Dakota
I built a simple Excel formula to calculate accruing interest on a loan. The interest rate changes every month. As of now, I go in and update the cell to add on the latest month and interest rate. I'm looking to make it less manually involved. Below is my formula. Does Excel provide anyway of handling variable interest?

Accruing interest = (number of days borrowed in January * (interest rate/365) * principal) + (number of days borrowed in February * (interest rate/365) * principal) + future month and interest rate + future month and interest rate, etc. etc.

Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)