# 2.5%

1. ### Another Newb question

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...
2. ### Conditional Formatting Marker Line Chart

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...
3. ### New at Graphs, etc

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...
4. ### Using the NPER to work out how many more payments I would require (but it needs to acknowledge that the payments would be increasing each year by 2.5%

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...
5. ### Calculating the future investment value, with a fixed interest rate, but increasing monthly payments.

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...
6. ### incremental percentage reduction

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

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

### Which adblocker are you using?

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

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