313 Calibri (Body) 11 v ab General .00 X fx =IF(AND(ISNUMBER(FIND($G$10,FORMULATEXT(B13))),ISNUMBER(FIND($G$11,FORMULATEXT(B13)))),1,0) A B 1 2 Current...

Transcribed Image Text:

313 Calibri (Body) 11 v ab General .00 X fx =IF(AND(ISNUMBER(FIND($G$10,FORMULATEXT(B13))),ISNUMBER(FIND($G$11,FORMULATEXT(B13)))),1,0) A B 1 2 Current Year Prior Year 3 Cash $7,440 $8,000 4 Accounts receivable 54,000 18,000 5 Equipment, net 44,000 40,000 6 Land 91,680 66,000 7 Total assets $197,120 $132,000 8 9 Required: D E F G H 10 Express the items in common-size percents. Round to 1 decimal place. 11 12 Current Year Prior Year 13 Cash 14 Accounts receivable 15 Equipment, net 16 Land 17 Total assets 18 19 20 0.0% 0.0% $7 ROUND 0 0 OOOOH 1600 0 0 SUM 1 1 21 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 22 Nothing in this area will be graded, but it will be submitted with your assignment. 23 24 25 313 Calibri (Body) 11 v ab General .00 X fx =IF(AND(ISNUMBER(FIND($G$10,FORMULATEXT(B13))),ISNUMBER(FIND($G$11,FORMULATEXT(B13)))),1,0) A B 1 2 Current Year Prior Year 3 Cash $7,440 $8,000 4 Accounts receivable 54,000 18,000 5 Equipment, net 44,000 40,000 6 Land 91,680 66,000 7 Total assets $197,120 $132,000 8 9 Required: D E F G H 10 Express the items in common-size percents. Round to 1 decimal place. 11 12 Current Year Prior Year 13 Cash 14 Accounts receivable 15 Equipment, net 16 Land 17 Total assets 18 19 20 0.0% 0.0% $7 ROUND 0 0 OOOOH 1600 0 0 SUM 1 1 21 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 22 Nothing in this area will be graded, but it will be submitted with your assignment. 23 24 25