Excel RECEIVED Function

Welcome to another insightful exploration at LearnExcel.io, where we aim to unravel the complexities of Microsoft Excel functions for you. Today, we’re delving into a particularly interesting Excel Date and Time Function known as RECEIVED. This function is invaluable for calculating the amount received at maturity for a fully invested security. Perfect for financial analysts and anyone working with investments, RECEIVED helps you keep tabs on your financial calculations effortlessly.

Category

The RECEIVED function falls under the category of Excel Date and Time Functions. This category encompasses a variety of functions designed to help you manipulate and work with dates and times in Excel, providing powerful tools for a wide range of applications.

Excel RECEIVED Syntax

RECEIVED(settlement, maturity, investment, discount, [basis])

Excel RECEIVED Parameters

• settlement: The date when the security is settled. This is the date after issuance when the security is delivered to the buyer.
• maturity: The security’s maturity date, which is when it expires and the principal amount is supposed to be paid back.
• investment: The amount of money invested in the security.
• discount: The security’s discount rate.
• [basis] (optional): The day count basis to use in calculations. This parameter can be left blank, in which case Excel uses the default (NASD) basis.

Return Value

The RECEIVED function returns the amount that will be received at the maturity of a fully invested security, accounting for the specified day count basis.

Examples

Consider an investment with the following characteristics:

• Settlement date: March 5, 2021
• Maturity date: June 5, 2021
• Investment amount: $10,000
• Discount rate: 10%

To calculate the amount received at maturity, use:

=RECEIVED("2021-03-05", "2021-06-05", 10000, 0.1, 0)

This formula would provide the total amount received at maturity based on the specified parameters.

Use Cases

The RECEIVED function is particularly useful for financial analysts and investors focusing on securities. Common use cases include:

• Calculating the maturity value of treasury bills.
• Estimating returns on short-term investments.

To use the RECEIVED function effectively, always ensure your date formats are consistent and clear, and understand the implications of the chosen day count basis on your calculations.

Common Errors

Users might encounter errors if:

• The settlement date is after the maturity date.
• Any of the numeric arguments are negative.

To avoid these errors, verify your input data thoroughly before running your formulas.

Compatibility

The RECEIVED function is available in Excel 2007 and later versions. It might not be available in earlier versions or could return different results due to updates in Excel’s calculation methods over the years.

Conclusion

We’ve covered the essential aspects of the RECEIVED function, from its syntax and parameters to practical examples and common use cases. As with any Excel function, the key to mastering RECEIVED is practice. Experiment with it in your own spreadsheets, using the examples provided here as a starting point. Remember, Excel is a powerful tool in the hands of those who know how to leverage its functions effectively. For more insightful tips and guidance on Excel functions, keep exploring LearnExcel.io.