Our Total Access Statistics program includes a collection of cash flow functions that perform a wide range of cash flow analysis:


  • Use discounted cash flows to generate Net Present Value (NPV), Present Value (FV), Future Value (FV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR) for periodic and date dependent payments and receipts
  • Analyze the data in your Access tables and queries (including linked data)
  • Support grouping on field values so you can perform multiple analyses in one pass
  • Generate results in Access tables that you can use in your queries, forms, and reports

Best of all, by using a database approach with support for groupings, calculations for each group of records is automatically generated making it far more powerful than performing the calculations in Microsoft Excel. Since the results are in Access tables, you can add them to your forms and reports.

Hope this helps.

Quote Originally Posted by cbh35711 View Post
I have been tasked with translating an Excel Cash Flow(NPV) calculator to Access. Before just wandering off in my own direction, I was curious on if someone had an example of a NPV calculator they have done/seen in Access?

Any assistance would be appreciated.

Thanks,

Chris