Instruction: Please answer all the question in the picture.

Task Questions to be done in Excel:

a. Draw a decision tree in the Excel File to represent the two alternatives being considered. Show all the nodes and the branches with proper labels, probabilities and expected returns clearly.

b. Show clearly how the total present value of each alternative is calculated in separate spreadsheets, one for alternative.

c. Create a comparison sheet using the following format in the attached photo. Based on the findings from (b), which alternative should NVIDIA pursue? Why?

Description: NVIDIA is headquartered in Santa Clara, California, and became a major force in the computer gaming industry with the launch of the RIVA series of graphics processors in 1997. To date, the company has become the world's leading graphic card manufacturer with a wide product range. In 2022, the production plant of NVIDIA's major supplier in Delaware producing the graphic processing units (a type of specialised integrated circuit chip) was damaged by a big fire which would negatively impact on the production capability of the plant in the immediate future. The management of NVIDIA must decide to either stay with the supplier at Delaware or source from an alternative supplier in Mexico for the coming three years. In both options, NVIDIA will incur an initial cost (at present value) but expects to get some savings every year (in future value). The expected cost of sourcing a new supplier in Mexico, upgrading its production equipment, and implementing the necessary quality assurance procedures is estimated at $5 million. Once in place, this partnership is expected to yield the savings in the next three years as shown in Table 1. The discount rate for this alternative is 3%. Table 1 Expected savings from sourcing an alternative supplier in Mexico The other alternative is to stay with the current supplier at Delaware for the next three years. The cost to undertake a temporary urgent repair of the damage caused by the fire is estimated at $3 million. Production engineers and risk assessors have estimated the savings of this alternative as shown in Table 2 . The discount rate for this alternative is 5%. Table 2 Expected savings from staying with the supplier at Delaware Task Questions to be done in Excel: a) Draw a decision tree in the Excel file to represent the two alternatives being considered. Show all the nodes and the branches with proper labels, probabilities and expected returns clearly. (5 marks) b) Show clearly how the total present value of each alternative is calculated in separate spreadsheets, one for one alternative. (8 marks) c) Create a comparison sheet using the following format. Based on the findings from (b), which alternative should NVIDIA pursue? Why? (1 mark) Description: NVIDIA is headquartered in Santa Clara, California, and became a major force in the computer gaming industry with the launch of the RIVA series of graphics processors in 1997. To date, the company has become the world's leading graphic card manufacturer with a wide product range. In 2022, the production plant of NVIDIA's major supplier in Delaware producing the graphic processing units (a type of specialised integrated circuit chip) was damaged by a big fire which would negatively impact on the production capability of the plant in the immediate future. The management of NVIDIA must decide to either stay with the supplier at Delaware or source from an alternative supplier in Mexico for the coming three years. In both options, NVIDIA will incur an initial cost (at present value) but expects to get some savings every year (in future value). The expected cost of sourcing a new supplier in Mexico, upgrading its production equipment, and implementing the necessary quality assurance procedures is estimated at $5 million. Once in place, this partnership is expected to yield the savings in the next three years as shown in Table 1. The discount rate for this alternative is 3%. Table 1 Expected savings from sourcing an alternative supplier in Mexico The other alternative is to stay with the current supplier at Delaware for the next three years. The cost to undertake a temporary urgent repair of the damage caused by the fire is estimated at $3 million. Production engineers and risk assessors have estimated the savings of this alternative as shown in Table 2 . The discount rate for this alternative is 5%. Table 2 Expected savings from staying with the supplier at Delaware Task Questions to be done in Excel: a) Draw a decision tree in the Excel file to represent the two alternatives being considered. Show all the nodes and the branches with proper labels, probabilities and expected returns clearly. (5 marks) b) Show clearly how the total present value of each alternative is calculated in separate spreadsheets, one for one alternative. (8 marks) c) Create a comparison sheet using the following format. Based on the findings from (b), which alternative should NVIDIA pursue? Why? (1 mark)