Finance Calculator

Constant-rate, constant-payment signed cashflow model. Match rate and period units. NPER/RATE solving supports savings cashflows only to avoid ambiguous multiple roots.

Your workbenchInputs are not stored

Result

Enter your values and run the tool to see your result.

How to use this tool

Check the units, enter your values, and run the tool. Results follow the assumptions and method below.

References

https://support.microsoft.com/en-us/excel/financial-functions-reference
https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/pv-function