Using Excel to enter pension payout

Q:

I understand you can use an Excel spreadsheet to input pension payout numbers. We are opting for a pension payout that increases over the clients lifetime. During that last 30 years, the performance has averaged 7.59% increases and we used $5, in order to be more conservative. Tim brought up the fact that some years the increase will be zero and he suggested we input each year’s numbers to reflect all returns, rather than use an average. Do you know how we do that?

A:

If you want to do year-by-year annuity payouts, then enter them in excel, and copy and paste them as a rectangle with Description and Annual Value into the Cash Infusions grid.  If you need more than 25 rows you will need to add more rows before you paste.

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk