PLEASE ANSWER REQUIREMENTS 2 THROUGH 4B

Data table Requirement 1. Show separate computations for cash, inventory, and omers" equity balances. Begin by calculating the cash b Laiculate the Inventory Dalance. Requirements 1. Prepare the budgeted balance sheet for Box Medical Supply at April 30. Show separate computations for cash, inventary, and owners' equity balances. 2. Prepare the combined cesh budget for April. 3. Supoose Box Medical Supply has become aware of more afticient (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 $19,000 ? (For this requirement, disregard the $42,300 initially budgeted for equloment purchases.) 4. Before granting a loan to Box Medical Supply, Metropoliten National Bank asks for a sensitivity analysis assuming that April sales are only $56,000 rather than the $84.000 originally budgated. While the cosi of goods sold will change, assume that purchases, depreciation, and the other operating expenses will remain the same as in the earller recuirements.) a. Prepare a revised budgeted balance sheet for Box Medical Supply, showing aeparate computations for cash, inventory, and chners equity balances. b. Suppose Box Medical Supply has e rminimum desired cash balence of $21,000. Will the company need to bormow cash in April? Data table Requirement 1. Show separate computations for cash, inventory, and omers" equity balances. Begin by calculating the cash b Laiculate the Inventory Dalance. Requirements 1. Prepare the budgeted balance sheet for Box Medical Supply at April 30. Show separate computations for cash, inventary, and owners' equity balances. 2. Prepare the combined cesh budget for April. 3. Supoose Box Medical Supply has become aware of more afticient (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 $19,000 ? (For this requirement, disregard the $42,300 initially budgeted for equloment purchases.) 4. Before granting a loan to Box Medical Supply, Metropoliten National Bank asks for a sensitivity analysis assuming that April sales are only $56,000 rather than the $84.000 originally budgated. While the cosi of goods sold will change, assume that purchases, depreciation, and the other operating expenses will remain the same as in the earller recuirements.) a. Prepare a revised budgeted balance sheet for Box Medical Supply, showing aeparate computations for cash, inventory, and chners equity balances. b. Suppose Box Medical Supply has e rminimum desired cash balence of $21,000. Will the company need to bormow cash in April