Math Financial Class

Entisoft Tools 2.0 Object Library
Version 2.1 Build 208
<-- Previous || Index || Main || Topics || Next -->

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.