Financial Module
  • 02 Oct 2023
  • 1 Minute to read
  • Dark
    Light

Financial Module

  • Dark
    Light

Article summary

Module Details

Core or Github ModuleGithub
Restart Required No 
Steps ExposedYes
Step Location Data > Financial > Excel Functions

Overview

The Financial Module provides a set of steps that perform various financial calculations. These steps are inspired by Excel's financial functions and include functions such as CUMIPMT, NPV, PMT, PV, Rate, and IRR. These steps can be used in conjunction with the Set and Get Excel steps.


Exposed Steps

Step NameDescription
CUMIPMTCalculates the cumulative interest paid between two periods in a loan or investment.
IRR
Calculates the internal rate of return for a series of cash flows.
NPV
Computes the net present value of a series of cash flows given a discount rate.
PMT
Determines the periodic payment required to repay a loan or achieve a certain future value.
PVCalculates the present value of an investment or loan.
RateComputes the interest rate per period of an investment or loan.



Was this article helpful?