Finance Research on NIKE
STUCK with your assignment? When is it due? Hire our professional essay experts who are available online 24/7 for an essay paper written to a high standard at a reasonable price.
Order a Similar Paper Order a Different Paper
Company of choice: NIKE- Q4 of 2022 reports
Instructions:
research sources, such as Yahoo! Finance and MSN Money, for the financial highlights and trading information on your selected company. Using these sites, you will compute the ratios for the most recent year-end of your chosen company. You will also need to collect the quarterly data for the four quarters of your chosen company (with the last quarter being of the same ending date as your year-end). An Excel template is provided for you to compute these ratios. You will research various internet sources for the financial highlights and trading information on your selected company. At the same time, you should research the data for industry averages. It is highly likely all the important ratios for the industry will be unavailable except at a prohibitive cost. I highly suggest you supplement these ratios with those of the closest competitor. Therefore, a good practice is to research two companies in part 1, your competitor and a competitor. Therefore, when you are searching for data, you can do so for both companies at the same time.
Using these sites, you will compute the ratios for the four most recent quarters of your chosen company. Please make sure the data for the industry and the competitor aligns with the quarterly data you get for your chosen company, especially with regards to the dates. When accumulating the data, consider the Q4 and the end of year fully audited data as the same date. QI, 2, and 3 are the quarters immediately before Q4. This may mean that you may have to ignore recent quarterly data. An Excel template will be provided for you to compute these ratios.
Part Two A: Numerical Analysis Computations
In this second phase of the research project, you will provide the following information necessary to begin your research. Use the Excel spreadsheet posted in the Research Project content page to input quarterly financial data for your chosen company. Quarter 4 should correspond to the most recent year-end data for the company as is produced in the company’s IOK report. Using the Excel template, compute the ratios for the four most recent quarters of your chosen company. Sources of free data include Yahoo Finance and MSN Money. Research at least three Web sites to obtain the most accurate and reliable information. By using at least three sources, you will be able to select the financial information from two of the sources with the most closely corresponding information.
START HERE
| Congatulations on achieving the first step towards mastering Financial Management by reinforcing your foundational knowledge in Algebra, Numerology, and Financial Accounting. You are now well equipped to master a company’s important Financial Management functions: evaluating its financial performance, comparing its performance over time (trend analysis) and in comparison (comparative analysis) to other firms in the industry. |
| Why is this important? Many times you are enticed to invest in a company’s stock because there is a lot of buzz on social media or your barber/hairdresser told you this is a sure deal ased on an inside tip! You will learn through your Business program that it is critical to possess this deep understanding of Financial Management, supplement it with data on the economy, industry and other considerations that allow you to rationally improve future decision-making. |
| We want to make sure you understand the synergies with the impressive work you have already done on the review of Accounting concepts. This project is designed to show you how to build on this work to make important Financial Management decisions. You can also supplement this analysis with data visulaization techniques that Excel allows you to do. |
| Once you understand these vital steps you will be well on the road to controlling the important inputs to keep creating and adding value for your chosen company to improve its long term performance. You can also use this type of analysis to make important investment decisions, in terms of investing in stocks and bonds for the long haul based on fundamental analysis. Good luck! |
| Please start this exercise by including the Financial Statement information that you have already gathered from the Accounting Review section into the next tab labelled “Input”. Then check the results in the tabs following beginning with Liquidity etc. |
Input
| [Company Name] | |||||||||
| Ratio Analysis | |||||||||
| Input Worksheet | |||||||||
| [Date] | |||||||||
| Gray cells will be calculated for you. You do not need to enter anything into them. When inputting the Q1 to Q4 data ensure that it is chronologically accurate with the end of Q4 being the same | |||||||||
| Enter amounts into the yellow cells only. | |||||||||
| Be sure to enter industry averages for the ratio calculations on the other pages of the spreadsheet by replacing every cell which contains red font. Use your algebraic skills you have already mastered to calculate the deviation or the variance of your company’s ratio with the industry/peer company’s avarage. | |||||||||
| Line Item | Beginning of Year | ||||||||
| Inventory | |||||||||
| Total assets | |||||||||
| Owners’ equity | |||||||||
| Number of common shares | |||||||||
| Line Item | Q1 | Q2 | Q3 | Q4 | Annual | ||||
| Current assets | $0 | ||||||||
| Fixed assets | $0 | ||||||||
| Other assets | $0 | ||||||||
| Total assets | 0 | 0 | 0 | 0 | $0 | ||||
| Average total assets | 0 | 0 | 0 | 0 | $0 | ||||
| Cash and cash equivalents | $0 | ||||||||
| Inventory | $0 | ||||||||
| Average inventory | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Current liabilities | $0 | ||||||||
| Total liabilities | $0 | ||||||||
| Owners’ equity | $0 | ||||||||
| Number of common shares | 0 | ||||||||
| Average number of common shares | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Average owners’ equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Market price per share | $0.00 | ||||||||
| Operating Cash flow | $0 | ||||||||
| Cash flow per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Dividends paid | $0 | ||||||||
| Total sales | $0 | ||||||||
| Cost of sales | $0 | ||||||||
| Other Operating expenses | $0 | ||||||||
| Operating income | 0 | 0 | 0 | 0 | $0 | ||||
| Earnings before interest and taxes | $0 | ||||||||
| Interest expense | $0 | ||||||||
| Net income | $0 | ||||||||
Liquidity
| [Company Name] | |||||||||||||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||||||||||||
| Liquidity Ratios | Q1 | Q2 | Q2 | Q3 | Q4 | Annual | |||||||||||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||||||||||||
| Current Ratio | = | Current Assets | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||||||||||||
| Current Liabilities | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Quick Ratio | = | Current Assets – Inventory | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ||||||||
| Current Liabilities | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | |||||||||||||||||||||||||||||||||||
| Variance | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Net Working Capital Ratio | = | Current Assets – Current Liabilities | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ||||||||
| Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Current Liabilities to Inventory Ratio | = | Current Liabilities | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||||||||||||
| Inventory | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Cash Ratio | = | Cash and Cash Equivalents | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||||||||||||
| Current Liabilities | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Operating Ratio | = | Operating Expenses | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||||||||||||
| Operating Income | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
Assets
| [Company Name] | |||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||
| Asset Ratios | Q1 | Q2 | Q3 | Q4 | Annual | ||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||
| Inventory Turnover Ratio | = | Total Cost of Sales | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Average Inventory | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Fixed Assets Turnover Ratio | = | Total Sales | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Fixed Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Total Assets Ratio | = | Total Sales | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Asset to Equity Ratio | = | Total Assets | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Owners’ Equity | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
Profitability
| [Company Name] | |||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||
| Profitability Ratios | Q1 | Q2 | Q3 | Q4 | Annual | ||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||
| Return on Assets Ratio | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Average Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Return on Equity Ratio | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Average Owners’ Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Profit Margin Ratio | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Total Sales | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Basic Earnings Power Ratio | = | Earnings Before Interest and Taxes | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Earnings per Share Ratio | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Average Number of Common Shares | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | |||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
Debt
| [Company Name] | |||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||
| Debt Ratios | Q1 | Q2 | Q3 | Q4 | Annual | ||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||
| Total Debt Ratio | = | Total Liabilities | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Interest Coverage Ratio | = | Earnings Before Interest and Taxes | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Interest Expense | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Debt/Equity Ratio | = | Total Liabilities | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Owners’ Equity | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
Market
| [Company Name] | |||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||
| Market Ratios | Q1 | Q2 | Q3 | Q4 | Annual | ||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||
| Earnings per Share | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| (EPS) Ratio | Average Number of Common Shares | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Price to Earnings Ratio | = | Market Price per Share | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ||||||||
| Earnings per Share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Price to Cash Flow Ratio | = | Market Price per Share | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ||||||||
| Cash Flow per Share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Payout Ratio | = | Dividends Paid | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Net Income | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
END HERE
| Congratulations! You have now completed the numerical part of the assignment. Next you need to answer a very important question, “What does this all mean for investment purposes?” To do this well you need to critically examine what you have been able to achieve and reflect on what it all means for decision-making. Therefore the next step is completing the AT-EASE reflection statement. |
START HERE
| Congatulations on achieving the first step towards mastering Financial Management by reinforcing your foundational knowledge in Algebra, Numerology, and Financial Accounting. You are now well equipped to master a company’s important Financial Management functions: evaluating its financial performance, comparing its performance over time (trend analysis) and in comparison (comparative analysis) to other firms in the industry. |
| Why is this important? Many times you are enticed to invest in a company’s stock because there is a lot of buzz on social media or your barber/hairdresser told you this is a sure deal ased on an inside tip! You will learn through your Business program that it is critical to possess this deep understanding of Financial Management, supplement it with data on the economy, industry and other considerations that allow you to rationally improve future decision-making. |
| We want to make sure you understand the synergies with the impressive work you have already done on the review of Accounting concepts. This project is designed to show you how to build on this work to make important Financial Management decisions. You can also supplement this analysis with data visulaization techniques that Excel allows you to do. |
| Once you understand these vital steps you will be well on the road to controlling the important inputs to keep creating and adding value for your chosen company to improve its long term performance. You can also use this type of analysis to make important investment decisions, in terms of investing in stocks and bonds for the long haul based on fundamental analysis. Good luck! |
| Please start this exercise by including the Financial Statement information that you have already gathered from the Accounting Review section into the next tab labelled “Input”. Then check the results in the tabs following beginning with Liquidity etc. |
Input
| [Company Name] | |||||||||
| Ratio Analysis | |||||||||
| Input Worksheet | |||||||||
| [Date] | |||||||||
| Gray cells will be calculated for you. You do not need to enter anything into them. When inputting the Q1 to Q4 data ensure that it is chronologically accurate with the end of Q4 being the same | |||||||||
| Enter amounts into the yellow cells only. | |||||||||
| Be sure to enter industry averages for the ratio calculations on the other pages of the spreadsheet by replacing every cell which contains red font. Use your algebraic skills you have already mastered to calculate the deviation or the variance of your company’s ratio with the industry/peer company’s avarage. | |||||||||
| Line Item | Beginning of Year | ||||||||
| Inventory | |||||||||
| Total assets | |||||||||
| Owners’ equity | |||||||||
| Number of common shares | |||||||||
| Line Item | Q1 | Q2 | Q3 | Q4 | Annual | ||||
| Current assets | $0 | ||||||||
| Fixed assets | $0 | ||||||||
| Other assets | $0 | ||||||||
| Total assets | 0 | 0 | 0 | 0 | $0 | ||||
| Average total assets | 0 | 0 | 0 | 0 | $0 | ||||
| Cash and cash equivalents | $0 | ||||||||
| Inventory | $0 | ||||||||
| Average inventory | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Current liabilities | $0 | ||||||||
| Total liabilities | $0 | ||||||||
| Owners’ equity | $0 | ||||||||
| Number of common shares | 0 | ||||||||
| Average number of common shares | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Average owners’ equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Market price per share | $0.00 | ||||||||
| Operating Cash flow | $0 | ||||||||
| Cash flow per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| Dividends paid | $0 | ||||||||
| Total sales | $0 | ||||||||
| Cost of sales | $0 | ||||||||
| Other Operating expenses | $0 | ||||||||
| Operating income | 0 | 0 | 0 | 0 | $0 | ||||
| Earnings before interest and taxes | $0 | ||||||||
| Interest expense | $0 | ||||||||
| Net income | $0 | ||||||||
Liquidity
| [Company Name] | |||||||||||||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||||||||||||
| Liquidity Ratios | Q1 | Q2 | Q2 | Q3 | Q4 | Annual | |||||||||||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||||||||||||
| Current Ratio | = | Current Assets | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||||||||||||
| Current Liabilities | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Quick Ratio | = | Current Assets – Inventory | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ||||||||
| Current Liabilities | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | |||||||||||||||||||||||||||||||||||
| Variance | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Net Working Capital Ratio | = | Current Assets – Current Liabilities | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ERROR:#DIV/0! | = | $0 | – | $0 | ||||||||
| Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Current Liabilities to Inventory Ratio | = | Current Liabilities | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||||||||||||
| Inventory | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Cash Ratio | = | Cash and Cash Equivalents | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||||||||||||
| Current Liabilities | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
| Operating Ratio | = | Operating Expenses | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||||||||||||
| Operating Income | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||
| Quarterly Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||||||||||||
Assets
| [Company Name] | |||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||
| Asset Ratios | Q1 | Q2 | Q3 | Q4 | Annual | ||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||
| Inventory Turnover Ratio | = | Total Cost of Sales | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Average Inventory | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Fixed Assets Turnover Ratio | = | Total Sales | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Fixed Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Total Assets Ratio | = | Total Sales | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Asset to Equity Ratio | = | Total Assets | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Owners’ Equity | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
Profitability
| [Company Name] | |||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||
| Profitability Ratios | Q1 | Q2 | Q3 | Q4 | Annual | ||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||
| Return on Assets Ratio | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Average Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Return on Equity Ratio | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Average Owners’ Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Profit Margin Ratio | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Total Sales | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Basic Earnings Power Ratio | = | Earnings Before Interest and Taxes | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Earnings per Share Ratio | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Average Number of Common Shares | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | |||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
Debt
| [Company Name] | |||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||
| Debt Ratios | Q1 | Q2 | Q3 | Q4 | Annual | ||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||
| Total Debt Ratio | = | Total Liabilities | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Total Assets | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Interest Coverage Ratio | = | Earnings Before Interest and Taxes | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Interest Expense | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Debt/Equity Ratio | = | Total Liabilities | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Owners’ Equity | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
Market
| [Company Name] | |||||||||||||||||||||||||
| Ratio Analysis | |||||||||||||||||||||||||
| Market Ratios | Q1 | Q2 | Q3 | Q4 | Annual | ||||||||||||||||||||
| Definition: | |||||||||||||||||||||||||
| Earnings per Share | = | Net Income | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| (EPS) Ratio | Average Number of Common Shares | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Price to Earnings Ratio | = | Market Price per Share | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ||||||||
| Earnings per Share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Price to Cash Flow Ratio | = | Market Price per Share | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ERROR:#DIV/0! | = | $0.00 | ||||||||
| Cash Flow per Share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
| Payout Ratio | = | Dividends Paid | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ERROR:#DIV/0! | = | $0 | ||||||||
| Net Income | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
| Industry Average | Insert the Industry Average for this ratio here. If you are unable to get reliable data for the Industry Average please access the data for your company’s closest competitor | ||||||||||||||||||||||||
| Variance | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||
| Quarter Growth/Decline | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||||||||||||||
END HERE
| Congratulations! You have now completed the numerical part of the assignment. Next you need to answer a very important question, “What does this all mean for investment purposes?” To do this well you need to critically examine what you have been able to achieve and reflect on what it all means for decision-making. Therefore the next step is completing the AT-EASE reflection statement. |
Everyone needs a little help with academic work from time to time. Hire the best essay writing professionals working for us today!
Get a 15% discount for your first order
Order a Similar Paper Order a Different Paper
