YEARLYINTEREST function

Returns interest expense on debt for specified number of years (or a specific year) from the period debt is incurred. Exit and commitment fees are excluded.

Syntax

The YEARLYINTEREST function syntax has the following arguments

  • Debt_amount     Required.    Number.    Amount of debt

  • Debt_term_months     Required.    Number.    Debt term in months

  • Annual_interest_rate     Required.    Number.    Annual interest rate %

  • Interest_method     Required.    Refer table.    Interest method. Note: default is 1 (equal payment) if not specified

    Interest method# values in formula Interest method mapping
    1 Equal payment
    2 Equal principal
    3 Interest only (Principal paid at maturity)
    4 Int & Principal accrued until maturity

  • Number_years_display     Required.    Number.    Number of years of this value to display; for example: enter 1 if you'd like to get the value for the first year. Input value must be >=1 and default=1.

  • Interest_only_period_months     Optional.    Number.    Number of months of deferral of principal repayment; default=0

  • Facility_fees_percent    Optional.    Number.    Facility fee as % of committed debt amount; default=0%

  • Exit_fees_percent     Optional.    Number.    Exit fees as % of committed debt amount; default=0%

  • Repay_or_convert     Optional.    Refer table.    Specify whether debt is repaid or converted to equity at maturity, if applicable; default=Repaid

    Convert or Repay values in formula Convert or Repay mapping
    1 Repaid
    2 Convert to equity

  • Year_number     Optional.    Number.    Year for which this value is required. Leave this blank (no input) if you need values displayed for a specified number of years. Input value must be integer >=1. For example, enter 2 if you'd like this value for year 2. Note: value will be returned for specified month only if you enter a value.