[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

how to figure (1+0.06) to the 5th

Posted on 2010-09-11
Medium Priority
609 Views
I know this isn't exactly an IT question, but I have to take this freakin financial mgt class on the way to an IT degree.
How do you calculate this
(1+0.06) with a tiny little 5 at the top of the right parentheses?

Thanks
dlewis61
0
Question by:dlewis61
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 5
• 4
• 3
• +2

LVL 27

Expert Comment

ID: 33653635
0

LVL 27

Expert Comment

ID: 33653661

``````This is simple enough to do by hand:

1.06   x 1.06     =  1.1236        ==> Two  factors

1.1236 x 1.1236   =  1.26247696    ==> Four factors

1.06   x 1.1236   =                ==> Five factors
``````
0

LVL 27

Expert Comment

ID: 33653691
>>  (1.06) x (1.06) x (1.06) x (1.06) x (1.06) =  1.33822558

The exact answer will have 10 decimal places.

If you invested \$1M for five years at 6% compounded annually, you would wind up with:

\$1,338,225.58       plus or minus fractions of a cent.
0

Author Comment

ID: 33653707
This is FANTASTIC
but how did you get the 1.06? Listen, I never got basic math skills....I got moved up to geometry etc. before I got all the basics down. I swear I'm not an idiot.

0

LVL 1

Expert Comment

ID: 33653723
(1+0.06)^5 = (1+0.06) * (1+0.06) * (1+0.06) * (1+0.06) * (1+0.06)
Usually it is used in money and interest. For example: if you store USD 1000 to your bank and the bank gives you 6% interest annually, then your money will be USD 1000 * (1+0.06)^5 after 5 years = USD 1000 * (1+0.06) * (1+0.06) * (1+0.06) * (1+0.06) * (1+0.06) = USD 1338.2255776
0

LVL 27

Accepted Solution

d-glitch earned 2000 total points
ID: 33653730
(1+0.06)  really means (1.00 + 0.06), regular decimal addition.

This form: (1 + small value) probably means they want you to think about binomial
expansions and approximations.  Binomial mean two terms: the 1 and the 0.06.

http://en.wikipedia.org/wiki/Binomial_theorem
0

LVL 1

Expert Comment

ID: 33653757
In scientific calculator, x^y means x raised to the yth power. It is usually written x with superscript y.
6^5 means you have to multiply 6 five times (6 * 6 * 6 * 6 * 6)
0

LVL 27

Expert Comment

ID: 33653838
If you were taking a physics course d-glitch would be right. But since our course is in finance it is reasonable to thin the 1+0.06 = 1.06 (which as has been said is multiplied 5 times in your problem.
D-glitche's note is very interesting however (especially from the stand point of physics) His method is very good when dealing with number close to 1, especially when the number of decimal points is limited as they are in some computer programs. As his link showed
(1+0.06)^5 = about 1 + 5*0.06 = 1.3 as has been shown. This proceduer is a binomial expansion and if you want a closer approximation, use more terms in the expansion as d-glitches link shows.
0

LVL 32

Expert Comment

ID: 33654627
If the power is very large (and 5 is not), then there is a faster way to compute the result rather than multiply the base N times. I'll illustrate the idea for N=5:

(1.06)^2 = 1.1236

1.1236^2 = 1.26247696

1.26247696 * 1.06 = 1.3382255776

So the above took 3 multiplies instead of 4. For higher powers, the savings is much more significant.

This works because:

(1.06)^5 = (1.06)^4 * (1.06) = (1.06)^2 * (1.06)^2 * (1.06)

0

Author Comment

ID: 33654899
Thanks folks I have a question

why do you think it is that when I enter (1.1)exp(5) in excel i get 163.2545
I enter 1.1*1.1*1.1*1.1*1.1 into a calculator and I get the correct answer of 1.611?
Is this a rounding issue?
0

LVL 27

Expert Comment

ID: 33655131
I think it is a programing error
0

LVL 1

Expert Comment

ID: 33655595
Please differentiate power (^) with EXP.
If you want to multiple 1.1 five times, you must type =1.1^5 in Excel, so you'll get 1.61051

EXP in Excel is (as copied from Excel 2003 Help):
EXP
Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.

Syntax
EXP(number)
Number    is the exponent applied to the base e.

Remarks
To calculate powers of other bases, use the exponentiation operator (^).
EXP is the inverse of LN, the natural logarithm of number.

So =1.1exp(5) is not =1.1^5
0

Author Comment

ID: 33655602
Thanks Santoso-g!!
0

LVL 32

Expert Comment

ID: 33655683
In excel, if you enter the following in a cell:
=POWER(1.06,5)
the result is:  1.338225578
0

Author Comment

ID: 33658051
Hi folks, thanks for your help. One more thing:

fva35=annual deposit * (FVIFA9%35)

fva35=2100.00 * (215.705)

Note that the '35' after fva is in little numbers to the right and slightly below fva.
The 9% and 35 by FVIFA is the same way.

How was 215.705 obtained?

Thanks
0

Author Comment

ID: 33658052
Hi folks, thanks for your help. One more thing:

fva35=annual deposit * (FVIFA9%35)

fva35=2100.00 * (215.705)

Note that the '35' after fva is in little numbers to the right and slightly below fva.
The 9% and 35 by FVIFA is the same way.

How was 215.705 obtained?

Thanks
0

LVL 27

Expert Comment

ID: 33658494
"How was 215.705 obtained?"
It is hard to tell. You have not said what the FVIFAS (with the 35 is
Did the 35 appear after the FVIF or after FVIF9%?
-
I suspect that the 35 is just an subscript index selecting a specific FVIF and fva.
My guess is the 9% of FVIF35 = 215.706
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Gift cards are not a new concept - it's been around for a very long time.  Undoubtedly, over the past you have received such a card or purchased one for a friend or relative.  Are you aware that you've been feeding the machine?  If not, read on :)
An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
Where to go on the main page to find the job listings. How to apply to a job that you are interested in from the list that is featured on our Careers page.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201â€¦
Suggested Courses
Course of the Month12 days, 13 hours left to enroll