Question: Complete a horizontal analysis using the balance sheet for the Nike, Inc. Find the amount and percent of increase or decrease for 2016 to 2017



Complete a horizontal analysis using the balance sheet for the Nike, Inc. Find the amount and percent of increase or decrease for 2016 to 2017 and 2017 to 2018 . Fill in the blanks on the table below. Amounts do not need the dollar sign (\$), whole numbers only, no decimals. Percentages should be two decimal places and no \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|l|}{\begin{tabular}{l} LIABILITIES AND SHAREHOLDERS' \\ EQUITY \end{tabular}} \\ \hline \multicolumn{8}{|l|}{ Current Liabilities } \\ \hline Current portion of long-term debt & 6 & 6 & 44 & & & & \\ \hline Notes payable & 336 & 325 & 1 & & & & \\ \hline Accounts payable & 2,279 & 2,048 & 2,191 & & & & \\ \hline Accrued liabilities & 3,269 & 3,011 & 3,037 & & & & \\ \hline Income taxes payable & 150 & 84 & 85 & & & & \\ \hline Total current liabilities & 6,040 & 5,474 & 5,358 & & & & \\ \hline Long-term debt & 3,468 & 3,471 & 1,993 & & & & \\ \hline \begin{tabular}{l} Deferred income taxes and other \\ liabilities \end{tabular} & 3,216 & 1,907 & 1,770 & & & & \\ \hline \multicolumn{8}{|l|}{ Commitments and contingencies } \\ \hline \multicolumn{8}{|l|}{ Redeemable preferred stock } \\ \hline \multicolumn{8}{|l|}{ Shareholders' equity } \\ \hline \multicolumn{8}{|l|}{ Common stock at stated value } \\ \hline \begin{tabular}{l} Class A convertible -329 and 353 \\ shares outstanding \end{tabular} & & & & & & & \\ \hline \end{tabular} \begin{tabular}{||l|l|l|l|l|l|l|l||} \hline \multicolumn{1}{|l|}{\begin{tabular}{l} Class B - 1,314 and 1,329 shares \\ outstanding \end{tabular}} & 3 & 3 & 3 & & & \\ \hline Capital in excess of stated value & 6,384 & 5,710 & 7,786 & & & \\ \hline \begin{tabular}{l} Accumulated other comprehensive \\ (loss) income \end{tabular} & (92) & (213) & 318 & & & \\ \hline Retained earnings & 3,517 & 6,907 & 4,151 & & \\ \hline Total shareholders' equity & 9,812 & 12,407 & 12,258 & & \\ \hline \begin{tabular}{l} TOTAL LIABILITIES AND \\ SHAREHOLDERS' EQUITY \end{tabular} & 22,536 & 23,259 & 21,379 & & \\ \hline \end{tabular} Complete a horizontal analysis using the balance sheet for the Nike, Inc. Find the amount and percent of increase or decrease for 2016 to 2017 and 2017 to 2018 . Fill in the blanks on the table below. Amounts do not need the dollar sign (\$), whole numbers only, no decimals. Percentages should be two decimal places and no \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|l|}{\begin{tabular}{l} LIABILITIES AND SHAREHOLDERS' \\ EQUITY \end{tabular}} \\ \hline \multicolumn{8}{|l|}{ Current Liabilities } \\ \hline Current portion of long-term debt & 6 & 6 & 44 & & & & \\ \hline Notes payable & 336 & 325 & 1 & & & & \\ \hline Accounts payable & 2,279 & 2,048 & 2,191 & & & & \\ \hline Accrued liabilities & 3,269 & 3,011 & 3,037 & & & & \\ \hline Income taxes payable & 150 & 84 & 85 & & & & \\ \hline Total current liabilities & 6,040 & 5,474 & 5,358 & & & & \\ \hline Long-term debt & 3,468 & 3,471 & 1,993 & & & & \\ \hline \begin{tabular}{l} Deferred income taxes and other \\ liabilities \end{tabular} & 3,216 & 1,907 & 1,770 & & & & \\ \hline \multicolumn{8}{|l|}{ Commitments and contingencies } \\ \hline \multicolumn{8}{|l|}{ Redeemable preferred stock } \\ \hline \multicolumn{8}{|l|}{ Shareholders' equity } \\ \hline \multicolumn{8}{|l|}{ Common stock at stated value } \\ \hline \begin{tabular}{l} Class A convertible -329 and 353 \\ shares outstanding \end{tabular} & & & & & & & \\ \hline \end{tabular} \begin{tabular}{||l|l|l|l|l|l|l|l||} \hline \multicolumn{1}{|l|}{\begin{tabular}{l} Class B - 1,314 and 1,329 shares \\ outstanding \end{tabular}} & 3 & 3 & 3 & & & \\ \hline Capital in excess of stated value & 6,384 & 5,710 & 7,786 & & & \\ \hline \begin{tabular}{l} Accumulated other comprehensive \\ (loss) income \end{tabular} & (92) & (213) & 318 & & & \\ \hline Retained earnings & 3,517 & 6,907 & 4,151 & & \\ \hline Total shareholders' equity & 9,812 & 12,407 & 12,258 & & \\ \hline \begin{tabular}{l} TOTAL LIABILITIES AND \\ SHAREHOLDERS' EQUITY \end{tabular} & 22,536 & 23,259 & 21,379 & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
