50.1K

Verified Solution

Link Copied!

Complete the below table to calculate the trend percents for all components of both statements using 2015 as the base year.

Refer to the results from part 1. (a) Did sales grow steadily over this period? (b) Did net income as a percent of sales grow over the past four years? (c) Did inventory increase over this period?

Please use the templates below. Thank you!!

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{l} ( $ thousands) \\ Sales \end{tabular}} & For & \begin{tabular}{l} HAR \\ Comparative \\ lears Ended \end{tabular} & \begin{tabular}{l} IN COMPANY \\ Income Sta \\ ecember \end{tabular} & \begin{tabular}{l} ments \\ 20212015 \end{tabular} & \multirow[b]{2}{*}{2017} & \multirow[b]{2}{*}{2016} & \multirow[b]{2}{*}{2015} & \\ \hline & 2021For & 2020 & 2019 & 2018 & & & & \\ \hline & $1,960 & $1,716 & $1,562 & $1,431 & $1,336 & $1,242 & $1,018 & \\ \hline Cost of goods sold & 1,410 & 1,147 & 987 & 864 & 803 & 750 & 598 & \\ \hline Gross profit & 550 & 569 & 575 & 567 & 533 & 492 & 420 & \\ \hline Operating expenses & 420 & 328 & 301 & 222 & 193 & 190 & 158 & \\ \hline Net income & $130 & $241 & $274 & $345 & $340 & $302 & $262 & \\ \hline \multicolumn{9}{|c|}{\begin{tabular}{c} Comparative Year-End Balance Sheets \\ December 31, 2021-2015 \end{tabular}} \\ \hline ( $ thousands) & \multicolumn{2}{|r|}{2021} & 2020 & 2019 & 2018 & 2017 & 2016 & 2015 \\ \hline \multicolumn{9}{|l|}{ Assets } \\ \hline Cash & & $74 & $98 & $102 & $104 & $108 & $107 & $110 \\ \hline Accounts receivable, net & & 533 & 560 & 507 & 389 & 342 & 324 & 229 \\ \hline Merchandise inventory & & 1,929 & 1,404 & 1,227 & 1,034 & 929 & 789 & 572 \\ \hline Other current assets & & 49 & 45 & 27 & 49 & 42 & 42 & 22 \\ \hline Long-term investments & & 0 & 0 & 0 & 152 & 152 & 152 & 152 \\ \hline Plant assets, net & & 2,361 & 2,351 & 2,057 & 1,160 & 1,199 & 1,066 & 915 \\ \hline Total assets & & $4,946 & $4,458 & $3,920 & $2,888 & $2,772 & $2,480 & $2,000 \\ \hline \multicolumn{9}{|l|}{ Liabilities and Equity } \\ \hline Current liabilities & & 1,244 & $1,046 & $686 & $571 & $495 & $468 & $302 \\ \hline Long-term liabilities & & 1,329 & 1,157 & 1,126 & 523 & 534 & 579 & 434 \\ \hline Common stock & & 900 & 900 & 900 & 800 & 800 & 700 & 700 \\ \hline other paid-in capital & & 225 & 225 & 225 & 200 & 200 & 175 & 175 \\ \hline Retained earnings & & 1,248 & 1,130 & 983 & 794 & 743 & 558 & 389 \\ \hline Total liabilities and equ & & $4,946 & $4,458 & $3,920 & $2,888 & $2,772 & $2,480 & $2,000 \\ \hline \end{tabular} Complete the below table to calculate the trend percents for all components of comparative income statements using 2015 as the base year. Note: Round your percentage answers to 1 decimal place. Complete the below table to calculate the trend percents for all components of comparative balance sheets using 2015 as the base yea Mnto. Rnund vour nerrontano ancuere to 1 derimal nlare Refer to the results from part 1. (a) Did sales grow steadily over this period? (b) Did net income as a percent of sales grow over the past four years? (c) Did inventory increase over this period

Answer & Explanation Solved by verified expert

See Answer