• Compare the liquidity, solvency, and profitability of these two companies.
• Tell me what conclusions can be made from the data?
• Would you advise me to invest in these companies? Why or why not?

1 Financial Satement Analysis Project 2 Target Corporation Calculation Times (18000/10000) Wal-Mart Stroes Calculation (50000/55000) Times 0.909090909 1.8 Current Ratio Current Assets/Current Liabilities (66600/7900) Times 8.430379747 (407000/3800) Times 107.1052632 Days 365/8.43 Days 43.29774614 365/107.10 3.408029879 Times Times 6.617647059 (45000/6800) (305000/34200) 8.918128655 Days 365/6.62 Days 55.13595166 (356/8.92) 40.91928251 Percentage 32.43243243 Percentage 25.06142506 21600/66600*100 (102000/407000)*100 66600-45000 21600 407000-305000 102000 Times Times 1.496629213 66600/44500 66600/167000 0.398802395 Accounts Receivable Turnover Ratio 7 Net Creadit Sales/Average Account Recieivable B 2 Average Collection Period 0 365/Accounts Receivable Turnover Ratio 1 -2 Inventory Turnover Ratio 3 Cost of Goods Sold/Average Inventory 4 5 Days in Inventory 6 365/inventory turnover ratio -7 -8 % of profit margin -9 (Gross profit/sales)*100 co Gross Profit 1 (Sales-Cost of Goods Sold) 2 -3 Asset Turnover Ratio 4 Net Sales/Average Total Assets 5 Average Total Assest 6 (Beginning of year balances of Total Assest + end of year balances of total asset)/2 7 8 Return On Assets -9 (Net Income/Total Assets)*100 0 1 Reture On Common Stockholders Equity 2 (Net Income/Common Stockholders Equity)*100 3 4 Debt to Asset Ratio 5 Total Labilities/Total Asset 16 Total Labilities 7 (current Liabilities +Long Term term debt) 8 9 Times Interest earned 0 EBITDA/Interset Earned 11 EBITDA 2 Net Income +interest +taxes +Depreciation +Amortisation 31 (45000+44100)/2 44550 (163000+171000)/2 167000 Percentage 9.965986395 Percentage 7.842105263 4395/44100*100 (13410/171000)*100 Percentage 31.61870504 Percentage 20.953125 4395/13900*100 (13410/64000)*100 Percentage 0.616780045 Percentage 0.584795322 27200/44100 (100000/171000) 10000+17200 27200 (45000+55000) 100000 Times Times 9.075342466 6625/730 (22610/1800) 12.56111111 4395+730+1500 6625 (13410+1800+7400) 22610 1 Financial Satement Analysis Project 2 Target Corporation Calculation Times (18000/10000) Wal-Mart Stroes Calculation (50000/55000) Times 0.909090909 1.8 Current Ratio Current Assets/Current Liabilities (66600/7900) Times 8.430379747 (407000/3800) Times 107.1052632 Days 365/8.43 Days 43.29774614 365/107.10 3.408029879 Times Times 6.617647059 (45000/6800) (305000/34200) 8.918128655 Days 365/6.62 Days 55.13595166 (356/8.92) 40.91928251 Percentage 32.43243243 Percentage 25.06142506 21600/66600*100 (102000/407000)*100 66600-45000 21600 407000-305000 102000 Times Times 1.496629213 66600/44500 66600/167000 0.398802395 Accounts Receivable Turnover Ratio 7 Net Creadit Sales/Average Account Recieivable B 2 Average Collection Period 0 365/Accounts Receivable Turnover Ratio 1 -2 Inventory Turnover Ratio 3 Cost of Goods Sold/Average Inventory 4 5 Days in Inventory 6 365/inventory turnover ratio -7 -8 % of profit margin -9 (Gross profit/sales)*100 co Gross Profit 1 (Sales-Cost of Goods Sold) 2 -3 Asset Turnover Ratio 4 Net Sales/Average Total Assets 5 Average Total Assest 6 (Beginning of year balances of Total Assest + end of year balances of total asset)/2 7 8 Return On Assets -9 (Net Income/Total Assets)*100 0 1 Reture On Common Stockholders Equity 2 (Net Income/Common Stockholders Equity)*100 3 4 Debt to Asset Ratio 5 Total Labilities/Total Asset 16 Total Labilities 7 (current Liabilities +Long Term term debt) 8 9 Times Interest earned 0 EBITDA/Interset Earned 11 EBITDA 2 Net Income +interest +taxes +Depreciation +Amortisation 31 (45000+44100)/2 44550 (163000+171000)/2 167000 Percentage 9.965986395 Percentage 7.842105263 4395/44100*100 (13410/171000)*100 Percentage 31.61870504 Percentage 20.953125 4395/13900*100 (13410/64000)*100 Percentage 0.616780045 Percentage 0.584795322 27200/44100 (100000/171000) 10000+17200 27200 (45000+55000) 100000 Times Times 9.075342466 6625/730 (22610/1800) 12.56111111 4395+730+1500 6625 (13410+1800+7400) 22610