1. Complete the balance sheet given in part (j). Comblete a supportina schedule of cash collections. 3. Prepare a pro forma balance sheet as of November 30. Cash Budget, Pro Forma Balance Sheet Bernard Creighton is the controller for Creighton Hardware Store. In putting together the cash budget for the fourth quarter of the year, he has assembled the following data. a. Sales c. Each month, the ending inventory exactly equals 40 percent of the cost of next month's sales. The markup on goods is 33.33 percent of cost. d. Inventory purchases are paid for in the month following purchase. e. Recurrina monthly expenses are as follows: f. Property taxes of $15,000 are due and payable on September 15 . g. Advertising fees of $6,000 must be paid on October 20 . h. A lease on a new storage facility is scheduled to begin on November 2. Monthly payments are $5,000. j. A partially completed balance sheet as of August 31 is given below. (Accounts payable is for inventory purchases only.) Liabilities \&