BulletCashflow1
1. Description
Bullet Cashflow - 1 cashflow type generates a single cashflow for each record based on the mapping provided for principal amount, interest amount and cashflow date.
2. Screen Configuration
Here for each Account Id, Principal Amount is assigned from OutBal, Interest Rate is assigned from IntRate, and Maturity Date is derived from MaturityDate from base input file.One Cashflow is generated for each account. Click ⬇️ to download the test-bed.
3. Cashflow Derivation Logic
Let's say,
ACCOUNT_ID : ACC1001
OUTSTANDING_AMOUNT: 1000.00
INTEREST_AMOUNT: 200.00
MATURITY_DATE: 31-01-2024
A single cashfow for account_id ' ACC1001' will get generate with below values,
principal_amount = 1000.00
interest_amount = 200.00
cashflow_date = 31-01-2024
4. Required Fields
| # | Parameters | Description | Is_Mandatory_Field |
|---|---|---|---|
| 1 | principal_amount | The amount field which needs to stamped as principal amount | YES |
| 2 | interest_amount | The amount field which needs to stamped as interest amount | YES |
| 3 | maturity_date | The date field which needs to stamped as cashflow date | YES |
5. Working Excel
Click ⬇️ to download the excel calculation.