Options for "Accounts titles for retained earnings":

Cont:

Plus/Minus options for each entry on the left side.

Options for the left side: accounts payable, accounts receivable, cash, common stock, dividends, insurance expense, prepaid insurance, pre-paid rent, rent expense, retained earnings, salaries expense, salaries payable, utilities expense

Choices for the left side text box:

Last text box - above "ending cash balance": "Plus: beginning cash balance" or "Less: Begining cash balance"

Format it the way it's displayed in the images - Please insure the formatting isn't confusing in the final post - some tables are incorrectly made and hard to understand where the numbers are supposed to be placed, please show me where the numbers are coming from and how you came to the solution. If possible, replicate these tables in excel and format them the same way as shown in the photos.

Required information Exercise 2-3A (Static) Effect of accruals on the financial statements LO 2-1, 2-2, 2-3 [The following information applies to the questions displayed below.] Milea Inc. experienced the following events in Year 1, its first year of operations: 1. Received $20,000 cash from the issue of common stock. 2. Performed services on account for $56,000. 3. Paid the utility expense of $2,500. 4. Collected $48,000 of the accounts receivable. 5. Recorded $10,000 of accrued salaries at the end of the year. 6. Paid a $2,000 cash dividend to the stockholders. Exercise 2-3A (Static) Part a Required a. Record the events in general ledger accounts under an accounting equation. In the last column of the table, provide appropriate account titles for the Retained Earnings amounts. The first transaction has been recorded as an example. (If there is no effect on the Account Titles for Retained Earnings, leave the cell blank. Not all cells will require input. Enter any decreases to account balances with a minus sign.) Accounts Titles for Retained Earnings Dividend Revenue Salaries expense Utility expense Prepare the income statement for the Year 1 accounting period MILEA INC. Statement of Changes in Stockholders' Equity For the Year Ended December 31, Year 1 \begin{tabular}{|l|r|r|} \hline Beginning common stock & & \\ \hline Plus: Common stock issued & 20,000 & \\ \hline Ending common stock & $ & $20,000 \\ \hline Beginning retained earnings & 43,500 & \\ \hline Plus: Net income & 2,000 & \\ \hline \hline Less: Dividend & & 41,500 \\ \hline Ending retained earnings & & $61,500 \\ \hline Total stockholders' equity & & \\ \hline \hline \end{tabular} Prevare the balance sheet for the Year 1 accountina Deriod. Srepare the statement of cash flows for the Year 1 accounting period. (Enter cash outflows with a minus sign.) Cash paid for expenses Cash received from customers Issue of stock Paid dividend