Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 fileStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started