QS 13-4 (Algo) Horizontal analysis LO P1 Compute the annual dollar changes and percent changes for each of the following accounts. (Decreases should be indicated with minus sign. Round percent change to one decimal place.) Short-term investments Accounts receivable. Notes payable Current Year $ 379,115 101,380 Prior Year $ 238,413 105,474 93,207 0 Horizontal Analysis-Calculation of Percent Change Numerator Denominator Percent Change Current Year Prior Year Percent Change 379,115 $ 101,380 0 Short-term investments Accounts receivable Notes payable S 238,413 105,474 93,207 Dollar Change Tableau DA 13-2: Exercise, Computing profit margin and return on assets LO P3 As consultants in advisory services, we are hired by Sayko Corporation to help analyze its regional operations in the contiguous US Sayko wishes to draw on our expertise in financial statement analysis to help identify further expansion of operations. A Tableau Dashboard is provided to aid our analysis. 1. Compute profit margin for the company's (a) West region and (b) Southwest region 2. in which region examined in part has the company best performed on profit margin? 3. Compute return on total sets for the company's (a) West region and Southwest region 4. In which region camined in part 3 has the company best performed on return on total assets? Complete this question by entering your answers in the tabs below. Red 1 Required 2 Required a Required Compute profit margin for the company () West region and (b) Southwest region. (Enter your answers as a whole percentage (0.12 should be entered as 12).) Margin region th) Borgon Regud 2 > Part 1 of 5 2 point 2 Years Ago Required information Use the following information for the Exercises below. (Algo) The following information applies to the questions displayed below) Simon Company's year-end balance sheets follow Arber Current Year 1 Year A Assets Cash 531,933 $3,097 Accounts receivable, net 95,415 67,34) Merchandise inventory 117,567 91,659 Prepaid expenses 30.703 9,899 plantas, net 32.353 224,00 Total assets 5557.94 5 41,021 Liabilities and Equity accounts payable 5 136,150 $3.293 Long-ters notes payable 106.999 110,635 Common stock, $10 par value 162.se 163.50 Ratained saring 2532 125.593 Total liabilities and equity 5 557,984 54,021 5 4,455 53,981 57,496 4.454 24.4 540, $ 55,447 89,483 362, See 2.670 5420,00 For both the current year and one year ago, compute the following ratios: Exercise 13-6 (Algo) Common-size percents LO P2 1. Express the balance sheets in common-size percents 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 unfavorablet 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? Answer is not complete. Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 and 3 Express the balance sheets in common-site percent. (Do not round intermediate calculations and round your final percentage answers to decimal place) SIMON COMPANY Complete this question by entering your answers in the tabs below. Req 1 Req 2 and 3 Express the balance sheets in common-size percents. (Do not round intermediate calculations percentage answers to 1 decimal place.) SIMON COMPANY Common-Size Comparative Balance Sheets December 31 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 Common stock, $10 par Retained earnings Total liabilities and equity Current Year % % % %6 1 Year Ago % % % 96 %6 % 96 96 Req 2 and 3
