It is really very easy to calculate using an Excel sheet.
The explanations are as follows:
(1) PRESENT VALUE:
Open a new Excel sheet and click on Insert on the Menu Bar. Then click on fx Function, a window would appear click on Financial in function category and select PV from the Function name and click OK. You will see a window that asks for- Rate, Nper, Pmt, Fv and Type.
In Rate- put the discount rate,
Nper-Number of annuity ...
The solution does a very job of explaining exactly how to use several of the financial functions in Excel: PV, FV, and IRR