\begin{tabular}{|c|c|c|c|c|c|c|} \hline Takes & 1,120 & 4,858 & 8,483 & 10,908 & 11,598 & 12,968 \\ \hline Net Earnings & 2,474 & 11,791 & 21,075 & 26,713 & 28,227 & 33,346 \\ \hline \multicolumn{7}{|l|}{ Balance Sheet } \\ \hline Assets & & & & & & \\ \hline Cash & 167.971 & 181,210 & 183,715 & 211,069 & 239,550 & 272,530 \\ \hline Accounts Receivable & 5,100 & 5.904 & 6,567 & 7,117 & 7,539 & 7,807 \\ \hline Inventory & 7,805 & 9,601 & 9.825 & 10,531 & 11,342 & 11,715 \\ \hline Property \& Equipment & 45,500 & 42,350 & 40,145 & 38,602 & 37,521 & 37,513 \\ \hline Total Assets & 226,376 & 239,065 & 240,252 & 267,319 & 295,951 & 329,564 \\ \hline Liabilities & & & & & & \\ \hline Accounts Payable & 3,902 & 4,800 & 4,912 & 5,265 & 5,671 & 5,938 \\ \hline Debt & 50,000 & 50,000 & 30,000 & 30,000 & 30,000 & 30,000 \\ \hline \begin{tabular}{l} Total Liabilities \\ Shareholder's Equity \end{tabular} & 53,902 & 54.800 & 34,912 & 35,265 & 35,671 & 35,938 \\ \hline Equity Capital & 170,000 & 170,000 & 170,000 & 170,000 & 170,000 & 170,000 \\ \hline Retained Earnings & 2,474 & 14,265 & 35,340 & 62,053 & 90,280 & 123,627 \\ \hline Shareholder's Equity & 172,474 & 184,265 & 205,340 & 232,053 & 260,280 & 293,627 \\ \hline Total Liabilities \& Shareholder & 226,376 & 239,065 & 240,252 & 267,319 & 295,951 & 329,564 \\ \hline \multicolumn{7}{|l|}{ Cash Flow Statement } \\ \hline Operating Cash Flow & & & & & & \\ \hline Net Earnings & 2.474 & 11,791 & 21,075 & 26,713 & 28,227 & 33,346 \\ \hline Plus: Depreciation \& Amortization & 19,500 & 18,150 & 17,205 & 16,544 & 16,080 & 15,008 \\ \hline Less: Changes in Working Capital & 9.003 & 1,702 & 775 & 903 & 827 & 375 \\ \hline Cash from Operations & 12,971 & 28,239 & 37,505 & 42,354 & 43,480 & 47.980 \\ \hline \multicolumn{7}{|l|}{ Investing Cash Flow } \\ \hline Investments in Property \& Equipment & 15,000 & 15,000 & 15,000 & 15,000 & 15,000 & 15,000 \\ \hline Cash from Investing & 15,000 & 15,000 & 15,000 & 15,000 & 15,000 & 15,000 \\ \hline \multicolumn{7}{|l|}{ Financing Cash Flov } \\ \hline Issuance (repayment) of debt & - & - & (20,000) & - & - & - \\ \hline Issuance (repayment) of equity & 170,000 & - & + & - & - & - \\ \hline Cash from Finanoing & 170,000 & - & 20,000) & & & \\ \hline Net Increase (decrease) in Cash & 167.971 & 13,239 & 2.505 & 27,354 & 28,480 & 32,980 \\ \hline Opening Cash Balance & - & 167.971 & 181.210 & 183,715 & 211.069 & 239,550 \\ \hline Closing Cash Balance & 167.971 & 181,210 & 183,715 & 211,069 & 239,550 & 272,530 \\ \hline \end{tabular} Assignment Chapter 17, Understanding Accounting and Financial Information - 1.5pt for each (full) correct answer below Whenever calculations are involved, include the calculations in your response. Using the statements provided for this assignment above, indicate the impact of each of these activities on the Balance Sheet for the following: 1. The company buys $400 inventory in 2018 and pays it in cash. 2. The company buys $600 inventory in 2018 and pays it in credit (accounts payable). 3. The company spends $500 on new property, and pays for it in $200 cash and the rest in long term debt. 4. The company returns $200 of its inventory to the original supplier, and gets a full refund from the supplier in cash 5. The company returns $200 of its inventory to the original supplier, and gets a refund from the supplier in credit (accounts payable). 6. A major company pays $300 in cash from the amounts that it owes to the company. 7. The company secures $700 in cash capital infusion from an outside investor. 8. The company secures a new $800 cash loan from a bank. Remember, in all cases: Assets = Liabilities + Owner's (or Shareholder's) Equity Calculate (AND show CALCULATIONS!) the following from the 2015 income statement (and balance sheet whenever needed) - see link above: 9. The Gross profit margin (\%) in 2015 10. Is the Gross Profit Margin increasing or declining in 2015 versus 2014? Don't just give an opinion - calculate and compare! 11. The Debt ratio in 2015 (See Debt ratio definition in the lecture PowerPoint presentation) 12. Is this Debt ratio healthy (based on the explanation given in the lecture as well as the PowerPoint presentation)? 13. The Net profit margin in 2015 14. The Inventory Turnover at the end of 2015 \begin{tabular}{|c|c|c|c|c|c|c|} \hline Takes & 1,120 & 4,858 & 8,483 & 10,908 & 11,598 & 12,968 \\ \hline Net Earnings & 2,474 & 11,791 & 21,075 & 26,713 & 28,227 & 33,346 \\ \hline \multicolumn{7}{|l|}{ Balance Sheet } \\ \hline Assets & & & & & & \\ \hline Cash & 167.971 & 181,210 & 183,715 & 211,069 & 239,550 & 272,530 \\ \hline Accounts Receivable & 5,100 & 5.904 & 6,567 & 7,117 & 7,539 & 7,807 \\ \hline Inventory & 7,805 & 9,601 & 9.825 & 10,531 & 11,342 & 11,715 \\ \hline Property \& Equipment & 45,500 & 42,350 & 40,145 & 38,602 & 37,521 & 37,513 \\ \hline Total Assets & 226,376 & 239,065 & 240,252 & 267,319 & 295,951 & 329,564 \\ \hline Liabilities & & & & & & \\ \hline Accounts Payable & 3,902 & 4,800 & 4,912 & 5,265 & 5,671 & 5,938 \\ \hline Debt & 50,000 & 50,000 & 30,000 & 30,000 & 30,000 & 30,000 \\ \hline \begin{tabular}{l} Total Liabilities \\ Shareholder's Equity \end{tabular} & 53,902 & 54.800 & 34,912 & 35,265 & 35,671 & 35,938 \\ \hline Equity Capital & 170,000 & 170,000 & 170,000 & 170,000 & 170,000 & 170,000 \\ \hline Retained Earnings & 2,474 & 14,265 & 35,340 & 62,053 & 90,280 & 123,627 \\ \hline Shareholder's Equity & 172,474 & 184,265 & 205,340 & 232,053 & 260,280 & 293,627 \\ \hline Total Liabilities \& Shareholder & 226,376 & 239,065 & 240,252 & 267,319 & 295,951 & 329,564 \\ \hline \multicolumn{7}{|l|}{ Cash Flow Statement } \\ \hline Operating Cash Flow & & & & & & \\ \hline Net Earnings & 2.474 & 11,791 & 21,075 & 26,713 & 28,227 & 33,346 \\ \hline Plus: Depreciation \& Amortization & 19,500 & 18,150 & 17,205 & 16,544 & 16,080 & 15,008 \\ \hline Less: Changes in Working Capital & 9.003 & 1,702 & 775 & 903 & 827 & 375 \\ \hline Cash from Operations & 12,971 & 28,239 & 37,505 & 42,354 & 43,480 & 47.980 \\ \hline \multicolumn{7}{|l|}{ Investing Cash Flow } \\ \hline Investments in Property \& Equipment & 15,000 & 15,000 & 15,000 & 15,000 & 15,000 & 15,000 \\ \hline Cash from Investing & 15,000 & 15,000 & 15,000 & 15,000 & 15,000 & 15,000 \\ \hline \multicolumn{7}{|l|}{ Financing Cash Flov } \\ \hline Issuance (repayment) of debt & - & - & (20,000) & - & - & - \\ \hline Issuance (repayment) of equity & 170,000 & - & + & - & - & - \\ \hline Cash from Finanoing & 170,000 & - & 20,000) & & & \\ \hline Net Increase (decrease) in Cash & 167.971 & 13,239 & 2.505 & 27,354 & 28,480 & 32,980 \\ \hline Opening Cash Balance & - & 167.971 & 181.210 & 183,715 & 211.069 & 239,550 \\ \hline Closing Cash Balance & 167.971 & 181,210 & 183,715 & 211,069 & 239,550 & 272,530 \\ \hline \end{tabular} Assignment Chapter 17, Understanding Accounting and Financial Information - 1.5pt for each (full) correct answer below Whenever calculations are involved, include the calculations in your response. Using the statements provided for this assignment above, indicate the impact of each of these activities on the Balance Sheet for the following: 1. The company buys $400 inventory in 2018 and pays it in cash. 2. The company buys $600 inventory in 2018 and pays it in credit (accounts payable). 3. The company spends $500 on new property, and pays for it in $200 cash and the rest in long term debt. 4. The company returns $200 of its inventory to the original supplier, and gets a full refund from the supplier in cash 5. The company returns $200 of its inventory to the original supplier, and gets a refund from the supplier in credit (accounts payable). 6. A major company pays $300 in cash from the amounts that it owes to the company. 7. The company secures $700 in cash capital infusion from an outside investor. 8. The company secures a new $800 cash loan from a bank. Remember, in all cases: Assets = Liabilities + Owner's (or Shareholder's) Equity Calculate (AND show CALCULATIONS!) the following from the 2015 income statement (and balance sheet whenever needed) - see link above: 9. The Gross profit margin (\%) in 2015 10. Is the Gross Profit Margin increasing or declining in 2015 versus 2014? Don't just give an opinion - calculate and compare! 11. The Debt ratio in 2015 (See Debt ratio definition in the lecture PowerPoint presentation) 12. Is this Debt ratio healthy (based on the explanation given in the lecture as well as the PowerPoint presentation)? 13. The Net profit margin in 2015 14. The Inventory Turnover at the end of 2015