I have a spreadsheet that I track daily balances of a fund and also the interest earnings on the fund.
I'd like to have data that I can report the weighted average balance for various time frames (see attached, column F is balance for the day) and also what the weighted average daily rate is for a period (also or instead would like this to be annualized).
I think our daily rates are truncated after 10 decimals as I don't get the exact same interest calculation using daily balance * daily rate (F*H). GeFONSI-History--Experts-Exchange-.xlsx
Can someone help me do this best (efficiently that's low maintenance to update as it's updated each month). Thank you!