Article Some of the content in this topic may not be applicable to some languages. Document libraries are collections of files that are shared in Web sites based...
Article Show All Hide All Returns the accrued interest for a security that pays periodic interest. If this function is not available, and returns the #NAME? error...
Article Show All Hide All Returns the accrued interest for a security that pays interest at maturity. If this function is not available, and returns the #NAME?...
Article Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle...
Article Returns the number of days from the beginning of the coupon period to the settlement date. If this function is not available, and returns the #NAME? error...
Article Returns the number of days in the coupon period that contains the settlement date. If this function is not available, and returns the #NAME? error, install...
Article Returns the number of days from the settlement date to the next coupon date. If this function is not available, and returns the #NAME? error, install and...
Article Show All Hide All Returns a number that represents the next coupon date after the settlement date. If this function is not available, and returns the #NAME...
Article Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. If this function is not available...
Article Show All Hide All Returns a number that represents the previous coupon date before the settlement date. If this function is not available, and returns the...
Article Returns the cumulative interest paid on a loan between start_period and end_period . If this function is not available, and returns the #NAME? error...
Article Returns the cumulative principal paid on a loan between start_period and end_period . If this function is not available, and returns the #NAME? error...
Article Returns the depreciation of an asset for a specified period using the fixed-declining balance method. Syntax DB ( cost , salvage , life , period ,month...
Article Show All Hide All Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify...
Article Returns the discount rate for a security. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in...
Article Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number. Use DOLLARDE to convert fractional dollar numbers, such...
Article Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction. Use DOLLARFR to convert decimal numbers to fractional...
Article Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of the cash flows and...
Article Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. If this function is not...
Article Some of the content in this topic may not be applicable to some languages. Function Description ACCRINT Returns the accrued interest for a security that...
Article Returns the future value of an investment based on periodic, constant payments and a constant interest rate. Syntax FV ( rate , nper , pmt ,pv,type) For...
Article Returns the future value of an initial principal after applying a series of compound interest rates. Use FVSCHEDULE to calculate the future value of an...
Article Show All Hide All Returns the interest rate for a fully invested security. If this function is not available, and returns the #NAME? error, install and...
Article Show All Hide All Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. For...
