How To Calculate Maturity Value In Excel Explained
3.1 هزار بار بازدید -
12 ماه پیش
-
In this video we discuss
In this video we discuss how to calculate the maturity value of an investment or a loan in excel. We go step by step through the formula and how to enter it into excel
Transcript/notes
Here is the formula for calculating maturity value for simple interest.
As an example, if someone borrows $1000, the simple rate of interest is 11% per year and the loan is for 2 years, what is the maturity value of the loan?
We are going to calculate the maturity value and put the answer in cell D3, so we left click on cell D3, so it is highlighted.
Next, we type in an equals sign. Referring to the maturity value formula, we left click on the principal amount, cell B2, now we type in a multiplication sign, which in excel is an asterisk, which is shift 8 on the keyboard, then we type in an open parenthesis. Next, we type in a 1, then we type in a plus or addition sign.
From here, we left click on the rate, which is cell B3, then we left click on the time, which is cell B4. Next, we type in a closed parenthesis to close off the 1 plus r times t portion of the formula, and then to finish off, we hit the enter key. And we have our answer of $1220.
Chapters/Timestamps
0:00 Formula for maturity value
0:13 Excel steps to calculate maturity value
Transcript/notes
Here is the formula for calculating maturity value for simple interest.
As an example, if someone borrows $1000, the simple rate of interest is 11% per year and the loan is for 2 years, what is the maturity value of the loan?
We are going to calculate the maturity value and put the answer in cell D3, so we left click on cell D3, so it is highlighted.
Next, we type in an equals sign. Referring to the maturity value formula, we left click on the principal amount, cell B2, now we type in a multiplication sign, which in excel is an asterisk, which is shift 8 on the keyboard, then we type in an open parenthesis. Next, we type in a 1, then we type in a plus or addition sign.
From here, we left click on the rate, which is cell B3, then we left click on the time, which is cell B4. Next, we type in a closed parenthesis to close off the 1 plus r times t portion of the formula, and then to finish off, we hit the enter key. And we have our answer of $1220.
Chapters/Timestamps
0:00 Formula for maturity value
0:13 Excel steps to calculate maturity value
12 ماه پیش
در تاریخ 1402/04/16 منتشر شده
است.
3,124
بـار بازدید شده