Forum Archive Index - July 2001

["Alan Shaw" <alan.shaw@clear.net.nz>]

If I understand what you're saying correctly you need to put ^ in front of
the t. That will give you (WACC+1)^t.

Hope this helps

Alan


----- Original Message -----
From: Philip Robinson <robph639@student.otago.ac.nz>
To: <sharechat@sharechat.co.nz>
Sent: Thursday, July 12, 2001 10:06 PM
Subject: [sharechat] Calling all Excell Gurus


>
>
> Hey any of you Excell gurus out there, I want to
>
> do this equation
>
> MVA = Sum EVAt / (WACC +1)t
> That last t goes to the power of the brackets
> and the Sum is one of those roman numerals big E thing which I can't put
in
> an e-mail.
>
> Which I try to use NPV in Excell and I can put in the WACC as rate and the
> EVA, but cannot find the t to put into the forumula.
>
> Am I using the wrong excell formula or is there something I am not
getting?
>
> ANY help would be much appreciated.
>
> Cheers
> Phil
>
>
> _______________________________________
> Philip Robinson
> Wellington School of Medicine
> University of Otago
>
>
> --------------------------------------------------------------------------
--
> http://www.sharechat.co.nz/          New Zealand's home for market
investors
> --------------------------------------------------------------------------
--
> To remove yourself from this list, please use the form at
> http://www.sharechat.co.nz/forum.shtml.
>


----------------------------------------------------------------------------
http://www.sharechat.co.nz/          New Zealand's home for market investors
----------------------------------------------------------------------------
To remove yourself from this list, please use the form at
http://www.sharechat.co.nz/forum.shtml.