Forum Discussion

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 inde...

Ask about Quickbase functionality

Formulas and functions

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
Qrew 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
  Qrew Cadet
  4 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
  ------------------------------