An engineering company requested that $500000 be spent on software and hardware to improve the efficiency of some control systems. tis improvement is expected to save $X.000 per year for 10 years in energy costs and $700000 at the end of 10 years in equipmentrefurbishment cos. use Microsoft Excel functions to find the following:

1-the net present worth of the project.

2-the internal rate of return

3-the annual worth of the project

X= your month of birth

MARR= 10% if you are born on an odd date

MARR= 12% if you are born on an even date