Formula Generator - RECEIVED function
The RECEIVED function calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. It considers the settlement date, maturity date, investment amount, discount rate, and optional day count convention to determine the final amount received.How to generate an RECEIVED formula using AI.
To get the RECEIVED formula, you can ask the AI chatbot the following question: "What formula can I use in Excel to calculate the amount received for a loan or investment?" The chatbot should then provide you with the RECEIVED formula and guide you on how to use it in your specific scenario.
RECEIVED formula syntax.
The RECEIVED function in Excel calculates the amount received at maturity for an investment with a specified interest rate and term. The syntax for the RECEIVED function is: RECEIVED(settlement, maturity, investment, discount, basis) - settlement: The date on which the investment was purchased. - maturity: The date on which the investment matures. - investment: The initial amount invested. - discount: The discount rate of the investment. - basis: (optional) The day count basis to use for calculations. The function returns the amount received at maturity, taking into account the investment amount, discount rate, and the number of days between the settlement and maturity dates.
Calculating the amount received at maturity for a bond investment
This use case demonstrates how to use the RECEIVED function to calculate the amount received at maturity for a bond investment. The function takes into account the settlement date, maturity date, investment amount, discount rate, and optional day count convention.
RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
Calculating the amount received at maturity for multiple bond investments
In this use case, we have a table of bond investments with different settlement dates, maturity dates, investment amounts, and discount rates. We can use the RECEIVED function along with other functions like SUM and IF to calculate the total amount received at maturity for all the investments.
SUM(RECEIVED(settlement1, maturity1, investment1, discount1, [day_count_convention]), RECEIVED(settlement2, maturity2, investment2, discount2, [day_count_convention]), ...)
Calculating the amount received at maturity with different day count conventions
In this use case, we want to calculate the amount received at maturity for a bond investment using different day count conventions. We can use the RECEIVED function along with the CHOOSE function to select the appropriate day count convention based on a given criteria.