YEARLYLOCINT function

Returns interest expense on outstanding line of credit for specified number of years (or a specific year) from the period debt is incurred.

Syntax

The YEARLYLOCINT function syntax has the following arguments

  • LoC_available     Required.    Number.    Amount of LoC available

  • Annual_interest_rate     Required.    Number.    Annual interest rate %

  • LoC_used     Required.    Array.    Amount of LoC that is used in a given month. Input is a row (of one or more columns) with amounts by month. Note: By default, this function will return a row of values for the same number of columns that you select for this input. Please make sure that adjacent cells do not have any other content. Add the month_numner input in this function if you need this value for a specific month (and not for all months).

  • Paydown_amount     Optional.    Array.    Cash available for paydown. Input is a row with amounts by month. Default=0 for all months.

  • Year_number     Optional.    Number.    Year for which this value is required. For example, enter 1 if you'd like this value for first year of this debt. Note: value will be returned for specified month only; default =1; must be integer >=1