Question

1. Net present value (NPV)

Evaluating cash flows with the NPV method

The net present value (NPV) rule is considered one of the most common and preferred criteria that generally lead to good investment decisions.

Consider this case:

Suppose Lumbering Ox Truckmakers is evaluating a proposed capital budgeting project (project Beta) that will require an initial investment of $3,000,000. The project is expected to generate the following net cash flows:

Year	Cash Flow
Year 1	$375,000
Year 2	$400,000
Year 3	$425,000
Year 4	$500,000

Lumbering Ox Truckmakers’s weighted average cost of capital is 8%, and project Beta has the same risk as the firm’s average project. Based on the cash flows, what is project Beta’s NPV?

-$1,104,949

-$1,604,949

-$1,204,949

-$1,229,949

Making the accept or reject decision

Lumbering Ox Truckmakers’s decision to accept or reject project Beta is independent of its decisions on other projects. If the firm follows the NPV method, it should   project Beta.

Suppose your boss has asked you to analyze two mutually exclusive projects—project A and project B. Both projects require the same investment amount, and the sum of cash inflows of Project A is larger than the sum of cash inflows of project B. A coworker told you that you don’t need to do an NPV analysis of the projects because you already know that project A will have a larger NPV than project B. Do you agree with your coworker’s statement?

Yes, project A will always have the largest NPV, because its cash inflows are greater than project B’s cash inflows.

No, the NPV calculation will take into account not only the projects’ cash inflows but also the timing of cash inflows and outflows. Consequently, project B could have a larger NPV than project A, even though project A has larger cash inflows.

No, the NPV calculation is based on percentage returns, so the size of a project’s cash flows does not affect a project’s NPV.

Answer 1

1: -$1,604,949

2: No, the NPV calculation will take into account not only the projects’ cash inflows but also the timing of cash inflows and outflows. Consequently, project B could have a larger NPV than project A, even though project A has larger cash inflows.

The NPV will be higher if the cash flows of one project are received earlier than the other project.

Workings

Book1 - Excel - x Comments Help O Tell me what you want to do AutoSave of HD- File Home Insert Draw Page Layout Calibri - 11 - A À = BI U - 9 - - A - Formulas = = gone E Sign in FF Share I. A Data Review View alle General 3- $ - % , O Insert 2X Delete Format Paste de Conditional Format as Formatting Table Cell Styles Sort & Find & Filter - Select Clipboard Font Alignment Number Styles Cells Editing P8 - : * fi K. м N Year Cash Flow -3000000 375000 400000 - am to co 425000 500000 NPV =NPV(8%,N3:N6)+N2 12 13