Beginning		March		Unadjusted		Adjustments		Adjusted		Post Closing
Account	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit
Cash	$ 6,000			$ 5,648	$ 352				$ 352		$ 352
Accounts Receivable	$ 5,000			$ 1,200	$ 3,800				$ 3,800		$ 3,800
Merchandise Inventory	$ 8,000		$ 5,880		$ 13,880				$ 13,880		$ 13,880
Supplies	$ 100		$ 900		$ 1,000			$ 850	$ 150		$ 150
Prepaid Insurance			$ 1,800		$ 1,800			$ 150	$ 1,650		$ 1,650
Equipment	$ 8,000				$ 8,000				$ 8,000		$ 8,000
Accumulated Depreciation		$ 3,000				$ 3,000		$ 1,200		$ 4,200		$ 4,200
Accounts Payable		$ 2,290	$ 150			$ 2,140				$ 2,140		$ 2,140
Salaries Payable		$ 50	$ 50			$ -				$ -		$ -
Unearned Revenue				$ 800		$ 800				$ 800		$ 800
Common Stock		$ 10,000				$ 10,000				$ 10,000		$ 10,000
Retained Earnings		$ 7,760				$ 7,760				$ 7,760		$ 10,692
Dividends	$ 14,000		$ 1,500		$ 15,500				$ 15,500
Sales Revenue		$ 64,000		$ 10,900		$ 74,900				$ 74,900
Sales Discounts	$ 1,000		$ 218		$ 1,218				$ 1,218
Cost of Goods Sold	$ 28,000		$ 6,500		$ 34,500				$ 34,500
Rent Expense	$ 4,600		$ 700		$ 5,300				$ 5,300
Salary Expense	$ 6,200		$ 850		$ 7,050				$ 7,050
Supplies Expense	$ 4,200				$ 4,200		$ 850		$ 5,050
Depreciation Expense					$ -		$ 1,200		$ 1,200
Insurance Expense	$ 2,000				$ 2,000		$ 150		$ 2,150
Total	$ 87,100	$ 87,100	$ 18,548	$ 18,548	$ 98,600	$ 98,600	$ 2,200	$ 2,200	$ 99,800	$ 99,800	$ 27,832	$ 27,832
	Unadjusted	Adjusted		Year-End	Year-End	Post Closing
	Trial Balance Total	Trial Balance Total	Net Income	Ret Earn	Total Asset	Trial Total
	$ 98,600	$ 99,800	$ 18,432	$ 10,692	$ 23,632	$ 27,832
	From Trial	From Trial	Sales-Exp	RE+NI-Div	From Trial	From Trial

So I got this far, but need help filling out the end of the year income statement, and retained earnings sheets.

Please Can you fill it out in excel so I know exactly what It looks like! Thank you!

Instructions and Information for the Case Requirements: 1) Using the information given below (Trial Balance as of Feb. 28), enter the beginning balances in the T- Accounts in the Accounting Records Package. On page 2 note the format of the Financial Statements that were produced based on the Trial Balance as of Feb. 28 (single step income statement and classified balance sheet). 2) Use the descriptions of the March transactions which are on page 3 to journalize all of the entries for March in the journal provided in the Accounting Records Package. 3) Post each entry into the T-Accounts provided in the Accounting Records Package. When finished posting, calculate the account balance for each T-Account and enter the balance on the Unadjusted Trial Balance on the form provided. Then, use the information found on the bottom of page 3 and any account balance information that is needed to journalize and post the adjusting entries. Calculate each account balance. 4) Using the T-Account balances, create an Adjusted Trial Balance on the form provided in the Accounting Records Package 5) Using the provided templates in the Accounting Records Package, prepare the: a. Income Statement b. Statement of Retained Earnings c. Balance Sheet 6) Write the four closing entries in the journal and post them to the T-Accounts and calculate the ending balance for each account. 7) Create the Post Closing Trial Balance on the form provided in the Accounting Records Package. c. Credit Trial Balance as of February 28, 2021 Debit 6,000 5,000 8,000 100 0 8,000 Cash Accounts Receivable Merchandise Inventory Supplies Prepaid Insurance Equipment Accumulated Depreciation Accounts Payable Salaries Payable Unearned Revenue Common Stock Retained Earnings Dividends Sales Revenue Sales Discounts Cost of Goods Sold Rent Expense Salary Expense Supplies Expense Depreciation Expense Insurance Expense 3,000 2,290 50 0 10,000 7,760 14,000 64,000 1,000 28,000 4,600 6,200 4,200 0 2,000 87,100 Totals 87,100 Financial Statements San Antonio Home Furnishings Company Income Statement For the Eleven Months Ended, February 28, 2021 64,000 1,000 63,000 28.000 35,000 Sales Revenue Less: Sales Discounts Net Sales Cost of Goods Sold Gross Profit Expenses Rent Expense Salary Expense Supplies Expense Depreciation Expense Insurance Expense Total Expenses Net Income 4,600 6,200 4,200 0 2.000 17.000 18.000 7,760 San Antonio Home Furnishings Company Statement of Retained Earnings For the Eleven Months Ended, February 28, 2021 Retained Earnings, April 1, 2020 Plus Net Income Less Dividends Increase in Retained Earnings Retained Earnings, Feb. 28, 2021 18,000 14.000 4.000 11.760 San Antonio Home Furnishings Company Balance Sheet February 28, 2021 Liabilities Current Liabilities 6,000 Accounts Payable 2,290 5,000 Salaries Payable 50 8,000 Unearned Revenue 100 Total Current Liab 2,340 Assets Current Assets Cash Accounts Receivable Merchandise Inventory Supplies Prepaid Insurance Total Current Assets Plant Assets Office Equipment Less: Accum Depr Total Plant Assets Total Assets 19,100 8,000 3,000 Stockholder's Equity Common Stock Retained Earnings Total SE Total Liab & SE 10,000 11,760 5,000 24,100 21,760 24,100 March Transactions: Date Mar. 1 Mar. 1 Supplies are purchased for cash $400. Two years of insurance is purchased for cash, costing $1,800. Paid rent expense of $700 for current month. Supplies are purchased on account for $500. Mar. 2 Mar. 2 Mar. 3 Received cash from customers on account, $1,200. Mar. 4 Mar. 6 Mar. 7 Mar. 8 Mar. 9 Paid creditor on account, $650. Paid $900 of salary to employees, of which $50 is accrued from the prior month. Received $800 from a customer in advance of providing the service. Purchased merchandise from Sofa Co. on account, $12,000 terms FOB Shipping Point, 1/10, 1/30. Paid $500 to San Antonio Pickup Service for transportation cost in connection with the purchase from the Sofa Co. Sold merchandise on account to Osgood Co., $10.900, terms FOB Shipping Point, 2/10, 1/30. The cost of the goods sold was $6,500. Received a check from Osgood Co. for the sale on Mar. 9, less the discount. Paid Sofa Co. for the merchandise purchased on Mar. 8. less the discount. Dividends of $1,500 are paid. Mar. 9 Mar. 18 Mar. 18 Mar. 31 Additional Information for Adjusting Entries: (a) Supplies on hand at the end of the year, March 31, are $150. (6) Record one month of insurance expense for March 31. Depreciation of Equipment for the year, $1,200. D E F G H I J L M B 1 Adjusted Trial Balance as of March 31, 2021 2 Debit Credit 3 Cash 4 Accounts Receivable 5 Merchandise Inventory 6 Supplies 7 Prepaid Insurance 8 Equipment 9 Accummulated Depr. 10 Accounts Payable 11 Salary Payable 12 Unearned Revenue 13 Common Stock 14 Retained Earnings 15 Dividends 16 Sales Revenue 17 Sales Discount 18 Cost of Goods Sold 19 Rent Expense 20 Salary Expense 21 Supplies Expense 22 Depreciation Expense 23 Insurance Expense 24 Total (check amt. 26 San Antonio Home Furnishings Company 27 Income Statement 28 For the Year Ended March 31, 2021 29 Sales Revenue $ 30 Less: Sales Discounts $ 31 Net Sales S 32 Cost of Goods Sold $ 33 Gross Profit $ 34 Expenses: 35 Rent Expense $ 36 Salary Expense $ 37 Supplies Expense $ 38 Depreciation Expense $ 39 Insurance Expense $ 40 Total Expenses 41 Net Income (check amt. 43 San Antonio Home Furnishings Company 44 Statement of Retained Earnings 45 For the Year Ended March 31, 2021 46 Beg. Retained Earnings $ 47 Plus: Net Income $ 48 Less: Dividends $ 49 Change in Retained Earnings 50 End Retained Earnings (check amt. $ Cover Page Journal Page of T-Accounts Unadj. Trial Bal. Adj. Trial B. & Two Fin. Stat. Bal. Sheet and Post Closing T.P Instructions and Information for the Case Requirements: 1) Using the information given below (Trial Balance as of Feb. 28), enter the beginning balances in the T- Accounts in the Accounting Records Package. On page 2 note the format of the Financial Statements that were produced based on the Trial Balance as of Feb. 28 (single step income statement and classified balance sheet). 2) Use the descriptions of the March transactions which are on page 3 to journalize all of the entries for March in the journal provided in the Accounting Records Package. 3) Post each entry into the T-Accounts provided in the Accounting Records Package. When finished posting, calculate the account balance for each T-Account and enter the balance on the Unadjusted Trial Balance on the form provided. Then, use the information found on the bottom of page 3 and any account balance information that is needed to journalize and post the adjusting entries. Calculate each account balance. 4) Using the T-Account balances, create an Adjusted Trial Balance on the form provided in the Accounting Records Package 5) Using the provided templates in the Accounting Records Package, prepare the: a. Income Statement b. Statement of Retained Earnings c. Balance Sheet 6) Write the four closing entries in the journal and post them to the T-Accounts and calculate the ending balance for each account. 7) Create the Post Closing Trial Balance on the form provided in the Accounting Records Package. c. Credit Trial Balance as of February 28, 2021 Debit 6,000 5,000 8,000 100 0 8,000 Cash Accounts Receivable Merchandise Inventory Supplies Prepaid Insurance Equipment Accumulated Depreciation Accounts Payable Salaries Payable Unearned Revenue Common Stock Retained Earnings Dividends Sales Revenue Sales Discounts Cost of Goods Sold Rent Expense Salary Expense Supplies Expense Depreciation Expense Insurance Expense 3,000 2,290 50 0 10,000 7,760 14,000 64,000 1,000 28,000 4,600 6,200 4,200 0 2,000 87,100 Totals 87,100 Financial Statements San Antonio Home Furnishings Company Income Statement For the Eleven Months Ended, February 28, 2021 64,000 1,000 63,000 28.000 35,000 Sales Revenue Less: Sales Discounts Net Sales Cost of Goods Sold Gross Profit Expenses Rent Expense Salary Expense Supplies Expense Depreciation Expense Insurance Expense Total Expenses Net Income 4,600 6,200 4,200 0 2.000 17.000 18.000 7,760 San Antonio Home Furnishings Company Statement of Retained Earnings For the Eleven Months Ended, February 28, 2021 Retained Earnings, April 1, 2020 Plus Net Income Less Dividends Increase in Retained Earnings Retained Earnings, Feb. 28, 2021 18,000 14.000 4.000 11.760 San Antonio Home Furnishings Company Balance Sheet February 28, 2021 Liabilities Current Liabilities 6,000 Accounts Payable 2,290 5,000 Salaries Payable 50 8,000 Unearned Revenue 100 Total Current Liab 2,340 Assets Current Assets Cash Accounts Receivable Merchandise Inventory Supplies Prepaid Insurance Total Current Assets Plant Assets Office Equipment Less: Accum Depr Total Plant Assets Total Assets 19,100 8,000 3,000 Stockholder's Equity Common Stock Retained Earnings Total SE Total Liab & SE 10,000 11,760 5,000 24,100 21,760 24,100 March Transactions: Date Mar. 1 Mar. 1 Supplies are purchased for cash $400. Two years of insurance is purchased for cash, costing $1,800. Paid rent expense of $700 for current month. Supplies are purchased on account for $500. Mar. 2 Mar. 2 Mar. 3 Received cash from customers on account, $1,200. Mar. 4 Mar. 6 Mar. 7 Mar. 8 Mar. 9 Paid creditor on account, $650. Paid $900 of salary to employees, of which $50 is accrued from the prior month. Received $800 from a customer in advance of providing the service. Purchased merchandise from Sofa Co. on account, $12,000 terms FOB Shipping Point, 1/10, 1/30. Paid $500 to San Antonio Pickup Service for transportation cost in connection with the purchase from the Sofa Co. Sold merchandise on account to Osgood Co., $10.900, terms FOB Shipping Point, 2/10, 1/30. The cost of the goods sold was $6,500. Received a check from Osgood Co. for the sale on Mar. 9, less the discount. Paid Sofa Co. for the merchandise purchased on Mar. 8. less the discount. Dividends of $1,500 are paid. Mar. 9 Mar. 18 Mar. 18 Mar. 31 Additional Information for Adjusting Entries: (a) Supplies on hand at the end of the year, March 31, are $150. (6) Record one month of insurance expense for March 31. Depreciation of Equipment for the year, $1,200. D E F G H I J L M B 1 Adjusted Trial Balance as of March 31, 2021 2 Debit Credit 3 Cash 4 Accounts Receivable 5 Merchandise Inventory 6 Supplies 7 Prepaid Insurance 8 Equipment 9 Accummulated Depr. 10 Accounts Payable 11 Salary Payable 12 Unearned Revenue 13 Common Stock 14 Retained Earnings 15 Dividends 16 Sales Revenue 17 Sales Discount 18 Cost of Goods Sold 19 Rent Expense 20 Salary Expense 21 Supplies Expense 22 Depreciation Expense 23 Insurance Expense 24 Total (check amt. 26 San Antonio Home Furnishings Company 27 Income Statement 28 For the Year Ended March 31, 2021 29 Sales Revenue $ 30 Less: Sales Discounts $ 31 Net Sales S 32 Cost of Goods Sold $ 33 Gross Profit $ 34 Expenses: 35 Rent Expense $ 36 Salary Expense $ 37 Supplies Expense $ 38 Depreciation Expense $ 39 Insurance Expense $ 40 Total Expenses 41 Net Income (check amt. 43 San Antonio Home Furnishings Company 44 Statement of Retained Earnings 45 For the Year Ended March 31, 2021 46 Beg. Retained Earnings $ 47 Plus: Net Income $ 48 Less: Dividends $ 49 Change in Retained Earnings 50 End Retained Earnings (check amt. $ Cover Page Journal Page of T-Accounts Unadj. Trial Bal. Adj. Trial B. & Two Fin. Stat. Bal. Sheet and Post Closing T.P