Walco County

Topics: Inflation, Operating cash flow, Cash flow Pages: 1 (258 words) Published: June 4, 2015

Minicase solution, Chapter 10

Principles of Corporate Finance, 11th 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 year 19 if construction and startup are delayed.
If all goes as planned, the project’s NPV is + $36.6 million, but cash flows could 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.
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • County Wexford Essay
  • Shasta County Analysis Essay
  • Personal Narrative: My Journey To Bucks County Essay
  • 2005 Cafr Budget Analysis for the School District of Hillsborough County Essay
  • Essay about Orange County
  • August: Osage County Essay
  • Poor Houses in Mercer County Essay
  • A Sand County Almanac Questions Essay

Become a StudyMode Member

Sign Up - It's Free