This is a collection of serverless apps that wrap common financial functions in AWS Lambda functions. The financial functions' names and interfaces are identical to the corresponding functions in Microsoft Excel for convenience.
In addition to the individual function apps, an API app is included, which stands up an Amazon API Gateway REST endpoint surfacing all of the functions.
- FV - Returns the future value of an investment based on periodic, constant payments and a constant interest rate.
- FVSCHEDULE - Returns the future value of an initial principal after applying a series of compound interest rates.
- PV - Returns the present value of an investment: the total amount that a series of future payments is worth now.
- NPV - Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values).
- XNPV - Returns the net present value for a schedule of cash flows.
- PMT - Calculates the payment for a loan based on constant payments and a constant interest rate.
- PPMT - Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate.
- IRR - Returns the internal rate of return for a series of cash flows.
- MIRR - Returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash.
- XIRR - Returns the internal rate of return for a schedule of cash flows.
- NPER - Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
- RATE - Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly payments at 6% APR.
- EFFECT - Returns the effective annual interest rate.
- NOMINAL - Returns the annual nominal interest rate.
- SLN - Returns the straight-line depreciation of an asset for one period.
- Create an AWS account if you do not already have one and login
- Search for the desired financial function application in the AWS Serverless Application Repository
- Click on the desired financial function application and click "Deploy"
This sample code is made available under a modified MIT license. See the LICENSE file.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent