• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Detailed guide on how to use the RECEIVED function in Excel

0 Comments

Detailed guide on how to use the RECEIVED function in Excel: The RECEIVED function is one of the basic financial functions used to calculate the amount received when an investment matures. Follow the article below to understand how to use the RECEIVED function in Excel.

1. Syntax of the RECEIVED function

Function syntax: =RECEIVED(settlement, maturity, investment, discount, [basis])

Where:

  • Settlement: Required argument, the security settlement date. The security settlement date is the date after the issue date when the security is sold to the buyer.
  • Maturity: Required argument, the security maturity date. The security maturity date is the date when the security expires.
  • Investment: Required argument, the amount invested in the security.
  • Discount: Required argument, the discount rate of the security.
  • Basis: Optional argument, the type of day count basis to use.
    Note:
  • If Basis is 0 or omitted, the day count basis is US (NASD) 30/360.
  • If Basis is 1, the day count basis is actual/actual.
  • If Basis is 2, the day count basis is actual/360.
  • If Basis is 3, the day count basis is actual/365.
  • If Basis is 4, the day count basis is European 30/360.
  • The settlement, maturity, and basis arguments are truncated to integer values.
  • If settlement or maturity is not a valid date, the RECEIVED function returns the #VALUE! error value.
  • If investment ≤ 0 or if discount ≤ 0, the RECEIVED function returns the #NUM! error value.
  • If basis < 0 or if basis > 4, the RECEIVED function returns the #NUM! error value.
  • If settlement ≥ maturity, the RECEIVED function returns the #NUM! error value.

2. How to use the RECEIVED function

For example, you purchase a bond with a face value of 1,000,000 issued on July 23, 2019, and maturing on July 23, 2020 with a discount rate of 7%.

Detailed guide on how to use the RECEIVED function in Excel

Detailed guide on how to use the RECEIVED function in Excel

At this point, to calculate the amount received after the bond matures, we have the following formula:

=RECEIVED(“23/7/2019″,”23/7/2020”,1000000,7%,3)

The result we will obtain is the amount received, which is 1,075,491.

Therefore, the above article has guided you on how to use the RECEIVED function in Excel. We hope that this article will be useful to you in your work. Good luck!

Rate this post
32
264 Views
How to create Header and Footer in Microsoft ExcelPrevHow to create Header and Footer in Microsoft ExcelApril 15, 2023
Useful Excel Tips and Tricks for Management AccountantsApril 15, 2023Useful Excel Tips and Tricks for Management AccountantsNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Windows 10 Pro Key Global Genuine Key Windows 10 Pro Key Global Genuine Key
    Rated 4.78 out of 5
    $6.00
  • Windows 10 Pro N Key Global Windows 10 Pro N Key Global
    Rated 4.83 out of 5
    $10.00
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • Windows 10 Pro Key Global 20 PC Windows 10 Pro Key Global 20 PC $50.00
  • Windows Server 2025 Remote Desktop Services 50 User Connections Windows Server 2025 Remote Desktop Services 50 User Connections $25.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • SQL Server 2014 Standard SQL Server 2014 Standard $20.00
  • Buy Windows 11 Pro CD Key License Buy Windows 11 Pro CD Key License
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2016 Essentials Key Global Windows Server 2016 Essentials Key Global
    Rated 4.79 out of 5
    $10.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.