Prepare the statement of cash flows.

Please format into excel table, and analyze the statement of cash flows.

Statement of Retained Earnings For Current Year Ended December 31 \begin{tabular}{l|c} Retained Earnings, Last Year & 123370 \\ \hline Add: Net Income & 26,590 \\ \hline Less: Dividends paid & -70500 \\ \hline Ending Retained Earnings & 79,460 \\ \hline \end{tabular} CLASSIFIED Balance Sheet For Years Ended December 31 Building, Book Value Land Total Property, Plant and Equipment TOTAL ASSETS 214,000100,000339,500$1,072,004 \begin{tabular}{r|rr} 220,000 & (6,000.00) & 2.7% \\ 150,000 & (50,000.00) & 33.3% \\ \hline 386,600 & (47,100.00) & 12.2% \end{tabular} Current Liabilities: Accounts payable Salaries payable FICA Taxes payable Federal Income Tax Withheld Payable Total Current Liabilities Long Term Liabilities: Bonds payable (due 2030) Less: Discount on Bonds Payab Bonds Payable, Carrying value Notes Payable (due in 2 years) Total Long Term Liabilities Total Liabilities Paid in capital: Common Stock, \$2 par - 200,000 shares authorized, 100,000 shares issued and Paid in capital in excess of par, Comme Total Paid in Capital Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES AND EQUITY 70,000680,00079,460759,460$1,072,004 \begin{tabular}{r|r|r|} \hline & 10,000.00 & 14.3% \\ \hline 595,000 & 155,000.00 & 14.3% \\ \hline 123,370 & (43,910.00) & 35.6% \\ \hline 718,370 & 41,090.00 & 5.7% \\ \hline$1,022,550 & & \\ \hline \hline \end{tabular} Statement of Cash Flows For Current Year Ended December 31 Cash flows from Operating activities: Net Income Adjustments to reconcile net income to net cash: Depreciation expense - bldg Depreciation expense - equip Gain on sale of equipment Loss on sale of land Notes Receivable (due in 6 months) Merchandise Inventory Supplies Accounts payable Salaries payable FICA Taxes payable Federal Income Tax Withheld Payable Total Adjustments Net Cash provided (or used) by Operating activities Cash flows from Investing activities: Cash received from sale of equipment Cash paid for new equipment Cash received from sale of land Net Cash provided (or used) by Investing activities Cash flows from Financing activities: Cash received from issuing bonds Cash paid on notes payable Cash received from issuing stock Cash paid for dividends Net Cash provided (or used) by Financing activities NET INCREASE (or DECREASE) IN CASH ADD: CASH BALANCE, LAST YEAR ENDING CASH BALANCE, CURRENT YEAR formula-do not change Analyze your company's Statement of Cash Flows 4. Prepare the Statement of Cash Flows and explain what it tells you about your company. You will use the financial statements as well as the following information for the current year: a. Sold old equipment with a book value of $10,700 for $9,500 cash cash providing a the gain on sale of equipment of $1,200. b. Purchased new equipment for $30,000 cash. c. Sold a $50,000 plot of land for $49,500 cash providing a $500 loss on sale of land. d. Bonds were issued for $75,000 cash e. Notes payable payment of $25,000 was made in cash. No new notes were issued this year. f. Common stock was issued for $85,000 cash g. Dividends of $67,500 were paid in cash. Statement of Retained Earnings For Current Year Ended December 31 \begin{tabular}{l|c} Retained Earnings, Last Year & 123370 \\ \hline Add: Net Income & 26,590 \\ \hline Less: Dividends paid & -70500 \\ \hline Ending Retained Earnings & 79,460 \\ \hline \end{tabular} CLASSIFIED Balance Sheet For Years Ended December 31 Building, Book Value Land Total Property, Plant and Equipment TOTAL ASSETS 214,000100,000339,500$1,072,004 \begin{tabular}{r|rr} 220,000 & (6,000.00) & 2.7% \\ 150,000 & (50,000.00) & 33.3% \\ \hline 386,600 & (47,100.00) & 12.2% \end{tabular} Current Liabilities: Accounts payable Salaries payable FICA Taxes payable Federal Income Tax Withheld Payable Total Current Liabilities Long Term Liabilities: Bonds payable (due 2030) Less: Discount on Bonds Payab Bonds Payable, Carrying value Notes Payable (due in 2 years) Total Long Term Liabilities Total Liabilities Paid in capital: Common Stock, \$2 par - 200,000 shares authorized, 100,000 shares issued and Paid in capital in excess of par, Comme Total Paid in Capital Retained Earnings Total Stockholder's Equity TOTAL LIABILITIES AND EQUITY 70,000680,00079,460759,460$1,072,004 \begin{tabular}{r|r|r|} \hline & 10,000.00 & 14.3% \\ \hline 595,000 & 155,000.00 & 14.3% \\ \hline 123,370 & (43,910.00) & 35.6% \\ \hline 718,370 & 41,090.00 & 5.7% \\ \hline$1,022,550 & & \\ \hline \hline \end{tabular} Statement of Cash Flows For Current Year Ended December 31 Cash flows from Operating activities: Net Income Adjustments to reconcile net income to net cash: Depreciation expense - bldg Depreciation expense - equip Gain on sale of equipment Loss on sale of land Notes Receivable (due in 6 months) Merchandise Inventory Supplies Accounts payable Salaries payable FICA Taxes payable Federal Income Tax Withheld Payable Total Adjustments Net Cash provided (or used) by Operating activities Cash flows from Investing activities: Cash received from sale of equipment Cash paid for new equipment Cash received from sale of land Net Cash provided (or used) by Investing activities Cash flows from Financing activities: Cash received from issuing bonds Cash paid on notes payable Cash received from issuing stock Cash paid for dividends Net Cash provided (or used) by Financing activities NET INCREASE (or DECREASE) IN CASH ADD: CASH BALANCE, LAST YEAR ENDING CASH BALANCE, CURRENT YEAR formula-do not change Analyze your company's Statement of Cash Flows 4. Prepare the Statement of Cash Flows and explain what it tells you about your company. You will use the financial statements as well as the following information for the current year: a. Sold old equipment with a book value of $10,700 for $9,500 cash cash providing a the gain on sale of equipment of $1,200. b. Purchased new equipment for $30,000 cash. c. Sold a $50,000 plot of land for $49,500 cash providing a $500 loss on sale of land. d. Bonds were issued for $75,000 cash e. Notes payable payment of $25,000 was made in cash. No new notes were issued this year. f. Common stock was issued for $85,000 cash g. Dividends of $67,500 were paid in cash