Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Looking to verify if I calculated the NPV correctly. The Project Price for each project were 80,000, 175,000, and 22,700. I changed those to negative

Looking to verify if I calculated the NPV correctly. The Project Price for each project were 80,000, 175,000, and 22,700. I changed those to negative numbers before using the following excel formula:=NPV(rate, value1, value2,etc...)

image text in transcribed
Project 1 Project 2 Project 3 Project Price ($80,000) ($175,000) ($22,700) Required Rate of Return 6% 8% 12% Time Period 5 2 Year 1 Cash Flows $48,000 85,000 $15,000 Year 2 Cash Flows $36,000 74,000 $12,000 Year 3 Cash Flows $22,000 38,000 Year 4 Cash Flows 26,800 Year 5 Cash Flows 19,000 NPV $14,900.49 $27,724.34 $231.41

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

9781119563099

Students also viewed these Accounting questions