• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# Financial Functions

esProc supplies financial functions that return financial information.

 Calculate the accrued interest for a security that pays periodic interest Calculate the accrued interest for a security that pays interest at maturity Calculate the coupon date Calculate the number of coupons payable between a security’s settlement date and maturity date/ the number of days in a coupon period that contains the settlement date/ the number of days from the beginning of a coupon's period to the settlement date / the number of days from the settlement date to the next coupon date Calculate the depreciation of an asset for a specified period Calculate the depreciation of an asset for a specified period Calculate the discount rate for a security Return the modified duration of a security that pays periodic interest with an assumed par value Calculate the interest rate for a security that pays interest at maturity Calculate the internal rate of return for a series of cash flows represented by numeric values Calculate the modified internal rate of return for a series of periodic cash flows Calculate the number of periods required to pay off a loan according to a specified periodic payment Calculate the net present value of an investment Calculate each period’s amount required to pay off an investment loan Calculate the price of a security Calculate the interest rate required to pay an investment Calculate the amount received at maturity for a security Calculate the straight-line depreciation of an asset for each period Calculate depreciation of an asset for a specified period, using the sum-of-years’ digits method Ø  Fv() Calculate the future value of an investment Calculate the depreciation of an asset for a specfied period Calculate the yield rate