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))
The formula in output cell B5: =POWER(1+B4,12)-1
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:
- Critical BenefitsPRO information including cutting edge post-reform success strategies, access to educational webcasts and videos, resources from industry leaders, and informative Newsletters.
- Exclusive discounts on ALM, BenefitsPRO magazine and BenefitsPRO.com events
- Access to other award-winning ALM websites including ThinkAdvisor.com and Law.com
Already have an account? Sign In
© 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.