My Math Forum How to calculate interest % per year? (using POWER in EXCEL)

 Elementary Math Fractions, Percentages, Word Problems, Equations, Inequations, Factorization, Expansion

December 29th, 2018, 07:19 PM   #1
Member

Joined: Oct 2014
From: Mars

Posts: 37
Thanks: 0

How to calculate interest % per year? (using POWER in EXCEL)

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

Quote:
 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
So, that means the INTEREST (%) per YEAR should be 100% (as the profit is 100% what was deposited).

But how do I plug these variables into the POWER(number, power) function in excel to get the same answer?

Last edited by Apple30; December 29th, 2018 at 08:03 PM.

 December 29th, 2018, 07:28 PM #2 Senior Member     Joined: Sep 2015 From: USA Posts: 2,529 Thanks: 1389 assuming interest accrues annually $P_V = P_I(1+r)^n$ $Profit = P_V - P_I = P_I((1+r)^n -1)$ $P_V \text{ is current value of the account}$ $P_I \text{ is the original investment}$ $r \text{ is the annual interest rate}$ $n \text{ is the number of years in the investment}$ in excel terms $Profit = P_I(POWER(1+r,n)-1)$ where you've either named certain cells $P_I,~r~,n$ or you use the cell addresses in the formula above.
 December 29th, 2018, 07:49 PM #3 Member   Joined: Oct 2014 From: Mars Posts: 37 Thanks: 0 Sorry, I don't quite understand. R is "the annual interest rate", but I don't know what it is, that's what I'm trying to figure out. I only know the number of days, initial deposit, and return.
December 29th, 2018, 08:30 PM   #4
Senior Member

Joined: Sep 2015
From: USA

Posts: 2,529
Thanks: 1389

Quote:
 Originally Posted by Apple30 Sorry, I don't quite understand. R is "the annual interest rate", but I don't know what it is, that's what I'm trying to figure out. I only know the number of days, initial deposit, and return.
right...
btw, your mistakenly assumed a rate of 100% in your first post.
The actual rate is 200%.

$P_V$ is what you're calling the return
$P_I$ is what you're calling the deposit
$n$ is the length of the investing in years

$P_V = P_I (1+r)^n$

$r = \left(\dfrac{P_V}{P_I}\right)^{1/n} - 1$

$r = POWER(P_V/P_I,1/n)-1$

 December 29th, 2018, 09:27 PM #5 Member   Joined: Oct 2014 From: Mars Posts: 37 Thanks: 0 Thanks Romsek!! I got it to work!

 Tags calculate, excel, interest, power, year

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post Chikis Elementary Math 2 October 17th, 2014 07:41 PM p99410 Algebra 5 February 23rd, 2014 10:06 PM grace25 Elementary Math 12 January 24th, 2013 08:46 PM macfable Economics 3 April 28th, 2011 11:17 AM douglasrac Economics 0 February 17th, 2011 09:14 AM

 Contact - Home - Forums - Cryptocurrency Forum - Top