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