need help with parts 2,3,4 thanks!
2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $53,000. 3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach. 4. A budgeted balance sheet as of June 30. Complete this question by entering your answers in the tabs below. Reg 1A Reg 1B Req 1C Req 1D Reg 2 Reg 3 Reg 4 Prepare a master budget for the three-month period ending June 30 that includes a cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $53,000. (Cash deficiency, repayments and interest should be indicated by a minus sign.) Earrings Unlimited Cash Budget For the Three Months Ending June 30 April May June Quarter Beginning cash balance Add collections from customers Total cash available 0 0 Less cash disbursements: Merchandise purchases Advertising Salaries Commissions Utilities Equipment purchases Dividends paid Total cash disbursements Excess (deficiency) of cash available over disbursements Financing Borrowings Repayments Interest Total financing Ending cash balance 00 000 0 0 0 0 0 0 $ $ $ $ 0 Req 1A Req 1B Reg 1C Req 1D Reg 2 Req3 Req 4 Prepare a master budget for the three-month period ending June 30 that includes a budgeted income statement for the three- month period ending June 30. Use the contribution approach. Earrings Unlimited Budgeted Income Statement For the Three Months Ended June 30 Variable expenses Fixed expenses: Complete this question by entering your answers in the tabs below. Reg 1A Reg 1B Req 1C Req 1D Reg 2 Reg 3 Reg 4 Prepare a master budget for the three-month period ending June 30 that includes a budgeted balance sheet as of June 30. Earrings Unlimited Budgeted Balance Sheet June 30 Assets Total assets Liabilities and Stockholders' Equity Total liabilities and stockholders' equity ( Req3 - Rega 2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $53,000. 3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach. 4. A budgeted balance sheet as of June 30. Complete this question by entering your answers in the tabs below. Reg 1A Reg 1B Req 1C Req 1D Reg 2 Reg 3 Reg 4 Prepare a master budget for the three-month period ending June 30 that includes a cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $53,000. (Cash deficiency, repayments and interest should be indicated by a minus sign.) Earrings Unlimited Cash Budget For the Three Months Ending June 30 April May June Quarter Beginning cash balance Add collections from customers Total cash available 0 0 Less cash disbursements: Merchandise purchases Advertising Salaries Commissions Utilities Equipment purchases Dividends paid Total cash disbursements Excess (deficiency) of cash available over disbursements Financing Borrowings Repayments Interest Total financing Ending cash balance 00 000 0 0 0 0 0 0 $ $ $ $ 0 Req 1A Req 1B Reg 1C Req 1D Reg 2 Req3 Req 4 Prepare a master budget for the three-month period ending June 30 that includes a budgeted income statement for the three- month period ending June 30. Use the contribution approach. Earrings Unlimited Budgeted Income Statement For the Three Months Ended June 30 Variable expenses Fixed expenses: Complete this question by entering your answers in the tabs below. Reg 1A Reg 1B Req 1C Req 1D Reg 2 Reg 3 Reg 4 Prepare a master budget for the three-month period ending June 30 that includes a budgeted balance sheet as of June 30. Earrings Unlimited Budgeted Balance Sheet June 30 Assets Total assets Liabilities and Stockholders' Equity Total liabilities and stockholders' equity ( Req3 - Rega