A new foreign museum will be build by the CNY Group and will cost $7,000,000 to build, $850,000 annually to maintain and operate and have an expected life of 25 years. The revenue is estimated to be $2,500,000 per year. The MARR is 5%. Conduct a sensitivity analysis based on the given information.

a) Calculate the PW of the Base case based on above given data. [0.5 point]

b) Calculate the PW for the range of -8% to +8% for initial cost. [0.5 point+0.5 point]

c) Calculate the PW for the range of -30% to +30% for annual revenue. [0.5 point+0.5 point]

d) Prepare a tabular distribution by using PW as FoM. [0.5 point+1 point +1 point]

e) Rank the order of input variables for their impact of the PW. [0.5 point+0.5 point]

f) Prepare a sensitivity graph comparing the percentage of deviation from the base case to the PW. [0.5 point+0.5 point]