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 limit
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 Pa