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 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
Get step-by-step solutions from verified subject matter experts
