Total of All Cash Inflows

I have provided the excel worksheet with the below questions that are needed to be answered which are rows 12-17(columns b -g). Thanks for your help

 

Question 7: Calculate the following Cash Flow Ratios: Net Income/Total Cash from Operations and Total Cash from Operations/Total of All Cash Inflows. Did the company receive a net cash inflow from Financing or from Sale of Investments?

Question 8: Calculate the following ratios using the Income Statement and Balance Sheet: Return on Equity (Net Income/Total Shareholder Equity), Profit Margin (Net Income/Revenues), Total Asset Turnover (Revenues/Total Assets), and the Equity Multiplier (Total Assets/Shareholder Equity). Notice that Return on Equity is the same as the multiplication of the next three ratios.

  • mba620_proj2_step4_1.xlsx