Based on the monthly cash budget, what is the maximum loan balance for January? Based on the daily cash budget, what is the maximum loan balance for January? Why are the numbers different?
Which budget should the clinic rely upon, the daily or monthly? Why?
Construct scenarios when billings are 5% higher and lower than the base case scenario here.
How do these scenarios change the maximum potential loan balances?
What credit line would you recommend for the clinic, using the best and worst scenarios as well?
Submission Instructions:
Before submitting your homework assignment, be sure to review the Case Study Assignment Grading Rubric.
When you have completed work on the “Model” tab and responded to all items in the “Question Set” tab of Assignment #11, please upload your work below as an Excel spreadsheet. All assignments should be completed and uploaded prior to the live session.
