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

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter19: Capital Investment
Section: Chapter Questions
Problem 13E: Buena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a...
icon
Related questions
Question
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning