Answered You can hire a professional tutor to get the answer.

QUESTION

Please I need help!! how do I calculate the NPV utilizing a spreadsheet?

Please I need help!! how do I calculate the NPV utilizing a spreadsheet?

9-4NPV.  Calculate the net present value (NPV) for the following 20-year projects.  Comment on the acceptability of each.  Assume that the firm has an opportunity cost of 14%.

a.    Initial investment is $10,000; cash inflows are $2,000 per year.

b.    Initial investment is $25,000; cash inflows are $3,000 per year.

c.    Initial investment is $30,000; cash inflows are $5,000 per year.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question