Question: Probably Excel or other spreadsheet You have been assigned to manage a project to upgrade all your company's data centre servers with new models. Each

Probably Excel or other spreadsheet
You have been assigned to manage a project to upgrade all your company's data centre servers with new models. Each new server will cost you $25,000 to purchase, and you need 10 of them in total. Each new server comes with three years' free maintenance worth $2,500/year (you'll have to pay this in the fourth and fifth years). Each new server saves you $2,000/year in electrical costs. Each new server saves you $1,000/year in air conditioning expenses.
The required Internal Rate of Return (IRR) on this project, over a five year period, is 15% above breakeven. It will take you $15,000/month for three months to install the new machines. (The old ones are scrap and have no value.) After that you have no further project expenses.
Using a discount rate of 2.5% to do the discounted cash flows, is there a case for this project (it meets or exceeds the IRR) or not?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!