Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. calculate the npv for each project and determine w

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: Zin 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

Other questions asked by students

Q

Please use excel and demonstrate the formulae used. A regional architecture/contractor firm purchased an HVAC unit for...

Finance
Q

Greatest president ~ A Gallup Poll of 1800 American adults in February 2009 asked the following...

Statistics
Q

Hi, i'm working on lab report on iodometric determination of Cu in Brass and can someone...

Chemistry
Q

A voltage source and a current source both supply current on an electrical system. So why...

Mechanical Engineering
Q

If f(x) = -3x+4, g(x) = 5x - 7x-5, and h(x) = -7x-2, find f(2)

Basic Math
Q

8 Male Color Blindness When conducting research on color blindness in males a researcher forms...

Statistics
Q

The equation y 2 x 1 2 5 is graphed in the xy plane Which...

Algebra
Q

Partner Z of the XYZ partnership receives a liquidating distribution of the following: ...

Accounting
Q

Troy Engines, Limited, manufactures a variety of engines for use in heavy equipment. The company...

Accounting
Q

Prepare journal entrles to record each of the following transactions. The company records purchases using...

Accounting
Q

Events: 1. Recognition of revenue on account. 2. Collection of cash from accounts receivable. 3....

Accounting
Q

Dillingham, Inc., has a 60-day collection period. The projected sales for each quarter next year...

Finance