| The Unit 4 Assignment is worth 40 Points. |
| Notes: |
| 1) Some of the ratios do NOT have sufficient data to compute a ratio. |
| In those ratios, simply type "Insufficient data to Compute". |
| The objective is to provide you an opportunity to employ critical thinking. |
| You need to be able to discern whether or not all elements are present. |
| 2) In the ratios that require an "Average" - assume that the BEGINNING Account Balance = - 0-. |
| 3) Remember, .50% is NOT the same as 50%. |
| 4) Use all transactions that include "Sales on Account" as "Net Credit Sales". |
| 5) Be sure to include your formulas in the proper cell. If you simply input an answer, feedback may be limited. |
| If you include your computations, additional feedback will be possible when an incorrect answer is given. |
| 6) Complete all ratios in all 3 sections - Parts A, B & C. There are 4 ratios in Part A, 2 in Part B, and 3 in Part C. |
Sky1011
Unit4_Financial_Report_Analysis_Template.xlsx
