Please include Excel formulas

E16 H x fx B C D E F Problem 3: Cash payments for SG&A expenses 2 3 Aristo Pharma Inc. projected selling and administrative expenses (SG&A) for the last quarter of 20Y1 as follows: 4 5 Total expenses October November December $72,000 $95,000 $120,000 7 B of the estimated monthly expenses, o Depreciation, insurance, and property taxes represent: $12,000 1 The annual insurance premium was paid on February 28, 2 Property taxes for the year will be paid in January 7 20Y2. 3 -4 Of the remainder expenses, 5 60% are expected to be paid in the month in which they are incurred; 6 with the balance to be paid in the following month. 7 -8 Required: 9 A. Prepare a schedule of cash payments for SG&A expenses for o October, November and December. 1 2 Solution: 3 Aristo Pharma Inc. 4 Schedule of Cash Payments for Selling and Administrative Expenses 5 For the last quarter of the year ended December 31 2041 26 October November December 27 October expenses Paid in October 9 Paid in November 0 November expenses 1 Paid in November 2 Paid in December 3 December expenses -4 Paid in December 5 Total cash payments -6 7 -8 M 09 DN