ad Case 26 Mountain Village Clinic, Cash Budgeting, on pages 175 177 of Pink and Song (2018) 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 of 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 ) The monthly cash budget you have prepared assumes that all cash flows occur on the same day each month Suppose the clinic's outflows tend to cluster at the beginning of the month, while collections tend to be heaviest toward the end of each month How would this imbalance affect the validity of the monthly budget What could be done to correct any inaccuracies that might occur Construct the clinic's daily cash budget for January Does it indicate the same maximum borrowing requirement for the month as does the monthly budget Does the end of January borrowing requirement in the daily budget match the end of January borrowing requirement in the monthly budget If not, explain the difference Should seasonal variations be incorporated into the clinic's target cash balance In other words, should the balance be higher during months when cash needs are greater The only receipts shown on the clinic's cash budget are collections What other types of cash inflows could occur 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 a significant impact on estimated borrowing requirements The clinic's cash management policy is to invest any surplus funds in marketable securities Can you suggest an investment policy that would provide liquidity and safety yet offer the clinic a reasonable return on its investment Specifically, describe the types of securities, the desired maturities, the espected returns, and the risks that would be involved Would your suggestions be the same for a business whose cash balances were projected to be in the millions of dollars as opposed to thousands of dollars What would be the impact on the monthly net cash flows if actual billings from November 2017 to June 2018 were 20 percent below the forecasted amounts What if they were 50 percent below the forecasted amounts In your answers, assume that purchases and labor costs, as well as other expenses, cannot be adjusted downward during this period even though realized volume was below that forecasted Suppose the clinic's third party payers changed their payment patterns and began paying as follows 10 percent in the month of sale, 20 percent in the following month, and 70 percent in the second month versus the old 20 20 60 pattern How large a credit line would the clinic require On the basis of your analyses, how large a credit line would you recommend that the clinic seek from First Bank YHLE Student Questions 6th Edition Review View S Wrap Test Merge Center General E Conditional UW Page Layout Formulas Data Arial 12A Paste BI O A BV X fx 2A Day 22 23 24 171 COLLECTIONS WORKSHEET 172 Bed changes $22 581 $22 581 173 Collections 174 1 30 days $4,516 175 3160 3 226 176 81 90 days 177 Total colections 179 SUPPLES WORKSHEET 100 Supplies payments 1812 months before use 162 1 month before use 183 Total supplies M 22 1 122 1 22 5 $22881 $450 2220 1450 1228 105 NET CASH GAIN LOSS) 186 Total colections 51312312 742 311742113 72 113 2 1137 113 14211212 1 190 General expense 1645 3645 5645 5545 545 80 5645 645 1865 3 3130 0 10 103 Termoan payment Total payments 1845 18 31 07 2007 10 197 BORROWINGI SURPLUS SUMMARY 190 Cast beginning with no bow171455515001527451A 201 Cumulative surplus cash fan balare 320 3183220 SAL O Y w 105 ar er 22 P 90000 DE COME 92 000 LA o o o 0 0 0 0 0 0 YHLE Student Questions 6th Edition Review View S Wrap Test Merge Center General E Conditional UW Page Layout Formulas Data Arial 12A Paste BI O A BV X fx 2A Day 22 23 24 171 COLLECTIONS WORKSHEET 172 Bed changes $22 581 $22 581 173 Collections 174 1 30 days $4,516 175 3160 3 226 176 81 90 days 177 Total colections 179 SUPPLES WORKSHEET 100 Supplies payments 1812 months before use 162 1 month before use 183 Total supplies M 22 1 122 1 22 5 $22881 $450 2220 1450 1228 105 NET CASH GAIN LOSS) 186 Total colections 51312312 742 311742113 72 113 2 1137 113 14211212 1 190 General expense 1645 3645 5645 5545 545 80 5645 645 1865 3 3130 0 10 103 Termoan payment Total payments 1845 18 31 07 2007 10 197 BORROWINGI SURPLUS SUMMARY 190 Cast beginning with no bow171455515001527451A 201 Cumulative surplus cash fan balare 320 3183220 SAL O Y w 105 ar er 22 P 90000 DE COME 92 000 LA o o o 0 0 0 0 0 0

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 08, 2024

ad Case 26: Mountain Village Clinic, Cash Budgeting, on pages 175-177 of Pink and Song (2018). Answer the following questions related to this case. Use

ad Case 26: Mountain Village Clinic, Cash Budgeting, on pages 175-177 of Pink and Song (2018).
Answer the following questions related to this case. Use the Excel spreadsheet as needed, but type your answers into a Word document.
1. Construct a monthly cash budget for the clinic for the period of 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.)
2. The monthly cash budget you have prepared assumes that all cash flows occur on the same day each month. Suppose the clinic's outflows tend to cluster at the beginning of the month, while collections tend to be heaviest toward the end of each month.
  1. How would this imbalance affect the validity of the monthly budget?
  2. What could be done to correct any inaccuracies that might occur?
3. Construct the clinic's daily cash budget for January. Does it indicate the same maximum borrowing requirement for the month as does the monthly budget? Does the end-of-January borrowing requirement in the daily budget match the end-of-January borrowing requirement in the monthly budget? If not, explain the difference.
4. Should seasonal variations be incorporated into the clinic's target cash balance? In other words, should the balance be higher during months when cash needs are greater?
5. The only receipts shown on the clinic's cash budget are collections. What other types of cash inflows could occur?
6. 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 a significant impact on estimated borrowing requirements?
7. The clinic's cash management policy is to invest any surplus funds in marketable securities.
  1. Can you suggest an investment policy that would provide liquidity and safety yet offer the clinic a reasonable return on its investment? Specifically, describe the types of securities, the desired maturities, the espected returns, and the risks that would be involved.
  2. Would your suggestions be the same for a business whose cash balances were projected to be in the millions of dollars as opposed to thousands of dollars?
8. What would be the impact on the monthly net cash flows if actual billings from November 2017 to June 2018 were 20 percent below the forecasted amounts? What if they were 50 percent below the forecasted amounts? In your answers, assume that purchases and labor costs, as well as other expenses, cannot be adjusted downward during this period even though realized volume was below that forecasted.
9. Suppose the clinic's third-party payers changed their payment patterns and began paying as follows: 10 percent in the month of sale, 20 percent in the following month, and 70 percent in the second month versus the old 20-20-60 pattern. How large a credit line would the clinic require?
10. On the basis of your analyses, how large a credit line would you recommend that the clinic seek from First Bank?

YHLE. Student Questions - 6th Edition Review View = S Wrap Test Merge Center General E % * Conditional UW Page Layout Formulas Data Arial 12A Paste BI O A BV X fx 2A Day 22 23 24 171 COLLECTIONS WORKSHEET 172 Bed changes $22.581 $22.581 173 Collections 174 1-30 days $4,516 175 3160 3.226 176 81-90 days 177 Total colections 179 SUPPLES WORKSHEET 100 Supplies payments 1812 months before use 162 1 month before use 183 Total supplies M 22/1 122 1 22.5 $22881 $450 2220 1450 1228 105 NET CASH GAIN LOSS) 186 Total colections 51312312.742 311742113.72 113.2 1137 113.14211212 1 190 General expense 1645 3645 5645 5545 545 80 5645 645 1865 / 3 3130 0 10 103 Termoan payment Total payments - 1845- 18 31.07 .2007 10 197 BORROWINGI SURPLUS SUMMARY 190 Cast beginning with no bow171455515001527451A 201 Cumulative surplus cash fan balare 320 3183220 SAL O Y w 105 ar er 22 P 90000 DE COME 92.000 LA o o o 0 0 0 0 0 0 + YHLE. Student Questions - 6th Edition Review View = S Wrap Test Merge Center General E % * Conditional UW Page Layout Formulas Data Arial 12A Paste BI O A BV X fx 2A Day 22 23 24 171 COLLECTIONS WORKSHEET 172 Bed changes $22.581 $22.581 173 Collections 174 1-30 days $4,516 175 3160 3.226 176 81-90 days 177 Total colections 179 SUPPLES WORKSHEET 100 Supplies payments 1812 months before use 162 1 month before use 183 Total supplies M 22/1 122 1 22.5 $22881 $450 2220 1450 1228 105 NET CASH GAIN LOSS) 186 Total colections 51312312.742 311742113.72 113.2 1137 113.14211212 1 190 General expense 1645 3645 5645 5545 545 80 5645 645 1865 / 3 3130 0 10 103 Termoan payment Total payments - 1845- 18 31.07 .2007 10 197 BORROWINGI SURPLUS SUMMARY 190 Cast beginning with no bow171455515001527451A 201 Cumulative surplus cash fan balare 320 3183220 SAL O Y w 105 ar er 22 P 90000 DE COME 92.000 LA o o o 0 0 0 0 0 0 +