RECEIVED: Calculating the value at maturity of a fully invested security


show more RECEIVED: Calculating the value at maturity of a fully invested security provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Financial Functions in Depth show less
please wait ...

RECEIVED: Calculating the value at maturity of a fully invested security

In the previous movie, I showed you how to calculate the interest rate behind an investment. In this movie I'll show you how to discover the amount you'll receive when you know the length of the investment and its interest rate. To make that calculation you will use the RECEIVED function. For the RECEIVED function you need to know five things. The first is the settlement date, which I have in cell C4 and that is the date that you gain control of the investment. Next is the maturity date and the maturity date is the date that final payment is due to you and the investment ends.

Then you have the investment. That's the amount you pay to get into the investment. Next you have the discount rate in C7 and the discount rate is the interest rate on the investment. Then next in cell C8 we have the basis, and basis is the way that you calculate days in a month and a year. We have it set value 0 which is the default and that is the North American standard which uses 30 day months and a ...

RECEIVED: Calculating the value at maturity of a fully invested security
Video duration: 2m 46s 2h 18m Intermediate

Viewers:

RECEIVED: Calculating the value at maturity of a fully invested security provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Financial Functions in Depth

Subjects:
Business IT
Software:
Excel
Author:
please wait ...