Version 2.1 Build 208

<--

**Declarations** Section, **MathFinancial_Verify** Sub, **Actual_360** Property, **Actual_365** Property, **Actual_Actual** Property, **European_30_360** Property, **US_NASD_30_360** Property, **CouponCount** Function, **CouponCountTest** Sub, **CouponDays** Function, **CouponDaysVerify** Sub, **CouponDaysVerifyOne** Sub, **CouponDaysTest** Sub, **CouponDaysThreeWayTest** Sub, **CouponDaysAfterSettlement** Function, **CouponDaysAfterSettlementTest** Sub, **CouponDaysBeforeSettlement** Function, **CouponDaysBeforeSettlementTest** Sub, **CumulativeInterestPayment** Function, **CumulativePrincipalPayment** Function, **Days360** Function, **Days360Verify** Sub, **Days360Test** Sub, **Days360ExcelTest** Sub, **DaysBetweenDates** Function, **DecliningBalanceDepreciation** Function, **DecliningBalanceDepreciationVerify** Function, **DoubleDecliningBalanceDepreciation** Function, **DoubleDecliningBalanceDepreciationVerify** Function, **Effect** Function, **EffectVerify** Sub, **FutureValue** Function, **FutureValueVerify** Sub, **FutureValueSchedule** Function, **GrossProfitCalc** Function, **GrossProfitMarginCalc** Function, **InterestPayment** Function, **InterestPaymentVerify** Sub, **InterestRate** Function, **InterestRateVerify** Sub, **InternalRateOfReturn** Function, **InternalRateOfReturnVerify** Sub, **ModifiedInternalRateOfReturn** Function, **ModifiedInternalRateOfReturnVerify** Sub, **NetPresentValue** Function, **NetPresentValueVerify** Sub, **NetProfitCalc** Function, **NextCouponDate** Function, **NextCouponDateTest** Sub, **NextCouponDateBasisTest** Sub, **Nominal** Function, **NominalVerify** Sub, **NumberPeriods** Function, **NumberPeriodsVerify** Sub, **Payment** Function, **PaymentVerify** Sub, **PaymentType** Function, **PaymentTypeVerify** Sub, **PresentValue** Function, **PresentValueVerify** Sub, **PreviousCouponDate** Function, **PreviousCouponDateTest** Sub, **PreviousCouponDateBasisTest** Sub, **PrincipalPayment** Function, **PrincipalPaymentVerify** Sub, **StraightLineDepreciation** Function, **StraightLineDepreciationVerify** Sub, **SumOfYearsDigitsDepreciation** Function, **SumOfYearsDigitsDepreciationVerify** Sub, **UnevenInternalRateOfReturn** Function, **UnevenNetPresentValue** Function, **VariableDecliningBalanceDepreciation** Function, **VariableDecliningBalanceDepreciationVerify** Sub, **XIRR** Function, **XIRRSample** Sub

**Declarations**Section**Math Financial _ Verify**Sub- Tests the routines in this Class during Development.
**Actual _360**Property- Day Count Basis Actual/360, for use within the financial date functions.
**Actual _365**Property- Day Count Basis Actual/365, for use within the financial date functions.
**Actual _ Actual**Property- Day Count Basis Actual/Actual, for use within the financial date functions.
**European _30_360**Property- Day Count Basis European 30/360, for use within the financial date functions.
**US_NASD_30_360**Property- Day Count Basis US (NASD) 30/360, for use within the financial date functions.
**Coupon Count**Function- Calculates the number of coupons payable between the settlement date and the maturity date.
**Coupon Count Test**Sub- Compare the CouponCount function to Excel's COUPNUM function.
**Coupon Days**Function- Calculates the number of days within the coupon period that includes the coupon date. That is the number of days between the previous coupon date and the next coupon date.
**Coupon Days Verify**Sub- Verify some cases of the CouponDaysBeforeSettlement, CouponDaysAfterSettlement, and CouponDays functions.
**Coupon Days Verify One**Sub- Used by the CouponDaysVerify function.
**Coupon Days Test**Sub- Compare the CouponDays function to Excel's COUPDAYS function.
**Coupon Days Three Way Test**Sub- Ensure consistency between the CouponDaysBeforeSettlement, CouponDaysAfterSettlement, and CouponDays functions.
**Coupon Days After Settlement**Function- Calculates the number of days between the settlement date and the next coupon date.
**Coupon Days After Settlement Test**Sub- Compare the CouponDaysAfterSettlement function to Excel's COUPDAYBS function.
**Coupon Days Before Settlement**Function- Calculates the number of days between the previous coupon date and the settlement date.
**Coupon Days Before Settlement Test**Sub- Compare the CouponDaysBeforeSettlement function to Excel's COUPDAYBS function.
**Cumulative Interest Payment**Function- Calculate the cumulative interest payment for an annuity based on fixed, periodic payments and a fixed interest rate.
**Cumulative Principal Payment**Function- Calculate the cumulative principal payment for an annuity based on fixed, periodic payments and a fixed interest rate.
**Days 360**Function- Determine the number of days between two dates using the specified day count basis (either US_NASD_30_360 or European_30_360).
**Days 360 Verify**Sub- Verify that the Days360 function works correctly.
**Days 360 Test**Sub- Compare the Excel version of the Days360 function to the Excel's Days360 function.
**Days 360 Excel Test**Sub- Compare the Excel and non-Excel versions of the Days360 function.
**Days Between Dates**Function- Determine the number of days between two dates using the specified day count basis. Version of the Days360 function that supports all of the Day Count Basis constants.
**Declining Balance Depreciation**Function- Calculate the fixed-declining balance depreciation for an asset for a specific period.
**Declining Balance Depreciation Verify**Function- Verify that the DecliningBalanceDepreciation function works correctly.
**Double Declining Balance Depreciation**Function- Calculate the double-declining balance depreciation (or depreciation using a similar method) for an asset for a specific period.
**Double Declining Balance Depreciation Verify**Function- Verify that the DoubleDecliningBalanceDepreciation function works correctly.
**Effect**Function- Calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
**Effect Verify**Sub- Verify that the Effect function works correctly.
**Future Value**Function- Calculate the Future Value of an annuity based on fixed, periodic payments and a fixed interest rate.
**Future Value Verify**Sub- Verify that the FutureValue function works correctly.
**Future Value Schedule**Function- Calculate the future value of an initial principal amount after applying a series of compound interest rates. Use to calculate the future value of an investment with a variable or adjustable interest rates.
**Gross Profit Calc**Function- "Gross Profit Calculator" Perform a calculation involving the Gross Profit equation. Solve for the Null argument. If all arguments non-null, return True if the expression is valid.
**Gross Profit Margin Calc**Function- "Gross Profit Margin Calculator" Perform a calculation involving the Gross Profit Margin equation. Solve for the Null argument. If all arguments non-null, return True if the expression is valid.
**Interest Payment**Function- Calculate the part of a payment representing interest for an annuity based on fixed, periodic payments and a fixed interest rate.
**Interest Payment Verify**Sub- Verify that the InterestPayment function works correctly.
**Interest Rate**Function- Calculate the fixed Interest Rate per period for an annuity based on fixed, periodic payments.
**Interest Rate Verify**Sub- Verify that the InterestRate function works correctly.
**Internal Rate Of Return**Function- Calculate the Internal Rate of Return for a series of periodic cash flows.
**Internal Rate Of Return Verify**Sub- Verify that the InternalRateOfReturn function works correctly.
**Modified Internal Rate Of Return**Function- Calculate the Internal Rate of Return for a series of periodic cash flows, when the payments and receipts are financed at different rates.
**Modified Internal Rate Of Return Verify**Sub- Verify that the ModifiedInternalRateOfReturn function works correctly.
**Net Present Value**Function- Calculate the Net Present Value of an investment based on a series of periodic cash flows and a discount rate.
**Net Present Value Verify**Sub- Verify that the NetPresentValue function works correctly.
**Net Profit Calc**Function- "Net Profit Calculator" Perform a calculation involving the Net Profit equation. Solve for the Null argument. If all arguments non-null, return True if the expression is valid.
**Next Coupon Date**Function- Calculates the next coupon date after the settlement date.
**Next Coupon Date Test**Sub- Compare the NextCouponDate function to Excel's COUPNCD function.
**Next Coupon Date Basis Test**Sub- Confirms that the Basis is irrelevant to the Excel COUPNCD function.
**Nominal**Function- Calculates the nominal annual interest rate, given the effective annual interest rate and the number of compounding periods per year.
**Nominal Verify**Sub- Verify that the Nominal function works correctly.
**Number Periods**Function- Calculate the Number of Periods for an annuity based on fixed, periodic payments and a fixed interest rate.
**Number Periods Verify**Sub- Verify that the NumberPeriods function works correctly.
**Payment**Function- Calculate the Payment for an annuity based on fixed, periodic payments and a fixed interest rate.
**Payment Verify**Sub- Verify that the Payment function works correctly.
**Payment Type**Function- Calculate the Payment Type for an annuity that is based on fixed, periodic payments and a fixed interest rate, given other information about the annuity. Function returns 1 (one) if for beginning of period payments or 0 (zero) for end of period payments.
**Payment Type Verify**Sub- Verify that the PaymentType function works correctly.
**Present Value**Function- Calculate the Present Value of an annuity based on fixed, periodic, future payments and a fixed interest rate.
**Present Value Verify**Sub- Verify that the PresentValue function works correctly.
**Previous Coupon Date**Function- Calculates the previous coupon date before the settlement date.
**Previous Coupon Date Test**Sub- Compare the PreviousCouponDate function to Excel's COUPPCD function.
**Previous Coupon Date Basis Test**Sub- Confirms that the Basis is irrelevant to the Excel COUPPCD function.
**Principal Payment**Function- Calculate the part of a payment representing principal for an annuity based on fixed, periodic payments and a fixed interest rate.
**Principal Payment Verify**Sub- Verify that the PrincipalPayment function works correctly.
**Straight Line Depreciation**Function- Calculate the straight-line depreciation for an asset for one period. The depreciation amount is the same in all periods through the end of its useful life.
**Straight Line Depreciation Verify**Sub- Verify that the StraightLineDepreciation function works correctly.
**Sum Of Years Digits Depreciation**Function- Calculate the sum-of-years' digits depreciation for an asset for a specific period.
**Sum Of Years Digits Depreciation Verify**Sub- Verify that the SumOfYearsDigitsDepreciation function works correctly.
**Uneven Internal Rate Of Return**Function- Calculate the Internal Rate of Return for a series of cash flows that may not be periodic. Similar to XIRR, but accepts the arguments differently.
**Uneven Net Present Value**Function- Calculate the Net Present Value for a series of cash flows that may not be periodic.
**Variable Declining Balance Depreciation**Function- Calculate the declining balance depreciation (or depreciation using a similar method) for a specific part of an asset's life.
**Variable Declining Balance Depreciation Verify**Sub- Verify that the VariableDecliningBalanceDepreciation function works correctly.
**XIRR**Function- Calculate the Internal Rate Of Return For uneven cash flows. Similar to UnevenInternalRateOfReturn, but accepts the arguments differently.
**XIRR Sample**Sub- Print some samples of the XIRR function.

This Windows-based ActiveX DLL provides many useful routines through its function-bearing and data structure classes. Consult the Help file for more information, or call us at 1-310-472-3736. For the latest news and files, visit our home page on the World Wide Web: http://www.entisoft.com

Copyright 1996-1999 Entisoft

Entisoft Tools is a trademark of Entisoft.