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))

Complete your profile to continue reading and get FREE access to BenefitsPRO, part of your ALM digital membership.

Your access to unlimited BenefitsPRO content isn’t changing.
Once you are an ALM digital member, you’ll receive:

  • 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
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.