Consider the interest paid on short-term borrowings and earned on short-term investments.Modify the monthly portion of the model to include these cash flows. Do these flows have asignificant impact on estimated borrowing requirements?

What would be the impact on the monthly net cash flows if actual billings from November 2009to June 2010 were 20 percent below the forecasted amounts? What if they were 50 percentbelow the forecasted amounts? In your answers, assume that purchases and labor costs, aswell as all other expenses, cannot be adjusted downward during this period even thoughrealized volume was below that forecasted.

Suppose the clinics third-party payers changed their payment patterns and began paying asfollows: 10 percent in the month of sale, 20 percent in the following month, and 70 percent inthe second month versus the old 20-20-60 pattern. How large a credit line would the clinicrequire?

PLEASE SEE PREDICTED FORECAST AND FIGURE WITH ADDTIONAL INFORMATION FROM THE CASE**** ALL INFORMATION IS PROVIDED HERE FOR ALL 3 QUESTIONS ABOVE PLEASE

PLEASE ZOOM IN AS I CANNOT MAKE EXCEL SHEET ANY BIGGER PLEASE************