231|EXCEL – Cougar Equipment Trial Balance

Time to Complete: 50 minutes
Difficulty: Intermediate

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”))

1 Like

Time to Complete: 30 minutes
Notes: Hard with SumIF

Net Profit Margin: 24.44%

=ABS(SUMIF(‘Journal Entries’!$J$6:$J$40,“>4000”,‘Journal Entries’!$L$6:$L$40)/(SUMIFS(‘Journal Entries’!$L$6:$L$40,‘Journal Entries’!$J$6:$J$40,“>4000”,‘Journal Entries’!$J$6:$J$40,“<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’!$J$6:$J$40,“>4000”,‘Journal Entries’!$L$6:$L$40)/(SUMIFS(‘Journal Entries’!$L$6:$L$40,‘Journal Entries’!$J$6:$J$40,“>1000”,‘Journal Entries’!$J$6:$J$40,“<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

ROE: 212.67%

=ABS(SUMIF(‘Journal Entries’!$J$6:$J$40,“>4000”,‘Journal Entries’!$L$6:$L$40)/(SUMIFS(‘Journal Entries’!$L$6:$L$40,‘Journal Entries’!$J$6:$J$40,“>3000”,‘Journal Entries’!$J$6:$J$40,“<4000”)))

1 Like

time to complete: 45 min
level: 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
=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”)

45 minutes
medium
=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”))

=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”)

=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”))

=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”)

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

=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”)

1 Like

Time to complete: 1 hour
Difficulty: Medium
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(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!J6:J40,“<6000”)/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
=ABS(‘Journal Entries’!L29/‘Journal Entries’!L9)

ROE: 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”))

Time To Complete: 45-60min
Difficulty: Medium-Hard
Solution:
Woodbury_Challenge231_Data.xlsx (255.5 KB)

Time to Complete: 25
Difficulty: Easy
Solutions:
Net Profit Margin = 24.44%
=SUMIF(‘Journal Entries’!J6:$J$40,“>4000”,‘Journal Entries’!$L$6:$L$40)/SUMIFS(‘Journal Entries’!$L$6:$L$40,‘Journal Entries’!J6:$J$40,“>4000”,‘Journal Entries’!J6:$J$40,“<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”))

DtE = 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”)

Inv 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”)

Time to complete: 40 minutes
Difficulty: hard
Solution–it wouldn’t let me submit my file as a macro enabled workbook so I saved as an xlsx
Challenge231_Datacompleted.xlsx (246.5 KB)

1 Like

Time to Complete: 45 min
Rating: Medium
Challenge231_Data.xlsx (267.8 KB)

Time to Complete: 45 Minutes
Difficulty: hard
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”)/SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40,“>2100”,‘Journal Entries’!J6:J40,“<2200”))

Return On Assets = 47.8%
=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

Return on Equity = 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”)

Time to Complete: 40 mins
Difficulty: Intermediate
Challenge231_Data.xlsx (248.7 KB)

Time to complete: 40 min
Difficulty: Intermediate
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,“>1100”,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
=‘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”)).

Time to complete: 60 minutes
Level: Intermediate
Solution:

Net Profit Margin = 24.44%

=SUMIFS(‘Journal Entries’!L6:L40, ‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!J6:J40, “<6000”)/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,“>4000”,‘Journal Entries’!J6:J40, “<6000”)/SUMIFS(‘Journal Entries’!L6:L40, ‘Journal Entries’!J6:J40,“>4000”,‘Journal Entries’!J6:J40, “<5000”)

ROA = 47.80%

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

Debt to Equity Ratio

=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’!L30/‘Journal Entries’!L10

ROE = 212.67%

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

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))/ABS(SUMIFS(‘Journal Entries’!L7:L41, ‘Journal Entries’!J7:J41,“>1000”, ‘Journal Entries’!J7:J41, “<2000”))

Debt to Equity = 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”))

Time to complete: 1 hour
Solution:
Net profit margin= 24.44%
=SUMIF(‘Journal Entries’!J6:J1048576,“>4000”,‘Journal Entries’!L6:L1048576)/SUMIFS(‘Journal Entries’!L6:L1048576,‘Journal Entries’!J6:J1048576,“>4000”,‘Journal Entries’!J6:J1048576, “<5000”)

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

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

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

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

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

Time: hour
Rating: not too bad, but some concepts were new to me so it took longer

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”)/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”)

Difficulty: Medium
Time: 1 hour

Net Profit Margin 24.44%
=ABS(SUMIF(‘Journal Entries’!J6:J40, “>4000”,‘Journal Entries’!L6:L40))/ABS(SUMIFS(‘Journal Entries’!L6:L40,‘Journal Entries’!J6:J40, “>4000”,‘Journal Entries’!J6:J40, “<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”))

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)/XLOOKUP(“Inventory”,TB_Account_Name,TB_Balance)

Time to Complete: 1 hour
Difficulty: Medium
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.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 Ratio = 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”))

1 Like

Time to complete: 45 min
Difficulty: intermediate

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,“>1100”,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 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 Ratio: 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”))

Time to complete: 30 minutes
Difficulty: Intermediate

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 Ratio = 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”))