I only need question 4 done. Please and thank you!

3. Selling, general and administrative Budget The SG&A budget is an estimate of all operating costs other than production. Total SG&A budget (including salaries, rent, advertising, depreciation and other) is $60,000 per quarter, of which $3,000 is depreciation expense. 4 - Complete the Cash Budget The cash budget is divided into four sections: 1.Cash receipts section lists all cash inflows excluding cash received from financing: 2.Cash disbursements section consists of all cash payments excluding repayments of principal and interest: Cash excess or deficiency section determines if the company will need to borrow money or if it will be able to repay funds previously borrowed; and 4. Financing section details the borrowings and repayments projected to take place during the budget period. Maintains a minimum cash balance of $30,000 and had no outstanding borrowings, The company's beginning cash balance for the upcoming fiscal year is $30,000 The company requires a minimum cash balance of $30,000 and may borrow in increments of $5,000 as needed from a local bank at a quarterly simple interest rate of 2%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. Pays a cash dividend of $50,000 in Quarter 2 and Quarter 4. Purchases $20,000 of equipment in Quarter 1, $30,000 in Quarter 2 and $25,000 in Quarter 4 (purchases paid in cash). Assume equivalent assets were retired, so there is no impact on depreciation expenses. 5 - Complete the Budgeted Income Statement Izzy's produces accrual based (GAAP) financial statements. Emel F Edt View insen Formal Toal Duta WOW o Belp Mutta 2 - C Home Draw Page Layout Formulas Data Review View Analytic Solver fx Data Mining Tallinn Sweden IB am Am Ruangan Lagical Rana Und TA Tent De La Mea Tante M Crash Calw Calidation Chat Qui SA be Rame Rama ng Win 616 $ $ $ C 0359 21,000.00 $ 35,000.00 56,000.00 $ 0355 30.500.00 5 35,000.00 65,500.00 E 0335 35,500.00 $ 35,000.00 70.500.00 5 055 38,200.00 $ 35,000.00 73,200.00 $ 0.35 125,200.00 140,000.00 265,200.00 5 10,000.00 $ 45,000.00 10,000.00 5 10,000.00 $ 55,500.00 $ 60,500.00 $ Cost per unit 10,000.00 $ 33,200.00 5 $ 40,000.00 2,252,000,00 1.06 5 $ $ 60,000.00 5 3,000.00 $ 63,000.00 $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 5 3,000.00 5 63,000.00 $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 3,000.00 63,000.00 30,000 324,000 354,000 312.000 396,000 456,000 2,976,000 32 Indirect sbor per unit 53 Variable OH 54 Fixed Overhead SS Total Overhead Costs 56 57 Noncash MOH-Depreciation 58 Cash payments for Overhead 59 60 3. Selling general and administrative Budget 61 Expenses per quarter 62 Non cash (Deprecation) 63 Cash for SGA 64 65 66 4. Cash Budget 67 Cash Receipts 68 Beginning cash balance 69 Cash Collections from Sales 70 Total Cash Receipts 71 72 Cash Disbursements 73 cash payments for purchases of inventory 74 Cash payments for direct labor 75 Cash payments for MOH 76 Cash payments for SG&A 77 Capital expenditures 78 Dividends 79 Total Cash Disbursements 80 81 Cash Excess (Deficiency) 82 83 Financing 84 borrowings BS Repayments 86 Interest 87 Net Financing 88 89 Ending Cash Balance 90 91 Minimum cash 92 93 interit quarterly 94 20.000 30,000 25,000 75,000 46,000 63,000 55,500 63.000 60,500 63,000 332.000 63.000 50,000 50,000 100,000 2% 30,000 30,000 30,000 30,000 30,000 2x 3. Selling, general and administrative Budget The SG&A budget is an estimate of all operating costs other than production. Total SG&A budget (including salaries, rent, advertising, depreciation and other) is $60,000 per quarter, of which $3,000 is depreciation expense. 4 - Complete the Cash Budget The cash budget is divided into four sections: 1.Cash receipts section lists all cash inflows excluding cash received from financing: 2.Cash disbursements section consists of all cash payments excluding repayments of principal and interest: Cash excess or deficiency section determines if the company will need to borrow money or if it will be able to repay funds previously borrowed; and 4. Financing section details the borrowings and repayments projected to take place during the budget period. Maintains a minimum cash balance of $30,000 and had no outstanding borrowings, The company's beginning cash balance for the upcoming fiscal year is $30,000 The company requires a minimum cash balance of $30,000 and may borrow in increments of $5,000 as needed from a local bank at a quarterly simple interest rate of 2%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. Pays a cash dividend of $50,000 in Quarter 2 and Quarter 4. Purchases $20,000 of equipment in Quarter 1, $30,000 in Quarter 2 and $25,000 in Quarter 4 (purchases paid in cash). Assume equivalent assets were retired, so there is no impact on depreciation expenses. 5 - Complete the Budgeted Income Statement Izzy's produces accrual based (GAAP) financial statements. Emel F Edt View insen Formal Toal Duta WOW o Belp Mutta 2 - C Home Draw Page Layout Formulas Data Review View Analytic Solver fx Data Mining Tallinn Sweden IB am Am Ruangan Lagical Rana Und TA Tent De La Mea Tante M Crash Calw Calidation Chat Qui SA be Rame Rama ng Win 616 $ $ $ C 0359 21,000.00 $ 35,000.00 56,000.00 $ 0355 30.500.00 5 35,000.00 65,500.00 E 0335 35,500.00 $ 35,000.00 70.500.00 5 055 38,200.00 $ 35,000.00 73,200.00 $ 0.35 125,200.00 140,000.00 265,200.00 5 10,000.00 $ 45,000.00 10,000.00 5 10,000.00 $ 55,500.00 $ 60,500.00 $ Cost per unit 10,000.00 $ 33,200.00 5 $ 40,000.00 2,252,000,00 1.06 5 $ $ 60,000.00 5 3,000.00 $ 63,000.00 $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 5 3,000.00 5 63,000.00 $ 60,000.00 $ 3,000.00 $ 63,000.00 $ 60,000.00 3,000.00 63,000.00 30,000 324,000 354,000 312.000 396,000 456,000 2,976,000 32 Indirect sbor per unit 53 Variable OH 54 Fixed Overhead SS Total Overhead Costs 56 57 Noncash MOH-Depreciation 58 Cash payments for Overhead 59 60 3. Selling general and administrative Budget 61 Expenses per quarter 62 Non cash (Deprecation) 63 Cash for SGA 64 65 66 4. Cash Budget 67 Cash Receipts 68 Beginning cash balance 69 Cash Collections from Sales 70 Total Cash Receipts 71 72 Cash Disbursements 73 cash payments for purchases of inventory 74 Cash payments for direct labor 75 Cash payments for MOH 76 Cash payments for SG&A 77 Capital expenditures 78 Dividends 79 Total Cash Disbursements 80 81 Cash Excess (Deficiency) 82 83 Financing 84 borrowings BS Repayments 86 Interest 87 Net Financing 88 89 Ending Cash Balance 90 91 Minimum cash 92 93 interit quarterly 94 20.000 30,000 25,000 75,000 46,000 63,000 55,500 63.000 60,500 63,000 332.000 63.000 50,000 50,000 100,000 2% 30,000 30,000 30,000 30,000 30,000 2x