homepage Welcome to WebmasterWorld Guest from 54.227.25.58
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
Home / Forums Index / Local / Foo
Forum Library, Charter, Moderators: incrediBILL & lawman

Foo Forum

    
Accounting Help
Npv
Acternaweb




msg:301628
 9:35 pm on Jul 14, 2003 (gmt 0)

I know this is not web related, but does anyone know how to figure out the Net Present Value
given the Cost of Capital and discount rate?

Thanks

 

bakedjake




msg:301629
 9:39 pm on Jul 14, 2003 (gmt 0)

Search for "how to compute net present value" on Google. The first result is from CCH, and contains tables that will guide you.

jeremy goodrich




msg:301630
 10:52 pm on Jul 14, 2003 (gmt 0)

How's the degree going? College is out for a friend of mine getting her master's in Economics, but I guess you're in summer school?

Hope they go well. Seems that equation is pretty famous (I don't have any business books from my college days left, I'm afraid) but it should be easy enough to find.

Is there a particular aspect of NPV calculations that are stumping you, or perhaps some trouble with where to plug in which value?

bakedjake




msg:301631
 10:57 pm on Jul 14, 2003 (gmt 0)

Re-reading my post makes it sound short. It wasn't intended that way. :)

I just mentioned CCH and their tools because I use them frequently, and they're very good at providing explainations and easy to use tools. I told you to do the Google search because I'm not sure (yet) where you can and can't post URLs on WW, so I err on the cautious side. :)

HTH.

Acternaweb




msg:301632
 12:47 pm on Jul 15, 2003 (gmt 0)

It sucks... I am in a e-commerece grad program and the teacher is an accouting/finance professor. He thinks everyone knows and wants to know this stuff.

The problem is there isn't a text book that goes along with the class. Well technically there is, but the text book is for cases.

Thanks for the help, will let you know what I find out.

pearl




msg:301633
 1:11 pm on Jul 15, 2003 (gmt 0)

I can do this in 5 words.

Excel, Insert Function, Financial, NPV.

Acternaweb




msg:301634
 1:33 pm on Jul 15, 2003 (gmt 0)

Thanks Pearl,

I tried that, but not sure it worked right.
Here is what I have:
cash flow for 0-3 (-2,-1, 8,4 million)
cost of capital (15%)
discount rate (25%)

How do I use the function for that?

edit_g




msg:301635
 1:37 pm on Jul 15, 2003 (gmt 0)

I am in a e-commerece grad program and the teacher is an accouting/finance professor. He thinks everyone knows and wants to know this stuff.

Everyone should want to know it!

If you're planning on making any money or managing any budgets in your ecommerce career then working out things like NPV will be very useful indeed. Just because you're focusing on ecommerce doesn't mean that you shouldn't know how a business works - it means that you should take care to learn this even more!

Acternaweb




msg:301636
 1:44 pm on Jul 15, 2003 (gmt 0)

I understand the basics of NPV, but can't find a forumla that I understand to determine this problem.

edit_g




msg:301637
 1:48 pm on Jul 15, 2003 (gmt 0)

Hope this helps:

http:**//www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=%22npv+formula%22

Try the third one down or one of the adwords.

Acternaweb




msg:301638
 2:05 pm on Jul 15, 2003 (gmt 0)

Thanks but none of that is helping. None of that takes into account finding the NPV knowing the cost of capital and the discount rate.

Markus




msg:301639
 2:18 pm on Jul 15, 2003 (gmt 0)

Is it possible that it is some kind of a trick question? IMO, the discount rate is based on the cost of capital and comprises some other factors like inflation. If this is the case, then you can simply ignore the capital cost.

If the discount rate does not comprise the cost of capital, you need a "nominal" discount rate. This should be (1 + 0.15)(1 + 0.25) - 1.

Anyway, it's a long time since I've been at uni and, so, I probably don't know what I'm talking about. :)

Acternaweb




msg:301640
 2:21 pm on Jul 15, 2003 (gmt 0)

Thanks

I used the Excel function and came up with
$3,494,400.00

Looks good enough for me. Spent too long on this one. Have many more to get to.

Thanks for all your help. I am sure I will be back

ShawnR




msg:301641
 2:21 pm on Jul 15, 2003 (gmt 0)

I think what is stumping you is that your prof has given you discount rate and cost of capital. One of them is irrelevant. The terms 'discount rate', 'hurdle rate', 'opportunity cost of capital' are all equivalent, so your discount rate is equal to your cost of capital. 'Your' in bold, because the rate depends on how risky the investment/project is; there is no such thing as the rate.

So you need to choose which of the given rates to use. Figure out which is based on the closest equivalent investment. e.g. Say the discount rate given is for property investments and the cost of capital given is an IT company's internal weighted average cost of capital. Then choose the discount rate if the project you are trying to calulate the value of is a building project, but choose the cost of capital if it is an IT project. Does that make sense?

The formula is really simple; you don't need Excel, and you should figure out how to do it the long way. I think I will show an explicit formula here, because even after bakedjake's post (msg #2) you still seem to be having trouble...

For 4 time periods:

C0 + C1/(1+r) + C2/(1+r)^2 + C3/(1+r)^3

Shawn

[added... Damn, I'm too late on the submit button. Markus got there first

It will depend on which discount rate you ended up using, but my guess is something closer to $8M, not $3M
]

Acternaweb




msg:301642
 2:34 pm on Jul 15, 2003 (gmt 0)

So it would be something like:

-2 + -1/(1+.25) + 8/(1+.25)+ 4/(1+.25)=6.8?

numbers are simplified.

ShawnR




msg:301643
 2:52 pm on Jul 15, 2003 (gmt 0)

No, more like:

-2 + -1/(1+.25) + 8/[(1+.25)*(1+.25)]+ 4/[(1+.25)*(1+.25)*(1+.25)]
= -2 + -1/1.25 + 8/1.56 + 4/1.95

(assuming 25% is the correct rate to use)

Acternaweb




msg:301644
 3:17 pm on Jul 15, 2003 (gmt 0)

AHHH I see the light, or so I think.
I believe 25% is correct since it is the discount rate.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Local / Foo
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved