RECEIVED function

The RECEIVED function in Jspreadsheet Formulas Pro is used to calculate the total amount you receive when a financial security you have invested in fully matures. This could be a bond or any other type of investment that has a maturity date. Essentially, it gives you the future value of your investment, assuming that the full investment amount is held until maturity. This function is especially helpful for financial planning and forecasting.

Documentation

Returns the amount received at maturity for a fully invested security.

Syntax

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

Parameter	Description
`settlement`	The security's settlement date.
`maturity`	The security's maturity date.
`investment`	The amount invested in the security.
`discount`	The security's discount rate.
`[basis]`	The type of day count basis to use: 0 or omitted for US (NASD) 30/360, 1 for actual/actual, 2 for actual/360, 3 for actual/365, 4 for European 30/360.

Behavior

The RECEIVED function returns the received amount of a fully invested security. It calculates the amount received at maturity for an investment in fixed-income securities such as bonds.

The function takes four mandatory parameters: settlement, maturity, investment, discount, and one optional parameter basis.
The function will return a #VALUE! error if any of the parameters are not numerical values, or if the dates are not valid.
If settlement is later than maturity, it will return a #NUM! error.
Boolean values are treated as 1 for TRUE and 0 for FALSE.

Common Errors

Error	Description
#VALUE!	The function will return this error if any of the parameters are not numerical values or if the dates are not valid.
#NUM!	This error occurs if the `settlement` date is later than the `maturity` date.

Best practices

Always make sure that the settlement date is earlier than the maturity date to avoid a #NUM! error.

Ensure that the investment and discount values are numerical. Text or boolean values will result in a #VALUE! error.

Be careful with the basis parameter. Remember that it is optional, and if omitted, it is assumed to be 0. If you use it, make sure you're using the correct type of day count basis.

Always check your dates to ensure they are valid to prevent any #VALUE! errors.

Usage

A few examples using the RECEIVED function.

// Basic calculation without basis
RECEIVED("2023-01-01","2023-06-01",1000,0.1)  
// Returns: 1043.48

// With Actual/Actual day count basis (1)
RECEIVED("2023-01-01","2023-06-01",1000,0.1,1)  
// Returns: 1043.16

Interactive Spreadsheet Demo

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>

<div id="spreadsheet"></div>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('MWU5YWI0YmRmOWE2Zjk2N2MwMmFjNzU4MTYwMGUzNTU1YzM5YWQxMzdmN2VjOTEyZmEwZjQzZDk2Yzk0M2E1MDRlMTE0YjdjM2Q2MjU5MDNjNDg3NDZmZDEwOWVhOWIwMzIwNTY1ODA1NzE0ODZmYzExZTc5MjEyN2M0ZjEwNzQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNalV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Settlement",
        "Maturity",
        "Investment",
        "Discount",
        "Amount Received"
    ],
    [
        "1/15/2024",
        "7/15/2024",
        10000,
        0.08,
        "=RECEIVED(A2,B2,C2,D2)"
    ],
    [
        "3/1/2024",
        "9/1/2024",
        25000,
        0.065,
        "=RECEIVED(A3,B3,C3,D3)"
    ],
    [
        "6/10/2024",
        "12/10/2024",
        15000,
        0.075,
        "=RECEIVED(A4,B4,C4,D4)"
    ]
]
  }]
});
</script>
</html>

import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";

// Set license
jspreadsheet.setLicense('MWU5YWI0YmRmOWE2Zjk2N2MwMmFjNzU4MTYwMGUzNTU1YzM5YWQxMzdmN2VjOTEyZmEwZjQzZDk2Yzk0M2E1MDRlMTE0YjdjM2Q2MjU5MDNjNDg3NDZmZDEwOWVhOWIwMzIwNTY1ODA1NzE0ODZmYzExZTc5MjEyN2M0ZjEwNzQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNalV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default function App() {
    // Spreadsheet array of worksheets
    const spreadsheet = useRef();

    // Worksheet data
    const data = [
    [
        "Settlement",
        "Maturity",
        "Investment",
        "Discount",
        "Amount Received"
    ],
    [
        "1/15/2024",
        "7/15/2024",
        10000,
        0.08,
        "=RECEIVED(A2,B2,C2,D2)"
    ],
    [
        "3/1/2024",
        "9/1/2024",
        25000,
        0.065,
        "=RECEIVED(A3,B3,C3,D3)"
    ],
    [
        "6/10/2024",
        "12/10/2024",
        15000,
        0.075,
        "=RECEIVED(A4,B4,C4,D4)"
    ]
];

    // Render component
    return (
        <Spreadsheet ref={spreadsheet}>
            <Worksheet data={data} />
        </Spreadsheet>
    );
}

<template>
    <Spreadsheet ref="spreadsheet">
        <Worksheet :data="data" />
    </Spreadsheet>
</template>

<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";

// Set license
jspreadsheet.setLicense('MWU5YWI0YmRmOWE2Zjk2N2MwMmFjNzU4MTYwMGUzNTU1YzM5YWQxMzdmN2VjOTEyZmEwZjQzZDk2Yzk0M2E1MDRlMTE0YjdjM2Q2MjU5MDNjNDg3NDZmZDEwOWVhOWIwMzIwNTY1ODA1NzE0ODZmYzExZTc5MjEyN2M0ZjEwNzQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNalV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Settlement",
        "Maturity",
        "Investment",
        "Discount",
        "Amount Received"
    ],
    [
        "1/15/2024",
        "7/15/2024",
        10000,
        0.08,
        "=RECEIVED(A2,B2,C2,D2)"
    ],
    [
        "3/1/2024",
        "9/1/2024",
        25000,
        0.065,
        "=RECEIVED(A3,B3,C3,D3)"
    ],
    [
        "6/10/2024",
        "12/10/2024",
        15000,
        0.075,
        "=RECEIVED(A4,B4,C4,D4)"
    ]
]

        return {
            data
        };
    }
}
</script>

import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";

// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('MWU5YWI0YmRmOWE2Zjk2N2MwMmFjNzU4MTYwMGUzNTU1YzM5YWQxMzdmN2VjOTEyZmEwZjQzZDk2Yzk0M2E1MDRlMTE0YjdjM2Q2MjU5MDNjNDg3NDZmZDEwOWVhOWIwMzIwNTY1ODA1NzE0ODZmYzExZTc5MjEyN2M0ZjEwNzQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNalV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

@Component({
    standalone: true,
    selector: "app-root",
    template: `<div #spreadsheet></div>`
})
export class AppComponent {
    @ViewChild("spreadsheet") spreadsheet: ElementRef;
    // Worksheets
    worksheets: jspreadsheet.worksheetInstance[];

    // Create a new data grid
    ngAfterViewInit() {
        // Create spreadsheet
        this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
            worksheets: [{
                data: [
    [
        "Settlement",
        "Maturity",
        "Investment",
        "Discount",
        "Amount Received"
    ],
    [
        "1/15/2024",
        "7/15/2024",
        10000,
        0.08,
        "=RECEIVED(A2,B2,C2,D2)"
    ],
    [
        "3/1/2024",
        "9/1/2024",
        25000,
        0.065,
        "=RECEIVED(A3,B3,C3,D3)"
    ],
    [
        "6/10/2024",
        "12/10/2024",
        15000,
        0.075,
        "=RECEIVED(A4,B4,C4,D4)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub