Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 periodStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started