Guest mouellette Posted March 4, 2005 Posted March 4, 2005 I have a DOL Audit correction that requires us to calculate a weighted average rate of return for Deferral deposits made on a weekly basis. Does anyone have a spreadsheet set up for this or know how I would create the formula in Excel?
stevena Posted March 4, 2005 Posted March 4, 2005 why dont you do it as a percentage of the year. 52 weeks... earnings for the year is "x" week 3 of the year would be +def/(3/52*x) i think this would work.... bummer you have to do this though.
Basically Posted March 4, 2005 Posted March 4, 2005 I am no Excel SS expert... I have seen a ton of formulas on spreadsheets where the formula starts with a +... what is the significance of the +? (sorry to interrupt the post)
stevena Posted March 4, 2005 Posted March 4, 2005 those of us who have dinosaur excel. the formulas have to have =+ at the beginning.
Basically Posted March 4, 2005 Posted March 4, 2005 oh... so it is simply a software issue... and for those who learned the old "original" way simply still use the + out of habit. Thanks
Basically Posted March 4, 2005 Posted March 4, 2005 Goodness no.... you could have been taught by someone who learned that way..... Sheesh, I need to watch my wording
stevena Posted March 4, 2005 Posted March 4, 2005 im getting silly...its friday and i have only 3 more tests to do out of 80...lots of late nights and i am overtired. and its so darn cold outside, i have had it with this snow. see, i am rambling.... three more, three more......
Guest mouellette Posted March 4, 2005 Posted March 4, 2005 Thanks stevena. I think your formula will work for us.
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