Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management And Policy

Authors: James C. Van Horne

12th Edition

0130326577, 9780130326577

More Books

Students also viewed these Finance questions

Question

Identify ways that country culture influences global business.

Answered: 1 week ago

Question

Define human resource ethics.

Answered: 1 week ago

Question

Describe the human resource management profession.

Answered: 1 week ago