Excel Data File:

Use the following items to prepare a balance sheet and a cash flow statement. Determine the total assets, total liabilities, net worth, total cash inflows, and total cash outflows. (Omit the "\$" sign in your response.) picture Click here for the Excel Data File \begin{tabular}{|l|r|l|r|} \hline Rent for the month & $1,410 & Auto insurance & $322 \\ \hline Monthly take-home salary & 3,740 & Household possessions & 3,940 \\ \hline Cash in chequing account & 650 & Stereo equipment & 3,110 \\ \hline Savings account balance & 2,860 & Payment for electricity & 97 \\ \hline Spending for food & 1040 & Lunches/parking at work & 238 \\ \hline Balance of educational loan & 2,320 & Donations & 113 \\ \hline Current value of automobile & 7,960 & Home computer & 2,330 \\ \hline Telephone bill paid for month & 70 & Value of stock investment & 1170 \\ \hline Credit card balance & 265 & Clothing purchase & 141 \\ \hline Loan payment & 98 & Restaurant spending & 211 \\ \hline \end{tabular}