1. Prepare the budgeted balance sheot for Sheet Medical Supply at Apri 30. Show separate computations for cash, inventory, and owners' equity balances. 2. Prepare the combined cash budget for Apnil. 3. Suppose Sheet Medical Supply has become aware of more efficient (and more expensive) equipment than it budgeted for purchase in April. What is the total amount of cash available for equipment purchases in Aprii, before financing, If the minimum desired ending cash balance is $16,000 ? (For this requirement, disregard the $42,200 initialy budgeted for equipment purchases.) 4. Before granting a loan to Sheet Medical Supply, City's First Bank asks for a sensitivity analysis assuming that Apnil sales are only $60,667 rather than the $01,000 originally budgeted. (While the cost of goods sold will change, assume that purchases, depreciation, and the other operativg expenses wili remain the same as in the earlier requirements.) a. Prepare a revised budgeted balance sheet for Sheet Medical Supply, showing separate computations for cash, inventory, and owners' equity balances. b. Suppose Sheet Medical Supply has a minimum desired cash balance of $15,000. Wil the company need to borrow cash in April? a. March 31 equipmont balance, $52,300; accumulated depreciation, $41,200. b. April caphal expenditures of \$42,200 budgoted for cash purchase of equipment c. Aprit depreciation expense, $700. d. Coot of goods sold. 45% of soles. e. Omher April operating expenses, including income tax, total \$14,200, 25\% of which wat be paid in cash and the remainder acorued at Apri 30 . 4. March 31 owners' equity, 592,800 9. March 31 cash balance, $40.300. h. April budgeled sales, 591,000,70% of which is for cash. Of the remaining 30%. half will be collected in April and half in May 1. April cash coliections on March salos, $29,200. 1. Aprit cash payments of March 31 liablites incurred for March purchases of inventory, $17,300. k. March 31 inventory balance, 529,500 . L. April purchases of inventory, $10,900 for cash and $36,300 on credit. Half of the credit purchases will be paid in April and hat in May. Shoet Modical Supply has appind for a loan, City's. First Bank has requestod a budgeted balance sheet as of April 30, and a combined cash budget for Apri. As sheot Medicai Supply's controler, you have assemblod the following information: (Click the icon to viow the information.) Read the requilements