Calculate the NPV for each project and determine which project should be accepted. Project A Project...

50.1K

Verified Solution

Question

Finance

Calculate the NPV for each project and determine which projectshould be accepted. Project A Project B Project C Project D InitialOutlay (105,000.00) (99,000.00) (110,000.00) (85,000.00) Inflowyear 1 53,000.00 51,000.00 25,000.00 45,000.00 Inflow year 250,000.00 47,000.00 55,000.00 50,000.00 Inflow year 3 48,000.0041,000.00 15,000.00 30,000.00 Inflow year 4 30,000.00 52,000.0021,000.00 62,000.00 Inflow year 5 35,000.00 40,000.00 35,000.0068,000.00 Rate 7% 10% 13% 18% NPV = $75,228.32 $77,364.07-$2,531.00 $69,006.08 Answer: Project B How to show work inexcell

Answer & Explanation Solved by verified expert

4.4 Ratings (905 Votes)

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

Calculate the NPV for each project and determine which projectshould be accepted. Project A Project B Project C Project D InitialOutlay (105,000.00) (99,000.00) (110,000.00) (85,000.00) Inflowyear 1 53,000.00 51,000.00 25,000.00 45,000.00 Inflow year 250,000.00 47,000.00 55,000.00 50,000.00 Inflow year 3 48,000.0041,000.00 15,000.00 30,000.00 Inflow year 4 30,000.00 52,000.0021,000.00 62,000.00 Inflow year 5 35,000.00 40,000.00 35,000.0068,000.00 Rate 7% 10% 13% 18% NPV = $75,228.32 $77,364.07-$2,531.00 $69,006.08 Answer: Project B How to show work inexcell