Analysis and Use of Financial Statements Project NIKE Inc. https://www.sec.gov/A
ID: 2419975 • Letter: A
Question
Analysis and Use of Financial Statements Project
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 annual report and calculate the ratios listed below. You will calculate the ratios for the two most recent years from available annual reports.
Once you have performed an analysis of the financial statements, you will write up a report summarizing the findings. 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 a conclusion.
Written proof of how the ratios were calculated MUST be attached to the report. You must calculate the ratios yourself.
Use the attached work page below to show proof of your calculations of the ratios (show all numbers in the calculations – not just the end result). The paper should be six (4) typed pages (not including the ratios and the ratio calculations). Roughly, the paper should have one page of introduction, four pages of analysis and interpretation, and one page of conclusion. The focus should be on the analysis and your interpretation.
The analysis of the financial ratios should include insights into the meanings behind the ratios. The ratios should tell a story about how the company is doing and its prospects for the future. You need to tell that story. In order to make the ratios more meaningful, a benchmark company or industry average for each ratio should also be included. You must calculate the benchmark company’s ratios as well. I do not need these calculations attached. The conclusion should provide insight into the financial future of the company. An investment recommendation should also be made in the conclusion.
Required ratios:
Liquidity Ratios and Asset Utilization ratios:
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 the company in the column labeled “Your Company.” You can calculate the ratios by hand or attached a sheet that clearly demonstrates how you calculated the ratio (i.e. X/Y = Z). The ratios you provide for your competitor or industry average do not need to be calculated (you can find these on various finance websites – though you will most likely have to calculate some yourself). Please attached this sheet to the back of your written project.
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
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
Explanation / Answer
Liquidity Ratio 2014 Current Ratio=Current assets/Current Liabilities 13696/5027 2.72 Quick Ratio=Current assets-Inventory-Prepaid Expense-Deferred Income tax/Current Liabilities (13696-3947-355-818)/5027 1.71 Account receivable Turnover=Net Credit Sales/Average Accountins receivable 27799/((3434+3117)/2) 8.49 Revenue is taken instaed of net credit sales as per the information given Inventory Tyrnover=COGS/Average Inventory 15353/((3947+3484)/2) 4.13 Average Cpllection Period=365/Accounts Receivable Turnover 365/8.49 42.99 total asset Turnover 27799/((18594+17545)/2) 0.85 Fixed Asset Turnover=Revenue/Average fixed Asset 27799/((18594-13696+17545-13630)/2) 3.48 Solvency ratio Debt to Equity ratio (18594-10824)/10824 0.72 Debtto total assets (18594-10824)/18594 0.42 Times Earned ratio=EBIT/Interest (3544+33(Interest)/33 108.39 Profitability Ratio Fgross margin ratio 12446/27799*100 44.77 % Profit Margin ratio 2693/27799*100 9.69 Return To Total assets 18594/27799*100 66.89 Return on cOmmon Equity 10824/27799*100 38.94 I have calculated ratio and answered various subparts
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.