A nationwide motel chain is considering locating a new motel in Bigtown, USA. The cost of building a 150 room motel is $5,000,000 and the life is expected to be 15 years. The furnishings for the motel must be replaced every five years at an estimated cost of $1.875,000 (so at year 0,5, and 10). The old furnishings have no salvage value. Annual operating and maintenance costs are estimated to be $125,000. The salvage value of the motel is estimated to be 20% of the cost of building, Rooms at the motel are projected to be rented at an average rate of $45 per night. The motel will typically rent 60% of the rooms per night. Assume the motel is open 365 days per year. The motel chain's MARR is 10%. 1. Using Excel, graph the EUAW of this project versus +/- 50% changes in the estimates for the capital investment (building cost and salvage value change, not the cost of the furnishings). On the same plot add a graph of the EUAW of the project versus the same % changes in estimates for the occupancy rate. Use percent change on the x-axis and EUAW on the y axis. 2. Determine the percent change that can be tolerated for these two factors before the project is no longer economically attractive. 3. To which of these two factors is the decision most sensitive