If somebody could help me with steps to the following homework problem.
I need help with a Financial Statement Analysis of Target 2015.
Compute the following ratios based on Targetâs financial statements.
Acid-test ratio
Current ratio
Inventory Turnover
Total Debt to Total Asset ratio
Net profit margin
Gross profit
Prepare a vertical Analysis of the Income Statement and Balance Sheet
Provide your analysis of how well or badly Target is doing based on your research.
You can use the link below to find Target's 2015 annual report:
https://corporate.target.com/_media/TargetCorp/annualreports/2015/pdfs/Target-2015-Annual-Report.pdf
Thanks
If somebody could help me with steps to the following homework problem.
I need help with a Financial Statement Analysis of Target 2015.
Compute the following ratios based on Targetâs financial statements.
Acid-test ratio
Current ratio
Inventory Turnover
Total Debt to Total Asset ratio
Net profit margin
Gross profit
Prepare a vertical Analysis of the Income Statement and Balance Sheet
Provide your analysis of how well or badly Target is doing based on your research.
You can use the link below to find Target's 2015 annual report:
https://corporate.target.com/_media/TargetCorp/annualreports/2015/pdfs/Target-2015-Annual-Report.pdf
Thanks
For unlimited access to Homework Help, a Homework+ subscription is required.
Related questions
Analysis and Use of Financial StatementsProject
NIKE Inc.
https://www.sec.gov/Archives/edgar/data/320187/000032018715000113/nke-5312015x10k.htm
This assignment requires financial ratio analysis on Nike Inc.company. You will be required to examine Nike's companyâs annualreport and calculate the ratios listed below. You will calculatethe ratios for the two most recent years fromavailable annual reports.
Once you have performed an analysis of the financial statements,you will write up a report summarizing thefindings. The report will include a brief introduction,synopsis of the companyâs business and current business situation,a summary of the studentâs interpretation of teamâs analysis, and aconclusion.
Written proof of how the ratios were calculated MUST beattached to the report. You must calculate the ratiosyourself.
Use the attached work page below to show proof of yourcalculations of the ratios (show all numbers in the calculations ânot just the end result). The paper should be six (4) typedpages (not including the ratios and the ratiocalculations). Roughly, the paper should have one page ofintroduction, four pages of analysis and interpretation, and onepage of conclusion. The focus should be on the analysis and yourinterpretation.
The analysis of the financial ratios should include insightsinto the meanings behind the ratios. The ratios should tell a storyabout how the company is doing and its prospects for the future.You need to tell that story. In order to make the ratios moremeaningful, a benchmark company or industry average for each ratioshould also be included. You must calculate the benchmark companyâsratios as well. I do not need these calculations attached. Theconclusion should provide insight into the financial future of thecompany. An investment recommendation should also be made in theconclusion.
Required ratios:
Liquidity Ratios and Asset Utilizationratios:
Current Ratio
Quick Ratio
Accounts receivable turnover
Inventory turnover
Average collection period
Total assets turnover
Fixed Asset turnover
Solvency & Leverage Ratios
Times interest earned
Debt-to-equity ratio
Debt to total assets
Fixed charge coverage
Profitability Ratios:
Profit margin ratio
Gross Margin ratio
Return on total assets
Return on common stockholdersâ equity
Evidence of Ratio Calculations
Please show your calculations of the financial rations of thecompany in the column labeled âYour Company.â You can calculate theratios by hand or attached a sheet that clearly demonstrates howyou calculated the ratio (i.e. X/Y = Z). The ratios you provide foryour competitor or industry average do not need to be calculated(you can find these on various finance websites â though you willmost likely have to calculate some yourself). Pleaseattached this sheet to the back of your writtenproject.
Ratio | Your Company | Competitor/Industry Avg. |
Current Ratio | ||
Quick Ratio | ||
A/R Turnover | ||
Inventory Turnover | ||
Average collection period | ||
Total Assets Turnover | ||
Fixed Asset turnover | ||
Times-interest Earned Ratio | ||
Debt-to-Equity Ratio | ||
Fixed charge coverage | ||
Profit Margin Ratio | ||
Gross Margin Ratio | ||
Return-on-Total Assets Ratio | ||
Return-on-Common Stockholdersâ Equity Ratio |
Evaluate the financial performance of Coca-Cola; (KO) and Pepsi (PEP) for the year ended December 31, 2016. Follow the instructions below to access each companyâs information and perform a financial analysis based on the financial measures we have learned in this course.
Select Http://www.yahoo.com/ and then select Finance. In the Search section at the top of the screen select KO for Coca-Cola and PEP for Pepsi
Select âFinancialsâ and select Income Statement when accessing the Income Statement
Select âFinancialsâ and select Balance Sheet when accessing the Balance Sheet
Do the following for KO and PEP for the year ended 12/31/16 only
Perform a vertical analysis of the Income Statement for KO and PEP for the year ended 12/31/16.
Include in your vertical analysis all of following as a % of total revenue:
Cost of Revenue as a % of Total Revenue
Gross Profit as a % of Total Revenue
Selling, gen and administrative expenses as a % of Total Revenue
Operating Income as a % of Total Revenue
Net Income as a % of Total Revenue
Current Ratio
Accounts Receivable turnover. Assume the total revenue on the income statement represents all sales on account for the year
Average collection period
Merchandise Inventory turnover. Assume the Cost of Revenue on the Income Statement is the same as the Cost of Goods Sold
Debt to Asset Ratio
Return on Assets Ratio
Asset Turnover
In preparing the vertical analysis and other financial analysis above; define each measure and identify the strengths and weaknesses of KO and PEP as related to each other. Below is an example of you should set it up.
Working Capital | KO | PEP |
Current Assets | $ 34,010,000 | $ 27,089,000 |
- Current Liabilities | $ 26,532,000 | $ 21,135,000 |
Net Working Capital = | $ 7,478,000 | $ 5,954,000 |
Strength or Weakness
Working Capital measures the ability of a company to meet its short-term obligations with current assets. Pepsi is and Coke are performing at about the same level. Cokes working capital is a little higher because they have higher current assets and current liabilities.
Requirements for Each Group
1.The vertical analysis prepared in 4 A above.
2.All of your computations for the financial analysis. (4 B through 4 H)
3.Identification of strengths and weaknesses. (Include a definition of each financial measure, a description of which company is doing better in each financial measure including the vertical analysis and explain why)
4.All group members must submit the Report Project Team Assessment
5.If the requirements above are not met, points will be deducted from Parts of the group projects.
Enter all requirements on the Group Project Problem 4 Tab.
Submit one set of answers per group for all four problems. Make sure to include each group members name at the top of each spreadsheet.
Each group member should download the Group Team Assessment and evaluate themselves and everyone else in their group. This evaluation should be submitted anonymously.