A nationwide motel chain is considering locating a new motel in Bigtown, USA. The cost of building a 130-room motel (excluding furnishings) is $5.4 million. The firm uses a 12-year planning horizon to evaluate investments of this type. The furnishings for this motel must be replaced every four years at an estimated cost of $1,850,000 (at k = 0, 4, and 8). The old furnishings have no market value. Annual operating and maintenance expenses for the facility are estimated to be $115,000. The market value of the motel after 12 years is estimated to be 20% of the original building cost. Rooms at the motel are projected to be rented at an average rate of $50 per night. On the average, the motel will rent 65% of its rooms each night. Assume the motel will be open 365 days per year. MARR is 8% per year. a. Using an annual-worth measure of merit, is the project economically attractive? b. Investigate sensitivity to decision reversal for the following three factors: (1) capital investment, (2) MARR, and (3) occupancy rate (average percent of rooms rented per night). To which of these factors is the decision most sensitive? Assume that the market value remains constant at the amount used in part a. c. Graphically investigate the sensitivity of the AW to changes in the above three factors. Investigate changes over the interval + 50%. On your graph, use percent change as the x-axis and AW as the y-axis. Capital Recovery Factor To Find A Given P AIP AWN- Discrete Compounding; i = 8% Single Payment Uniform Series Compound Compound Sinking Amount Present Amount Present Fund Factor Worth Factor Factor Worth Factor Factor To Find F To Find P To Find F To Find P To Find A Given P Given F Given A Given A Given F FIP PIF FIA PIA AIF 1.0800 0.9259 1.0000 0.9259 1.0000 1.1664 0.8573 2.0800 1.7833 0.4808 1.2597 0.7938 3.2464 2.5771 0.3080 1.3605 0.7350 4.5061 3.3121 0.2219 1.4693 0.6806 5.8666 3.9927 0.1705 1.5869 0.6302 7.3359 4.6229 0.1363 1.7138 0.5835 8.9228 5.2064 0.1121 1.8509 0.5403 10.6366 5.7466 0.0940 1.9990 0.5002 12.4876 6.2469 0.0801 2.1589 0.4632 14.4866 6.7101 0.0690 2.3316 0.4289 16.6455 7.1390 0.0601 2.5182 0.3971 18.9771 7.5361 0.0527 2.7196 0.3677 21.4953 7.9038 0.0465 2.9372 0.3405 24.2149 8.2442 0.0413 3.1722 0.3152 27.1521 8.5595 0.0368 000V 1.0800 0.5608 0.3880 0.3019 0.2505 0.2163 0.1921 0.1740 0.1601 0.1490 0.1401 0.1327 0.1265 0.1213 0.1168 11 12 13 14 15