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.

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

• Topic Participants

• Varadarajan AR

  

• Sticky Posts

• Latest updates to Zia in Office Integrator

  Hello Zoho Office Integrator users! We’re pleased to share exciting updates to the proofing capabilities of Zia, our AI-driven writing assistant, in Office Integrator. With these updates, you can now get spell and grammar check in Brazilian Portuguese,

• Role management in Zoho Office Integrator

  Hey Office Integrator users! We're pleased to announce that users now have the ability to assign role-based permissions, which empowers them to execute specific operations within Office Integrator and manage tasks like adding or removing user accounts

• Introducing post-paid billing in Zoho Office Integrator

  Hey users, We're pleased to announce that you can now maintain uninterrupted business operations even after API calls associated with your Office Integrator subscription plan have expired. With our new flexible post-paid billing option, you have the flexibility

• Recent Topics

• XML format to import knowledgebase into Zoho Desk

  Hi, We just started to use Zoho Desk and want to import our knowledgebase from our old support system (Freshdesk) to Zoho Desk. Can anyone give us information about the format of xml file to import? There is no explanation on the related page.

• Zoho Desk integration with Power BI

  Hi, I want to be able to create a Power BI report which has live updates of ticket data from zoho desk, is this possile at all? Thanks Jack

• Arranging Ticket Templates

  Is there any way to arrange our ticket templates? It doesn't look very organised when it's just arranged according to when they were created. We want the list to look more organised, by arranging/grouping them by topics, or even just by alphabetical

• What they mean with "Portal"?

  I just downloaded this app to take my personal notes on digital art studio because it seemed to me the most comfortable app to do it, I use it very often, what do they mean by “no activity on your portal”? I have about 1 year of work here and I don't

• favorites no longer listed

  Hello, I can no longer navigate to my Favorites from the pulldown at the top of my grid view (see attached screenshot). I wasn't able to find it anywhere! Please help me display my Favorites. Thank you!

• Notecards Disappeared

  Got a new phone. Downloaded and signed in Zoho Notebook. Not finding the Note cards. Just Empty Note books. Frustrating.

• Table Errors

  Hello, I'm new to Zoho Notebook and using it on several Mac/Apple devices. My question is regarding tables: Why do they become broken, and how to fix the error without retyping all my data? (Please see the screenshot attached.)

• Online Calculator with Zoho Forms?

  I'd like to build a custom calculator on my website. Zoho Forms seems to offer all the fields for basic calculations performed live without pressing any "Calculate" buttons. Unfortunately, there is still that "Submit" button at the bottom. There is nothing

• Zoho Tables instead of Zoho Creator Spreadsheet reports <3

  That would make my day for sure. Zoho Creator is create, but miss data entering as AirTable/Spreadsheet can. Seeing Zoho putting effort in this makes me think maybe one day we could see a similar interface for Zoho Creator spreadsheet reports. B.

• Notebook Stack

  Hi Everyone I Hope you´re fine, I´m sorry if this idea was posted before (I made a search but I haven´t find anything related). So, Having the possibility of stacking notebooks would be an interesting way to order notebooks that correspond to the same

• Writing on sketch cards is bugged when zoomed in

  When zoomed in, it writes a noticeable distance above or to the side of where you're actually trying to write. The further you're zoomed in, the more noticeable it is. Zooming is also entirely absent on the desktop version.

• Swipe between notes on iPhone

  It'd be convenient if I could move from one note to the next in a notebook simply by swiping left to right.

• Sales IQ chat is not working in signed android apk

  I have integrated ZOHO sales IQ support chat and i have followed each step and its working fine in my development build but when i create signed APK for it. Chat does not work in it and showing awaiting for detail. I previously asked the same query but

• COQL order by COUNT not working

  Dear community, I am trying to get a list of deal amounts per planner working on it and sorted to get see who has the least amount of deals. For some reason, I am unable to use sort by in combination with a COUNT. My original code was: query = "select

• I want to duplicate a report and name it something else

  Hi, I have created a report, and now want to reproduce it and call it something else. so that I will end up with TWO separate reports with different titles. Please tell me how do I copy / reproduce a report please

• Zoho CRM: Sales Rep Professional Certification Program on Coursera

  We are happy to share that we have published the Zoho Sales Representative Professional Certificate in partnership with Coursera, a leading platform for online learning and career development that offers access to courses and degrees from leading universities

• OS X Notebook quits immediately upon launch

  NoteBook for OS X (Sequoia, but also under Sonoma) always quits immediately upon launch (so I cannot use the "Attach user log" option). I've restarted my MacBook but the problem persists. If it helps, attached is a diagnostic report from Library>Log

• Can External users upload files or images to WorkDrive?

  I want to know if it is possible for someone externally through a link and PW be able to upload files and images onto WorkDrive?

• Multi-line fields character limits

  Is there a way to set the character limit higher on multi-line fields so that we are not losing information pasted into the field? When the text is entered or pasted, there is no error to say that the text is too large. After saving and going back to view most of the text is gone.   Also, when viewing the resume, the text is not wrapped in the multi line fields and can t be read without scrolling across the page.

• Taz bot not working — What should I do to resolve this issue?

  I am experiencing issues with the Taz bot in Zoho Cliq—not receiving responses or it does not seem to work as expected. Could you please explain why the Taz bot might not be functioning and what steps I should take to resolve this issue? Thank you!

• OneNote Migration

  I am trying to migrate two notebooks from OneNote. For five days now I have had no notification that migration has completed and the migration page show 50% complete - one notebook completed one not finished. It just stays like this. I am unable to cancel

• Set various time slot reminders for task and event

  Hi I would like known if there is possibility to set various time reminders for a task or event like we have the possibility to do in google calendar or google task. For example I'am creating an event or task and I want to be alerted before 30min and

• Zoho Calendar not functioning---cannot edit, add attendees, etc.

  Hello, My calendar is acting strange. I'm using Chrome as my browser and pop ups are not blocked (the calendar worked fine yesterday). When creating an event, I'm not able to "edit" the event and add attendees, etc. The link is non-responsive. I cannot

• Spilt Axis for stacked column and line graph

  Each month around this time I prepare a business review deck. One of the biggest annoyances I have with Zoho, also happens to be something that most other platforms have provided for a long time now, and that is being able to create a chart with stacked

• Pin a note on top

  Dear Zoho Notebook Team, Please highly consider adding ability to pin a note on top and arrange pinned notes. I have a lot of notes that I want to pin important ones on top and this feature is missing badly. Thank you.

• Windows 11 app ver 2.2.8

  I have been trialing Zoho Notes syncing between my PC and iphone. No problems with iphone but the Windows 64 bit app ver 2.2.8 was very buggy and would lock up completely, needing a Control Alt Delete etc to close it down. It seemed to be connected to

• Deluge Script: Onboarding → Access Form

  Hello everyone, Edit: Sorry, I think I put this topic in the wrong section. I’ve recently run into an issue that’s been giving me a bit of a headache for the past few weeks. Context: This is my first time using Deluge to create a script, but it’s not

• Windows Device Authentication

  We have recently started using ManageEngine, and my boss saw a device management feature in the Zoho One directory. We thought it would either help give us more intergration into Zoho one through bringing ManageEngine services through Zoho one. Or, it

• How can I change spell check language?

  I cannot find the way to change spell check language. My "display language" is English, and I want to have the same one for Spell Check, but it is Russian!!! How can I change it? In one of your explanations you mentioned that I have to choose it from

• Mail is so slow - doesn't even work!

  Mail has been getting slower and slower - and today it's not even pulling up emails in either Inbox or Unread. This is beyond frustrating since email is a big part of business. Sent a request through the useless help portal - no response. Called the useless

• User marked as SPAMMER. Mail Fetch has also been disabled for any active POP accounts.

  I am the administrator for joelles.com One of our accounts has been blocked saying this: User marked as SPAMMER. Mail Fetch has also been disabled for any active POP accounts. I cannot change the disabled account in the control panel as it says that it

• My domain did not activate

  Hi, my domain (apsaindustrial.com.ar) did not activate, and the phone verification message never arrived. Please would you solve this problem? Thanks.

• ME SALE ESTE ERROR: No fue posible enviar el mensaje;Motivo:554 5.1.8 Email Outgoing Blocked

  Ayuda!! Me sale este error al intentar enviar mensajes desde mi correo electronico de Zoho! Tampoco recibo correos pues cuando me envia rebotan. Ayuda, Me urge enviar unos correo importantes!! Quedo atenta MAGDA HERNANDEZ +5731120888408

• Is there a way to sync Tags between CRM and Campaigns/Marketing Hub?

  I wonder if there is a way to synch the tags between CRM and Marketing-Hub / Campaigns?

• how to see if a specific contact opened an email in zoho campaign?

  how to see if a specific contact opened an email in zoho campaign?

• Revenue Management: #8 Revenue Recognition in Educational & Training Institutions

  Educational Institutions and training centres typically collect course fees at the time of enrolment, sometimes for a one-day workshop and sometimes for a year-long certification course. You might also charge separately for course materials or evaluation.

• How to Customize Task Creation to Send a Custom Alert Using JavaScript in Zoho CRM?

  Hello Zoho CRM Community, I’m looking to customize Zoho CRM to send a custom alert whenever a task is created. I understand that Zoho CRM supports client scripts using JavaScript, and I would like to leverage this feature to implement the alert functionality.

• Using files from Zoho CRM in Gemini/ChatGPT/Claude

  Hi all, I’ve got subscriptions to Gemini and a few other AI tools which I use for tasks like data enrichment, email composition, etc. In our workflow, we often receive various documents from clients — such as process workflows, BRDs/requirement documents

• Maximum file limit in zoho people LMS

  Dear Team, I am having approximately 4.9 GB of material, including PPTs and videos for uploading in zoho people LMS course. May I know what is the maximum limit limit for the course files Thanking you, With regards, Logeswar V Executive _ Operations

• Dynamically prefill ticket fields

  Hello, I am using Zoho Desk to collect tickets of our clients about orders they placed on our website. I would like to be able to prefill two tickets fields dynamically, in this case a readonly field for the order id, and a hidden field for the seller

• Next Page