Instructions: Note that you cannot alter the struction of this workbook 1. Use the solution tab to answer this question 2. Fill the highlighted cells in the solution tab 3. The wider cells (column B) have dropdown options, select the appropriate one 4. Column D is for your number/amount 5. The formulas are preset. Just input your numbers! 6. Save file name using your full name 7. Submit via blackboard Liabilities and Stockholders' Equity \begin{tabular}{|l|r|r|r|} \hline Accounts payable & $112,000 & $67,300 \\ \hline Accrued expenses payable & 16,500 & 17,000 \\ \hline Bonds payable & 110,000 & 150,000 \\ \hline Common stock & 220,000 & 175,000 \\ \hline Retained earnings & 224,000 & 105,450 \\ \hline Total & $682,500 & $514,750 \\ \hline \hline \end{tabular} The following information pertain to Lehman College net income: \begin{tabular}{l|lr|} \hline Sales revenue & $454,707 \\ \hline Sales discount & $56,240 \\ \hline Sales return and allowance & $5,687 \\ \hline Beginning inventory & $251,890 \\ \hline Purchases & $511,692 \\ \hline Ending inventory & $628,122 \\ \hline Operating expenses, including depreciation of $46,500 & $58,910 \\ \hline Income tax expense & $27,280 \\ \hline Interest expense & $4,730 \\ \hline Loss on disposal of plant assets & $7,500 \\ \hline \end{tabular} Additional data: 1. New equipment costing $85,000 was purchased for cash during the year 2. Old equipment having an original cost of $57,000 was sold for $1,500 cash 3 . Bonds matured and were paid off at face value for cash 4. A cash dividend of $40,350 was declared and paid during the year Instructions Preapare a statement of cash flows using the indirect method