For this assignment you will be preparing all four financial statements for Dress Right Clothing Corporation. All of the information needed to prepare the statements has been provided on the trial balance tab of the Excel Project 3 Excel file. You must follow the correct format of the statements as shown in your ACC 200 textbook. 2 From the Trial Balance tab, use the information provide to prepare an Income Statement. Use Cell references for the account names as well as the dollar amount balances needed to complete the statement. It is very important to prepare an accurate Income Statement with correct numbers. 3 On the Statement of SHE tab, prepare a Statement of Stockholders' Equity. Use cell references and or formulas to prepare the statement. Information that is required from the Trial Balance and Income Statement be referenced using a cell reference. Any balances that need to be calculated should be formulas. It is very important to prepare an accurate Statement of Stockholders Equity with correct numbers. 4 On the Balance Sheet tab, prepare a Balance Sheet. Use cell references for the account descriptions (from the trial balance) and for the amounts. Use formulas to add where needed. A template has been provided for you. It is very important to prepare an accurate Balance Sheet with correct numbers. 5 On the Statement of Cash Flows tab, prepare a Statement of Cash Flows. A template has been provided for you to populate with the required information. All of the information for the preparation of the Statement of Cash Flows can be found on the Trial Balance, the Income Statement, and the Statement of Stockholders' Equity. Use cell references for the amounts to be used to prepare the statement. Use formulas where needed. For the change in the Balance Sheet accounts, the information has been provided for you in Column E in the trial balance tab. Use the descriptions for the adjustments in the operating section of the cash flow statement. As found in your ACC 200 textbook. Use cell references for the amounts and formulas where necessary. It is very important to prepare an accurate Statement of Cash Flows with correct numbers.

\begin{tabular}{|c|c|c|c|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c|}{ D } & C \\ \hline 1 & \multicolumn{1}{|c|}{ Dress Right Clothing } \\ \hline 2 & \multicolumn{1}{|c|}{ Income Statement } \\ \hline 3 & \multicolumn{1}{|c|}{ For the Year Ended December 31, 2022} \\ \hline 4 & & \\ \hline 5 & & \\ \hline 6 & Revenues: & & \\ \hline 7 & Sales Revenue & & \\ \hline 8 & Cost of Goods Sold & & \\ \hline 9 & Gross Profit & & \\ \hline 10 & & & \\ \hline \end{tabular} Operating Expenses: Other Income \& Expenses: Net Income \begin{tabular}{|r|r|} \hline & 0 \\ \cline { 2 } & \\ \hline \multicolumn{1}{|r}{} & 0 \\ \hline & \\ \hline & \\ \hline \hline \end{tabular} A4 fx 2 Statement of Stockholders' Equity 3 For the year ended December 31, 2022 \begin{tabular}{|c|c|c|c|c|} \hline 4 & & & & Total \\ \hline 5 & & Common & Retained & Stockholders' \\ \hline 6 & & Stock & Earnings & Equity \\ \hline 7 & Beginning of year balance & $23,800 & & \\ \hline 8 & Issuance of Common Stock & 36,200 & & \\ \hline 9 & Net Income & & & \\ \hline 10 & Dividends & & & \\ \hline 11 & & & & \\ \hline 12 & End of year balance & $60,000 & & \\ \hline & & & & \\ \hline \hline \end{tabular} D6 ^fx Liabilities B6 fx= IIncome Statement'!C25 \begin{tabular}{|c|c|c|c|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c|}{ D } & C \\ \hline 1 & \multicolumn{1}{|c|}{ Dress Right Clothing } \\ \hline 2 & \multicolumn{1}{|c|}{ Income Statement } \\ \hline 3 & \multicolumn{1}{|c|}{ For the Year Ended December 31, 2022} \\ \hline 4 & & \\ \hline 5 & & \\ \hline 6 & Revenues: & & \\ \hline 7 & Sales Revenue & & \\ \hline 8 & Cost of Goods Sold & & \\ \hline 9 & Gross Profit & & \\ \hline 10 & & & \\ \hline \end{tabular} Operating Expenses: Other Income \& Expenses: Net Income \begin{tabular}{|r|r|} \hline & 0 \\ \cline { 2 } & \\ \hline \multicolumn{1}{|r}{} & 0 \\ \hline & \\ \hline & \\ \hline \hline \end{tabular} A4 fx 2 Statement of Stockholders' Equity 3 For the year ended December 31, 2022 \begin{tabular}{|c|c|c|c|c|} \hline 4 & & & & Total \\ \hline 5 & & Common & Retained & Stockholders' \\ \hline 6 & & Stock & Earnings & Equity \\ \hline 7 & Beginning of year balance & $23,800 & & \\ \hline 8 & Issuance of Common Stock & 36,200 & & \\ \hline 9 & Net Income & & & \\ \hline 10 & Dividends & & & \\ \hline 11 & & & & \\ \hline 12 & End of year balance & $60,000 & & \\ \hline & & & & \\ \hline \hline \end{tabular} D6 ^fx Liabilities B6 fx= IIncome Statement'!C25