Excel McGraw Hill Excel Question - Saved Sear File Home Insert Draw Formulas Data Review View Help Calibri 11 V B A1 A Xfx Accessibility tab summary: Transactions for Simon Company are B D 12345 Simon Company's year-end balance sheets follow. At December 31 Current Year 1 Year Ago 2 Years Ago Assets 6 Cash $31,800 $35,625 $37,800 11 7890123ILLTE22222222 26 Accounts receivable, net 89,500 - 62,500 50,200 Merchandise inventory 112,500 82,500 54,000 Prepaid expenses 10,700 9,375 5,000 Plant assets, net 278,500 255,000 230,500 Total assets $523,000 $445,000 $377,500 Liabilities and Equity Accounts payable $129,900 $75,250 $51,250 14 Long-term notes payable 98,500 101,500 83,500 15 Common stock, $10 par value 163,500 163,500 163,500 16 Retained earnings 131,100 104,750 79,250 Total liabilities and equity $523,000 $445,000 $377,500 19 Required: 1. Express the balance sheets in common-size percents. 22 (Use cells A4 to D17 from the given information to complete this question.) 24 25 SIMON COMPANY Common-Size Comparative Balance Sheets December 31 = B Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Tyne E F