Calculate your investment's value with the NPV, PV, and FV functions in Zoho Office Integrator

Calculate your investment's value with the NPV, PV, and FV functions in Zoho Office Integrator

Hi users,
 
We are pleased to introduce three new formulas in Zoho Office Integrator's document editor: Net Present Value (NPV), Present Value (PV), and Future Value (FV). These formulas allow you to calculate the value of your investment over a specific period of time, after taking into account the discount rate (such as inflation or interest rate).

A real world example of the NPV function:

Say you are an investment banker and you wish to send a few investment opportunities and plans to your clients. To help them select the best option you can use the NPV function to compare the expected returns for each investment plan during a specific period.
 

Sample NPV function :

  1. = NPV(0.05,-5000,4000,2000,6500)
where:
0.05 is the interest rate in decimals (5%),
5,000 is the initial investment amount,  
4,000, 2,000, and 6,500 are periodic cash flows.

Info
Note: You can use the NPV, PV, and FV functions in both regular documents and merge templates. Learn more about Zoho Office Integrator's Merge APIs.

Want to see how to use Zoho Office Integrator? Check out this overview.
 
Try the new NPV, PV, and FV functions in Zoho Office Integrator and let us know your feedback by dropping a comment or writing to us at support@zohoofficeapi.com or support@eu.zohoofficeapi.com.
 
If you have any formulas that you want us to add in Zoho Office Integrator, let us know in the comments.
 
Best regards,
The Office Integrator Team