6.2 Discounting Engine Cash Flows Decimal Values

When computing Cash Flows in the discounting engine, the Excel used for computing the cash flows contains a precision of 15 places after the decimal. However, the application computes the values with a precision of 31 places after the decimal.

For example;

For a Cash Flow amount of 591032.98, if the discounting is done for 6 months considering the rate for every term as 0.233294, the discounted value calculated by the application will be 582827.0470511801010228550497950952 whereas the value calculated in excel will be 582827.0457552210000.

Hence, for a sufficiently large value of Cash Flow amount, there might be a difference in Excel calculated value and the value calculated by the application