XYZ is a multinational manufacturing company that have investment in different countries. XYZ aiming to enter in a new market by initiating a new factory. The capital budget is limited to $200,000,000. XYZ is analyzing its capital expenditure proposals for improving the profitability of the company through the new investment. The analyst team in XYZ, is preparing an analysis of the five different proposals under consideration by Andrews, the CEO of the company. The risk manager estimated that the inflation will be an average of 9% for the coming 10 years. Table Q2 show the expected cash flow for the five proposals Table Q1 Cash flow for different proposals A B D E Capital investment 70000000 100000000 50000000 80000000 90000000 Expected cash flow $/year 37000000 3625000 35000000 3250000 36250000 Total annual expenses 5750000 4600000 3450000 6900000 8050000 Market value (end of useful life) 5000000 8000000 7000000 1100000 1000000 Useful life (Year) 3 4 2 6 6 Because the company's cash is limited, Andrews thinks the payback method should be considered as one of the decision methods. However, the company decided to use PW strategies in decision making. After a hot discussion in the executive board, they decided to evaluate each project from the three methods: Payback method, PW and the benefit cost method Assumption 1. All cash flows occur at the end of the year except for initial investment amounts will be in the beginning of the year. 2. Use repeatability assumption for different useful life. Requirement 1. Show all calculation using a suitable software as well as the manual calculation 2. Write a comprehensive conclusion supported by numbers XYZ is a multinational manufacturing company that have investment in different countries. XYZ aiming to enter in a new market by initiating a new factory. The capital budget is limited to $200,000,000. XYZ is analyzing its capital expenditure proposals for improving the profitability of the company through the new investment. The analyst team in XYZ, is preparing an analysis of the five different proposals under consideration by Andrews, the CEO of the company. The risk manager estimated that the inflation will be an average of 9% for the coming 10 years. Table Q2 show the expected cash flow for the five proposals Table Q1 Cash flow for different proposals A B D E Capital investment 70000000 100000000 50000000 80000000 90000000 Expected cash flow $/year 37000000 3625000 35000000 3250000 36250000 Total annual expenses 5750000 4600000 3450000 6900000 8050000 Market value (end of useful life) 5000000 8000000 7000000 1100000 1000000 Useful life (Year) 3 4 2 6 6 Because the company's cash is limited, Andrews thinks the payback method should be considered as one of the decision methods. However, the company decided to use PW strategies in decision making. After a hot discussion in the executive board, they decided to evaluate each project from the three methods: Payback method, PW and the benefit cost method Assumption 1. All cash flows occur at the end of the year except for initial investment amounts will be in the beginning of the year. 2. Use repeatability assumption for different useful life. Requirement 1. Show all calculation using a suitable software as well as the manual calculation 2. Write a comprehensive conclusion supported by numbers
