BG5150 Posted January 8, 2016 Posted January 8, 2016 Does anyone have a good earning calculation worksheet? The one I'm using if definitely faulty, as it is showing me a greater loss than what the account earned over the year. For example, I have 100 loss in the account, but the spreadsheet is using 106 loss overall. I used to have a good one in a previous job, that that has been lost to posterity. QKA, QPA, CPC, ERPATwo wrongs don't make a right, but three rights make a left.
BG5150 Posted February 3, 2016 Author Posted February 3, 2016 Let me put this another way. I need to do corrections to some accounts and using actual earnings is not reasonable. Does anyone have a spreadsheet rubric to make a reasonable effort to calculate the earnings? I have developed a formula using the excess contribution earnings calculator from the IRS Pub. 590. Does anyone have anything different? Or better? QKA, QPA, CPC, ERPATwo wrongs don't make a right, but three rights make a left.
Bird Posted February 3, 2016 Posted February 3, 2016 Earnings should be Ending balance + withdrawals - deposits - beginning balance. But that will give you actual earnings, so I'm still confused about why "using actual earnings is not reasonable." Maybe I'm still missing something. Ed Snyder
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now