Forum Discussion
SUMIF
Hi I am looking for help with a formula to calculate outstanding portfolio. Each investment has a maturity date a cash flow on the maturity. I want to calculate outstanding portfolio on each dat...
What do I7, E6:E98 and C6:C98 contain?
Hi HansVogelaar
Sorry, I was trying to upload the screen shot but can't seem to be able to do that.
I7 - reference date for calculating outstanding amounts for various maturity
E6:E98 - Maturity dates
C6:C98 - Is principal amount that will be repaid on maturity.
I want to calculate amount that will mature in in x years from I7.
Thanks
AB