My Math Forum  

Go Back   My Math Forum > High School Math Forum > Elementary Math

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


Reply
 
LinkBack Thread Tools Display Modes
December 29th, 2018, 07:19 PM   #1
Member
 
Joined: Oct 2014
From: Mars

Posts: 37
Thanks: 0

Question 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?

Thanks in advance for your help!

Last edited by Apple30; December 29th, 2018 at 08:03 PM.
Apple30 is offline  
 
December 29th, 2018, 07:28 PM   #2
Senior Member
 
romsek's Avatar
 
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.
romsek is online now  
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.
Apple30 is offline  
December 29th, 2018, 08:30 PM   #4
Senior Member
 
romsek's Avatar
 
Joined: Sep 2015
From: USA

Posts: 2,529
Thanks: 1389

Quote:
Originally Posted by Apple30 View Post
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$
romsek is online now  
December 29th, 2018, 09:27 PM   #5
Member
 
Joined: Oct 2014
From: Mars

Posts: 37
Thanks: 0

Thanks Romsek!!

I got it to work!
Apple30 is offline  
Reply

  My Math Forum > High School Math Forum > Elementary Math

Tags
calculate, excel, interest, power, year



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate: (i) his average weekly sales during the year. Chikis Elementary Math 2 October 17th, 2014 07:41 PM
Calculate interest p99410 Algebra 5 February 23rd, 2014 10:06 PM
Simple Interest: How to find the actual interest rate? grace25 Elementary Math 12 January 24th, 2013 08:46 PM
Calculate interest on loan macfable Economics 3 April 28th, 2011 11:17 AM
Calculate interest rate based on interest in parcels douglasrac Economics 0 February 17th, 2011 09:14 AM





Copyright © 2019 My Math Forum. All rights reserved.