Discount Rate Question
Hi
If I have the NPV of a cash stream calculated with a discount rate of
8%, and the NPV of the same cash stream calculated using 6%, can I
calculate the NPV at 3.5%?
I don't think this is possible (no unique solution) - but I'd be very
interested in members' views. Is there, for example, an 'approximate'
or 'most likely' solution???
Thanks,
Rob
.
Relevant Pages
- RE: Offset function gives different answer in columns v Rows
... NPV function on its own works fine between rows and columns. ... I found that using different discount rates gives a different constant error ... but cannot figure out the correlation between discount rate and the constant. ... I used the Offset function to allow for NPV on different dates. ...
(microsoft.public.excel.worksheet.functions) - RE: Offset function gives different answer in columns v Rows
... NPV is very sensitive to the number of decimal place accuracy of the numbers. ... I found that using different discount rates gives a different constant error ... but cannot figure out the correlation between discount rate and the constant. ... I used the Offset function to allow for NPV on different dates. ...
(microsoft.public.excel.worksheet.functions) - Re: IRR
... what are the two values of discount rate which give ... Can you get IRR to work using these numbers? ... IRR is the rate for which the NPV is zero. ... You could certainly analyze your investment by looking at total outflow vs ...
(microsoft.public.excel.worksheet.functions) - Re: Discount Rate Question
... If I have the NPV of a cash stream calculated with a discount rate of ... 8%, and the NPV of the same cash stream calculated using 6%, can I ... y-axes for the r. ... for a reasonable estimation, you may want more input or have ...
(sci.math) - Re: NPV vs XNPV
... Errata .... ... the same result as the standard NPV calculation?" ... my speculation about the exact daily computation of XNPV ...
(microsoft.public.excel.worksheet.functions) |
|
