Analyze your investments easily with Zoho Writer's new formulas

Analyze your investments easily with Zoho Writer's new formulas

Hey Zoho Writer users!
 
We are happy to let you know that we have enhanced Zoho Writer's formula with new functions to calculate your investment's present value (PV), net present value (NPV), and future value (FV).
 
These functions can help you determine the value of a series of cash flows from an investment compared to a discount rate (such as inflation or interest). Read on to learn their syntax and how to use these functions. 

NPV function

Syntax  
=NPV(discount, cashflow1, cashflow2, ...)
 
Inputs:
discount
The discount rate of the investment over a period
cash flow
The amount of money coming in or going out in the investment period
 
Note:
The discount should be provided as a decimal number. For example if the discount is 3% then the value should be 0.03.
Calculate NPV with the initial investment amount by adding it in the first cash flow parameter as a negative amount.
Tip:
Discount can also be mentioned as a table cell reference or merge field.
Cash flow can be mentioned as a table cell reference, merge field, or a table cell range (if it is used in a table in the same document).

Examples of NPV 

Example
Syntax
Output
Calculate the NPV of a $3,000 investment with cash flows of $5,000, $2,000, and $4,500 at a discount rate of 10%
=NPV(0.1,-3000,5000,2000,4500)
5981.1488286
Calculate the NPV of an investment with cash flows of $500, $750, and $1,000 at a discount rate of 7%
=NPV(0.07,500,750,1000)
1899.799
  

PV function

Syntax  
=PV(rate, number_of_periods, payment_amount, future_value, end_or_beginning)
 
Inputs:
rate
The rate of interest over the investment period
number_of_periods
The number of months, years, or other time periods you are considering as the investment horizon
payment_amount
The amount you are investing
future_value
The expected future value of the investment
end_or_beginning
The time when payment is due in your investment period. The value should be 0 if the payment is at the end of the period and 1 if it is at the beginning.

Note:
The rate, number_of_periods, and payment_amount should have units of consistent value. For example, for a 24-month investment with monthly payments, the rate should be divided by 24 and the number_of_periods should be 24.
The future_value and end_or_beginning are optional parameters and their default value will be 0.
 
Here are some examples of PV

Example
Syntax
Output
Calculate the PV of $500 paid in 5 payments over one year with an interest rate of 5%
=PV(0.05,5,-500,0,0)
99.98713
Calculate the PV of an amount of $100 paid over 12 months, with an interest rate of 5%, paid at the beginning of the investment period
=PV(0.0041,12,-100,0,1)
338.330
 

FV function

Syntax   
=FV(rate, number_of_periods, payment_amount, present_value, end_or_beginning)

Inputs:
rate
The rate of interest over the investment period
number_of_periods
The number of months (or other periods of time) you are investing
payment_amount
The amount you are investing
present_value
The present value of the amount you are investing
end_or_beginning
The time when payment is due in your investment period. The value should be 0 if the payment is at the end of the period and 1 if it is at the beginning.
 
Note:
The rate, number_of_periods, and payment_amount should have units of consistent value. For example, for an investment for 24 months, paid quarterly the rate should be divided by 8 and the number_of_periods should be 8.
The present_value and end_or_beginning are optional parameters and their default value will be 0.

Here are some examples of FV

Example
Syntax
Output
Calculate the FV of an investment with an amount of $1,000 paid in 6 payments over one year with an interest of 7% and present value of $10,000
=FV(0.07,6,-1000,-10000)
2658889000
Calculate the FV of an investment with an amount of $500 paid over 12 months with an interest of 5% paid at the beginning of the investment period and present value of $5,000
=FV(0.0041,12,-500,-5000,1)
413203.0951
  

How to use these functions in Zoho Writer documents 

  1. Click the hamburger menu located on the top left side of the editor and click Fields.
  2. Click Formula under the Dynamic Fields category.
  3. In the New Formula popup, click Choose Function and choose your desired function from the list.
Try the new functions in Zoho Writer and let us know your suggestions and feedback in the comments below or at support@zohowriter.com or support@eu.zohowriter.com.
 
If you have any functions that you want us to add in Zoho Writer, please let us know.
 
Regards,
Team Writer


      • Sticky Posts

      • Easily perform calculations using dates with the new DATEDIF function

        Hey Zoho Writer users! We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years. Function syntax: =DATEDIF(start_date, end_date, unit) Inputs:

      • Zoho Writer's WordPress extensions

        Hey Zoho Writer users! Say goodbye to all your WordPress content publishing woes with Zoho Writer's WordPress extensions. Publish content with all your formatting and images, republish content when you update a document, and more—from a single window

      • Date-based conditions and filters

        Configure conditions with date  Hi everyone! We are excited to announce that you can now compare and filter data with date-based conditions. This update lets you compare date fields in a document to a reference date and display a text or value if the

      • Introducing group by, aggregation, and repeating regions in mail merge templates

        Display data exactly the way you want and highlight key insights with Zoho Writer's enhanced merge templates. We've supercharged Zoho Writer's merge templates with the capability to dynamically group, aggregate, and repeat data as blocks. You can now

      • Say hello to an improved way to merge documents!

        Automating all your documents from start to finish is now easier than ever with Writer's new merge tools.   If you haven't seen it yet, you can read the main announcement here. Here is the full list of the features we've rolled out: 1. Dynamic Table Headers

        • Recent Topics

        • Kiosk Button Actions

          I need to add an action to a Kiosk Button to loop me back to start the kiosk again and I am not sure what that looks like (function, etc.).

        • Dependent drop-downs... how?

          Good day. I have 2 different situations where I need a dependent drop-down field. First is for a subform, where I want to show related fields for a specific customer on the main form. In my case it is a parent whose children make use of our school transport

        • Reporting Limitation on Lead–Product Relation in Zoho CRM

          I noticed that Zoho CRM has a default Products related list under Leads. However, when I try to create a report for Lead–Product association, I’m facing some limitations. To fix this, I’m considering adding a multi-lookup field along with a custom related

        • Series Label in the Legend

          My legend reads 'Series 1' and 'Series 2'. From everything I read online, Zoho is supposed to change the data names if it's formatted correctly. I have the proper labels on the top of the columns and the right range selected. I assume it's something in

        • Dynamic Signature - Record owner

          Hi everyone, I’m using Zoho Writer merge templates from Zoho CRM and have two questions: Owner signature: How can I automatically insert the CRM record owner’s signature in the merged document? I’m not sure where this signature is stored or how to reference

        • Printing from Zoho Creator hosted on my own server to printers hosted on my clients local network

          Hello. Fairly new to Zoho Creator and looking for best options to be able to print from my application hosted on my own server to any printer hosted on my clients own local network. Any advice is welcome. Thank you.

        • Add System Pre-Defined Lookup Field to Subform?

          Hi there! New to using Zoho, so this may already exist, but I'm having trouble figuring it out. Is there a way to get the system pre-defined Account Lookup field (in our case, renamed to Company Name), as the starting point for a subform? In our company,

        • Numbered / bullet point List in Zho Cliq

          Hi, is there a way to format chat messages in Cliq like this Topic 1 Hey, I finished this project yesterday etc... Topic 2 I am still working on this etc...

        • Cannot Access Subform Display Order in Deluge

          As highlighted in this community post, we still have to deal with the significant limitation of not being able to access the user-sorted order of subform rows through Deluge. This creates a major disconnect between the UI capabilities and backend automation,

        • How many groups in Zoho Mail can I make?

          I'm currently on the free plan, which has a limit of 10 users. Does that limit includes groups too? If not, what is the limit for groups? Thanks!

        • Feature Suggestion for Zoho Social: Auto-reply to Comments or Keywords

          Hi Zoho team, I'd like to suggest a very specific feature that would be extremely helpful for customer engagement: the ability to automatically send a reply to comments on posts — either all comments or those containing specific keywords. For example,

        • Already have Zoho account. Not letting me log in

          I already have a Zoho account that is associated with my Google email and my phone number. Even though I'm already logged in to Zoho, when I click on the mail icon to access my email, it takes me to the pricing page. When I click on the free option, it

        • ZOHO Mail App Not working

          There seems to be an issue with Zoho Mail App today. It is not connecting to server, internet is working fine, tried uninstalling app and reinstalling, loading circle keeps spinning round. Is there an update on the way?

        • facing error 550 5.4.6 while sending emails

          Please help me fix this issue

        • Allow Itemization for Recurring Expenses

          For whatever reason, one cannot itemize a Recurring Expense. This capability should be added. The use cases to support this are largely the same as what they were to allow for itemization in Expenses. Anything that would need to be itemized for a regular

        • Zoho reply to not working. just reply to my self

          Hello. i using on my wordpress website a contact form from Wsform. i can set the reply to email there. normally it works. but since i am using your wordpress plugin zoho mail it doesn`t work. its not using the reply to (email from customer). I just can

        • Can't receive any email from other platform

          Hello,everyone, i'm just join zoho and create two email accounts for my own business. I was using it to get a verified email from stripe, but can't receive it. and I use my private gmail account to send test email twice, first time show below reply, but

        • Your Incoming has been blocked and the emails will not be fetched in your Zoho account and POP Accounts

          Can some on help me regarding our account . thank you so much

        • Zoho Creator integration with Sage 50

          Hi, Wondering if anyone has had any experience connecting Zoho to Sage 50 and could share any information on this matter. Thank you.

        • Conditional Email Forwarding

          How can I set conditional email forwarding of the users? For example: Mail should be forwarded to a address only if it comes from a particular sender. So, I want such email forwarding, which forwards mails based on particular conditions, like the incoming

        • Incoming emails not appearing in Inbox

          Hello, I have an issue with incoming emails sent from my website (domain: h2ostop.si). Emails are visible in the Sent folder, which means they are successfully sent through Zoho SMTP, but they never appear in my Inbox. Nothing arrives in Inbox, Spam,

        • Email Opt Out Question

          Has the problem where if a customer is emailed opt out prevents you sending standard emails? For me this feature is simply to stop any email marketing and should not block people from receiving emails via Zoho mobile, which makes no sense.

        • Can No Longer Access Zoho Email Accounts from iPhone or iPad Apple Mail Apps ,.

          Keeps asking for password, Says ID or password incorrect. Tried creating a new app specific password. Same result. Is this possibly related to the server maintenance. Have verified all email settings, userid and password. This has worked for years until

        • Latest update caused issue in using marathi typingzoho

          With latest update now marathi typing does Not work in zohonotebook. I preferred zoho over other because it was supporting marathi font without any distortion.. But after new update,keyborad simply does not work

        • Login verification emails never received.

          I can't login to my account. You send a verification email, but it never arrives. This is a common problem, frequently caused by some relay point out there classifying the sender as a spammer. Is there anything I can do to bypass this? Maybe get a text

        • Global lists for Multi select

          It would be great if I could select a global list to use for a multi select dropdown filed.

        • Yahoo is rejecting e-mails sent from a Zoho server

          Diagnostic-Code: 4.7.0 [TSS04] Messages from 136.143.169.51 temporarily deferred due to unexpected volume or user complaints - 4.16.55.1; see https://postmaster.yahooinc.com/error-codes Remote-MTA: dns; mta5.am0.yahoodns.net

        • Yahoo blocks e-mail sent from Zoho servers

          Getting this for a bunch of Yahoo addresses. Do you know if some of your servers got blacklisted? Diagnostic-Code: 4.7.0 [TSS04] Messages from 136.143.169.51 temporarily deferred due to unexpected volume or user complaints - 4.16.55.1; see https://postmaster.yahooinc.com/error-codes

        • Working with dates and Function Field

          Hello friends! I'm trying to add days to a date, however the field function will always shows 00:00:00 after the resultant date. How can I display only the date, whithout the time? toDate(input.request_date.addDay(input.Prazo_acordado),"MM,d,yyyy") The code above will result something like "11-Feb-2020 00:00:00", but I want to display only "11-Feb-2020"

        • What's New in Zoho Analytics - November 2025

          We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's

        • Unable to send message;Reason:550 5.4.6 Unusual sending activity detected. Please try after sometime.

          Please help my account got blocked automatically, can you help me how to avoid it? Thanks so much

        • temporary system errorlouis

          J'essaye d'envoyer des mails avec mes 2 adresses mail qe nous avons sur le compte arthur@lepunch.fr et louis@lepunch.fr mais j'ai toujours le message temporaire system error, je reçois les mails mais impossible d'en envoyer a qui que ce soit

        • How to Cancel/Delete Queued Mail Merge?

          Hi. I just tried to do a mail merge before realizing there's a limit on number of sends. I accidentally sent one of my lists twice, and all of those emails are currently queued. Is there any way to cancel or delete a queued mail merge? Would love to be

        • SOLVED: Stopping Multiple Invitations when sync with Google Calendar

          I wanted to share this solution as I wasn't able to find it when searching through the Zoho community and via web search. The issue: When requestor books a meeting through Zoho Bookings, the requestor receives a confirmation email from both Bookings and

        • Need to add a new admin for my domain

          Hello Zoho Support, I am the owner of the domain localeistanbul.com. The current super admin account (admin@localeistanbul.com) is not accessible. I do not want to reset or delete the existing account because I need to keep all existing emails. Please

        • Possible Fraud Site.

          Hello. I received a text with the sender's name as zoho, claiming that my account was at risk and that I should sign in at https://verify.zohomails.ru/signin to verify my account. I signed in on the web address above, and a few days later someone hacked

        • Zoho mail to Teaminbox

          Hello, We're searching for new mail program. Now I'm testing a bit with zoho mail and team inbox. My findings in the research: Pop mail throught zoho mail is almost instant. Any pop or imap via external provider takes a couple minutes to 15 minutes before

        • Crear tarea CRM con recordatorio desde Zoho Flow

          Hola, estoy intentando crear desde Zoho Flow una tarea en CRM. Lo he logrado hacer pero sin recordatorio, ya que no se como se debe escribir el string adecuado. He probado varias alternativas, pero ninguna me funcionó hasta ahora. - FREQ=NONE;ACTION=EMAIL;TRIGGER=DATE-TIME:${FechaVto}

        • Inquiry Regarding Automated Assignment of Zoho TeamInbox Messages using Zoho Flow and Deluge

          Hello, Our company is currently using Zoho TeamInbox, and we are interested in automating the assignment of responsible parties using tools such as ZOHO Flow and Deluge. Is it possible to achieve this? Allow me to provide more details. Currently, when

        • Multiple clients in one project

          Hi team, What is the possibility to have more than one client to be linked for one project in the Zoho Books? Our business model is to have a project, and this project have expenses/bills, as well, we issue invoices for this same project to several customers.

        • Next Page