Accounting Question

Overview

1. In your text, go through Chapter 3 ST1 through ST5 (pages 104-105). Use the Excel file M2_Problem_Set_Exce Download M2_Problem_Set_Excel that I provide and the formula sheet in the book to make the calculations. Be sure to use cell references. (50 pts) (MLO1, MLO2)
   • See Assigned Readings “Related to Excel Basics for Problem Set” for tutorials on entering formulas in Excel.
   • Note: You can skip ST3. part D if you want with no penalty.
2. Write one sentence (in the Excel File) next to each ratio you calculated in Question 1 describing what that number means in words. (50 pts) MLO1)
   • For example, if you calculate the average collection period as 40, you should write something like “on average, it takes 40 days for Freemont Corporation to collect its accounts receivable.”
3. Submit your modified Excel file when you have completed the project by 11:59 PM ET Sunday.