I need to know how to do this IN EXCEL, please! Dennis wants to determine if...

70.2K

Verified Solution

Question

Finance

I need to know how to do this IN EXCEL,
please! Dennis wants to determine if the discount rate reallymakes any difference in the net present value of a project. Hefeels that if a project is acceptable at one rate of return, itwill be acceptable at all rates of return. To explain why histhinking is incorrect, you are creating an example to illustrateyour point. The cash flows you are using are as follows: time zerois -$71,000, years 1 through 4 are $17,500 each, and years 5 and 6are $22,500 each. What is net present value at a discount rate of12 percent and 17 percent?

Answer & Explanation Solved by verified expert

4.0 Ratings (561 Votes)

Net Present value Present value of cash inflows Present valueof cash See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

I need to know how to do this IN EXCEL,please! Dennis wants to determine if the discount rate reallymakes any difference in the net present value of a project. Hefeels that if a project is acceptable at one rate of return, itwill be acceptable at all rates of return. To explain why histhinking is incorrect, you are creating an example to illustrateyour point. The cash flows you are using are as follows: time zerois -$71,000, years 1 through 4 are $17,500 each, and years 5 and 6are $22,500 each. What is net present value at a discount rate of12 percent and 17 percent?