Forum Discussion

DustinDustin's avatar
DustinDustin
Qrew Member
8 years ago

Need help developing script to run NPV and IRR functions

I have formulas set to calculate cash flows based on annual benefits and costs, but I have never created a script in QuickBase and I'm struggling to find a good resource. The cash flow fields are independent formula fields for years 0 -5.

Any links or videos on scripting would be helpful, especially those that incorporate finance functions like NPV and IRR.
App builders
Ask about Quickbase functionality
Formulas and functions
  • GabrielFigueroa's avatar
    GabrielFigueroa
    Qrew Member
    4 years ago
    Hi Dustin,

       Did you ever get a resolution to this question of calculating IRR & NPV?

    Thanks,

    ------------------------------
    Gabriel Figueroa
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      This is not going to be possible using native Quickbase. The only thing I can think of is to use a Juiced add-on called XL Docs.  That would allow you to push a button to create an Excel spreadsheet which of course can do those calculations easily.

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • AnnettaColeman's avatar
        AnnettaColeman
        Qrew Cadet
        3 years ago

        The QuickBase PV formula works very well, albeit a bit differently than an Excel formula.  Excel PV natively presumes even cash flows and as we all know future benefits may fluctuate. 

        • The QB PV can be used for either even cash flows in the future or a unique cash flow n years in the future.  
        • Similarly, Excel PV can be used for either even cash flows in the future or a unique cash flow n years in the future (then added up for the range of years). 
          Be careful not to use NPV (which compares initial outflow to future flows) which works on a range, but provides a different calculation.
        The IRR or ROI can then be calculated also.  



        ------------------------------
        Annetta Coleman
        ------------------------------