Purchase Solution

NPV and IRR

Not what you're looking for?

Ask Custom Question

A project has the following cash flows:

Year Cash Flow

0 $65,200
1 -31,200
2 -49,100

Required:

(a)What is the IRR for this project? (Do not include the percent sign (%). Round your answer to 2 decimal places, e.g. 32.16.)

IRR ___?____ percent

(b)

(i)What is the NPV of this project, if the required return is 10 percent? (Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places, e.g. 32.16.)

NPV $__?___

(ii)Should the firm accept the project?
Yes? ______
or
No? ______

(c)What is the NPV of the project if the required return is 0 and 20 percent? (Negative amount should be indicated by a minus sign. Round your answers to 2 decimal places, e.g. 32.16.)

NPV at 0 percent $ ____?____

NPV at 20 percent $ ____?____

Purchase this Solution

Solution Summary

Calculates NPV and IRR of projects.

Solution Preview

Please see attached file

A project has the following cash flows:

Year       Cash Flow

0          $65,200
1          -31,200
2          -49,100

Required:

(a)What is the IRR for this project? (Do not include the percent sign (%). Round your answer to 2 decimal places, e.g. 32.16.)

IRR _13.94__ percent

IRR (Internal Rate of Return)

IRR (Internal rate of return) is calculated using Excel function IRR

Year Cash flow

0 $65,200
1 ($31,200)
2 ($49,100)
IRR= 13.94%

We can check whether the answer is correct by discounting the cash flow at IRR rate, NPV then should be zero

Year Cash flow Discount ...

Purchase this Solution


Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.