2.5%

Column A, cells A1, A2 etc have values in it. i.e. 525000 675000 etc. In cell B1, B2 etc I need to know how to get 7% of the first 100,000 and 2.5% of the remaining amount I.E 525,000, 7% of 100,000 plus 2.5% of 425,000 675,000, 7% of the first 100,000 plus 2.5% of 575,000 I can do it in two...

Hello all, I have a table with two types of percentages based on a time period: Predicted Achieved I plotted the graph, but I wondered if it is possible to conditionally format the markers of the Predicted series. Eg: At week 41 I predicted 2.5% and achieved 2.5%. Green marker. In week...

Hi everyone, first time poster but read the forums often and have learned a lot. I dont use the graphs, etc in Excel very often I am trying to find the best way to display this info in a graph (the boss is persistent that it be graphed. I have put in a bar chart, but now they are asking if it...

Hi All, I used the follwing forumla: =(FV(Int,NPER,0,-NPV(Int,PMT*(1+Grw)^(ROW(INDIRECT("1:"&NPER))-1))*(1+Int) to work out my future investment value. I wanted to start paying £20 every month into an investment portfolio for the next 40 years, wit a fixed interest rate of 2.5%. However, every...

Hi All, I have had a look at a number of forums to try and find the answer to my question, but I will need this to be simplified. Suppose I started paying £20 every month into an investment portfolio for the next 40 years, with a fixed interest rate of 2.5%. However, every year I increase my...

Hello all, I'm looking to create a formula that will decrease a percentage applied each year by a 2.5%. For example, to start or year 0, 50% is applied. In Year 1 this is reduced 2.5% to 47.5%, in year 2 there is a further reduction of 2.5% to 45%. This continues until the percentage applied...