Answered You can buy a readymade answer or pick a professional tutor to order an original one.
Time Value of Money Calculations
The IT department has requested an update in its server population. This upgrade is required to maintain a competitive position. The CEO has asked that you evaluate the project and submit a recommendation to her, in terms of whether the company should move forward with this request. The calculated value of the project is a reduction of expenses, including power and replacement costs, as shown in Table1:
Year
Decrease in Expenses
1$30,000.00
2$100,000.00
3$120,000.00
4$100,000.00
5$30,000.00
Assume the impact after five years to be immeasurable. The cost of capital to the firm is currently 8% and the cost of the project today is $286,000.Required:
 Calculate the net present value of the project
 Calculate the internal rate of return
 Calculate the payback period
 Calculate the discounted payback period
Submit an Excel file with your calculations, and a 2to5page paper that explains the calculations and provides your final assessment and decision. Justify your recommendations. The paper must be submitted as a Word document and it must follow APA style guidelines.
Use the following file naming conventions: MS Word: LastnameFirstInitial_M1_A3.doc MS Excel: LastnameFirstInitial_M1_A3.Excel.xls
For example, if your name is John Smith, your document will be named SmithJ_M1_A3.doc ( and LastnameFirstInitial_M1_A3.Excel.xls)
 @
 329 orders completed
 ANSWER

Tutor has posted answer for $25.00. See answer's preview
*** ** department *** requested ** ****** ** *** server ********** **** ******* is ******** ** ******** a competitive ******** *** *** has ***** **** *** ******** *** ******* *** submit a ************** ** *** ** ***** ** whether *** ******* ****** **** ******* **** this request *** calculated ***** of *** ******* ** * ********* of expenses including power *** *********** costs ** ***** ** Table1: YearDecrease ** Expenses1$30000002$100000003$120000004$100000005$3000000Assume *** ****** ***** **** ***** ** be immeasurable *** **** ** capital ** the firm ** currently ** *** *** **** of *** ******* ***** is $286000Required:Calculate *** *** ******* value ** *** **************** *** internal rate of returnCalculate *** payback *************** the ********** ******* periodSubmit ** Excel **** with **** ************ *** * *********** ***** **** ******** *** ************ *** ******** your ***** ********** *** decision Justify **** recommendations *** ***** **** be ********* as * Word ******** *** it **** follow APA style guidelinesUse *** ********* **** ****** ************** ***** LastnameFirstInitial_M1_A3docMS ****** ************************************* ******* ** **** name ** **** ***** your ******** **** ** ***** *************** * *** ***********************************