Information Technology Evaluation and Implementation I 

 

Unit IV Project 2 

NPV and ROI Calculations Case 

Using the NPV-ROI Spreadsheet Template provided, which covers three years, enter the following values to determine the net present value (NPV), ROI percentage, and in what year payback is achieved. Click here for a copy of the template. 

NPV-ROI Spreadsheet Template:  

 Discount Rate = 8.00%  Costs: Year 0 = $200,000; Year 1 = $20,000; Year 2 = $20,000; Year 3 = $20,000  Benefits: Year 0 = 0; Year 1 = $100,000; Year 2 = $100,000; Year 3 = $100,000 

Submit your completed spreadsheet along with comments explaining the NPV and ROI values that you came up with.  

Course Textbook  
Schwalbe, K. (2014). Information technology project management (Rev. 7th ed.). Boston, MA: Cengage Learning.   

 

 

 

Financial Analysis for Project NameCreated by:Date:Discount rate1.00%Assume the project is completed in Year 0Year0123 TotalCosts5111Discount factor1.000.990.980.97Discounted costs51118Benefits0101010Discount factor1.000.990.980.97Discounted benefits010101029Discounted benefits - costs(5)99921NPVCumulative benefits - costs(5)41321ROI270%AssumptionsEnter assumptions hereInstructions: Change the inputs, shown in green below (i.e., interest rate, costs, andbenefts). Be sure to double-check the Formulas based on the inputs.

• 1494549631-Copy of UnitIV_NPV-ROISpreadsheetTemplate.xlsx

ComputerScienceExpert

(11)

Status NEW Posted 12 May 2017 12:05 AM My Price 11.00

-----------

Attachments

file 1494549635-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer