Case Study: Mountain Village Clinic

Use the 2 attached files as reference for the questions. No data is needed to be changed or filled in on the
Excel sheet.
Read Case 26: Mountain Village Clinic, Cash Budgeting, on pages 175-177 of Pink and Song (2018) (Links to
an external site.).
Answer the following questions related to this case. Use the Excel spreadsheet as needed, but type your
answers into a Word document.
Construct a monthly cash budget for the clinic for the period January through June 2018. What is the maximum
monthly loss during the six-month planning period? What is the maximum cumulative borrowing balance? (For
purposes of this question, disregard any interest payments on short-term bank loans or interest received from
investing surplus funds.)

Sample Solution