nper

  1. K

    Calculate end of stock date with NPER formular

    Hi all, I have an excel sheet that help us calculate hove many days we have on stock for a specific component and return the date we run out of stock. The calculation contains the current stock level, different phase out day for for each product the specific component is a part of and usage per...
  2. J

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

    [VBA] Use application.run to active sub error

    I was replicating the loan amount calculator VBA. Now I have created a button to get a calculated value. the calculation process is listed in the sub 'Calculate' which is in a module. However, there is always an error message when i click the botton. i click debug and it yellow highlight...
  4. D

    NPER Calculation (Incorrect Answer)

    Dear All I want to calculate the remaining period (in months) of a EUR10,000 loan where I have already paid EUR1,000. The interest rate is 12% and my monthly payments are EUR100 at the beginning of each month. This is in fact the example that can be found on MS Excel 2003 and 2007 for the...

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
Back
Top