0207 POWER() vs. Caret Sign ( ^ )

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.21
You save:  د.إ146.92
List Price:  A$190.56
You save:  A$54.45
List Price:  ৳11,884.34
You save:  ৳3,395.77
List Price:  CA$174.66
You save:  CA$49.90
CHF 90.53
List Price:  CHF 126.75
You save:  CHF 36.21
List Price:  kr877.41
You save:  kr250.70
List Price:  €117.96
You save:  €33.70
List Price:  £100.67
You save:  £28.76
List Price:  HK$1,088.02
You save:  HK$310.88
List Price:  ₹10,412.35
You save:  ₹2,975.17
List Price:  RM591.03
You save:  RM168.88
List Price:  ₦57,601.68
You save:  ₦16,458.80
List Price:  kr1,234.29
You save:  kr352.68
List Price:  NZ$200.72
You save:  NZ$57.35
List Price:  ₱6,999.02
You save:  ₱1,999.86
List Price:  ₨22,760.84
You save:  ₨6,503.56
List Price:  S$189.59
You save:  S$54.17
List Price:  ฿4,603.85
You save:  ฿1,315.48
List Price:  ₺1,183.47
You save:  ₺338.16
List Price:  B$729.18
You save:  B$208.35
List Price:  R2,044.87
You save:  R584.29
List Price:  Лв230.80
You save:  Лв65.94
List Price:  ₩161,258.68
You save:  ₩46,077.20
List Price:  ₪451.72
You save:  ₪129.07
Already have an account? Log In


Welcome everybody, this time he talks about a formula or a trick, which allows you to multiply our five into five into five into five using a simple trick. So if you are thinking of multiplying certain number of times, do not apply this old traditional trick where you have to put in the same number a couple of times no other way to give you the answer, but this is rather tedious. Rather than using this trick, I would ask you to put that digit five, put shift six in place that will give the carrot sign which is to the power sign as for Excel, and then put the digit four, so five to the power four is 625. The same thing can also be achieved using a formula although people rarely use this, but they may write the formula power which asks for a number and then asked for the power component that means to the power what four 625 Where is this used?

Quite often in the areas corporate finance and valuation, were compounding discounting annuity all these are very nominal calculations. So in this case, I have certain cash invested in a certain project, let's say today $5,000. The rate of return that I'm expecting is 10%. And I wish to find out that at the end of year one, at the end of year two, or year three, or year four or five, how much money would I be left with if I keep the money invested. So I'm choosing equal to equal to Formula choosing the cell counting $5,000 pressing f4 to ensuring it's fixed, locked, multiplied with within brackets one plus plus what rate of return being 10% I fixed that too. Then Then comes a trick bar to the power to the power one to the power one.

So this is the formula which normally finance professionals do apply for compounding. So at the end of year one 5000, which is the principal plus 10% return return that happens to be 500. all added up and given to you 5500. But then you ask yourself, I wish to keep this money. invested for another year. And let's see how much money would you find at the end of year two. So the same formula if I copy paste the next cell, it says 5500 plus 550.

That happens to be how much 6050. If I copy paste the formula that the cell drag autofill option, or I may simply choose shift Right, right, right and press Ctrl Yes, Ctrl R. So I'm able to find out to this to the power sign that the end of year three or year four or five, how much money would I be left with if I keep the money invested? So that was it to the bar sign

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.