Calculate business problem in excel

Need help with my Business question – I’m studying for my class.

Calculate the following problems using Microsoft® Excel®:

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

Project A Project B Project C Project D

Inital Outlay (105,000.000) (99,000.00) (110,000.00) (85,000.00)

Inflow year 1 53,000.00 51,000.00 25,000.00 45,000.00

Inflow year 2 50,000.00 47,000.00 55,000.00 50,000.00

Inflow year 3 48,000.00 41,000.00 15,000.00 30,000.00

Inflow year 4 30,000.00 52,000.00 21,000.00 62,000.00

Inflow year 5 35,000.00 40,000.00 35,000.00 68,000.00

Rate 7% 10% 13% 18%

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support