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

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • 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:
          • 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
          • Introducing Org Fonts in Zoho Writer

            Hey Zoho Writer users! We're excited to share that you can now add custom fonts (from web fonts with publicly accessible URLs) using Zoho Writer's Org Fonts. This option allows all users across your organization to use the custom font without the hassle

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ








                                ご検討中の方

                                  • Recent Topics

                                  • Office-365-agenda and Microsoft Teams Integration

                                    Dear, I have a trial version of Zoho Recruit and trying to evaluate the Microsoft Teams Integration in Zoho Recruit. After registering with my Office 365 account and checking the result of the registration/sign-in at https://mysignins.microsoft.com/ (which
                                  • Delegate Access - Mobile iOS/iPad

                                    We’re over the moon that delegate access is now available in Zoho Mail as we were nearly ready to switch platforms because of it! Is there a timeline on when delegate mailboxes will be accessible from the iOS and iPad OS applications? Thanks, Jake
                                  • How to add Connector in developer platform zoho?

                                    Hi, I am working on creating an Extension, and part of the development is to retrieve Email templates. In my CRM instance I can invokeURL by creating Zoho OAuth connection and get the template. But developer platform does not provide Zoho OAuth or any
                                  • How to archive Lost/Junk Leads so sales reps don’t see them, but keep them for reporting?

                                    Hi everyone, In our Zoho CRM we have two Lead Status values: Lost Lead and Junk Lead. What I want to achieve is: When a lead is marked as Lost or Junk, it should disappear from my sales reps’ Lead views (so they only see active leads). At the same time,
                                  • Zoho CRM Canvas Copy Original Layout

                                    Hello all, I want to use Canvas to make small changes to certain views, not to make huge changes. Is it possible to copy the original Zoho layout and set-up and start from there? I checked and all I can find are some templates which are far from the original
                                  • Is there a way to request a password?

                                    We add customers info into the vaults and I wanted to see if we could do some sort of "file request" like how dropbox offers with files. It would be awesome if a customer could go to a link and input a "title, username, password, url" all securely and it then shows up in our team vault or something. Not sure if that is safe, but it's the best I can think of to be semi scalable and obviously better than sending emails. I am open to another idea, just thought this would be a great feature.  Thanks,
                                  • Revenue Management: #5 Revenue Recognition in SaaS

                                    If you're building or running a SaaS business, you've probably encountered this. You get paid upfront for a subscription and a one-time onboarding fee, but you end up with confusion about when to consider it revenue. Can I book all of it now? Should I
                                  • MS Teams for daily call operations

                                    Hello all, Our most anticipated and crucial update is finally here! Organizations using Microsoft Teams phone system can now integrate it effectively with Zoho CRM for tasks like dialling numbers and logging calls. We are enhancing our MS Teams functionality
                                  • Zoho Learn Course Access Issue

                                    One of the learners in a specific course can't see any lessons. They are registered as both a user and learner for this course in Zoo Learn. What could be the reason?
                                  • ZOHOLICS Japan 2025 開催のお知らせ(再投稿)

                                    【コミュニティユーザーの皆さまへお知らせ】 Zoho 最大のユーザーイベント「ZOHOLICS Japan 2025」を9月19日(金)に開催します。 AI活用に関する特別講演、ユーザー事例、Zoho 製品の活用例のご紹介など、Zoholicsならではのセッションをご用意しています。 Zoho コミュニティ開催のMeetupとはまた違った雰囲気のイベントです。 ご都合のつく方はお気軽にご参加ください✨ 詳細はこちら https://events.zoho.jp/zoholics2025#/?affl=forumpost2
                                  • Phone Number format for Bulk Upload via csv for Zoho Sign

                                    What is the phone number format that we need to use for a bulk recipient upload via csv in zoho sign, should the country code be included for ex if its US should it be +18889007865 ior 18889007865 or without country code 8889007865? the sample csv provided
                                  • Filter Page Elements By Selectable Date Range

                                    I have created a basic Page that will serve as a client dashboard with elements that will provide simple counts & sums of data in reports. There are no reports or forms added to the page, just elements. It currently functions as needed, but shows the
                                  • Can’t Enter my Notebook is Locked

                                    I’ve been using Notebook for taking notes at my college for a month and I never signed in and I never established a password. Today I tried to enter the app after the update and it asked me for a password. I need to access to my notes urgently and I can’t
                                  • Send Email Directly to Channel

                                    Hi, We are coming from Slack. In Slack each channel has a unique Email address that you can send emails too. I currently forward a specific type of email from my Gmail InBox directly do this channel for Verification Codes so my team doesn't have to ask
                                  • Secure your external sharing process with OTP Authentication

                                    For any business, it's crucial to share files externally in a way that is both secure and controlled. Let's say you want to share confidential data with your partners and vendors. You must ensure that only your intended recipients can access the shared
                                  • Items attribute questions

                                    Many of my items have attributes, such as size and color. How can I add new fields to the "New Items" screen to capture that in my Purchase Orders, Items, and Sales Order pages? I only see these attribute fields when adding an Item Group. Also, on the
                                  • Is there a way to search mail for items you haven't yet responded to?

                                    I'm trying to create a search to show emails that haven't been responded to and that have also been assigned a tag or label. Is there a way to search for the inverse of replied?
                                  • Zobot and Sales IQ

                                    What will happen to the Zoho Sales IQ being integrated to the website after creating the Zobot on the website too
                                  • Subtotals per Header

                                    Hey, we would like to display subtotals per header in our invoices:
                                  • upgrade storage

                                    how to upgrade my storage
                                  • Linking items from books and subscription

                                    Linking books and subscription It is a pity that it is not possible to associate with a product an article present in ZohoBooks This would make it possible to manage products composed of a nomenclature of articles of books
                                  • Add the ability to view number of hours planned for a workorder while in the Dispatch Console

                                    Hi Zoho, When dispatching a work order through the Dispatch Console, there's currently no way to view the number of planned hours for the service tasks associated with that specific work order. Having to click into the details each time to check planned
                                  • Uploading Files from uploads api

                                    I tried uploading the image from the API call but its giving me unauthorized error even i have given valid token in header. After uploading i need that id to pass in create ticket api uploads but its not uploading that file. Please help me out in th
                                  • Categorize Items with Item Headers

                                    Hello customers, Did you ever want to classify items based on specific categories to help your customers understand your invoice better? With the new Item Header feature, you can easily categorize items in your invoices and estimates and give them a common title.  Item Headers are available in the Invoices, the Recurring Invoices and the Estimates module. It can be carried forward from estimates to invoices at the time of converting the estimates.  To add an item header: Go to the Estimates, Invoices
                                  • URLs being masked despite disabling tracking

                                    Hey, We had disabled click tracking from an email update we are sharing with our users. Despite this, the URL the end user is receiving is masked, and looks like "https://qksyl-cmpzourl.maillist-manage.net/click/1d8e72714515cda6/1d8e72714515ca70" instead
                                  • Change format of quantity format

                                    Hi,  I would like to change the qunatity format from 1,00 to 1.  Is this possible?   thanks!
                                  • square up and Zoho books

                                    Since we set up the app connection between square up and Zoho books we have realised that when the amounts are getting transferred Zoho is adding VAT again making the numbers 20% more than they should be. We have checked our settings and they VAT/ Tax
                                  • How to provide Access rights to specific Bank accounts

                                    We have several bank accounts. I want to provide certain members access to only 2-3 accounts. It appears that when I give permissions, they are for ALL bank accounts. How do I do that?
                                  • Errors Getting a Bank Transaction

                                    Using Postman(for testing), I am receiving errors when attempting to get a single bank transaction. I am able to receive the list of bank transactions with https://www.zohoapis.com/books/v3/banktransactions/?organization_id={org_id} but when I try to
                                  • Subscriptions Plans and CRM Products Integration?

                                    Is there any way to set up plans and pricing in Zoho Subscriptions and have those available as Products in the CRM? We are trying to set up the CRM and the Products seem to be more geared toward selling products that are not subscription based.  So if we sell annual or monthly contracts which are $10/seat/month, I can set this up as a plan in Subscriptions, but how can I set the same thing up in the CRM for the salespeople to sell/quote? What is the best practice for setting up the CRM Products to
                                  • Mapping Zoho Subscription Plans and Products to CRM and Books

                                    We have products that are one time products and subscription products.   1) We would like to have the ability to create an opportunity in CRM that includes both one-time charge products and subscription products.  Currently the only way of creating a subscription product is by defining a "Product->Plan" hierarchy in Zoho Subscription.  It appears that the only SYNC between Subscription and CRM is around contacts and the Product->Plan hierarchy doesn't sync to CRM, thus, you would need a duplicate
                                  • Zoho People Attendance Module - Split Shifts

                                    Hello, Our business employs a number of college students who often split their workdays between work hours and class schedules, resulting in split shifts. For example: Employee 1 works 9am to 11:30am and then leaves for class, returning to work at 3pm
                                  • Bulk update fields based on date

                                    Hi! I need all the quotes with "Quote Stage" set to "Next Year" to update to "Draft" every January 8 (every year). Can you help?
                                  • Target for a campaign

                                    Hi, Hope you can help me. I need to create a report (for a marketing campaign) that combines Deals and Contacts to export all the contacts with closed deals. I can easily do that, what I cannot do is to remove from the target the contacts that have more
                                  • Zoho Desk + Jira integration - Email notifications and comments posted by administrator instead of real user

                                    Dear All, I set up the integration under my admin account, and now when users leave comments in Jira (to created tickets in Zoho Desk), the email notifications show that the ‘Administrator’ left a comment, not a real user. The same happens in the ticket
                                  • Celebrating the power of visuals

                                    On World Photography Day, we would like to highlight the power of visuals in customer service. Visuals promote learning and understanding in less time. A photograph can rekindle a memory, convey more than words, and give a fresh perspective. How does
                                  • Customer address in Zoho Bookings

                                    Hello,  Is it possible to add customer address information to the Zoho bookings appointment screen? Or have it pull that information automatically from the CRM? We are wanting to use this as a field management software but it is difficult to pull the address from multiple sources when it would be ideal to have a clickable address on the appointment screen that opens up the user's maps.  It would also be advantageous for the "list view" to show appointment times instead of just duration and booking
                                  • Blocking / black listing customers

                                    Hi, We have a situation, we observed that certain customers are blocking multiple appointments with our advsiors but not showing up. Some of these are repeat offenders. This leads to those service hours getting blocked and not available for genuine customers.
                                  • Option to block bookings from specific email address or ip adresss in zoho booking

                                    Sometime few of our client keep booking irrelevant booking service just to resolve their queries and they keep booking it again and again whenever they have queries. Currently its disturbing our current communication process and hierarchy which we have
                                  • Feature Request: Email Templates for notifications accross all services

                                    Currently in Zoho Bookings, email notifications (such as booking confirmations, reminders, and cancellations) must be customized individually for each service. This becomes time-consuming and error-prone when managing multiple services that require consistent
                                  • Next Page