Hi Guys!
Below is a link to my "debt tracker spreadsheet". What I want is a current total of all my debt balances after taking into account my last payment. I think I could use the FV function but I was trying to get away with not having to input the number of payments because I'm not sure whether I can use the remaining payments or the amount of payments I started with. Anyway, the current formula I use to calculate my new balance is: =IF((I8-H9)<=0.0001,0,(I8-H9)*(1+(H$5/12))). I have no idea where I came up with this. It gets it close to the current balance but it's always a little off. It's starting to bug me now so I was hoping to get some suggestions from you all. I appreciate your help!!
https://vectr.com/aswan0503/e1a7sy8prT.svg?width=640&height=640&select=e1a7sy8prTpage0
Below is a link to my "debt tracker spreadsheet". What I want is a current total of all my debt balances after taking into account my last payment. I think I could use the FV function but I was trying to get away with not having to input the number of payments because I'm not sure whether I can use the remaining payments or the amount of payments I started with. Anyway, the current formula I use to calculate my new balance is: =IF((I8-H9)<=0.0001,0,(I8-H9)*(1+(H$5/12))). I have no idea where I came up with this. It gets it close to the current balance but it's always a little off. It's starting to bug me now so I was hoping to get some suggestions from you all. I appreciate your help!!
https://vectr.com/aswan0503/e1a7sy8prT.svg?width=640&height=640&select=e1a7sy8prTpage0
