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.
K-t-F 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) Its not easy being green
stevena Posted March 4, 2005 Posted March 4, 2005 those of us who have dinosaur excel. the formulas have to have =+ at the beginning.
K-t-F 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 Its not easy being green
K-t-F 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 Its not easy being green
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