Review the spreadsheet model, paying particular attention to (1) what assumptions are currently embedded in the model, (2) how the financial forecasts are developed, and (3) how financing feedbacks are handled. Briefly describe the model and its assumptions.

Disregard the forecasting results supplied with the model.

a. Use your own assumptions to develop the hospital's forecasted financial statements. Be sure to analyze your results from the perspectives of both accounting consistency and financial feasibility.

b. Use the current industry comparative data given in case 1 to help assess the hospitals projected financial condition. Summarize your results in a table that shows key financial ratios, retained earnings, and external financing requirements (if required) for each year, along with five-year totals for earnings and financing.

3. In general, what effect do the profitability, capital intensity, and growth rate of a firm have on its external financing requirement?

4. Discuss what changes would have to be made to the forecast if the hospital were investor-owned.

5. Which of the notes to the financial statements given in case 24 could have a material effect on your forecast? Explain.

6. In your opinion, what are three key learning points from this case?