Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question: A new computer system will require an initial outlay of $17,500, but it will increase the firms cash flows by $3,500 a year for

Question: A new computer system will require an initial outlay of $17,500, but it will increase the firms cash flows by $3,500 a year for each of the next 8 years. a.Calculate the NPV and find out if the system worth installing if the required rate of return is 9%? What if it is 14%? I know the correct answers are 1871.87 at 9% and -1263.98 at 14%. However, When I do it, I get the wrong answer and I do it like this:0-17500 =npv(9%, -17500, 3500...3500...) 13500 = 1,717.13 23500 33500 43500 =npv(14%, -17500, 3500...3500...) 53500 =-1108.75 63500 73500 83500 Can anyone explan step by step how to calculate an NPV? Can you help explain how to do this on excel? And perhaps by hand? This is holding me up and I know I

A new computer system will require an initial outlay of $17,500, but it will increase the firms cash flows by $3,500 a year for each of the next 8 years. a.Calculate the NPV and find out if the system worth installing if the required rate of return is 9%? What if it is 14%? I know the correct answers are 1871.87 at 9% and -1263.98 at 14%. However, When I do it, I get the wrong answer and I do it like this:0-17500 =npv(9%, -17500, 3500...3500...) 13500 = 1,717.13 23500 33500 43500 =npv(14%, -17500, 3500...3500...) 53500 =-1108.75 63500 73500 83500 Can anyone explan step by step how to calculate an NPV?

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_2

Step: 3

blur-text-image_3

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

International Financial Management

Authors: Geert Bekaert, Robert Hodrick

3rd edition

1107111820, 110711182X, 978-1107111820

More Books

Students also viewed these Finance questions

Question

Describe three different revenue models for a portal such as Yahoo!

Answered: 1 week ago