Localfund.com - All about Fund and Investment
*Home>>>Debt Financing

How do I compute compounded interest on a spreadsheet?


I keep track of my personal finances in Excel, specifically my debt (credit cards, student loans, and mortgage). I know my balance due and interest rate for each, and want to compute how long it will take me to pay off each item including compounded interest.

I actually cannot assist with the formula on the spreadsheet, but what I do is just calculate it on http://partners.leadfusion.com/tools/mot... -- then I add it to my spreadsheet. I update it once every few months as I'm able to pay more on debt or whatever.

usually to calculate compound interest, you would:

principal divided by interest rate.

I do the same thing on a principal worksheet at home. Lets say I take $3000 and invest it annually at say 8%... ill start with one cell at $3000 (ex. cell A1), the one below it would read ((A2+3000)*1.08). After that i just click and drag the cell down to get what I would get annually. Good Luck!

Tags
  Easy Money   Easy Investing   Earn Money   Direct Investment   Debt Financing   Capital Investment   Business Investment   Business financing
Related information
  • Credit Charged off transferred to collections... but collection agency not reporting?

    Sorry to tell you, but no you are not off the hook, at least not for 7 more years. Here are some links that may help you out with this. ...

  • M&A related question-please help?

    Well, there are probably more ways. But the two that I can see off the top of my head are that you get the tax shelter from the interest payments on your 100$. Not only that, but because you paid...

  • I need help understanding this Q and A ?

    "Debt" just means they borrow money. Maybe it's a line of credit or a loan, or maybe the company issues bonds. (Bonds are just fancy loan notes. Stock, on the other hand, is a part o...

  • What is my recourse if I am threatened by a collection agency?

    If you can prove to the credit agencies that they report to that it could not possibly be your debt by means such as you were under 18 at the time of the charges, or prove that you father resided a...

  • Iam looking for a grantor who will help me and my husband borrow $15000 from a finance company in new zealand?

    good luck on your loan search -------------------- # Don鈥檛 pay for the promise of a loan. # Ignore any ad 鈥?or hang up on any caller 鈥?that guarantees a loan in exchange for a fee in advance. #...

  • BAD CREDIT: Paying off chargeoffs, rebuilding credit score..??

    My husband paid off a $5000 chargeoff last year, and his credit score is now around 670. I don't remember what is was before, but he used to get denied any credit he would apply for and now h...

  • Should I make a large down payment on a used car or pay down credit cards?

    Tis a quandary. You need a car. You also need to get that debt paid down. Using 71% of your available credit is lowering your credit score by a bunch. You really need to get that under 30%. ...

  • Any loan experts out there?

    YOu would have no problem getting a 100 percent loan - Lenders will love you, for you credit score and job time alone - rates are still in the 6's but they are creeping up - - if yoiu thought ...

  •  

    Categories--Copyright/IP Policy--Contact Webmaster