Hi, I need a formula to calculate a daily compound interest rate where I know the initial value and the present value. For example, if in a week an investment increased by 30% (let's say $100 becomes $130), how would I display the daily compound interest, ie by what percent did it increase each day over 7 compound periods?
I've tried using the NOMINAL function but can't get a sensible result.
Most grateful for any help!
I've tried using the NOMINAL function but can't get a sensible result.
Most grateful for any help!