Tip: If you use formulas to calculate the Average cells, be sure to use the Round() function to round to 0 decimal places. ?xample, the following formula will llate the value in cell 136 and round the t to 0 decimal places: und((E36+G36)/2,0) The calculation of Average Total ts and the calculation of Average | Stockholders' Equity are only in the first time you need the age amount. Once you calculate the age amount, then use that average unt as needed in the other ratio llations. 119 Home Depot also had negative kholder's Equity due to repurchases ommon Stock. As a result of the ative Beginning of Year Amount for kholders' Equity for 2020 , the age Total Stockholders' Equity for ) was very small. This made the ) Assets-to-Equity Ratio and Return quity \% very large and meaningless 020 as well. THE HOME DEPOT, INC. CONSOI InATFR RAI DNCF SHFFTS Table of Contents THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS Basic weighted average common shares Basic earnings per share $$1,05415.591,05815.53$$1,07411.981,07811.94$$1,09310.291,09710.25 Diluted weighted average common shares Diluted earnings per share See accompanying notes to consolidated financial statements. THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY \begin{tabular}{lrrr} Paid-in Capital: & & & \\ \hline Balance at beginning of year & 11,540 & 11,001 & 10,578 \\ \hline Shares issued under employee stock plans & 194 & 229 & 172 \\ Stock-based compensation expense & 398 & 310 & 251 \\ \hline Balance at end of year & 12,132 & 11,540 \\ \hline \end{tabular} Retained Earnings: Balance at beginning of year Cumulative effect of accounting changes Net earnings Cash dividends Other Balance at end of year Accumulated Other Comprehensive Loss: Balance at beginning of year \begin{tabular}{rrr} (671) & (739) & (772) \\ & & (31) \\ (77) & 60 & 53 \\ 9 & 8 & 8 \\ 35 & & 3 \\ \hline(704) & (671) \\ \hline \end{tabular} Treasury Stock: Balance at beginning of year Repurchases of common stock Balance at end of year Total stockholders' (deficit) equity See accompanying notes to consolidated financial statements. THE HOME DEPOT. INC