compound interest

I'll need a math wiz to help me with solving this question. I'd like to input this in Excel, so please make the solution formula-friendly. How long will it take to turn investing P into A, via dividend growth stocks? I know most of the calcs out there help people figure out what A would be if...

Hi I need to calculate compound interest with the following variable The principal value is : 100000 Now I need to calculate in row the following 1st year PV : 100,000 at 4% interest rate 2nd Year PV (100000 fixed) + (100000 X 4% PA) So and so forth till 15 yrs. I need this information all in...

Apologies if some iteration of this question has already been asked, but I wasn't able to find an exact analogue to my situation. I'd like to create a formula that calculates compound interest on a note based on user inputs for: (i) principal, (ii) annual interest rate, (iii) interest accrual...

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

Consider $100 invested for three years with the following returns: <tbody> <tbody> Initial investment $100.00 Return in Year One 6.8% 106.8% Return in Year Two -3.0% 97.0% Return in Year Three 10.6% 110.6% Terminal Value $ 114.58 4.64% <== AACR </tbody> The values in Column C...

Hello there. I was wondering what formula to use to calculate compound interest where the interest rate is not fixed each year e.g. investment of £400k interest rate months 1-12 @ 3% interest rate month 13-24 @ 3.5% interest rate month 25-100 @ 3% etc Hope that makes sense. I am using...

Hi all, I'm trying to build a table to calculate compounding of interest however the input amount is something I need to edit and the interest changes at different levels. I tried stacking multiple IF statements so =IF(A1<=300,0.01,IF(A1>300 OR <1000... my formula breaks. I don't know how to...

I am trying to create a spread sheet that will take a legal claim amount, add court costs and recoverable expenses to get the total judgment amount, and then apply a varied percentage (based upon the percentage of attorney fees awarded-hopefully with the ability to "set" the attorney fee owed by...

I need to make a calculation similar to that styled for mortgages with one exception, I need to add in $50k every year in addition to about 15% annual interest, the principal starting at $50k. None of the free online calculators do this plus I need to specify a different number of years than...

I saw this once, but can't remember how it's done. If I have an investment that returned the following in three years: 2.3% 4.6% 9.5% . . . my compound return is 1.023*1.046*1.095 minus 1, or 17.17%. If I have those three percentages in Column A, I usually create a formula in Column B to add...

Hi there. I am trying to understand how/why the IRR calculation is different than I would inherently assume. Let me explain. You can also view the simple file I created here on dropbox. https://dl.dropbox.com/u/83120324/IRR%20Calc.xlsx Assume an investor required a 10% internal rate of...