Class Module
75 Members
Math Financial Class
Entisoft Tools 2.0 Object Library · MathFinancial · 37 Functions · 5 Properties · 32 Subroutines
Declarations
Declarations
These functions perform financial calculations. Copyright 1998 Entisoft
Section
Actual_360
Actual _360
Day Count Basis Actual/360, for use within the financial date functions.
Property
Actual_365
Actual _365
Day Count Basis Actual/365, for use within the financial date functions.
Property
Actual_Actual
Actual _ Actual
Day Count Basis Actual/Actual, for use within the financial date functions.
Property
European_30_360
European _30_360
Day Count Basis European 30/360, for use within the financial date functions.
Property
US_NASD_30_360
US_NASD_30_360
Day Count Basis US (NASD) 30/360, for use within the financial date functions.
Property
CouponCount
Coupon Count
Calculates the number of coupons payable between the settlement date and the maturity date.
Function
CouponDays
Coupon Days
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.
Function
CouponDaysAfterSettlement
Coupon Days After Settlement
Calculates the number of days between the settlement date and the next coupon date.
Function
CouponDaysBeforeSettlement
Coupon Days Before Settlement
Calculates the number of days between the previous coupon date and the settlement date.
Function
CumulativeInterestPayment
Cumulative Interest Payment
Calculate the cumulative interest payment for an annuity based on fixed, periodic payments and a fixed interest rate.
Function
CumulativePrincipalPayment
Cumulative Principal Payment
Calculate the cumulative principal payment for an annuity based on fixed, periodic payments and a fixed interest rate.
Function
Days360
Days 360
Determine the number of days between two dates using the specified day count basis (either US_NASD_30_360 or European_30_360 ).
Function
DaysBetweenDates
Days Between Dates
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.
Function
DecliningBalanceDepreciation
Declining Balance Depreciation
Calculate the fixed-declining balance depreciation for an asset for a specific period.
Function
DecliningBalanceDepreciationVerify
Declining Balance Depreciation Verify
View VB6 signature, parameters, and usage notes.
Function
DoubleDecliningBalanceDepreciation
Double Declining Balance Depreciation
Calculate the double-declining balance depreciation (or depreciation using a similar method) for an asset for a specific period.
Function
DoubleDecliningBalanceDepreciationVerify
Double Declining Balance Depreciation Verify
View VB6 signature, parameters, and usage notes.
Function
Effect
Effect
Calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
Function
FutureValue
Future Value
Calculate the Future Value of an annuity based on fixed, periodic payments and a fixed interest rate.
Function
FutureValueSchedule
Future Value Schedule
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.
Function
GrossProfitCalc
Gross Profit Calc
"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.
Function
GrossProfitMarginCalc
Gross Profit Margin Calc
"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.
Function
InterestPayment
Interest Payment
Calculate the part of a payment representing interest for an annuity based on fixed, periodic payments and a fixed interest rate.
Function
InterestRate
Interest Rate
Calculate the fixed Interest Rate per period for an annuity based on fixed, periodic payments.
Function
InternalRateOfReturn
Internal Rate Of Return
Calculate the Internal Rate of Return for a series of periodic cash flows.
Function
ModifiedInternalRateOfReturn
Modified Internal Rate Of Return
Calculate the Internal Rate of Return for a series of periodic cash flows, when the payments and receipts are financed at different rates.
Function
NetPresentValue
Net Present Value
Calculate the Net Present Value of an investment based on a series of periodic cash flows and a discount rate.
Function
NetProfitCalc
Net Profit Calc
"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.
Function
NextCouponDate
Next Coupon Date
Calculates the next coupon date after the settlement date.
Function
Nominal
Nominal
Calculates the nominal annual interest rate, given the effective annual interest rate and the number of compounding periods per year.
Function
NumberPeriods
Number Periods
Calculate the Number of Periods for an annuity based on fixed, periodic payments and a fixed interest rate.
Function
Payment
Payment
Calculate the Payment for an annuity based on fixed, periodic payments and a fixed interest rate.
Function
PaymentType
Payment Type
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.
Function
PresentValue
Present Value
Calculate the Present Value of an annuity based on fixed, periodic, future payments and a fixed interest rate.
Function
PreviousCouponDate
Previous Coupon Date
Calculates the previous coupon date before the settlement date.
Function
PrincipalPayment
Principal Payment
Calculate the part of a payment representing principal for an annuity based on fixed, periodic payments and a fixed interest rate.
Function
StraightLineDepreciation
Straight Line Depreciation
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.
Function
SumOfYearsDigitsDepreciation
Sum Of Years Digits Depreciation
Calculate the sum-of-years' digits depreciation for an asset for a specific period.
Function
UnevenInternalRateOfReturn
Uneven Internal Rate Of Return
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.
Function
UnevenNetPresentValue
Uneven Net Present Value
Calculate the Net Present Value for a series of cash flows that may not be periodic.
Function
VariableDecliningBalanceDepreciation
Variable Declining Balance Depreciation
Calculate the declining balance depreciation (or depreciation using a similar method) for a specific part of an asset's life.
Function
XIRR
XIRR
Calculate the Internal Rate Of Return For uneven cash flows. Similar to UnevenInternalRateOfReturn , but accepts the arguments differently.
Function
CouponCountTest
Coupon Count Test
View VB6 signature, parameters, and usage notes.
Sub
CouponDaysAfterSettlementTest
Coupon Days After Settlement Test
View VB6 signature, parameters, and usage notes.
Sub
CouponDaysBeforeSettlementTest
Coupon Days Before Settlement Test
View VB6 signature, parameters, and usage notes.
Sub
CouponDaysTest
Coupon Days Test
View VB6 signature, parameters, and usage notes.
Sub
CouponDaysThreeWayTest
Coupon Days Three Way Test
View VB6 signature, parameters, and usage notes.
Sub
CouponDaysVerify
Coupon Days Verify
View VB6 signature, parameters, and usage notes.
Sub
CouponDaysVerifyOne
Coupon Days Verify One
Used by the CouponDaysVerify function.
Sub
Days360ExcelTest
Days 360 Excel Test
View VB6 signature, parameters, and usage notes.
Sub
Days360Test
Days 360 Test
View VB6 signature, parameters, and usage notes.
Sub
Days360Verify
Days 360 Verify
View VB6 signature, parameters, and usage notes.
Sub
EffectVerify
Effect Verify
View VB6 signature, parameters, and usage notes.
Sub
FutureValueVerify
Future Value Verify
View VB6 signature, parameters, and usage notes.
Sub
InterestPaymentVerify
Interest Payment Verify
View VB6 signature, parameters, and usage notes.
Sub
InterestRateVerify
Interest Rate Verify
View VB6 signature, parameters, and usage notes.
Sub
InternalRateOfReturnVerify
Internal Rate Of Return Verify
View VB6 signature, parameters, and usage notes.
Sub
MathFinancial_Verify
Math Financial _ Verify
View VB6 signature, parameters, and usage notes.
Sub
ModifiedInternalRateOfReturnVerify
Modified Internal Rate Of Return Verify
View VB6 signature, parameters, and usage notes.
Sub
NetPresentValueVerify
Net Present Value Verify
View VB6 signature, parameters, and usage notes.
Sub
NextCouponDateBasisTest
Next Coupon Date Basis Test
View VB6 signature, parameters, and usage notes.
Sub
NextCouponDateTest
Next Coupon Date Test
View VB6 signature, parameters, and usage notes.
Sub
NominalVerify
Nominal Verify
View VB6 signature, parameters, and usage notes.
Sub
NumberPeriodsVerify
Number Periods Verify
View VB6 signature, parameters, and usage notes.
Sub
PaymentTypeVerify
Payment Type Verify
View VB6 signature, parameters, and usage notes.
Sub
PaymentVerify
Payment Verify
View VB6 signature, parameters, and usage notes.
Sub
PresentValueVerify
Present Value Verify
View VB6 signature, parameters, and usage notes.
Sub
PreviousCouponDateBasisTest
Previous Coupon Date Basis Test
View VB6 signature, parameters, and usage notes.
Sub
PreviousCouponDateTest
Previous Coupon Date Test
View VB6 signature, parameters, and usage notes.
Sub
PrincipalPaymentVerify
Principal Payment Verify
View VB6 signature, parameters, and usage notes.
Sub
StraightLineDepreciationVerify
Straight Line Depreciation Verify
View VB6 signature, parameters, and usage notes.
Sub
SumOfYearsDigitsDepreciationVerify
Sum Of Years Digits Depreciation Verify
View VB6 signature, parameters, and usage notes.
Sub
VariableDecliningBalanceDepreciationVerify
Variable Declining Balance Depreciation Verify
View VB6 signature, parameters, and usage notes.
Sub
XIRRSample
XIRR Sample
View VB6 signature, parameters, and usage notes.
Sub