DEBTCONVERTED function

Returns amount of debt converted to equity (or other income) for specified number of months (or a specific month) from month debt is incurred

Syntax

The DEBTCONVERTED 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_months_display     Required.    Number.    Number of months of this value to display; for example: enter 12 if you'd like to get the value for the first 12 months. Input value must be >=1 and default=12.

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

  • Facility_fees_percent    Optional. 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

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