Answer Part B using the table provided please. Thank you so much

E50 V Note: the above provides your answer to part "a"-type 28 Payments of A/p 29 Lagged 1 month (1.00 or 100%) 30 | Lagged 2 months (0%) $ 255,000 $300,000 360,000 $375,000$390,000 $420,000 Wages and Salaries 31 (6% of Current Month's Sales) $ 25,500 $ 30,0DO 36,000 37,500 39,000 42,000 $ 8,500 10,000 $ 12,000 $ 12,500 13,000 14,000 $12,750 $ 15,0D0 18,000 18,750 19,500 21,000 Monthly Lease Payments 32 (2% of Current Month's Sales) Monthly Advertising Expense 33 (3% of Current Month's Sales) Monthly R&D Expense (12% of Month's Sales, but 34 ONLY for Aug Sep and Oct) 35 Insurance Prepayment 36 Miscellaneous Expenses 37 Taxes 38 Total Cash Disbursements $ $ 15,000 $ 20,000 25,000 $30,000 $316,750 $435,000 $ 563,000 $ 548,750 $ 60,000 $ 72,000 $ 75,000 $ 24,000 35,000 40,000 S 45,000 496,500 $606,000 $ 40,000 $ 40 See Table 4.10, pg. 126) $ 301,480 $406,850 493,810 $583,500 621,190 648,070 496,500 606,000 124,690 42,070 61,830 Total Cash Receipts 316,750 435,000 563,000 548,750 43 Less: Total Cash Disbursements 44 Net Cash Flow S Add: Beginning Cash all 15,270 (28,150) (69,190) 34,750 15,000 8,42 Ending Cash (before investine (270) (28,420) 97,610) (62,860) 15000 15000 61,830 103,900 6 or borrowing 7 Less: Minimum Cash Balance 15000 15000 15000 Required Total Financing (notes payable-> credit line) Excess Cash Balance $ (15,270) (43,420) $(112,610) $(77,860) 48 | Cash 49 (marketable securities Note: the above provides your answer to part "a type your answer for part "b"in a Word doc and print it out. On part b, use the ISO% rule to calculate the requested credit line amount from the bank. Note: When finished, print your entire worksheet out 51 Aso called "Target Cash Balonce