Basic Maths

Simple question, I think.

Suppose clients fee was £650 20 years ago, and practice inflation is 4%.

My naive assumption was this was 650*0.04^20 in excel.  But its seems not, as I get 7.146825580544E-26 - oops!

Sure I can do it the long way over 20 rows and 2 columns and arrive at £1,369, but there must be a more elegant way.

 

 

 

Comments
There are 78 comments. Login or register to view them.

=650*(1+4%)^20 

mrme89 |
mrme89's picture

=650*1.04^19

19james88 |

^ This

Constantly Confused |
Constantly Confused's picture

Polynomial expansion

mikewhit |

Err NO

Chris Smail |
Chris Smail's picture

Bonkers maths

andrew.hyde |

That one has whiskers on it

Chris Smail |
Chris Smail's picture

It may have whiskers

paulwakefield1 |

Another useful approximation is

paulwakefield1 |

Hmm

Constantly Confused |
Constantly Confused's picture

Is it...

Constantly Confused |
Constantly Confused's picture

It's because

paulwakefield1 |

But

Constantly Confused |
Constantly Confused's picture

@CC

George Attazder |
George Attazder's picture

And I thought you lot were numerate

Chris Smail |
Chris Smail's picture

Oh well...

George Attazder |
George Attazder's picture

Anything divided by zero is

Triggle |

How about

George Attazder |
George Attazder's picture

@Triggle

George Attazder |
George Attazder's picture

@George

paulwakefield1 |

No the result is in fact any

Triggle |

You can't prove...

George Attazder |
George Attazder's picture

They do

paulwakefield1 |

Any number divided by zero is

Triggle |

The answer is ...

BKD |
BKD's picture

Surely

Pottedbeef |
Pottedbeef's picture

What is infinity?

BKD |
BKD's picture

Just realised an error...

George Attazder |
George Attazder's picture

Let's assume that ...

BKD |
BKD's picture

Divide by zero

mikewhit |

BKD

Pottedbeef |
Pottedbeef's picture

Also

Pottedbeef |
Pottedbeef's picture

Proof

BKD |
BKD's picture

!

Constantly Confused |
Constantly Confused's picture

Linear analysis

neileg |

I'm with BKD

kdauda |
kdauda's picture

Moving on ...

BKD |
BKD's picture

1/0 = Infinity

paras007 |

No, no, no BKD (and others)

George Attazder |
George Attazder's picture

Or ...

BKD |
BKD's picture

No BKD

George Attazder |
George Attazder's picture

:)

Constantly Confused |
Constantly Confused's picture

Constantly Confused |
Constantly Confused's picture

'Real' world

kdauda |
kdauda's picture

The square root of -1?

Triggle |

No, no ,no, no George

BKD |
BKD's picture

Exactly, George

BKD |
BKD's picture

It's not my fault...

George Attazder |
George Attazder's picture

Gosh

mwngiol |
mwngiol's picture

Now we're getting somewhere

BKD |
BKD's picture