Case 26 CASE 26 MOUNTAIN VILLAGE CLINIC: Cash Budgeting Copyright 2018 Foundation of the American College of Healthcare Executives. Not for sal ModelI Instructor Version This case demonstrates the use of a cash budget for analyzing a business's cash flows and nancing needs over time. The worksheet has a single input section, but it has separate models for the monthly and the daily cash budgets. Changes in input data will flow through to both mod and will be reflected in the output. Note that the model extends out to Column M. The model consists of a complete base case analysis-no changes need to be made to the exis MODEL-GENERATED DATA section. However, values in the INPUT DATA section of the studel spreadsheet have been replaced by zeros. Students must select appropriate input values and E them into the cells with values colored red. After this is done, any error cells will be corrected ar the base case solution will appear. The KEY OUTPUT section includes the most important outp from the MDDEL-GENERATED DATA