Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the NPV of a machine that is bought for $5,000, sold at the end of year 5 for $2,500, and produces the following cash

Calculate the NPV of a machine that is bought for $5,000, sold at the end of year 5 for $2,500, and produces the following cash flows: year 1) +$700; year 2) +$600; year 3) +$500; year 4) +$400; year 5) +300, assuming the cost of capital is 6%.

I am using excel to solve the problem, I have the cash flows set up as follows

year $
0 5000
1 700
2 600
3 500
4 400
5 300

I calculated the NPV using the excel formula (2,155.20) but where do I go from here and how does the 5000 factor in? Do I subtract it from the NPV total?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Free Dollar For College For Dummies

Authors: David Rosen, Caryn Mladen

1st Edition

0764554670, 978-0764554674

More Books

Students also viewed these Finance questions

Question

Explain the nature of human resource management.

Answered: 1 week ago