If anybody want to invest his money in future investment then first he want to know what the return of the investment is after completed the specific time. So, it is very important to know how to calculating future value in MS Excel? FV() is the most popular financial function of Microsoft Excel. This function is used to returns future value of investment which is based on a specific periodic, fixed payment and fixed rate of interest.
Syntax of FV:
FV(rate, pmt, nper, pv, type) rate: Annual Interest Ratenper: Number of Periodpmt is the payment monthly installment which is made on each period. It can be feed as a negative number.pv: Present/Principal Value type: It’s an optional value. If you feed 0, it means end of the period and if you feed 1, If you ignore this part then it is assumed to be 0.
Example:When you want to calculate future value of an investment like invest amount Rs. 1000/- for 60 months @ 8.50% annual interest rate in the case of RD (Recurring Deposit) If you want to calculate future value of an investment like investment amount Rs. 1,00,000/- for 60 months @ 11.50% annual interest rate in the case of FD (Fixed Deposit) then, you have to take following steps:
Easily Calculating Future Value in Excel
Step 1: Prepare the following sheet in MS Excel.
Step 2: If you want to calculate RD (Recurring Deposit) amount, then you have to type following formula in Cell B6 =FV(B5/12,B4,-B3) then press enter it will show you Rs. 74,442.44/- as a result.
Must Read: – How to Age calculation From Date of Birth – MS EXCEL
Step 3: If you want to calculate FD (Fixed Deposit) amount then you have to type following formula in Cell C6 =FV(C5/12,C4,0,-C3) then press enter it will show you Rs. 1,77,227.19/- as a result.
I hope you like this post and also sort out your problem regarding to calculating future value in excel. Share this post in your friends and improve your knowledge. Give your important suggestions in the comment box. Thanks.