Use the information provided below to prepare a partial end$-$of$-$period spreadsheet for Albert$$s Gift Shop for the year ended December $31,20--.$ The ending merchandise inventory is $$47,000.$ Albert estimates that customers will be granted $$7,500,$ in refunds next year for merchandise sold this year. The estimated cost of the returned inventory is $$6,000.$ Albert$$s Gift Shop Partial Trial Balance For Year Ended December $31,20--1$ ACCOUNT TITLE DEBIT BALANCE CREDIT BALANCE $2$ Merchandise Inventory $41,000\mathrm{.}003$ Estimated Returns Inventory $3,500\mathrm{.}004$ Customer Refunds Payable $4,000\mathrm{.}005$ Income Summary $6$ Sales $175,000\mathrm{.}007$ Sales Returns and Allowances $13,000\mathrm{.}008$ Purchases $123,000\mathrm{.}009$ Purchases Returns and Allowances $1,500\mathrm{.}0010$ Purchases Discounts $1,200\mathrm{.}0011$ Freight$-$In $900\mathrm{.}00$ Required: $1.$ Complete the Adjustments columns for Merchandise Inventory and related accounts $2.$ Extend all accounts to the Adjusted Trial Balance columns. $3.$ Prepare the cost of goods sold section from the spreadsheet.