ahow all steps and formulas please!!
Simon Company's year-end balance sheets follow Current Yr 1 Ye AB 2 Yrs Ajo At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings Total liabilities and equity $ 26,419 76,571 96,274 8,595 249.065 $ 456,924 $ 30,882 $ 31,532 54,043 42,471 72,872 45,227 8,437 2,468 227,666 202,3e2 $393,900 $325,000 $ 112,636 $ 67,900 $ 42,042 85,902 163,500 94,885 $ 456,924 92,409 71,825 163,500 163,500 70,091 47,633 $ 393,900 $ 325,000 1. Express the balance sheets in common-size percents (Do not round intermediate calculations and round your final percentage answers to 1 decimal place.) 2. Assuming annual sales have not changed in the last three years, is the change in accounts receivable as a percentage of total assets favorable or unfavorable? 3. Assuming annual sales have not changed in the last three years, is the change in merchandise inventory as a percentage of total assets favorable or unfavorable? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 and 3 Express the balance sheets in common-size percents. (Do not round Intermediate calculations and round your final percentage answers to 1 decimal place.) SIMON COMPANY Common Size Comparative Balance Sheets December 31 Current Year 1 Year Ago 2 Years Ago Assets Cash Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 and 3 Express the balance sheets in common-size percents. (Do not round intermediate calculations and round your final percentage answers to 1 decimal place.) SIMON COMPANY Common Size Comparative Balance Sheets December 31 Current Year 1 Year Ago 2 Years Ago Assets Cash % Accounts receivable net Merchandise inventory Prepaid expenses Plant assets, net Total assets % Liabilities and Equity Accounts payable % Long term notes payable secured by mortgages on plant assets Common stock, S10 par Retained earnings Total liabilities and equity % Req2 and 3 > 2. Assuming annual sales have not changed in the last three years, is the change in accounts receivable as a percentage of total assets favorable or unfavorable? 3. Assuming annual sales have not changed in the last three years, is the change in merchandise inventory as a percentage of total assets favorable or unfavorable? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 and 3 Assuming annual sales have not changed in the last three years, is the change in accounts receivable as a percentage of total assets favorable or unfavorable? Assuming annual sales have not changed in the last three years, is the change in merchandise Inventory as a percentage of total assets favorable or unfavorable? Show less 2. Change in accounts receivable 3. Change in marchandise inventory
