A company is considering a $240,000 investment in machinery with the following net cash flows. The company requires a 9% return on its investments. Initial investment Required rate of return Required: $240,000 9% (a) Compute the net present value of this investment. Present Value of Net Period 1 Net Cash Flows Cash Flows $53,000 $48,624 20 49,000 41,242 3 136,000 105,017 4 78,000 55,257 5 61,000 39,646 Totals $377,000 $289,786 (240,000) $49,786 Initial investment Net present value Verify the value of cell C18 using the NPV function (b) Should the machinery be purchased? Yes
A company is considering a $240,000 investment in machinery with the following net cash flows. The company requires a 9% return on its investments. Initial investment Required rate of return Required: $240,000 9% (a) Compute the net present value of this investment. Present Value of Net Period 1 Net Cash Flows Cash Flows $53,000 $48,624 20 49,000 41,242 3 136,000 105,017 4 78,000 55,257 5 61,000 39,646 Totals $377,000 $289,786 (240,000) $49,786 Initial investment Net present value Verify the value of cell C18 using the NPV function (b) Should the machinery be purchased? Yes
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter12: Capital Investment Analysis
Section: Chapter Questions
Problem 2MAD
Related questions
Question

Transcribed Image Text:A company is considering a $240,000 investment in machinery with the following net cash flows. The
company requires a 9% return on its investments.
Initial investment
Required rate of return
Required:
$240,000
9%
(a) Compute the net present value of this investment.
Present Value of Net
Period
1
Net Cash Flows
Cash Flows
$53,000
$48,624
20
49,000
41,242
3
136,000
105,017
4
78,000
55,257
5
61,000
39,646
Totals
$377,000
$289,786
(240,000)
$49,786
Initial investment
Net present value
Verify the value of cell C18 using the NPV function
(b) Should the machinery be purchased?
Yes
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps

Recommended textbooks for you

Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub

Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College

Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub

Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College

Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning