Google Answers Logo
View Question
 
Q: financial accounting ( Answered 4 out of 5 stars,   0 Comments )
Question  
Subject: financial accounting
Category: Business and Money > Accounting
Asked by: k9queen-ga
List Price: $10.00
Posted: 03 Feb 2003 12:29 PST
Expires: 05 Mar 2003 12:29 PST
Question ID: 156829
Please calculate the NPV, PI and IRR for the following project:
The initial cash outlay is $50,000.  The required rate of return is 12 percent.
The expected annual free cash flow from the project are as follows:

year   
0      -$50,000
1       12,000
2       12,000
3       12,000
4       12,000
5       12,000
6       12,000
Answer  
Subject: Re: financial accounting
Answered By: omnivorous-ga on 03 Feb 2003 13:30 PST
Rated:4 out of 5 stars
 
K9Queen –

NPV (net present value) = PV net cash flows – net cash invested
PV net cash flows are calculated:  NCF(year t)/(1+r)^t ; where t is
the number of complete years and r is the cost of capital.  NCF is the
net cash flow.

NPV Calculation:
-----------------------

Year     Net Cash Flow
O . . . .  –$50,000
1  . . . .  $10,714 = $12,000/1.1200
2  . . . .  $  9,566 = $12,000/1.2544 
3  . . . .  $  8,542 = $12,000/1.4049
4  . . . .  $  7,626 = $12,000/1.5735
5  . . . .  $  6,809 = $12,000/1.7623
6  . . . .  $  6,080 = $12,000/1.9738


NPV = -$663

This project wouldn't have a positive net present value until a 7th
year of free cash flow, assuming a 12% cost of capital.  This also
tells us that the internal rate of return will be slightly less than
12%.


IRR Calculation:
-----------------

IRR is the cost of capital r where:
NCF(year t)/(1+r)^t = net cash invested

This calculation is usually done with a financial calculator or Excel
spreadsheet because it's a six-year series depending on choosing the
right value of r, your cost-of-capital.  (If I had to guess, I'd run
back through the calculations above using 11.9% to see how much closer
0.1% gets to a $0 NPV.)

In this case 11.53% is the IRR.


PI Calculation:
--------------------

PI (profitability index) = present value net cash flows / net
investment

Here you're looking for a value higher than 1 to allow you to give a
project the go-ahead.  But our profitability index is:
$49,337/$50,000 = 0.9867


Here's an excellent presentation outlining not just the mathematical
definitions of these financial accounting terms but their advantages
and limitations:
University of Houston, Bauer School of Business
"Capital Budgeting" (2003)
http://www.bauer.uh.edu/~csheh/Lecture%208.ppt


Google search strategy:
NPV + IRR + PI


If any part of this answer is confusing, please let us know via a
clarification request before rating the answer.

Best regards,

Omnivorous-GA
k9queen-ga rated this answer:4 out of 5 stars and gave an additional tip of: $4.00
Very clear and thorough!
Thank you for all the explanations!

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy