Excel Assessment: In this assignment, you will demonstrate your knowledge and competencies to use Excel to solve an accounting problem. Approximately 50% of your grade will be based on correct use of Excel and the remaining 50% will be based on your ability to create a Statement of Cash Flows using both the direct & indirect methods.
Instructions:
1) Use the Comparative Balance Sheets & the Income Statement along with the additional information included in the tabs below to prepare a Statement of Cash Flows using the Direct Method. Place your answer on the Direct Method tab of this spreadsheet.
2) Use the Comparative Balance Sheets & the Income Statement along with the additional information below to prepare a Statement of Cash Flows using the Indirect Method. Place your answer on the Indirect Method tab of this spreadsheet.
3) Use the Excel formula function for all computations.
4) Do not copy and paste figures from the Balance Sheets or Income Statement when preparing the Statement of Cash Flows. Instead, reference data from one sheet to another using Excel formulas..
Attachment:- excelassessment.xlsx