Understanding Excel formulas for financial analysis.

How do I use the Excel financial formulas to calculate present value, future value and discount rates?

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/finance/understanding-excel-formulas-for-financial-analysis-28r

Solution Preview

Pmt- Payment received each period (put - 've sign if you're receiving the payment, +'ve sign if its outflow),
FV- This is the value of the last payment over the annuity. It's -'ve if you're receiving it otherwise +'ve. But this is generally not used.
Type- If you are getting payments at the beginning of each period put 1 and if at the end of each period put 0.

After putting all this just press OK and you will get the result in the selected ...