Excel Workbook Assignment
A. Create the Statement of Cash Flows using the Indirect Method from the information provided. Include the required supplemental information regarding interest and taxes, and include any significant non-cash transactions (40 points-graded for accuracy and format, including Excel spreadsheet links).
B. (1) Calculate the Operating Cash Flows to Net Sales Ratio; the Operating Income to Net Sales Ratio; and the Net Income to Net Sales Ratio;
(2) Calculate the Operating Cash Flow on Total Assets Ratio and the Return on Total Assets Ratio. Be sure to use Average Total Assets in your denominator for these last two ratios (10 points-graded for accuracy and format, including Excel spreadsheet links).
Attachment:- Excel Workbook.rar