Complete "Problem 8-21 Schedule of Expected Cash Collections; Cash Budget" in chapter 8 of Managerial Accounting and present your responses in an Excel spreadsheet.

\fWeek 7 Assignment Template ALL YELLOW HIGHLIGHTED CELLS REQUIRE DATA INPUT DO NOT KEY OVER FORMULAS IF YOU SEE A RED TRIANGLE IN THE CORNER OF A CELL, I HAVE INSERTED A COMMENT TO HELP YOU. HOVER OVER THE CELL TO SEE THE COMMENT. Name: Date: Class: Professor: Number/Problem 1 Schedule of Expected Cash Collections... Insert Monthly Sales totals not the figured percentages here 2 Description From Accounts Receivable From April Sales: 30% $ 60% $ 8% $ From May Sales: 30% $ 60% $ From June Sales: 30% $ Total Cash Collections Month May April - $ - $ - - June $ - $ - $ $ - $ - - $ $ - $ $ $ $ $ $ $ $ $ $ $ - $ - Quarter $ - Cash Budget... Description Cash Balance, Beginning..................... Add Receipts: Collection from Customers........... Total Available...................................... Less Disbursements: Merchandise Purchases.................. Payroll................................................ Lease Payments............................... Advertising....................................... Equipment Purchases.................... Total Dispursements............................ Month May April June Quarter $ - $ - $ - $ - $ $ - $ $ - $ $ - $ $ - $ $ $ $ $ $ - $ $ $ $ $ $ - $ $ $ $ $ $ - $ $ $ $ $ $ - Excess (Deficiency) of Receipts over Dispursements........................... Financing: Borrowings...................................... Repayments.................................... Interest............................................ Total Financing...................................... Cash Balance, Ending..................... 3 Provide your answer here... $ - $ - $ - $ - $ $ $ $ $ - $ $ $ $ $ - $ $ $ $ $ - $ $ $ $ $