Question: HELP, I need the formulas for the things that I'm missing on excel. Thanks! The adjusted trial balance for M Company as of December 31,2023

HELP, I need the formulas for the things that I'm missing on excel. Thanks!

HELP, I need the formulas for the things that I'm missing onexcel. Thanks! The adjusted trial balance for M Company as of December31,2023 is presented below. REQUIRED: Prepare an income statement and statement ofretained earnings for the yearended December 31. Prepare a classified balance sheet

The adjusted trial balance for M Company as of December 31,2023 is presented below. REQUIRED: Prepare an income statement and statement of retained earnings for the yearended December 31. Prepare a classified balance sheet as of December 31 . This is the company's first year of operations. All yellow cells require either an account title or a valid formula. All totals must include the SUM function. \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ M Company } \\ \hline \multicolumn{2}{|c|}{ Statement of Retained Earnings } \\ \hline \multicolumn{2}{|c|}{ For the Year Ended December 31, 2023 } \\ \hline Retained earnings, January 1, 2023 & & 0 \\ \hline Net income & & 27,340 \\ \hline Dividends & & \\ \hline Retained earnings, December 31, 2023 & & \\ \hline & & \\ \hline \end{tabular} Your score: 64% \begin{tabular}{|l|l|r|} \hline \multicolumn{1}{|c|}{ Equity } & & 167,860 \\ \hline Common stock & & \\ \hline Retained earnings & & \\ \hline Total equity & & \\ \hline Total liabilities and equity & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!