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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education