I am not sure how to do this assignment.
Brief Guidelines of Project One for FIRE 371 (3% of semester grade) You are required to write a short financial analysis paper for a publicly-traded US company. Each paper must contain the following ingredients. 1. Obtain the Data (1%) a. Pick a publicly-traded US company ( a lot of companies are publicly traded, examples include Walmart, Apple, Google, Amazon etc) b. Download the firm’s financial data from capital IQ (refer to the manual); 2. Financial Analysis – Excel Worksheet (2%) a. Using the balance sheet and income statement for analysis b. Calculate 8 ratios for the most recent 5 years (these 8 ratios are – current ratio; inventory turnover; receivables turnover; total asset turnover; profit margin; equity multiplier; return on asset; return on equity), and think about the trends c. Submit the excel worksheet to D2L (sample excel file is posted on D2L) Deadline: 10/20/2021 Capital IQ Self Registration: 1. Go to S CSU Library: 2. Choose “Find a DataBase” on the screen, and then go to “C”, you will find “Capital IQ”. 3. Enter their StarID & Password to get the Capital IQ site 4. Click New User and start from here to set up your account. Caveats: 1. Students must create and use their accounts via the library link. If they go straight to Capital IQ, it won’t work. 2. Part of the instructions asks for email address. The students must use @go.stcloudstate.edu (or possibly @stcloudstate.edu if they don't have the 'go' part). That will identify them as SCSU students. Step 1: Go to : www.capitaliq.com Login with your username and password (you should have received an email from S&P for that, each student has an account already set up for them). Step 2: Choose a company and input the firm’s name. I will use LuLuLemon as one example. Input the company name http://www.capitaliq.com/ lhhcd Sticky Note Follow Capital IQ self registration manual to get your username and password to log into capital IQ lhhcd Cross-Out lhhcd Inserted Text Step 3: When you input the firm name, the following is the screen you will see, then click “Compustat Financials/Income Statement”. C lick Step 4: After that, click “Download Financials” and save the files to the location you desire. Step 5: In the financial information you downloaded, the only worksheets we need are the first two sheets – balance sheet and income statement. You can delete other sheets. Income Statement Lululemon Athletica Inc. (NasdaqGS:LULU) > Compustat Financials > Income Statement In Millions of the reported currency, except per share items.Template:Standard Restatement:Latest Period Type:Annual Order:Latest on Right Currency:Reported Currency Conversion:Historical Units:S&P Capital IQ (Default) Decimals:Capital IQ (Default) Income Statement For the Fiscal Period Ending12 months Jan-31-201512 months Jan-31-201612 months Jan-31-201712 months Jan-31-201812 months Jan-31-2019LTM 12 months Jul-31-2019 CurrencyUSDUSDUSDUSDUSDUSD Total Revenue1,797.22,060.52,344.42,649.23,288.33,580.8 Cost of Goods Sold824.7990.01,057.11,137.21,349.51,460.4 Gross Profit972.51,070.51,287.31,512.01,938.82,120.4 Selling General & Admin. Exp.538.1628.1778.5904.31,110.51,218.8 Depreciation and Amortization58.473.487.7104.5122.5137.5 Operating Income376.0369.1421.2503.2705.8764.1 Interest ExpenseCFCFCFCFCF0 Interest and Related IncomeCFCFCFCFCF0 Other Non-Operating Inc. (Exp.)7.1(0.6)1.64.09.40 Non-Operating Income (Expense)7.1(0.6)1.64.09.49.1 Total Unusual Items000(47.2)00 Pretax Income383.1368.5422.7460.0715.3773.3 Income Taxes144.1102.4119.3201.3231.4238.8 Income Before Extra & Minority Int.239.0266.0303.4258.7483.8534.5 Minority Interest000000 Income Before Extraordinary Items239.0266.0303.4258.7483.8534.5 Extra Items & Disc. Operations-----0 Net Income239.0266.0303.4258.7483.8534.5 Preferred Dividends000000 Common Stock Equiv. & Other Adj.000000 Net Income to Common239.0266.0303.4258.7483.8534.5 Per Share Items Basic EPS Excl. Extra Items$1.66$1.9$2.21$1.9$3.63$4.07 Basic EPS Incl. Extra Items$1.66$1.9$2.21$1.9$3.63$4.07 Weighted Avg. Basic Shares Out.143.9140.4137.1136.0133.4131.3 Diluted EPS Excl. Extra Items$1.66$1.89$2.21$1.9$3.61$4.05 Diluted EPS Incl. Extra Items$1.66$1.89$2.21$1.9$3.61$4.05 Weighted Avg. Diluted Shares Out.144.3140.6137.3136.2134.0131.9 EPS from Operations$1.89$1.9$2.21$2.59$3.86$4.31 Diluted EPS from Operations$1.89$1.89$2.21$2.59$3.84$4.29 Supplemental and Other Operating Expense Items EBITDA434.4442.5508.8607.7828.3901.6 EBIT376.0369.1421.2503.2705.8764.1 EBITDAR540.4566.9656.2775.01,026.3- EBITA376.9369.9421.9503.2705.8764.1 Common Dividends00000- Normalized Net Income272.0266.7303.0352.2515.0565.7 Interest Capitalized000000 Excise Taxes000000 R&D Expense-----0 Total Pension Expense--3.25.26.4- Rental Expense106.0124.5147.4167.3198.0- Stock Compensation Expense8.310.416.817.629.640.1 Amortization of Intangibles0.90.80.7--0 Total Operating Expenses1,362.81,618.11,835.52,041.52,460.02,679.2 Income / (Loss) from Affiliates000000 Foreign Exchange Income6.412.0(8.3)7.31.44.1 Earnings from Discontinued Operations000000 Extraordinary Items000000 Company NotesNA2016 NotesNA2018 Notes2019 NotesNA Effective DateMar-27-2015Apr-14-2016Dec-08-2018Mar-29-2018Apr-12-2019Sep-06-2019 Note: For multiple class companies, per share items are primary class equivalent, and for foreign companies listed as primary ADRs, per share items are ADR-equivalent. Balance Sheet Lululemon Athletica Inc. (NasdaqGS:LULU) > Compustat Financials > Balance Sheet In Millions of the reported currency, except per share items.Template:Standard Restatement:Latest Period Type:Annual Order:Latest on Right Currency:Reported Currency Conversion:Historical Units:S&P Capital IQ (Default) Decimals:Capital IQ (Default) Balance Sheet Balance Sheet as of:Jan-31-2015Jan-31-2016Jan-31-2017Jan-31-2018Jan-31-2019Jul-31-2019 CurrencyUSDUSDUSDUSDUSDUSD Assets Cash664.5501.5734.8990.5881.3623.7 Short-Term Investments000000 Cash & Short-Term Investments664.5501.5734.8990.5881.3623.7 Trade Receivables13.713.19.219.235.827.7 Income Tax Refund0CFCFCFCF- Other Receivables00000- Other Receivables, Total-----CF Total Receivables13.713.19.219.235.827.7 Total Inventories208.1284.0298.4329.6404.8494.3 Prepaid ExpensesCFCFCFCFCF- Other Current Assets64.7118.4120.397.0107.3- Other Current Assets, Total64.7118.4120.397.0107.3187.3 Total Current Assets951.0917.01,162.71,436.31,429.31,333.0 Gross Property, Plant & Equipment453.9553.4701.8817.4972.51,729.4 Accumulated Depreciation & Amort.(157.9)(203.8)(278.3)(343.7)(405.2)(455.3) Net Property, Plant & Equipment296.0349.6423.5473.6567.21,274.1 Investment & Advances, Equity00000- Investment & Advances, Other00000- Total Intangible Assets26.224.824.624.724.2- Other Assets, Total23.022.746.763.964.087.6 Total Assets1,296.21,314.11,657.51,998.52,084.72,694.7 Liabilities Accounts Payable9.310.424.824.695.5110.5 Notes Payable & Other ST Borrowings00000- Current Portion of LT Debt00000- Total Current Debt-----130.2 Income Taxes Payable20.137.730.315.767.45.1 Accrued Expenses84.2119.7115.9129.7194.0- Other Current Liabilities46.357.770.5122.6143.5- Other Current Liabilities, Total130.5177.4186.3252.3337.5306.8 Total Current Liabilities159.9225.5241.4292.6500.5552.6 Long-Term Debt00000568.3 Deferred Taxes & Investment Tax Credit3.610.87.31.314.214.1 Other Liabilities43.150.348.9107.6124.052.3 Total Liabilities206.6286.6297.6401.5638.71,187.4 Redeemable Minority Interest000000 Preferred Stock, Redeemable000000 Preferred Stock, Nonredeemable000000 Common Stock0.70.60.60.60.60.6 Capital Surplus241.7245.5266.6284.3315.3329.9 Retained Earnings847.2781.31,092.71,312.11,130.11,176.8 Total Treasury Stock-----0 Total Common Equity1,089.61,027.51,360.01,597.01,446.01,507.4 Total Parent Equity1,089.61,027.51,360.01,597.01,446.01,507.4 Nonredeemable Minority Interest000000 Total Equity1,089.61,027.51,360.01,597.01,446.01,507.4 Total Liabilities and Equity1,296.21,314.11,657.51,998.52,084.72,694.7 Supplemental Items Common Shares Outstanding141.9137.3137.1135.4130.9130.3 Book Value/Share7.687.489.9211.7911.0411.57 Tangible Book Value1,063.41,002.71,335.41,572.31,421.71,483.2 Tangible Book Value/Share7.497.39.7411.6110.8611.38 Total Debt00000698.5 Net Debt(664.5)(501.5)(734.8)(990.5)(881.3)74.8 Debt Equivalent Oper. Leases847.9995.81,179.21,338.41,584.0- Inventories, Raw Materials000000 Inventories, Work In Process000000 Inventories, Finished Goods208.1284.0298.4329.6404.8494.3 Inventories, Other000000 LIFO Reserve00000- Estimated Doubtful ReceivablesIFIFIFIFIF- Working Capital791.1691.5921.31,143.7928.8780.4 Goodwill24.423.824.224.624.224.2 Other Intangibles1.80.90.30.100 Deferred Charges00000- Other Assets23.022.746.763.964.0- Deferred Taxes3.610.87.31.314.214.1 Investment Tax Credit00000- Total Employees8,62811,00012,50013,40015,700- Company NotesNA2016 NotesNA2018 Notes2019 NotesNA Effective DateMar-27-2015Apr-14-2016Apr-01-2017Mar-29-2018Apr-12-2019Sep-06-2019 Note: For multiple class companies, total share counts are primary class equivalent, and for foreign companies listed as primary ADRs, total share counts are ADR-equivalent. Ratio Calculations Balance Sheet as of:Jan-31-2015Jan-31-2016Jan-31-2017Jan-31-2018Jan-31-2019 CurrencyUSDUSDUSDUSDUSD8 ratios20152016201720182019 Assets Cash664.5501.5734.8990.5881.3Current Ratio5.954.074.824.912.86 Short-Term Investments00000Inventory Turnover3.963.493.543.453.33 Cash & Short-Term Investments664.5501.5734.8990.5881.3Receivable Turnover130.74157.20254.83138.1791.89 Total Asset Turnover1.391.571.411.331.58 Trade Receivables13.713.19.219.235.8 Income Tax Refund0CFCFCFCFProfit Margin0.130.130.130.100.15 Other Receivables00000Equity Multiplier1.191.281.221.251.44 Other Receivables, Total-----Return on Asset0.180.200.180.130.23 Total Receivables13.713.19.219.235.8Return on Equity0.220.260.220.160.33 Total Inventories208.1284.0298.4329.6404.8 Prepaid ExpensesCFCFCFCFCF Other Current Assets64.7118.4120.397.0107.3 Other Current Assets, Total64.7118.4120.397.0107.3 Total Current Assets951.0917.01,162.71,436.31,429.3 Gross Property, Plant & Equipment453.9553.4701.8817.4972.5 Accumulated Depreciation & Amort.(157.9)(203.8)(278.3)(343.7)(405.2) Net Property, Plant & Equipment296.0349.6423.5473.6567.2 Investment & Advances, Equity00000 Investment & Advances, Other00000 Total Intangible Assets26.224.824.624.724.2 Other Assets, Total23.022.746.763.964.0 Total Assets1,296.21,314.11,657.51,998.52,084.7 Liabilities Accounts Payable9.310.424.824.695.5 Notes Payable & Other ST Borrowings00000 Current Portion of LT Debt00000 Total Current Debt----- Income Taxes Payable20.137.730.315.767.4 Accrued Expenses84.2119.7115.9129.7194.0 Other Current Liabilities46.357.770.5122.6143.5 Other Current Liabilities, Total130.5177.4186.3252.3337.5 Total Current Liabilities159.9225.5241.4292.6500.5 Long-Term Debt00000 Deferred Taxes & Investment Tax Credit3.610.87.31.314.2 Other Liabilities43.150.348.9107.6124.0 Total Liabilities206.6286.6297.6401.5638.7 Redeemable Minority Interest00000 Preferred Stock, Redeemable00000 Preferred Stock, Nonredeemable00000 Common Stock0.70.60.60.60.6 Capital Surplus241.7245.5266.6284.3315.3 Retained Earnings847.2781.31,092.71,312.11,130.1 Total Treasury Stock----- Total Common Equity1,089.61,027.51,360.01,597.01,446.0 Total Parent Equity1,089.61,027.51,360.01,597.01,446.0 Nonredeemable Minority Interest00000 Total Equity1,089.61,027.51,360.01,597.01,446.0 Total Liabilities and Equity1,296.21,314.11,657.51,998.52,084.7 Income Statement For the Fiscal Period Ending12 months Jan-31-201512 months Jan-31-201612 months Jan-31-201712 months Jan-31-201812 months Jan-31-2019 CurrencyUSDUSDUSDUSDUSD Total Revenue1,797.22,060.52,344.42,649.23,288.3 Cost of Goods Sold824.7990.01,057.11,137.21,349