debt

  1. H

    Budget/debt sheet help!!!!

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

    Using MMULT to find optimal Debt-to-Equity Ratio

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

    Formula that allows overpayment to flow to a different cell

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

    Multiple Compound Calculations

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

    Debt Balance Tracker

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top