Use the Last four years of Lululemon Athleticas financial statement data to answer the question

Level-Up Excel Skill 5 Cash Conversion Cycle Using the latest four years of financial statement data, calculate the Cash Conversion Cycle for the company for the latest three reporting years. Add a tab to your Exeel workbook and ereate an Excel model that will calculate the length of time cash is tied up by the company I working capital. 1. The model should clearly label the financial statement data that are used as inputs into the calculations. 2. The model should output the intermediate calculations of Inventory conversion period; average collection period, and payables defernable period. 3. Final output for each of the latest years should be calculated from the intermediate calculations from number (2). 4. What do you obserye in the trends of the company's cash flows related to working capital manngement? - corporate.lululemon.com lululemon athletica inc. CONSOLIDATED BALANCE SHEETS (Amounts in thousands, except per share amounts) \begin{tabular}{|c|c|c|} \hline & \begin{tabular}{l} Januacy 29 \\ 2023 \end{tabular} & \begin{tabular}{l} January 30, \\ 2022 \end{tabular} \\ \hline \multicolumn{3}{|l|}{\begin{tabular}{l} ASSETS \\ Curfent assets \end{tabular}} \\ \hline \multicolumn{3}{|l|}{ Current assets } \\ \hline Cash and cash equivalents & 1,154,867 & 1.759871 \\ \hline Accounts receivable, net & 132,906 & 77,001 \\ \hline Inwentories & 1,447,367 & 965.481 \\ \hline Prepaid and receivable income taxes & 185,641 & 118,928 \\ \hline \multirow[t]{2}{*}{ Prepaid expenses and other current assets } & 238,672 & 192572 \\ \hline & 3,159,453 & 2,614,853 \\ \hline Property and equipment, net: & 1,269,614 & 927,710 \\ \hline Right-of-use lease assets & 969,419 & 803,543 \\ \hline Goodwill & 24,144 & 385.850 \\ \hline Intangible assets, net & 21,961 & 71,299 \\ \hline Deferred income tax assets & 6,402 & 5.091 \\ \hline \multirow[t]{2}{*}{ Other non-current assets } & 156,045 & 132,102 \\ \hline & 5,607,038 & 4,942,478 \\ \hline \multicolumn{3}{|l|}{ LABILITIES AND STOCKHOLDERS EQUITY } \\ \hline \multicolumn{3}{|l|}{ Curfent liabilities: } \\ \hline Accounts payable & 172,732 & 289,728 \\ \hline Accrued liabilities and other & 399,223 & 330,800 \\ \hline Accrued compensation and related expenses & 248,167 & 204,921 \\ \hline Current lease liabilities & 207.972 & -188.995 \\ \hline Current income takes payable & 174,221 & 133,852 \\ \hline Unedeemed gift card liability & 251,478 & 20d,195 \\ \hline & 38,405 & 48842 \\ \hline & 1,492,198 & 1,405,334 \\ \hline Non-surrent lease liabilities: & 862,362 & 692056 \\ \hline Non-current income taxes payable & 25,555 & 39074 \\ \hline Deferred income tax liabilities & 55,084 & 53,352 \\ \hline \multirow{2}{*}{\begin{tabular}{l} Deferred ncoine tax liabilies \\ Other non-current liabilities: \end{tabular}} & 20,040 & 13.615 \\ \hline & 2,458,239 & 2,202,432 \\ \hline \multicolumn{3}{|l|}{ Commitments and contingencies } \\ \hline \multicolumn{3}{|l|}{\begin{tabular}{l} Commitments and contingenciet \\ Stockholders' equity \end{tabular}} \\ \hline \begin{tabular}{l} Stockholders' equity \\ Undesignated preferred stock $0.01 par value: 5.000 shares authorized; none issued and outstanding \end{tabular} & - & - \\ \hline & - & - \\ \hline & - & - \\ \hline Commoo stock, 50,005 per value: 400,000 shares authorized; 122,205 and 123,297 issued and oststanding & 611 & 616 \\ \hline & 474,695 & 422.507 \\ \hline \begin{tabular}{l} Additional pais-incapical \\ Retained earnings \end{tabular} & 2,926.127 & 2,512,840 \\ \hline \begin{tabular}{l} Retained earnings \\ Accurmulated oqher comprehensive ioss \end{tabular} & (252,584) & (195,917) \\ \hline Arcumulated other comprehensive ioss & 3.148,799 & 2,740,046 \\ \hline & 5,607,031 & 4,942.478 \\ \hline \end{tabular} See accompanying notes to the consolidated financial statements lululemon athletica inc. CONSOUDATED STATEMENTS OF OPERATIONS AND COMPREHENSIVE INCOME See accompanying notes to the consolidated financial statements See accompanyies notes to the coniclidated financial statements 41 lululemon athletica inc. CONSOUDATED STATEMENTS OF OPERATIONS ANO COMPREHENSIVE INCOME See accompanyine notes to the consolidated financial Aatements lululemon athletica inc. CONSOUDATED STATEMENTS OF OPERATIONS AND COMPREHENSIVE INCOME See accompanying notes to the consolidated financial statements