Could I get assistance on the following. Please advise.

6.

The budget director for Franklin Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1, October is the first month of operations; accordingly, there are no beginning account balances Required 3. Complete the schedute of cash payments for 5&A expenses by lling in the missing amounts. b. Determine the amount of salaries payable the company will report on its proforma balance sheet at the end of the fourth quarter. c. Determine the am0unt of prepaid insurance the company will report on its proforma balance sheet at the end of the fourth quarter. J Req A ' Req B and C Complete the schedule of cash payments for 5&A expenses by lling in the missing amounts. Equipment lease expense Prior month's salary expense, 100% Cleaning supplies Insurance premium Depreciation on computer Rent Miscellaneous expenses Total disbursements for operating expenses $ 19.200 $ Budgeted SM Expenses Equipment lease expense $ 5.900 $ 5,900 $ 5,900 Salary expense 5.300 5.800 6,200 Cleaning supplies 2.860 2.710 3,100 Insurance expense 1.200 1,200 1,200 Depreciation on computer 2.200 2,200 2,200 Rent 2.500 2.500 2,500 Miscellaneous expenses 740 740 740 Total operating expenses $ 20300 S 21,050 $ 21.340 Schedule of Cash Payments for SS-A Expenses 17,150 $ 18,040 Req A Req B and C Determine the amount of salaries payable and prepaid insurance the company will report on its pro forma balance sheet at the end of the fourth quarter. b. Salaries payable 0. Prepaid insurance The accountant for Munoz's Dress Shop prepared the following cash budget. Munoz's desires to maintain a cash balance of $24,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 3 percent per month. Required 3. Complete the cash budget by filling in the missing amounts. b. Determine the amount of net cash flows from operating activities Munoz's will report on the third quarter proforma statement of cash ows. c. Determine the amount of net cash flows from financing activities Munoz's will report on the third quarter proforma statement of cash ows. Req A Req B and C Complete the cash budget by lling in the missing amounts. Note: Any shortages or repayments should be indicated with a minus sign. Round your answers to the nearest whole dollar amount. Section 1: Cash receipts Beginning cash balance Add cash receipts $ 47,500 190,000 ::| 210.000 250.600 Total cash available Section 2: Cash payments 23?,500 For inventory purchases 170,526 145.230 1?9.152 For 8&A expenses 59,500 65.560 66.432 For interest expense Total budgeted disbursements Section 3: Financing activities 0 230,026 Surplus (shortage) 7,474 Borrowing (repayments) 16,526 E Ending cash balance $ 24,000 $ 24,000 $ 24.000 Reg A Req B and C Determine the amount of net cash flows from both operating and financing activities Munoz's will report on the third quarter pro forma statement of cash flows. Note: Round intermediate calculations and final answers to the nearest whole dollar amount. Net cash (operating activities) Net cash (financing activities)Perez Medical Clinic has budgeted the following cash flows. January February March Cash receipts S 111,666 5 117,666 $ 137,666 Cash payments For- inventory purchases 95,566 }'?,566 96,566 For' 5861 expenses 36,566 3?, 566 32,566 Perez Medical had a cash balance of $13,500 on January 1. The company desires to maintain a cash balance of $10,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 3 percent per month. Repayments may be made in any amount available. Perez pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Prepare a cash budget. Note: Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign. Cash Budget January February March Section 1: Cash Receipts Total cash available Section 2: Cash Payments Total budgeted disbursements Section 3: Financing Activities