Ratios		BJ's
Working Ratio		$ (560,631)
Current Assets		1,470,581
Current Liabilities		2,031,212
Current Ratio
Debt to Asset Ratio
Return on Equity
Return on Assets
Inventory Turnover
Days in Inventory
Accounts Receivable Turnover
Times Interest Earned
Free Cash Flow
Gross Profit Rate
Profit Margin
Asset Turnover

Determine what amounts are needed to calculate the ratios requested. For example you need Current Assets and Current Liabilities to compute the Current Ratio. Enter the names of the items needed in the boxes in column A for each of the ratios. I have completed the first set of account titles. Next, use the cell reference function and any other necessary formulas to enter the numbers for each of the items for each of the companies in the boxes under the requested ratios. Next use the numbers you have entered to calculate the ratios requested. ROUND ALL RATIO AMOUNTS TO 3 DECIMAL PLACES * Do not use percentages Repeat the steps for each of the ratios listed on the Ratio Tab Lastly, please show formulas on the formulas ratio page by copying over the ratios tab and pasting to the formulas tab. Lastly, use ctr and save so that the ratios page shows numbers and the formulas page show formulas only. Remeber no credit is given if formulas are not shown or used. HINTS Assume all sales were on credit where necessary. Show all numbers as positives not negatives by multiply by 1 COGS can also be called Cost of Sales Use Merchandise Costs for COGS for Costco Use Net income including noncontrolling interests for Costco Income Tax Expense can also be called the Provision for Income Taxes Remember to consider the Statement of Cash Flows when trying to determine cash spent for any particular items. Grading There are a total of 106 boxes that need to be filled in. Each box isworth 0.50 points If all correct total points possible is .50106=53 Each student must submit an ORIGINAL excel file that is their own work. While students are encouraged to work together, each student must process and format his/her own set of excel worksheet. Duplicate submissions (format, not numbers) will result in the students receiving a 0 for the assignment. And possibly other consequesces as stated inthe University Integrity policies. Show all numbers as positives not negatives by multiply by 1 COGS can also be called Cost of Sales Use Merchandise Costs for COGS for Costco Use Net income including noncontrolling interests for Costco Income Tax Expense can also be called the Provision for Income Taxes Remember to consider the Statement of Cash Flows when trying to determine cash spent for any particular items. \begin{tabular}{|l|r|r|r|} \hline Consolidated Balance Sheets (Parentheticals) - \$ 1 & Jan. 30,2021 & Feb. 01,2020 & Feb. 02,2019 \\ \hline shares shares in Thousands & $0.01 & $0.01 & $0.01 \\ \hline Preferred stock, par value (in dollars per share) & 5,000 & 5,000 & 0 \\ \hline Preferred stock, authorized (in shares) & 0 & 0 & 0 \\ \hline Preferred stock, outstanding (in shares) & 0 & 0 & 0 \\ \hline Common stock, par value (in dollars per share) & $0.01 & $0.01 & $0.01 \\ \hline Common stock, authorized (in shares) & 300,000 & 300,000 & 305,000,000 \\ \hline Common stock, issued (in shares) & 143,428 & 140,723 & 138,099,000 \\ \hline Common stock, outstanding (in shares) & 137,192 & 137,298 & 137,317,000 \\ \hline Treasury stock, shares (in shares) & 6,236 & 3,425 & 782,000 \\ \hline \end{tabular} Determine what amounts are needed to calculate the ratios requested. For example you need Current Assets and Current Liabilities to compute the Current Ratio. Enter the names of the items needed in the boxes in column A for each of the ratios. I have completed the first set of account titles. Next, use the cell reference function and any other necessary formulas to enter the numbers for each of the items for each of the companies in the boxes under the requested ratios. Next use the numbers you have entered to calculate the ratios requested. ROUND ALL RATIO AMOUNTS TO 3 DECIMAL PLACES * Do not use percentages Repeat the steps for each of the ratios listed on the Ratio Tab Lastly, please show formulas on the formulas ratio page by copying over the ratios tab and pasting to the formulas tab. Lastly, use ctr and save so that the ratios page shows numbers and the formulas page show formulas only. Remeber no credit is given if formulas are not shown or used. HINTS Assume all sales were on credit where necessary. Show all numbers as positives not negatives by multiply by 1 COGS can also be called Cost of Sales Use Merchandise Costs for COGS for Costco Use Net income including noncontrolling interests for Costco Income Tax Expense can also be called the Provision for Income Taxes Remember to consider the Statement of Cash Flows when trying to determine cash spent for any particular items. Grading There are a total of 106 boxes that need to be filled in. Each box isworth 0.50 points If all correct total points possible is .50106=53 Each student must submit an ORIGINAL excel file that is their own work. While students are encouraged to work together, each student must process and format his/her own set of excel worksheet. Duplicate submissions (format, not numbers) will result in the students receiving a 0 for the assignment. And possibly other consequesces as stated inthe University Integrity policies. Show all numbers as positives not negatives by multiply by 1 COGS can also be called Cost of Sales Use Merchandise Costs for COGS for Costco Use Net income including noncontrolling interests for Costco Income Tax Expense can also be called the Provision for Income Taxes Remember to consider the Statement of Cash Flows when trying to determine cash spent for any particular items. \begin{tabular}{|l|r|r|r|} \hline Consolidated Balance Sheets (Parentheticals) - \$ 1 & Jan. 30,2021 & Feb. 01,2020 & Feb. 02,2019 \\ \hline shares shares in Thousands & $0.01 & $0.01 & $0.01 \\ \hline Preferred stock, par value (in dollars per share) & 5,000 & 5,000 & 0 \\ \hline Preferred stock, authorized (in shares) & 0 & 0 & 0 \\ \hline Preferred stock, outstanding (in shares) & 0 & 0 & 0 \\ \hline Common stock, par value (in dollars per share) & $0.01 & $0.01 & $0.01 \\ \hline Common stock, authorized (in shares) & 300,000 & 300,000 & 305,000,000 \\ \hline Common stock, issued (in shares) & 143,428 & 140,723 & 138,099,000 \\ \hline Common stock, outstanding (in shares) & 137,192 & 137,298 & 137,317,000 \\ \hline Treasury stock, shares (in shares) & 6,236 & 3,425 & 782,000 \\ \hline \end{tabular}