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

                                  • 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
                                  • Allow customers to choose meeting venue and meeting duration on booking page

                                    My business primarily involves one-to-one meetings with my clients. Given the hybrid-work world we now find ourselves in, these meetings can take several forms (which I think of as the meeting "venue"): In-person Zoom Phone call I currently handle these
                                  • Approval-based booking with Zoho Creator and Zoho Bookings

                                    Hi community members, We have developed a workaround for approval-based booking using Zoho Creator and Zoho Bookings! This provides a temporary solution as we work on the native feature, and it's useful for anyone needing an approval workflow when confirming
                                  • Member Accounts in Related List

                                    Hi Team, Currently, when a parent account is associated with an account in FSM, there is no related list displaying the associated member accounts under the parent account’s related list section. To view member accounts, I have to manually search using
                                  • how do i remove a specific Zoho Service from my account

                                    I no longer need Zoho CRM, ZRM Assist nor ZRM BugTracker. How do I remove them from the list of apps for my account?
                                  • I Want migarte all invoice details to zoho sheets

                                    I want to migrate all existing invoice details to Zoho Sheet, and automatically update the sheet whenever a new invoice is created.
                                  • were can i find my invoices i need this for my accountant

                                    were can i find my invoices i need this for my accountant, how can i get id direct to my email?
                                  • ONLY email field not populating Writer fillable document (randomly)

                                    I have a Zoho Writer fillable document that has pulled all my data from my Zoho Sheets file, EXCEPT the email column. It pulled every data before and after that column with no issues. Screenshots attached. It's not my first time using the app or the feature,
                                  • My number is marked as spam

                                    Hello Zoho Mail Support, My phone number was incorrectly flagged as “spam” during sign-up. This is my personal number, and I have not engaged in any spam activities. Kindly review and verify my account so I can proceed with my email setup. Thanks.
                                  • Personnalisation des paramètres dans Zoho Mail

                                    Pourquoi cela compte-t-il ? La personnalisation des paramètres dans Zoho Mail permet aux administrateurs de configurer l’environnement de messagerie en fonction des besoins spécifiques de leur organisation. Que ce soit pour alléger l’interface pour certaines
                                  • How To Save Data Into Zoho CRM Sandbox

                                    Hi Community, I want to save data into my zoho sandbox , for this I am using this api endpoint - https://www.zohoapis.com/crm/v8/Patients but I am getting this error - { "success": false, "message": "Zoho API request failed", "error": { "code": "INVALID_MODULE",
                                  • Automate pushing Zoho CRM backups into Zoho WorkDrive

                                    Through our Zoho One subscription we have both Zoho CRM and Zoho WorkDrive. We have regular backups setup in Zoho CRM. Once the backup is created, we are notified. Since we want to keep these backups for more than 7 days, we manually download them. They
                                  • Question about retrieving unsubscribed contacts (outside of lists) via API

                                    Hello, I am currently using Zoho Marketing Automation and would like to integrate it with our company’s core system. For this purpose, I am exploring the API options available to retrieve contact information. Specifically, I would like to know if there
                                  • Getting “mandatory field missing: Service_Line_Items” When Creating Work Order via Zoho Flow Deluge

                                    Hi Team, I’m trying to create a Work Order in Zoho FSM with only a Service Line Item (no Parts). However, I keep getting this error: Work Order Response: {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"Service_Line_Items"},"message":"required field
                                  • How to customize the colors of the Client Portal login screen and add the company logo?

                                    As title, how to customize the colors of the Client Portal login screen and add the company logo?
                                  • Daily updates/fixes and how to see what was changed?

                                    When I receive the notification that zoho was updated and I need to refresh it. How can I see what was changed or fixed? Sometimes they change things that effect my books and I need to know what they did. For example over this past weekend something was
                                  • Upcoming Change: Snowflake Username/Password Authentication Deprecation – Action Required

                                    Hello Users, Snowflake has officially announced that username and password-based authentication will be deprecated by November 2025. You can find the official announcement [here]. If you're using a Snowflake connection in Zoho Analytics to import data,
                                  • Why should I choose Zoho Inventory vs Odoo?

                                    Hello there! I have used Zoho in different companies I've worked in, and I have a positive perception of it. I am starting a new import business for pipes, tubes, fittings, valves, elbows, etc., which all have serial numbers, cast numbers, etc., so I
                                  • Product Updates in Zoho Workplace applications | July 2025

                                    Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this July. Zoho Mail Import bookmarks from Pocket Worried about losing your Pocket bookmarks? Don't worry we have got you.
                                  • PLEASE FIX YOR BUGS

                                    PICTURES ARE BEING REJECTED DESPITE THEM FOLLOWING THE GUIDELINES ON DIMENTIONS.
                                  • Kaizen# 204 - Answering Your Questions | Perform Field Updates before Blueprint transition via Client Script

                                    Hello everyone! Welcome back to another exciting Kaizen post. One of the questions we received through your Kaizen feedback was: “How can I update fields before Blueprint transition and how to prevent a transition based on a condition using Client Script?”
                                  • Create online meetings for Booking Pages with Zoho Meetings and Zoom

                                    Greetings, We hope you're all doing well. We're excited to share some recent enhancements to Bigin's Booking Pages. As you know, Booking Pages let you create public pages to share your availability so that your customers can easily book time slots with
                                  • Filters in audit logs

                                    Greetings, I hope all of you are doing well. We're happy to announce a few recent enhancements we've made to Bigin. We'll go over each one in detail. Previously, there were no filters available to narrow down data in audit logs. Now, we've introduced
                                  • Enhanced help options in Bigin

                                    Greetings, We're excited to introduce a new enhancement to Bigin's Help section: a comprehensive Help Options panel that brings together all your support resources in a single, well-organized space. Previously, the Need Help? menu provided only a limited
                                  • Zoho FSM API Developer Needed

                                    Hi, I’m looking for a developer with experience using Zoho FSM APIs. Scope: Connect WordPress website booking form to Zoho FSM Check availability (date, time, region) Create Work Orders + Service Appointments automatically Notify both customer and scheduler
                                  • Revenue Management: #4 What if there are uncertainties in project or service delivery?

                                    Our previous post taught us how Zoho Billing makes life easy for businesses with its automated revenue recognition rule. However, certain businesses have more challenges that an automated system cannot handle, and there are certain situations where automated
                                  • This mobile number has been marked spam. Please contact support-as@zohocorp.com

                                    Bom dia, estou tentando colocar o número 11 94287-6695 e esta com erro "This mobile number has been marked spam. Please contact support-as@zohocorp.com" pode me ajudar, por favor?
                                  • Feature Request: Ability to Set a Custom List View as Default for All Users

                                    Dear Zoho CRM Support Team, We would like to request a new feature in Zoho CRM regarding List Views. Currently, each user has to manually select or favorite a custom list view in order to make it their default. However, as administrators, we would like
                                  • Items Serial Tracking Issue

                                    We enabled Zoho Items inventory tracking then disabled it after some time now we want to enable it again When I check the missing serial number reports I see one item But I cant see any option to Add the serial numbers Where and how to add the serial
                                  • Composite Services and Account Tracking

                                    I am looking to garner support/request the ability to make composite services. A quick search in the forums brings up multiple requests for this feature. I fail to see why an item is mandatory while services are optional. I also would like to see the
                                  • Zoho Payroll integration with Zoho Books - unable to match multiple bank feeds to one wage payment

                                    For one employee's wage, I make two partial payments. Those bank feed transactions come into Zoho Books via bank integration. I make one pay-run for the month in Zoho Payroll and that comes into Zoho Books via the Zoho integration. Zoho Books doesn't let me match multiple bank feed transactions against a single wage item. Please fix urgently. I can't complete my books because of this.
                                  • Add Checkbox Selection & Bulk Actions to Delivery Challans Module

                                    Hi Zoho Team, I’ve noticed that in the Sales Orders module, there are checkboxes beside each entry that allow users to select multiple records for bulk actions such as print, email, or delete. However, in the Delivery Challans module, this option appears
                                  • Can't be able to check-in in laptop

                                    even after giving location access still i can't be able to check-in in laptop.
                                  • Compensation Cess on Coal ₹400 per tonne. ?????

                                    The compensation cess rate varies by the type of product. And the cess is calculated based on the value of the product without GST. Coal, for example, comes with a cess of ₹400 per tonne. That means that if you sell 2 tonnes of coal that have a value
                                  • 7 month over zoho book purchase but still not immpliments Golive

                                    7 month over zoho book purchase but still not immpliments Golive one problems zoho team short out then other problems come still very poor mangments and immliments team . struggling with the templates in ZOHO Books. Especially with the placement of some
                                  • Next Page