question content area top part 1 medical supply has applied for a loan. has requested a budgeted balance sheet as of april 30, and a combined cash budget for april. as medical supply's controller, you have assembled the following information: loading...(click the icon to view the information.) read the requirementsloading.... question content area bottom part 1 requirement 1. show separate computations for cash, inventory, and owners' equity balances. begin by calculating the cash balance. cash beginning balance cash inflows: cash sales collections cash outflows: payment of march liabilities cash purchases payments for april (credit) purchases purchase of equipment operating expenses ending balance part 2 calculate the inventory balance. inventory beginning balance add: purchases less: cost of goods sold ending balance part 3 calculate the owners' equity balance. owners' equity beginning balance add: revenues less: expenses ending balance part 4 prepare the budgeted balance sheet for medical supply at april 30. box medical supply budgeted balance sheet april 30 assets current assets: cash accounts receivable inventory total current assets plant assets: equipment accumulated depreciation total assets part 5 liabilities current liabilities: accounts payable accrued expenses payable total liabilities owners' equity owners' equity total liabilities and owners' equity part 6 requirement 2. prepare the combined cash budget for april. box medical supply combined cash budget for the month ended april 30 beginning cash balance, april 1 plus: cash collections from customers total cash available less cash payments: purchases operating expenses acquisition of equipment ending cash balance, april 30 part 7 requirement 3. suppose 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 ? (for this requirement, disregard the initially budgeted for equipment purchases.) the amount of cash available for equipment purchases in april, before financing, if the minimum desired ending cash balance is $13,000 (and disregarding the $42,300 initially budgeted for equipment purchases) is . part 8 requirement 4. before granting a loan to medical supply, asks for a sensitivity analysis assuming that april sales are only rather than the 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 medical supply, showing separate computations for cash, inventory, and owners' equity balances. begin by calculating the cash balance. (round amounts to the nearest whole dollar.) cash beginning balance cash inflows: cash sales collections cash outflows: payment of may liabilities cash purchases payments for april (credit) purchases purchase of equipment operating expenses paid ending balance part 9 calculate the inventory balance. (round amounts to the nearest whole dollar.) inventory beginning balance add: purchases less: cost of goods sold ending balance part 10 calculate the owners' equity balance. (round amounts to the nearest whole dollar.) owners' equity beginning balance add: revenues less: expenses ending balance part 11 prepare the budgeted balance sheet for medical supply at april 30. box medical supply budgeted balance sheet april 30 assets current assets: cash accounts receivable inventory total current assets plant assets: equipment accumulated depreciation total assets part 12 liabilities current liabilities: accounts payable accrued expenses payable total liabilities owners' equity owners' equity total liabilities and owners' equity part 13 b. suppose medical supply has a minimum desired cash balance of . will the company need to borrow cash in april? the company have to borrow cash in april if sales revenue is $58,000. the company's cash balance is than the minimum balance of $18,000.
