The provided financial statement data are for Starbucks during the 2019-2022 period. Calculate the following ratios and analyze the company's performance and financial conditions during and post-pandemic era.

Fill in all the open blue spaces in the excel sheet.

BALANCE SHEET DATA Assets: Current Assets: Cash and cash equivalents Short-term investments (Marketable Securities) Accounts receivable - net Inventories Prepaid expenses and other current assets Total Current Assets Fixed Assets: Long-term investments Equity and cost investments Property and equipment, Gross Less: Accumulated depreciation Property and Equipment, Net Operating Lease, Right-of-use Asset Deferred income taxes Intangible and Other assets Goodwill Total Fixed Assets Total Assets Liabilities and Equities: \begin{tabular}{|c|c|c|c|c|c|c|} \hline jilities and Equities: & & 2022 & & 2021 & 2020 & 2019 \\ \hline \multicolumn{7}{|l|}{ Current Liabilities: } \\ \hline Accounts payable & $ & 1,441.40 & $ & 1,211.60 & $997.90 & $1,189.70 \\ \hline Accrued liabilities & $ & 2,137.10 & $ & 2,321.20 & $1,258.90 & $3,045.40 \\ \hline Employee-related Liabilities, Current & $ & 761.70 & $ & 772.30 & $696.00 & 664.60 \\ \hline Operating Lease liability, Current & $ & 1,245.70 & $ & 1,251.30 & $1,248.80 & $1,386.72 \\ \hline Deferred Revenue, Current & $ & 1,641.90 & $ & 1,596.10 & $1,456.50 & $1,269.00 \\ \hline Short-term Debt & $ & 175.00 & $ & - & $438.80 & $ \\ \hline Long-term Debt, Current Maturities & $ & 1,749.00 & $ & 998.90 & $1,249.90 & $ \\ \hline Total Current Liabilities & $ & 9,151.80 & $ & 8,151.40 & $7,346.80 & $7,555.42 \\ \hline \multicolumn{7}{|l|}{ Long-Term Liabilities: } \\ \hline Long-term debt & $ & 13,119.90 & $ & 13,616.90 & $14,659.60 & $11,167.00 \\ \hline Operating Lease liability, Noncurrent & $ & 7,515.20 & $ & 7,738.00 & $7,661.70 & $7,412.91 \\ \hline Deferred Revenue, Noncurrent & $ & 6,279.70 & $ & 6,463.00 & $6,598.50 & $6,744.40 \\ \hline Deferred Tax and Other Liabilities, Noncurrent & $ & 610.50 & $ & 737.80 & $907.30 & $1,370.50 \\ \hline Total Long-Term Liabilities & $ & 27,525.30 & $ & 28,555.70 & $29,827.10 & $26,694.81 \\ \hline & $ & 36,677.10 & $ & 36,707.10 & $37,173.90 & $34,250.24 \\ \hline \multicolumn{7}{|c|}{$36,677.10$36,707.10$37,173.90$34,250.24} \\ \hline Common stock + Additional paid in capital & $ & 206.40 & $ & 847.30 & $375.10 & 42.30 \\ \hline Retained earnings > & $ & (8,449.80) & $ & (6,315.70) & $(7,815.60) & $(5,771.20) \\ \hline Accum. other comprehensive income > & $ & (463.20) & $ & 147.20 & $(364.60) & (503.30) \\ \hline Total Common Shareholders' Equity & $ & (8,706.60) & $ & (5,321.20) & $(7,805.10) & $(6,232.20) \\ \hline Noncontrolling interests & $ & 7.90 & $ & 6.70 & 5.70 & 1.20 \\ \hline Total Equity & $ & (8,698.70) & \$ & (5,314.50) & \$ (7,799.40) & $(6,231.00) \\ \hline Total Liabilities and Equity & $ & 27,978.40 & $ & 31,392.60 & $29,374.50 & $28,019.24 \\ \hline \end{tabular} 2022 2021 2020 2019 \begin{tabular}{|c|c|c|c|c|c|c|} \hline$ & 2,818.40 & $ & 6,455.70 & & 4,350.90 & $2,686.60 \\ \hline$ & 364.50 & $ & 162.20 & $ & 281.20 & 70.50 \\ \hline$ & 1,175.50 & $ & 940.00 & $ & 883.40 & 879.20 \\ \hline$ & 2,176.60 & $ & 1,603.90 & $ & 1,551.40 & $1,529.40 \\ \hline$ & 483.70 & $ & 594.60 & $ & 739.50 & 488.20 \\ \hline \$ & 7,018.70 & $ & 9,756.40 & $ & 7,806.40 & $5,653.90 \\ \hline \end{tabular} \begin{tabular}{|r|r|rr|rr|lr|} \hline$ & 279.10 & $ & 281.70 & $ & 206.10 & $ & 220.00 \\ \hline$ & 311.20 & $ & 268.50 & $ & 478.70 & $ & 396.00 \\ \hline$ & 15,609.80 & $ & 14,828.80 & $14,155.30 & $14,273.50 \\ \hline & (9,049.30) & $ & (8,459.30) & $(7,913.90) & $(7,841.80) \\ \hline & 6,560.50 & $ & 6,369.50 & $6,241.40 & $6,431.70 \\ \hline \end{tabular} r 2022 2021 2020 2019 \begin{tabular}{|l|l|l|l|l|} $13,119.90 & $13,616.90 & $14,659.60 & $11,167.00 \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & 1,515.20 & & 1,138.00 & $ & $1,412.91 \\ \hline & 6,279.70 & $ & 6,463.00 & $6,598.50 & $6,744.40 \\ \hline & 610.50 & 5 & 737.80 & 907.30 & $1,370.50 \\ \hline & 27,525.30 & $ & 28,555.70 & $29,827.10 & $26,694.81 \\ \hline & 36,677.10 & $ & 36,707.10 & $37,173.90 & 34,250.24 \\ \hline & 206.40 & $ & 47.30 & 375.10 & 42.30 \\ \hline \$ & (8,449.80) & $ & (6,315.70) & $(7,815.60) & $(5,771.20) \\ \hline$ & (463.20) & $ & 147.20 & $(364.60) & (503.30) \\ \hline \$ & (8,706.60) & $ & (5,321.20) & $(7,805.10) & $(6,232.20) \\ \hline & 7.90 & ? & 6.70 & 5.70 & 1.20 \\ \hline$ & (8,698.70) & $ & (5,314.50) & $(7,799.40) & $(6,231.00) \\ \hline S & 27,978.40 & $ & 31,392.60 & $29,374.50 & $28,019.24 \\ \hline \end{tabular}