Question: please help. if possible, please attach the excel file or give a link to it. Thank you! 3. Please, solve the following exercises about the

 please help. if possible, please attach the excel file or give

please help. if possible, please attach the excel file or give a link to it. Thank you!

3. Please, solve the following exercises about the Total Cost of Ownership (TCO) theory (12 points): You are the Procuremen investments (projects) can be more economically viable for your entity: t Agency of your country and you should evaluate which of the following 3 Time Project 1 Project2 Project3 10,000 (CapEx) 2,000 (OpEx) 15,000 (CapEx 1,000 (OpEx) 1,000 CapEX) 8,000( 1,100 (OpEX) 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 2 2,000 1,000 1,000 1,000 1,000 1,000 2,000 2,000 10 12 Project 1 lasts 5 years. Project 2 lasts 8 years and Project 2 lasts 12 years. Please: a. Calculate the Total Cost of Ownership (TCO) or Net Present Value (NPV) of the investment b. Make a ranking of the investments (i.e. which is the most feasible) and ev aluate which project c. If the interest rate becomes equal to 3%, i.e., how does change the previous ranking? (Scenario using 196 as a discount rate is better according to the NPV theory analysis) N.B, Please, use spreadsheet and deliver also the Excel file

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!