Purchase Solution

Finance Questions: NPV and IRR, Payback, calculate the NPVs for 2 projects, Profitability Index and more...

Not what you're looking for?

Ask Custom Question

(See attached file for full problem description)

---
Problem 7-9
NPV and IRR. A project that costs $3,000 to install will provide annual cash flows of $800 for each of the next 6 years.
Is this project worth pursuing if the discount rate is 10 percent?
Project NPV

How high can the discount rate be before you would reject the project?
Maximum Project Rate

Problem 7-10
Payback. A project that costs $2,500 to install will provide annual cash flows of $600 for the
next 6 years. The firm accepts projects with payback periods of less than 5 years.

Will the project be accepted?
Project payback period

Should this project be pursued if the discount rate is 2 percent?
NPV of Project at 2%

What if the discount rate is 12 percent?
NPV of Project at 12%

Will the firm's decision change as the discount rate changes?

Problem 7-19
Here are the cash flows for two mutually exclusive projects:

Project C0 C1 C2 C3
A ($20,000) $8,000 $8,000 $8,000
B ($20,000) 0 0 $25,000

Use the MS Excel NPV function to calculate the NPVs for both projects in the profile below. In part B use the IRR function.
a. At what interest rates would you prefer project A to B?
NPV Profile
Discount
Rate NPVA NPVB
0% FORMULA FORMULA
2% FORMULA FORMULA
4% FORMULA FORMULA
6% FORMULA FORMULA
8% FORMULA FORMULA
10% FORMULA FORMULA
12% FORMULA FORMULA
14% FORMULA FORMULA
16% FORMULA FORMULA
18% FORMULA FORMULA
20% FORMULA FORMULA

b. What is the IRR of each project?

Project A IRR
Project B IRR

Problem 7-23
Profitability Index. Consider the following projects:
Project C0 C1 C2
A (2,100.00) 2,000.00 1,200.00
B (2,100.00) 1,440.00 1,728.00

a. Calculate the profitability index for A and B assuming a 22 percent opportunity cost of capital.
Project A NPV
Project B NPV

Project A Profitability Index
Project B Profitability Index

b. Use the profitability index rule to determine which project(s) you should accept (i) if you
could undertake both and (ii) if you could undertake only one.
---

Purchase this Solution

Solution Summary

You will find the answer to this puzzling question inside...

Purchase this Solution


Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media