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