WALDO COUNTY Minicase solution, Chapter 10 Principles of Corporate Finance, 12th Ed. R. A. Brealey, S. C. Myers and F. Allen The attached Excel spreadsheet was prepared by George Chavez for the proposed Downeast Tourist Mall. The spreadsheet will carry out the various sensitivity and breakeven analyses suggested in the minicase. Enter changes in the inflation rate and forecast errors for rental revenues and share of retail sales in the spreadsheet’s left hand panel. To see the effect of a year’s delay in startup, enter 0 if no delay and 1 is start up is delayed one year. Changes in the timing and amount of construction costs should be entered directly in the cash flow table. All cash flows except depreciation are forecasted in real terms. Note that depreciation is not subtracted in calculating operating cash flow. Depreciation tax shields are valued separately by discounting at the nominal rate. We isolated these tax shields to see the effect of changes in inflation. Inflation affects the PV of depreciation tax shields, which are fixed in nominal terms. The other cash flows are given in real terms and discounted at (1.09/1.02) – 1 = .0686. The project’s terminal value is $30 million, the value of the land in year 18, or in If all goes as planned, the project’s NPV is + $36.6 million, but cash flows could year 19 if construction and startup are delayed. turn out worse or better than projected. For example, a 20 per cent shortfall in rentals and share of retail sales cuts NPV to - $1.1 million. Copyright © 2017 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education. 本文来源：https://www.wddqw.com/doc/6a711a9c0608763231126edb6f1aff00bfd57049.html