Make graph in exc el that show the comparison on Machine A vs. Machine B Net Present Value using the below data: NPV of Machine A = 13.70 million NPV of Machine B = 10.30 million Since, Machine A has Higher NPV than Machine B. Machine A should be accepted for capital Investment B C D E 3 Machine A Vear Cashflows DVE@ 10% Present Value

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 4EB: Assume a company is going to make an investment in a machine of $825,000 and the following are the...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Draw graph in excel that show the comparison between Machine A vs. Machine B Net Present Value using the attached data. Please note there are two pages with data,

Make graph in excel that show the comparison on Machine A vs. Machine B Net Present
Value using the below data:
NPV of Machine A = 13.70 million
NPV of Machine B = 10.30 million
Since, Machine A has Higher NPV than Machine B. Machine A should be accepted
for capital Investment
В
E
3
Machine A
Year Cashflows PVF@ 10% Present Value
-25
1
-25.00
6.
1
0.9091
2.73
7
2
4
0.8264
3.31
8
0.7513
3.76
9.
4
6.
0.6830
4.10
10
8
0.6209
4.97
11
11
0.5645
6.21
12
7
9.
0.5132
4.62
13
8.
8.
0.4665
3.73
14
7
0.4241
2.97
15
10
6.
0.3855
2.31
16
Net Present Value
13.70
17
SUM(E5:E15)
Transcribed Image Text:Make graph in excel that show the comparison on Machine A vs. Machine B Net Present Value using the below data: NPV of Machine A = 13.70 million NPV of Machine B = 10.30 million Since, Machine A has Higher NPV than Machine B. Machine A should be accepted for capital Investment В E 3 Machine A Year Cashflows PVF@ 10% Present Value -25 1 -25.00 6. 1 0.9091 2.73 7 2 4 0.8264 3.31 8 0.7513 3.76 9. 4 6. 0.6830 4.10 10 8 0.6209 4.97 11 11 0.5645 6.21 12 7 9. 0.5132 4.62 13 8. 8. 0.4665 3.73 14 7 0.4241 2.97 15 10 6. 0.3855 2.31 16 Net Present Value 13.70 17 SUM(E5:E15)
C
E
TO
19
Machine B
20
Year Cashflows PVF@ 10% Present Value
21
-20
1
-20.00
22
1
2
0.9091
1.82
23
4
0.8264
3.31
24
3
4
0.7513
3.01
25
4
6.
0.6830
4.10
26
8
0.6209
4.97
27
6.
7
0.5645
3.95
28
7
6.
0.5132
3.08
29
8.
0.4665
2.80
30
9.
5
0.4241
2.12
31
10
3
0.3855
1.16
32
Net Present Value
10.30
33
SUM(E21:E31)
||||
B.
Transcribed Image Text:C E TO 19 Machine B 20 Year Cashflows PVF@ 10% Present Value 21 -20 1 -20.00 22 1 2 0.9091 1.82 23 4 0.8264 3.31 24 3 4 0.7513 3.01 25 4 6. 0.6830 4.10 26 8 0.6209 4.97 27 6. 7 0.5645 3.95 28 7 6. 0.5132 3.08 29 8. 0.4665 2.80 30 9. 5 0.4241 2.12 31 10 3 0.3855 1.16 32 Net Present Value 10.30 33 SUM(E21:E31) |||| B.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
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