Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

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 Table-1:

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 2-to-5-page 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)

Show more
Elite2
Elite2
  • @
  • 331 orders completed
ANSWER

Tutor has posted answer for $25.00. See answer's preview

$25.00

*** ** department *** requested ** ****** ** *** server ********** **** ******* is ******** ** ******** a competitive ******** *** *** has ***** **** *** ******** *** ******* *** submit a ************** ** *** ** ***** ** whether *** ******* ****** **** ******* **** this request *** calculated ***** of *** ******* ** * ********* of expenses including power *** *********** costs ** ***** ** Table-1: 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 ******** **** ** ***** *************** * *** ***********************************

Click here to download attached files: Time-Value.docx
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question