I'm trying to calculate the interest per year in MS Excel using the POWER() function, but don't quite understand how to calculate it.

Sorry the forum is formatting my writing strangely...

Lets say I have

But how do I plug these variables into the POWER(

Thanks in advance for your help!

Sorry the forum is formatting my writing strangely...

Lets say I have

So, that means the INTEREST (%) per YEAR should be 100% (as the profit is 100% what was deposited).DEPOSIT : ONE DOLLAR , initially invested

RETURN : THREE DOLLARS , the total amount returned

PROFIT : TWO DOLLARS , RETURN - DEPOSIT

DAYS : 365 , the number of days the investment lasted

But how do I plug these variables into the POWER(

*number*,*power*) function in excel to get the same answer? :unsure:Thanks in advance for your help!

Last edited: