Question

Slieuule Ul CdSil Payments Excel Learning Systems Inc. was organized on September 30, 2016. Projected selling and administrative expenses for each of the first three months of operations are as follows: October $139,600 November 129,800 December 118,100 Depreciation, insurance, and property taxes represent $30,000 of the estimated monthly expenses. The annual insurance premium was paid on September 30, and property taxes for the year will be paid in June. The company expects that 75% of the remainder of the expenses will be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for October, November, and December Excel Learning Systems Inc. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending December 31, 2016 October November December October expenses: Paid in October $ Paid in November November expenses: Paid in November Paid in December December expenses: Paid in December Total cash payments

Answer 1

Excel Learning Systems Inc. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending December 31, 2016 Ocober November December October expenses: Paid in October $ 82,200 Paid in November $ 27,400 April expenses: Paid in November $ 74,850 Paid in December $ 24,950 December expenses: Paid in December $ 66,075 Total cash payments $82,200 $ 102,250 $91,025 Working Notes: October Expenses: Paid in October = ($139,600-$30,000)*75% = $82,200 Paid in November = ($139,600-$30,000)*(100% -75%) = $27,400 November Expenses: Paid in November = ($129,800-$30,000) =$74,850 Paid in December = ($129,800-$30,000)*(100% -75%) =$24,950 December Expenses: Paid in December = ($118,100-$30,000)*75% = $66,075