fbpx

Assignment 3: time value of money calculations

Don't use plagiarized sources. Get Your Assignment on
Assignment 3: time value of money calculations
Just from $13/Page
Order Now

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)

By Week 1, Day 7, deliver your assignments to the M1: Assignment 3 Dropbox.

Assignment 3 Grading Criteria

Maximum Points

Calculated the NPV of the project correctly, explaining the results clearly

20

Calculated the IRR of the project correctly, explaining the results clearly

20

Calculated the Payback Period of the project correctly, explaining the results clearly

20

Calculated the Discounted Payback Period of the project correctly, explaining the results clearly

20

Synthesized an effective, well-reasoned recommendation for improvement.

12

Used correct spelling, grammar, and punctuation and followed APA style guidelines.

8

Total:

100

 

Recent Blog Posts

No recent articles to show.

Other Blog Posts

What are the key elements of an essay

You may clearly understand what an essay is and have had the experience of writing a number. However, it is […]

Feb 25th, 2022

How to write a research paper fast

The day inevitably comes; you need to submit your assignment. You have been procrastinating on writing your paper until the […]

Feb 24th, 2022

220+ best humanities research paper topics

Choosing a paper topic can be a daunting task for any assignment. A student may face agony trying to come […]

Feb 24th, 2022

How to write a media analysis essay

The media is an integral part of modern society. Think of what would happen to the world if there were […]

Feb 23rd, 2022

Great tricks on how to write a hypothesis in 2022

A hypothesis is a statement that can be proven by scientific research. It proves the theory of action and reaction, […]

Feb 22nd, 2022

How to get better at math

Math is not difficult. However, it is complex and tough compared to other subjects and requires a little bit more […]

Feb 22nd, 2022