Business Finance Homework Help

CSU Reportable Segment Identification Excel Spreadsheet

 

Option #1: Reportable Segment Identification

A company has five business units that may be reportable as business segments. Data for these entities is as follows:

A ($000)
B
C D E
Sales $621 $853 $1,237 $2,832 $4,720
Profit 103 (218) 832 1.337 (583)
Assets 1,200 2,780 2,324 4,280 8,321

Submission Requirements:

  • Using the ACT470_Mod06-Option01.xlsx Excel spreadsheet in the Module 6 folder, identify the threshold base for each category above and signify (yes/no) if each business segment is reportable by category.
  • Review the grading rubric following this assignment, to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.