Thursday, January 31, 2019

FuTuRe VaLuE



When we make any investment or do fixed deposit or any recurring deposit (RD) or take an insurance policy. We want to know/calculate how much amount we get after maturity/due date.

  • It is very easy to calculate the total amount after maturity by applying a simple formula. Below you can see a table in which the amount, rate % and the time period is given.

  • By applying formula =FV(Rate,Nper,Pmt,,1) here one stand for beginning of the period. After you type =FV you can see a description.
  • Now we select all the figures according to the formula. As you can see below.
  • Now a question arises here why the amount appear which minus sign and red colour. This is because your bank is receiving your money on your behalf and it will pay out this money at the end. And the accountant denotes this amount by red colour or negative sign.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

FrEeZe PaNe

In a company or a school we have a number of students and employees and we maintain the data of all of them but sub times a hindrance ca...

  • SpLiT nAmE
    This formula is related to the separation of the first name and the last name in different cells. We generally write the name with its s...
  • MuLtIpLy
    The next formula is basically for calculating total amount of per unit price of the product  or salary of the employees per day etc  ...
  • mR. & mRs.
    When we have completed our data and submit that data to our authority and they say to add salutation MR. or MRS.   In front of the name...