Question
In: Statistics and Probability
A company has to choose between two new machines, the Alpha and the Beta. Both machines...
A company has to choose between two new machines, the Alpha and the Beta. Both machines would cost $30 000 and have an expected lifetime of 4 years. Estimates of the
annual cash inflows which each machine would generate are given below
|
Machine |
Year |
0 |
1 |
2 |
3 |
4 |
|
Alpha |
Cash flow |
-$30,000 |
$14,000 |
$15,000 |
$15,000 |
$14,000 |
|
Beta |
Cash flow |
-$30,000 |
$8,000 |
$13,000 |
$15,000 |
$21,500 |
The company staff decides that 12% is an appropriate discount rate.
- Find the net present value (NPV) of both projects.
- Which project would you invest in? What does your answer depend on?
Solutions
Expert Solution
a)
NPV is calculated as follows
PV = cash flow / (1 + r)ⁿ
Setting this in Excel
| Rate | 0.12 | ||||
| Machine | Alpha | Beta | |||
| Year | Cash flow | Present Value | Cash flow | Presenet Value | |
| 0 | ($30,000) | ($30,000) | ($30,000) | ($30,000) | |
| 1 | $14,000 | $12,500.00 | $8,000 | $7,142.86 | |
| 2 | $15,000 | $11,957.91 | $13,000 | $10,363.52 | |
| 3 | $15,000 | $10,676.70 | $15,000 | $10,676.70 | |
| 4 | $14,000 | $8,897.25 | $21,500 | $13,663.64 | |
| Net Present Value | $14,032 | $11,847 |
Excel sheet is
and the formula applied is
So, the NPV of alpha = $14,031.86
and NPV of Beta = $11,846.72
b)
I would invest in Project alpha as the NPV of alpha is greater than that of Beta
orchestra answered 1 year agoRelated Solutions
The Borstal Company has to choose between two machines that do the same job but have...
The Borstal Company has to choose between two machines that do
the same job but have different lives. The two machines have the
following costs:
Year
Machine A
Machine B
0
$47,000
$57,000
1
11,400
10,800
2
11,400
10,800
3
11,400
+ replace
10,800
4
10,800
+ replace
These costs are expressed in real terms. Suppose that technological
change is expected to reduce costs by 10% per year. There will be
new machines in year 1 that cost 10% less...
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated...
Alpha and Beta are
divisions within the same company. The managers of both divisions
are evaluated based on their own division’s return on investment
(ROI). Assume the following information relative to the two
divisions:
Case
1
2
3
4
Alpha
Division:
Capacity in
units
53,000
302,000
108,000
206,000
Number of units
now being sold to
outside customers
53,000
302,000
84,000
206,000
Selling price
per unit to outside
customers
$
97
$
42
$
67
$
45
Variable costs
per unit...
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated...
Alpha and Beta are divisions within the same company. The
managers of both divisions are evaluated based on their own
division’s return on investment (ROI). Assume the following
information relative to the two divisions: Case 1 2 3 4 Alpha
Division: Capacity in units 57,000 291,000 101,000 200,000 Number
of units now being sold to outside customers 57,000 291,000 75,000
200,000 Selling price per unit to outside customers $103 $40 $62
$48 Variable costs per unit $65 $21 $39 $32...
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated...
Alpha and Beta are divisions within the same company. The
managers of both divisions are evaluated based on their own
division’s return on investment (ROI). Assume the following
information relative to the two divisions:
Case
1
2
3
4
Alpha Division:
Capacity in units
51,000
298,000
109,000
195,000
Number of units now being sold to
outside customers
51,000
298,000
84,000
195,000
Selling price per unit to outside
customers
$
99
$
42
$
70
$
47
Variable costs per unit...
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated...
Alpha and Beta are divisions within the same company. The
managers of both divisions are evaluated based on their own
division’s return on investment (ROI). Assume the following
information relative to the two divisions:
Case
1
2
3
4
Alpha Division:
Capacity in units
58,000
284,000
106,000
191,000
Number of units now being sold to
outside customers
58,000
284,000
82,000
191,000
Selling price per unit to outside
customers
$
97
$
45
$
65
$
45
Variable costs per unit...
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated...
Alpha and Beta are divisions within the same company. The
managers of both divisions are evaluated based on their own
division’s return on investment (ROI). Assume the following
information relative to the two divisions:
Case
1
2
3
4
Alpha Division:
Capacity in units
57,000
319,000
109,000
205,000
Number of units now being sold to
outside customers
57,000
319,000
84,000
205,000
Selling price per unit to outside
customers
$
103
$
43
$
68
$
45
Variable costs per unit...
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated...
Alpha and Beta are divisions within the same company. The
managers of both divisions are evaluated based on their own
division’s return on investment (ROI). Assume the following
information relative to the two divisions:
Case
1
2
3
4
Alpha Division:
Capacity in units
53,000
282,000
105,000
200,000
Number of units now being sold to
outside customers
53,000
282,000
80,000
200,000
Selling price per unit to outside
customers
$
104
$
44
$
69
$
45
Variable costs per unit...
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated...
Alpha and Beta are divisions within the same company. The
managers of both divisions are evaluated based on their own
division’s return on investment (ROI). Assume the following
information relative to the two divisions:
Case
1
2
3
4
Alpha Division:
Capacity in units
55,000
291,000
109,000
204,000
Number of units now being sold to
outside customers
55,000
291,000
84,000
204,000
Selling price per unit to outside
customers
$
102
$
40
$
62
$
47
Variable costs per unit...
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated...
Alpha and Beta are divisions within the same company. The
managers of both divisions are evaluated based on their own
division’s return on investment (ROI). Assume the following
information relative to the two divisions:
Case
1
2
3
4
Alpha Division:
Capacity in units
50,000
284,000
103,000
192,000
Number of units now being sold to
outside customers
50,000
284,000
80,000
192,000
Selling price per unit to outside
customers
$
98
$
39
$
62
$
45
Variable costs per unit...
Alpha and Beta are divisions within the same company. The managers of both divisions are evaluated...
Alpha and Beta are divisions within the same company. The
managers of both divisions are evaluated based on their own
division’s return on investment (ROI). Assume the following
information relative to the two divisions:
Case
1
2
3
4
Alpha Division:
Capacity in units
54,000
295,000
102,000
198,000
Number of units now being sold
to
outside customers
54,000
295,000
77,000
198,000
Selling price per unit to
outside
customers
$
98
$
39
$
65
$
46
Variable costs per unit...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- (1) What are some pitfalls in writing an RFP? What information should be provided as part...
- You are creating an enhanced entity relationship model for a campus information system. A junior team...
- 1.-Evolving into Multinationalism. As a firm evolves from purely domestic into a true multinational enterprise, it...
- A guidance counselor claims that high school students in a college preparation program have higher ACT...
- As a supervisor of a production department, you must decide the daily production totals of a...
- how can a virus encode a protein larger than the size of its genome?
- Please provided detail answers: What are Personal Health Records (PHRs)? What data is captured in Personal...
ADVERTISEMENT