Want to check if your investment is profitable? Use PV Function. It will help you to determine that an investment is profitable or not.
PV Function is one of the multi-usage functions in excel. You can use it to calculate the present value of a financial investment or a loan.
And, in the case of a loan, you can get the actual present value of a loan you can afford to pay in monthly payments. For using PV function in excel, you need a constant interest rate, constant periodic payments.
Let’s say if you have to pay $2000 every year for next 20 years to get $50000 at the end of 20 years. It will tell you that it’s profitable or not.
PV(rate, nper, pmt, [fv], [type])
Let’s say you want to invest $4000 in an investment plan and in return, you’ll get $1000 at the end of each year for next 5 years.
That means you’ll get total $5000 in next 5 years.
Now, the thing is, you have to evaluate that this investment is profitable or not. As you are investing $4000 today and the return will come to you in next 5 years.
Here, we are using 5% as an interest rate.
In above calculation, when we used PV function it has returned -4329.
So, here the present value of your investment is $4329 and you are investing $4000 for it. Hence, your investment is profitable.
Quick Tip: If the present value of the investment(inflows) is greater the cost of the investment, the investment is a good one.
To learn more about Excel PV Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.