have assembled the following informalon (Clck the icon to vow the information) Read the requiements Data table Requirement 1. Show soparate consutations for cash invontory, and own a. March 31 equoment balance, 352,400 , accumblatod depreciaton, $41,600 b. Acel capess expendtunes of $42700 budgeted for cash purchese of equpment c. Aget depreciation expense, $400 d. Cost of goods sold, 65% of sabs. and the remander accrued at Acer 30 . 1. March 31 oweers' equity, 592,500 g. March 31 cash bavance, $40,200. Apont and hat in May 1. Apri cash coloctoos on Narch salen. 520,100 1. Apri cash payments ef March 3 r labstes incanted for March purchases of Wwentory. 517,500 k. March 31 inventory balancen, 520,000 be pod in Aget and hait in May Requirements 1. Prepare the budgeted balance sheet for Class Medical Supply at April 30 Show separate computations for cash, inventory, and owners' equity balances. 2. Prepare the combined cash budget for April. 3. Suppose Class 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 April, before financing, if the minimum desired ending cash balance is $13,000 ? (For this requirement, disregard the $42,700 initially budgeted for equipment purchases.) 4. Before granting a loan to Class Medical Supply. Midwest's Commerce Bank asks for a sensitivity analysis assuming that April sales are only $58,000 rather than the $87,000 originally budgeted. (While the cost of goods sold will change, assume that purchases, depreciation, and the other operating expenses will remain the same as in the earlier requirements ) a. Prepare a revised budgeted balance sheet for Class Medical Supply, showing separate computations for cash, inventory, and owners' equity balances b. Suppose Class Medical Supply has a minimum desired cash balance of $25,000 Will the company need to borrow cash in April? have assembled the following informalon (Clck the icon to vow the information) Read the requiements Data table Requirement 1. Show soparate consutations for cash invontory, and own a. March 31 equoment balance, 352,400 , accumblatod depreciaton, $41,600 b. Acel capess expendtunes of $42700 budgeted for cash purchese of equpment c. Aget depreciation expense, $400 d. Cost of goods sold, 65% of sabs. and the remander accrued at Acer 30 . 1. March 31 oweers' equity, 592,500 g. March 31 cash bavance, $40,200. Apont and hat in May 1. Apri cash coloctoos on Narch salen. 520,100 1. Apri cash payments ef March 3 r labstes incanted for March purchases of Wwentory. 517,500 k. March 31 inventory balancen, 520,000 be pod in Aget and hait in May Requirements 1. Prepare the budgeted balance sheet for Class Medical Supply at April 30 Show separate computations for cash, inventory, and owners' equity balances. 2. Prepare the combined cash budget for April. 3. Suppose Class 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 April, before financing, if the minimum desired ending cash balance is $13,000 ? (For this requirement, disregard the $42,700 initially budgeted for equipment purchases.) 4. Before granting a loan to Class Medical Supply. Midwest's Commerce Bank asks for a sensitivity analysis assuming that April sales are only $58,000 rather than the $87,000 originally budgeted. (While the cost of goods sold will change, assume that purchases, depreciation, and the other operating expenses will remain the same as in the earlier requirements ) a. Prepare a revised budgeted balance sheet for Class Medical Supply, showing separate computations for cash, inventory, and owners' equity balances b. Suppose Class Medical Supply has a minimum desired cash balance of $25,000 Will the company need to borrow cash in April