231|EXCEL – Cougar Equipment Trial Balance

[Kambrie_Earl]

Time to Complete: 1hr
Rating: Difficult
Solution:
Net Profit Margin = 24.44%
=SUM(‘Journal Entries’!L21:L40)/SUM(‘Journal Entries’!L21:L23)

Current Ratio: 3.57
=ABS(SUM(‘Journal Entries’!L6:L10)/SUM(‘Journal Entries’!L16:L17))

ROA: 47.80%
=ABS(SUM(‘Journal Entries’!L21:L40)/SUM(‘Journal Entries’!L6:L15))

Debt to Equity Ratio: 1.32
=ABS(SUM(‘Journal Entries’!L16:L18)/SUM(‘Journal Entries’!L19:L20))

Inventory Turnover: 7.19
=ABS(‘Journal Entries’!L29/‘Journal Entries’!L9)

ROE: 212.67%
=(SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40))/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”)

[Kibson_Elmore]

Time to complete: 1 hr
Rating: Medium
Solution:
Challenge231_Data.xlsx (220.0 KB)

[James_Bryner]

TIme to complete: 45 Minutes
Difficulty: Medium
The concepts weren’t hard, but it was repetitive and slow.

[James_Bryner]

Solution:

Net Profit Margin = 24.44%
=SUM(‘Journal Entries’!L21:L40)/SUM(‘Journal Entries’!L21:L23)

Current Ratio: 3.57
=ABS(SUM(‘Journal Entries’!L6:L10)/SUM(‘Journal Entries’!L16:L17))

ROA: 47.80%
=ABS(SUM(‘Journal Entries’!L21:L40)/SUM(‘Journal Entries’!L6:L15))

Debt to Equity Ratio: 1.32
=ABS(SUM(‘Journal Entries’!L16:L18)/SUM(‘Journal Entries’!L19:L20))

Inventory Turnover: 7.19
=ABS(‘Journal Entries’!L29/‘Journal Entries’!L9)

ROE: 212.67%
=(SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40))/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”)

[Easton_Edwards]

Time to complete: 45 minutes
Rating: intermediate

Solution:
Net Profit Margin: 24.44%
=SUMIF(‘Journal Entries’!J6:J40, “>4000”, ‘Journal Entries’!L6:L40)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!J6:J40,“<5000”)

Current Ratio: 3.57
=SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>1100”,‘Journal Entries’!J6:J40,“<1200”)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2100”,‘Journal Entries’!J6:J40,“<2200”)

ROA: 47.8%
=SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>1000”,‘Journal Entries’!J6:J40,“<2000”)

Debt to Equity Ratio: 1.32
=SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2000”,‘Journal Entries’!J6:J40,“<3000”)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”)

Inventory Turnover: 7.19
=‘Journal Entries’!L29/‘Journal Entries’!L9

ROE: 212.67%
=SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”)

[Kailani_Schulthies]

Time to Complete: 30 minutes
Rating: Intermediate
Solution:
Net Profit Margin = 24.44%
=SUM(‘Journal Entries’!L21:L40)/SUM(‘Journal Entries’!L21:L23)

Current Ratio: 3.57
=ABS(SUM(‘Journal Entries’!L6:L10)/SUM(‘Journal Entries’!L16:L17))

ROA: 47.80%
=ABS(SUM(‘Journal Entries’!L21:L40)/SUM(‘Journal Entries’!L6:L15))

Debt to Equity Ratio: 1.32
=ABS(SUM(‘Journal Entries’!L16:L18)/SUM(‘Journal Entries’!L19:L20))

Inventory Turnover: 7.19
=ABS(‘Journal Entries’!L29/‘Journal Entries’!L9)

ROE: 212.67%
=(SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40))/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”)

[Vincent_Hamer]

Time to complete: 45 min
Difficulty: Medium-hard

Net Profit Margin: 24.44%
=ABS(SUMIF(TB_Account_ID, “>4000”, TB_Balance)) / ABS(SUMIFS(TB_Balance, TB_Account_ID, “>4000”, TB_Account_ID, “<5000”))

Current Ratio: 3.57
=ABS(SUMIFS(TB_Balance, TB_Account_ID, “>0”, TB_Account_ID, “<1200”)) / ABS(SUMIFS(TB_Balance, TB_Account_ID, “>2100”, TB_Account_ID, “<2200”))

ROA: 47.80%
=ABS(SUMIF(TB_Account_ID,“>4000”,TB_Balance))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>1000”,TB_Account_ID,“<2000”))

Debt to Equity Ratio: 1.32
=ABS(SUMIFS(TB_Balance, TB_Account_ID, “>2000”, TB_Account_ID, “<3000”)) / ABS(SUMIFS(TB_Balance, TB_Account_ID, “>3000”, TB_Account_ID, “<4000”))

Inventory Turnover: 7.19
=XLOOKUP(“Cost of Goods Sold”, TB_Account_Name, TB_Balance, 0, 0) / XLOOKUP(“Inventory”, TB_Account_Name, TB_Balance, 0, 0)

ROE: 212.67%
=ABS(SUMIF(TB_Account_ID, “>4000”, TB_Balance)) / ABS(SUMIFS(TB_Balance, TB_Account_ID, “>3000”, TB_Account_ID, “<4000”))

[Gwen_Chandler]

time: 45 min
level: intermediate

Net Profit Margin: 24.44%
=ABS(SUMIF(‘Journal Entries’!J7:J41,“>4000”,‘Journal Entries’!L7:L41))/ABS(SUMIFS(‘Journal Entries’!L7:L41,‘Journal Entries’!J7:J41,“>4000”,‘Journal Entries’!J7:J41,“<5000”))

Current Ratio: 3.57
=ABS(SUMIFS(‘Journal Entries’!L7:L41, ‘Journal Entries’!J7:J41, “>1100”,‘Journal Entries’!J7:J41, “<1200”))/ABS(SUMIFS(‘Journal Entries’!L7:L41, ‘Journal Entries’!J7:J41, “>2100”,‘Journal Entries’!J7:J41, “<2200”))

ROA: 47.80%
=ABS(SUMIF(‘Journal Entries’!J7:J41,“>4000”,‘Journal Entries’!L7:L41))/(SUMIFS(‘Journal Entries’!L7:L41,‘Journal Entries’!J7:J41,“>1000”,‘Journal Entries’!J7:J41, “<2000”))

Debt to Equity Ratio: 1.32
=ABS(SUMIFS(‘Journal Entries’!L7:L41,‘Journal Entries’!J7:J41,“>2000”,‘Journal Entries’!J7:J41,“<3000”)/ABS(SUMIFS(‘Journal Entries’!L7:L41,‘Journal Entries’!J7:J41,“>3000”,‘Journal Entries’!J7:J41,“<4000”)))

Inventory Turnover: 7.19
=‘Journal Entries’!L30/‘Journal Entries’!L10

ROE: 212.67

=ABS(SUMIF(‘Journal Entries’!J7:J41,“>4000”,‘Journal Entries’!L7:L41))/ABS(SUMIFS(‘Journal Entries’!L7:L41,‘Journal Entries’!J7:J41,“>3000”,‘Journal Entries’!J7:J41, “<4000”))
[/quote]

[Alexa_McKee]

Time to complete: 45 minutes
Difficulty: Medium
Net Profit Margin = 24.44%
=(SUMIF(‘Journal Entries’!$J$6:$J$40,“>4000”,‘Journal Entries’!$L$6:$L$40))/(SUMIFS(‘Journal Entries’!$L$6:$L$40, ‘Journal Entries’!J6:J40, “>4000”, ‘Journal Entries’!J6:J40, “<5000”))
Current Ratio = 3.57
=ABS(SUMIFS(‘Journal Entries’!L6:L40, ‘Journal Entries’!J6:J40, “>1100”, ‘Journal Entries’!J6:J40, “<1200”))/ABS((SUMIFS(‘Journal Entries’!L6:L40, ‘Journal Entries’!J6:J40, “>2100”, ‘Journal Entries’!J6:J40, “<2200”)))
ROA = 47.80%
=ABS(SUMIF(‘Journal Entries’!$J$6:$J$40,“>4000”,‘Journal Entries’!$L$6:$L$40)/ABS((SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>1000”,‘Journal Entries’!J6:J40,“<2000”))))
Debt to equity ratio = 1.32
=ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2000”,‘Journal Entries’!J6:J40,“<3000”))/ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”))
Inventory turnover = 7.19
=(XLOOKUP(‘Journal Entries’!J29,‘Journal Entries’!J6:J40,‘Journal Entries’!L6:L40))/(XLOOKUP(‘Journal Entries’!J9,‘Journal Entries’!J6:J40,‘Journal Entries’!L6:L40))
ROE = 212.67%
=ABS(SUMIF(‘Journal Entries’!$J$6:$J$40,“>4000”,‘Journal Entries’!$L$6:$L$40)/ABS((SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”))))

[Grace_Jeppson]

time to complete: 1 hr
Difficulty: Hard
Solution:
Net Profit margin: 24.44%
=ABS(SUMIF(TB_Account_ID,“>4000”,TB_Balance))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>4000”,TB_Account_ID,“<5000”))

Current Ratio: 3.57
=ABS(SUMIFS(TB_Balance,TB_Account_ID,“>0”,TB_Account_ID,“<1200”))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>2100”,TB_Account_ID,“<2200”))

ROA: 47.80%
=ABS(SUMIFS(TB_Balance,TB_Account_ID,“>4000”))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>1000”,TB_Account_ID,“<2000”))

Debt to equity: 1.32
=ABS(SUMIFS(TB_Balance,TB_Account_ID,“>2000”,TB_Account_ID,“<3000”))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>3000”,TB_Account_ID,“<4000”))

Inventory Turnover: 7.19
=XLOOKUP(“cost of goods sold”,TB_Account_Name,TB_Balance)/XLOOKUP(“Inventory”,TB_Account_Name,TB_Balance)

ROE: 212.67
=ABS(SUMIFS(TB_Balance,TB_Account_ID,“>4000”))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>3000”,TB_Account_ID,“<4000”))

[Alexandria_White]

Time to complete: 45 minutes
level intermediate
solutions:
Net Profit Margin: 24.44%

=ABS(SUMIF(‘Journal Entries’!J6:J41,“>4000”,‘Journal Entries’!L6:L3424)/SUMIFS(‘Journal Entries’!L6:L3424,‘Journal Entries’!J6:J3424,“>4000”,‘Journal Entries’!J6:J3424,“<5000”))

Current Ratio 3.57

=ABS(SUMIFS(‘Journal Entries’!L6:L3424,‘Journal Entries’!J6:J3424,“>1100”,‘Journal Entries’!J6:J3424,“<1200”))/ABS(SUMIFS(‘Journal Entries’!L6:L3424,‘Journal Entries’!J6:J3424,“>2100”,‘Journal Entries’!J6:J3424,“<2200”))

ROA 47.8%

=ABS(SUMIF(‘Journal Entries’!J6:J41,“>4000”,‘Journal Entries’!L6:L3424)/ABS(SUMIFS(‘Journal Entries’!L6:L3424,‘Journal Entries’!J6:J3424,“>1000”,‘Journal Entries’!J6:J3424,“<2000”)))

Debt to Equity Ratio 1.32

=ABS(SUMIFS(‘Journal Entries’!L6:L3424,‘Journal Entries’!J6:J3424,“>2000”,‘Journal Entries’!J6:J3424,“<3000”))/ABS(SUMIFS(‘Journal Entries’!L6:L3424,‘Journal Entries’!J6:J3424,“>3000”,‘Journal Entries’!J6:J3424,“<4000”))

Inventory Turnover 7.19

=‘Journal Entries’!L29/‘Journal Entries’!L9

ROE 212.67%

=ABS(SUMIFS(‘Journal Entries’!L6:L3424,‘Journal Entries’!J6:J3424,“>4000”))/ABS(SUMIFS(‘Journal Entries’!L6:L3424,‘Journal Entries’!J6:J3424,“>3000”,‘Journal Entries’!J6:J3424,“<4000”))

[Nolan_Ward]

Time: 1 hour
Difficulty Hard

Net Profit Margin = 24.44%
=ABS(SUMIF(TB_Account_ID,“>4000”,TB_Balance))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>4000”,TB_Account_ID,“<5000”))

Current Ratio = 3.57
=ABS(SUMIFS(TB_Balance,TB_Account_ID,“>0”,TB_Account_ID,“<1200”))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>2100”,TB_Account_ID,“<2200”))

ROA = 47.8%
=ABS(SUMIFS(TB_Balance,TB_Account_ID,“>4000”))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>1000”,TB_Account_ID,“<2000”))

Debt-to-Equity Ratio = 1.32
=ABS(SUMIFS(TB_Balance,TB_Account_ID,“>2000”,TB_Account_ID,“<3000”))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>3000”,TB_Account_ID,“<4000”))

Inventory Turnover = 7.19
=‘Journal Entries’!L30/‘Journal Entries’!L10

ROE = 212.67%
=ABS(SUMIF(TB_Account_ID,“>4000”,TB_Balance))/ABS(SUMIFS(TB_Balance,TB_Account_ID,“>3000”,TB_Account_ID,“<4000”))

[Jaden_Coles]

Time to Complete: 45 minutes
Difficulty: Intermediate

Solution:
Net Profit Margin = 22.44%
=ABS(SUMIF(‘Journal Entries’!J6:J1048576,“>4000”,‘Journal Entries’!L6:L1048576))/ABS(SUMIFS(‘Journal Entries’!L6:L1048576,‘Journal Entries’!J6:J1048576,“>4000”,‘Journal Entries’!J6:J1048576,“<5000”))

Current Ratio = 3.57
=ABS(SUMIFS(‘Journal Entries’!L6:L1048576,‘Journal Entries’!J6:J1048576,“>1100”,‘Journal Entries’!J6:J1048576,“<1200”)/SUMIFS(‘Journal Entries’!L6:L1048576,‘Journal Entries’!J6:J1048576,“>2100”,‘Journal Entries’!J6:J1048576,“<2200”))

ROA = 47.80
=ABS(SUMIF(‘Journal Entries’!J6:J1048576,“>4000”,‘Journal Entries’!L6:L1048576))/ABS(SUMIFS(‘Journal Entries’!L6:L1048576,‘Journal Entries’!J6:J1048576,“>1000”,‘Journal Entries’!J6:J1048576,“<2000”))

Debt to Equity = 1.32
=ABS(SUMIFS(‘Journal Entries’!L6:L1048576,‘Journal Entries’!J6:J1048576,“>2000”,‘Journal Entries’!J6:J1048576,“<3000”))/ABS(SUMIFS(‘Journal Entries’!L6:L1048576,‘Journal Entries’!J6:J1048576,“>3000”,‘Journal Entries’!J6:J1048576,“<4000”))

Inventory Turnover = 7.19
=SUMIF(‘Journal Entries’!D5:D1048576,“=5090”,‘Journal Entries’!H5:H1048576)/SUMIF(‘Journal Entries’!D5:D1048576,“=1130”,‘Journal Entries’!H5:H3424)

ROE = 212.67%
=SUMIF(‘Journal Entries’!J6:J1048576,“>4000”,‘Journal Entries’!L6:L1048576)/SUMIFS(‘Journal Entries’!L6:L1048576,‘Journal Entries’!J6:J1048576,“>3000”,‘Journal Entries’!J6:J1048576,“<4000”)

[Gabrielle_Johnson]

Time to Complete: 40 minutes
Difficulty: Hard
Challenge231_Data.xlsx (249.4 KB)

[Genevieve_Nichols]

2. a) =SORT(UNIQUE($D$5:$D$3424))
   b) =XLOOKUP(J6,$D$5:$D$3424,$E$5:$E$3424)
   c) =SUMIF($E$5:$E$3424,K6,$H$5:$H$3424)
3. Assets: =AND($J6<2000, $J6 >0)
   Liabilities: =AND($J6<3000, $J6 >2000)
   Owners’ Equity: =AND($J6<4000, $J6 >3000)
   Temporary Accounts: =$J6>4000
4. a) =(ABS(SUM(‘Journal Entries’!L21:L23))-ABS(SUM(‘Journal Entries’!L24:L40)))/ABS(SUM(‘Journal Entries’!L21:L23))
   b) =SUM(‘Journal Entries’!L6:L10)/ABS(SUM(‘Journal Entries’!L16:L17))
   c) =(ABS(SUM(‘Journal Entries’!L21:L23))-ABS(SUM(‘Journal Entries’!L24:L40)))/SUM(‘Journal Entries’!L6:L15)
   d) =ABS(SUM(‘Journal Entries’!L16:L18))/ABS(SUM(‘Journal Entries’!L19:L20))
   e) =‘Journal Entries’!L29/‘Journal Entries’!L9
   f) =(ABS(SUM(‘Journal Entries’!L21:L23))-SUM(‘Journal Entries’!L24:L40))/ABS(SUM(‘Journal Entries’!L19:L20))

[Cannon_Hamilton]

Time to complete: 20 minutes
Difficulty: Beginner-Intermediate
Challenge231_Data.xlsx (260.1 KB)

[Aishwarya_Ramesh]

Time to Complete: 40 minutes
Net Profit Margin: 24.44%
=ABS((SUMIF(‘Journal Entries’!J6:J40,“>4000”, ‘Journal Entries’!L6:L40))/(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!J6:J40,“<5000”)))

Current Ratio = 3.57
=ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>1100”,‘Journal Entries’!J6:J40,“<1200”)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2100”,‘Journal Entries’!J6:J40,“<2200”))

Return On Assets = 47.80%
=ABS(SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>1000”,‘Journal Entries’!J6:J40,“<2000”))

Debt to Equity Ratio = 1.32
=ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2000”,‘Journal Entries’!J6:J40,“<3000”)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”))

Inventory Turnover = 7.19
=‘Journal Entries’!L29/‘Journal Entries’!L9

Return on Equity = 212.67%
=ABS(SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”))

[Shane_Hawkins]

Time to Complete: 50 Minutes
Difficulty: Intermediate
Notes: Great practice for sumif and sumifs!

Solution:
Net Profit Margin=24.44%
=(SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!J6:J40,“<5000”))

Current Ratio=3.57
=ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>1100”,‘Journal Entries’!J6:J40,“<1200”))/ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2100”,‘Journal Entries’!J6:J40,“<2200”))

ROA=47.80%
=ABS(SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40))/ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>1000”,‘Journal Entries’!J6:J40,“<2000”))

Debt to Equity=1.32
=ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2000”,‘Journal Entries’!J6:J40,“<3000”))/ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”))

Inventory Turnover=7.19
=‘Journal Entries’!L29/‘Journal Entries’!L9

ROE=212.67%
=SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”)

[Claire_Campbell]

Time to complete: 25 minutes
Difficulty: Intermediate
Notes: Mainly difficult because I didn’t understand how to use a sumifs function. Figured it out!

Solution:
Net Profit Margin: 24.44%
=(SUMIFS(‘Journal Entries’!$H$5:$H$3424,‘Journal Entries’!D5:D3424,“>4000”))/SUMIFS(‘Journal Entries’!H5:H3424,‘Journal Entries’!D5:D3424,“>4000”,‘Journal Entries’!D5:D3424,“<5000”)

Current Ratio: 3.57%
=(SUMIFS(‘Journal Entries’!H5:H3424, ‘Journal Entries’!D5:D3424, “>1100”, ‘Journal Entries’!D5:D3424, “<1200”))/(SUMIFS(‘Journal Entries’!H5:H3424, ‘Journal Entries’!D5:D3424, “>2100”, ‘Journal Entries’!D5:D3424, “<2200”))

ROA: 47.80%
=(SUMIF(‘Journal Entries’!D5:D3424,“>4000”, ‘Journal Entries’!H5:H3424))/(SUMIFS(‘Journal Entries’!H5:H3424,‘Journal Entries’!D5:D3424,“>1000”,‘Journal Entries’!D5:D3424,“<2000”))

Debt to Equity: 1.32
=(SUMIFS(‘Journal Entries’!H5:H3424, ‘Journal Entries’!D5:D3424, “>2000”, ‘Journal Entries’!D5:D3424, “<3000”))/(SUMIFS(‘Journal Entries’!H5:H3424, ‘Journal Entries’!D5:D3424, “>3000”, ‘Journal Entries’!D5:D3424, “<4000”))

Inventory Turnover: 7.19
=‘Journal Entries’!L29/‘Journal Entries’!L9

ROE: 212.67%
=(SUMIF(‘Journal Entries’!D5:D3424,“>4000”,‘Journal Entries’!H5:H3424))/(SUMIFS(‘Journal Entries’!H5:H3424, ‘Journal Entries’!D5:D3424, “>3000”, ‘Journal Entries’!D5:D3424, “<4000”))

[Hailey_Smith]

Time to Complete: 45 minutes
Difficulty: Intermediate

Net Profit Margin = 24.44%
=(SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40))/(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!J6:J40,“<5000”))

Current Ratio = 3.57
=ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>1100”,‘Journal Entries’!J6:J40,“<1200”)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2100”,‘Journal Entries’!J6:J40,“<2200”))

ROA = 47.80%
=ABS(SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>1000”,‘Journal Entries’!J6:J40,“<2000”))

Debt to Equity Ratio = 1.32
=SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2000”,‘Journal Entries’!J6:J40,“<3000”)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”)

Inventory Turnover = 7.19
=‘Journal Entries’!L29/‘Journal Entries’!L9

ROE = 212.67%
=SUMIF(‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!L6:L40)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>3000”,‘Journal Entries’!J6:J40,“<4000”)