complete the spreadsheet with calculations and explanations.

ASSUMPTIONS \begin{tabular}{|c|c|c|c|c|} \hline & & 2022e & 2023e & 2024e \\ \hline Sales growth & & 10% & 10% & 5% \\ \hline Gross margin is the same & & 42% & 42% & 42% \\ \hline COGS & & 58% & 58% & 58% \\ \hline Accounts receivable is the same proportion of sales in 2021 & & 8.14% & 8% & 8% \\ \hline Inventory is the same proportion of COGS in 2021 & & 31% & 31% & 31% \\ \hline Reduce notes payable by $60 & $ & (60.00)$ & $ & \\ \hline Maintain the same amount of long-term debt & & $457.00 & $457.00 & $457.00 \\ \hline Depreciate NP\&E with the same amount & & $276.00 & $276.00 & $276.00 \\ \hline Tax rate will be & & 21% & 21% & 21% \\ \hline Interest rate will be & & 8% & 8% & 8% \\ \hline Payout ratio & & 33% & 33% & 33% \\ \hline Accounts payable is the same proportion of COGS in 2021 & & 26% & 26% & 26% \\ \hline \begin{tabular}{l} \# of shares \\ WACC, see below \end{tabular} & & 8,000 & 8,000 & 8,000 \\ \hline \end{tabular}