Help Center > null > Cashflow

Cashflow Tab

This tab contains information about Instrument Summary Panel, Funds, Co-Investors, Amortization Schedule Panel, Actual Cashflow Panel, Expected Cashflow Panel, Valuation (Current & History) and IRR and MoC History.

Instrument Summary Panel list view contains following details
  1. Inst. Name
  2. Inst. Type
  3. Fund/Co-Investor
  4. Inv CCY
  5. Fund/Investor CCY
  6. No. of Inst. Purchased
  7. Current No. of Inst.
  8. Investment Amount (Inst CCY)
  9. Current Cost (Inst CCY)
  10. Sale Proceeds/Principal Repaid (Inst CCY)
  11. Dividend/Interest (Inst CCY)
  12. Accrual Payment (Inst CCY)
  13. Other Income (Inst CCY)
  14. Penalty Interest (Inst CCY)

View link in Action column display Instrument Summary in detail i.e. which fields are used while creating this instrument.

View History link in Action column display values of Instrument while edited in multiple time.

Add Instrument You can add Instrument Summary by clicking the Add link in top right, a pop-up window will open to select what type of Instrument is created i.e. either Loan, Bond, Equity etc. and proceed , after selecting instrument type fill all the required fields to create instrument. Edit or Delete using links in the Action column is edit .





Add Instrument




View Instrument




Amount added in Acquition for different dates are now display in Amortization sheet Downloaded from Amortization Schedule for the selected instrument.


Instrument View History






Funds list view contains following details
  1. Fund Name
  2. Fund Short Name
  3. Fund CCY
  4. Investment Amount
  5. Current Cost
  6. Sale Proceeds/Principal Repaid
  7. Dividend/Interest
  8. Accrual Payment
  9. Other Income
  10. Penalty Interest
  11. Total Realization
  12. Valuation Date
  13. Valuation
This panel display list of Funds used in Instruments.



Co-Investors list view contains following details
  1. Investor Name
  2. Investor Type
  3. Investor CCY
  4. Investment Amount
  5. Current Cost
  6. Sale Proceeds/Principal Repaid
  7. Dividend/Interest
  8. Accrual Payment
  9. Other Income
  10. Penalty Interest
  11. Total Realization
  12. Valuation Date
  13. Valuation
This panel display list of Investors used in Instruments.



Amortization Schedule Panel

Select instrument from the dropdown and data corresponding to selected instrument will be populated. List view shows following details of the selected instrument
  1. End Date
  2. No. of Inst Purchased
  3. Bonds Held
  4. Principal Held
  5. Purchase Discount
  6. Acquisition Amount
  7. Acquisition Fees (to be paid)
  8. Interest Paid on Acquisition
  9. Principal Repayment (to be recd)
  10. Return of Capital (Security Receipts)
  11. Redemption Premium (after WHT)
  12. Cash Interest (after WHT)
  13. Interest Accrued/PIK
  14. PIK Bonds
  15. PIK Interest (after WHT)
  16. Fee Income (after WHT)
  17. Equity Upside (after WHT)
  18. Dividend
  19. No. of Inst Sold

You can aslo perform multiple operations on the selected instrument like
  1. Generate/Download Amortization Schedule : Automatic or Manula
  2. Import Amortization Schedule


    3. Import downloaded Amortization sheet by click on Choose File and import is done only when Is Validate should be Yes in sheet.
  3. View Amortization Schedule History
  4. Generate Report(Amortization Schedule vs Payments
  5. Close Amortization Schedule
    6. If Amortization is Closed for an instrument then all transaction should display in Gray color and user unable to make payment against any transaction i.e. while clicking on Viewpayment from Action, Add link hide from add payment popup. 11
You can get Payment details by clicking on Cashflow link next to each record in the list view.

Add Payment from View Payment link.



View Amortization Schedule History : You can Download Amortization Sheet imported by user on different dates.


Actual Cashflow Panel

Select instrument from the dropdown and data corresponding to selected instrument will be populated. List view shows following details of the selected instrument
  1. Tran Date
  2. Inst. Name
  3. Instrument Type
  4. Investment CCY
  5. Fund/Investor CCY
  6. Tran Type
  7. Transaction Description
  8. No. of Instruments
  9. Transaction Amount (Inv CCY)
  10. Transaction Amount (Fund CCY)
  11. Exchange Rate
  12. Price per Inst. (Inv CCY)
  13. Price per Inst. (Fund CCY)
  14. Notes
  15. TDS
You can add records by clicking the Add link in top right and Edit or Delete using links in the Action column.

Download Template will download Template in excel and show how to import data from excel.

Import Actual Data will import data from excel and display on the screen.

Export To XLS will download data in excel sheet as display on screen.


S/N Transaction Type Description
1 EPUR Equity Purchase
2 ESAL Equity Sale
3 EDIV Dividend
4 LPUR Loan Purchase
5 LADV Loan Advance
6 LSAL Loan Sale
7 BPUR Bond Purchase
8 BSAL Bond Sale
9 BPIK Bond Payment in Kind
10 AIPP Accrued Interest Paid on Purchase
11 AIRS Accrued Interest Received on Sale
12 REP Principal Repayment
13 INT Interest Payment
14 ACP Accrual Payment
15 IOP Interest on overdue Principal
16 IOI Interest on overdue Interest
17 WPUR Warrants/Options Purchase
18 WSAL Warrants/Options Sale
19 ECON Equity Purchase through conversion
20 PCON Pref Share conversion to equity
21 BCON Bond conversion to equity
22 WCON Warrant (options) conversion to equity
23 OTC Other Cost
24 OTI Other Income/Fee

You can also apply sorting on columns highlighted in blue color either in Ascending or Decending order. After applying sorting an arrow with red color is display in upward or downward direction.

View History link in Action column display values of actual data while edited in multiple times or payment added from Amortization.

16

Expected Cashflow Panel

Select instrument from the dropdown and data corresponding to selected instrument will be populated. List view shows following details of the selected instrument
  1. Tran Date
  2. Inst. Name
  3. Instrument Type
  4. Investment CCY
  5. Tran Type
  6. Transaction Description
  7. No. of Instruments
  8. Transaction Amount
  9. Original Expected Amount
  10. Price per Instrument
  11. Notes
You can add records by clicking the Add link in top right and Edit using links in the Action column.

Download Template will download Template in excel and show how to import data from excel.

Import Expected Data will import data from excel and display on the screen.

Export To XLS will download data in excel sheet as display on screen.


You can also apply sorting on columns highlighted in blue color either in Ascending or Decending order. After applying sorting an arrow with red color is display in upward or downward direction.

View History link in Action column display values of expected data while edited in multiple times or payment added from Amortization.




Valuation (Current & History) list view contains following details.

  1. Valuation Date
  2. Method
  3. Health Status
  4. Valuation

You can add Valuation by clicking the Add link in top right and Edit using links in the Actions column.

View History link in Action column display values of Valuation data while edited in multiple times.



IRR and MoC History list view contains following details
  1. Date
  2. IC Case IRR %
  3. Expected Gross IRR %
  4. Gross IRR %
  5. IC Case MoC
  6. Expected Gross MoC
  7. Gross MoC
  8. Reported to Investor - Yes/No
You can add IRR and MoC History by clicking the Add link in top right and Edit or Delete using links in the Action column.