Annuities and long-term investments can be complex and difficult to comprehend and calculate. There are many financial aspects to annuities and without a clear understanding of these, making informed decisions can become daunting. That's where Excel's PV function comes in.