Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

*cant be amazon* You determine the format. I would like you to use some computer application, not pen and paper. I would suggest WORD for

*cant be amazon*
image text in transcribed
You determine the format. I would like you to use some computer application, not pen and paper. I would suggest WORD for any analysis comments and EXCEL for any spreadsheet analysis (Horizontal/Vertical) You are analyzing a company from a financial standpoint and comparing them to another company. Make it easy for us to read and understand. Make a recommendation to deal with this company or not based on your analysis. 1. Choose a company from the following public companies. That means they trade their stock on a major stock exchange to anyone. TARGET, COSTCO, MACYS, HOME DEPOT, WALLMART, CVS, ALBERTSONS (includes Safeway). OFFICE DEPOT, OR KOHLS 2. Go to the company website to get the full financial information. Or just google the company name and IOK. The 10K or the carnings release at the fiscal year end has the financial results. YOU MUST USE A FULL YEAR INCOME STATEMENT. For most you should be able to find the 2020 10K. If not, use the 2019 3. Look at the Income statement, and balance sheet. If you want to know what the company says about its financial results read the latest financial statement released by the company 4. Do a Horizontal analysis of the Income Statement and Balance Sheet and a Vertical analysis of the Income Statement using 2020 and 2019 or 2019 and 2018, If you can download into EXCEL that would work great for this. If not, input the numbers into EXCEL or some other spreadsheet program, 5. Tell me a little about the company, What does the company do? What do they sell? Where are they incorporated? Where is their headquarters? Who are their woditors? Who else is in this business? Who are the competitors? Look at their Statement of Cash Flows - dad cash go up since last year or down. What caused the largest increases, largest decreases? List the top 3 things causing cash to go up and 3 causing cash to go down Do the have a positive net income, is it higher than last year! What are the big changes on the income statement from last year! How do they account for inventory - FIFO, LIFO or Weighted Avg? How do they depreciate their physical assets, straight line or other? Do they have any uneared or deferred revenue? Is their current ratio higher or lower than last year? What is their stock price per share? Is it higher or lower than a year ago? If you could ask the company president 3 questions, what would they be? 6. Choose a second company from the list above. These are all merchandise companies so choose any one you want. Some might have very big differences in their financials because some sell high volume at lower prices and some sell lower volume at higher prices. Analyze the financial results of the 2 companies side by side including the following: (For this, you will need to find the last full year of financial results for your second company, either 2019 or 2018) . Current Ratio Debt ratio? Quick ratio (to be discussed in class) How much cash do they have? Gross Profit - some don't calculate it if so, skip Profit Margin (Net Income divided by Net Sales or Revenue) Accounts Receivable Turnover, Average days to collect (365/AR turnover) Inventory tumover. How many times in a year do they turn over inventory What is their carings per share or loss? What is their PE ratio (use a current stock price, like May 15) If you had the SSS to invest, which company would you invest in? You determine the format. I would like you to use some computer application, not pen and paper. I would suggest WORD for any analysis comments and EXCEL for any spreadsheet analysis (Horizontal/Vertical) You are analyzing a company from a financial standpoint and comparing them to another company. Make it easy for us to read and understand. Make a recommendation to deal with this company or not based on your analysis. 1. Choose a company from the following public companies. That means they trade their stock on a major stock exchange to anyone. TARGET, COSTCO, MACYS, HOME DEPOT, WALLMART, CVS, ALBERTSONS (includes Safeway). OFFICE DEPOT, OR KOHLS 2. Go to the company website to get the full financial information. Or just google the company name and IOK. The 10K or the carnings release at the fiscal year end has the financial results. YOU MUST USE A FULL YEAR INCOME STATEMENT. For most you should be able to find the 2020 10K. If not, use the 2019 3. Look at the Income statement, and balance sheet. If you want to know what the company says about its financial results read the latest financial statement released by the company 4. Do a Horizontal analysis of the Income Statement and Balance Sheet and a Vertical analysis of the Income Statement using 2020 and 2019 or 2019 and 2018, If you can download into EXCEL that would work great for this. If not, input the numbers into EXCEL or some other spreadsheet program, 5. Tell me a little about the company, What does the company do? What do they sell? Where are they incorporated? Where is their headquarters? Who are their woditors? Who else is in this business? Who are the competitors? Look at their Statement of Cash Flows - dad cash go up since last year or down. What caused the largest increases, largest decreases? List the top 3 things causing cash to go up and 3 causing cash to go down Do the have a positive net income, is it higher than last year! What are the big changes on the income statement from last year! How do they account for inventory - FIFO, LIFO or Weighted Avg? How do they depreciate their physical assets, straight line or other? Do they have any uneared or deferred revenue? Is their current ratio higher or lower than last year? What is their stock price per share? Is it higher or lower than a year ago? If you could ask the company president 3 questions, what would they be? 6. Choose a second company from the list above. These are all merchandise companies so choose any one you want. Some might have very big differences in their financials because some sell high volume at lower prices and some sell lower volume at higher prices. Analyze the financial results of the 2 companies side by side including the following: (For this, you will need to find the last full year of financial results for your second company, either 2019 or 2018) . Current Ratio Debt ratio? Quick ratio (to be discussed in class) How much cash do they have? Gross Profit - some don't calculate it if so, skip Profit Margin (Net Income divided by Net Sales or Revenue) Accounts Receivable Turnover, Average days to collect (365/AR turnover) Inventory tumover. How many times in a year do they turn over inventory What is their carings per share or loss? What is their PE ratio (use a current stock price, like May 15) If you had the SSS to invest, which company would you invest in

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For Executives And MBAs

Authors: Paul Simko, James Wallace, Joseph Comprix

5th Edition

1618533665, 9781618533661

More Books

Students also viewed these Accounting questions

Question

1. Letters and diaries in history.

Answered: 1 week ago

Question

Score: Question 6 11/12 answered re cosu If d(z) = 4 ,2 9 du then

Answered: 1 week ago