debt

Hi All, I have a debt of about 500.000 USD with an annual interest rate of 4.5% (quarterly added, so every 3rd month, the debt is increased by approximately 4.5% * 0.25 = 1.13%). Me and my friend are able to pay off debt at our own pace. I would like to setup an excel sheet, where I can...

Ok so I have my monthly bills on one sheet and my overall debt on the second sheet and I want some way to tell excel when I pay a monthly bill and it automatically take that amount off the total debt on the second page. I cannot figure out a way to tell excel when I make a payment. So in my...

Hey guys! I am trying to build out a MMULT + MINVERSE formula to automatically solve for an optimal debt to equity ratio. <tbody> Input (optimal ratio) 1 Debt 1 Equity 2 Debt-to-equity Ratio .5 </tbody> Currently, my debt to equity ratio is .5, or 1/2. What I am trying to do is...

I am needing help developing a formula that allows the overflow from one to apply to another cell. Basically someone is paying multiple monthly debts but the second debt can't be satisfied until the first one is and the third one can't be satisfied until the second one is. So this is a monthly...

Hi, I have been working on a debt consolidation calculator. Basically I want to list a set of debts and have excel calculate when each debt is being paid off and create a graph over time. The part I am having trouble with is as each debt is being paid off, the contribution of that debt now...

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...