Here's a small Excel spreadsheet you can create to convert any single-premium annuity payout into an equivalent annual interest rate. (Boldface cells are for input.)
| A | B | |
| 1 | Premium | $100,000 |
| 2 | Mo. Payment | $712.50 |
| 3 | Period in Years | 18.16 |
| 4 | Monthly Rate | 0.34% |
| 5 | Annual Rate | 4.10% |
The formula to enter in output cell B4: =RATE((B3*12),B2,-B1))
Continue Reading for Free
Register and gain access to:
- Breaking benefits news and analysis, on-site and via our newsletters and custom alerts
- Educational webcasts, white papers, and ebooks from industry thought leaders
- Critical converage of the property casualty insurance and financial advisory markets on our other ALM sites, PropertyCasualty360 and ThinkAdvisor
Already have an account? Sign In Now
NOT FOR REPRINT
© 2024 ALM Global, LLC, All Rights Reserved. Request academic re-use from www.copyright.com. All other uses, submit a request to [email protected]. For more information visit Asset & Logo Licensing.
