financial statement analysis
Using the latest 3 years of 10k reports (not annual reports) from the SEC or company website, you will perform the following tasks:
1. Calculate net profit margin for the last two years and compare the ratios.
2. Calculate the account receivable turnover for the last two years.
3. Create the cash and receivables report: Include bad debt expense and allowance for doubtful accounts and the type and number of cash or cash equivalents accounts for the last two years.
4. Create the Inventories report. Include the way inventory is carried: FIFO, LIFO, etc., and COGS and Ending Inventory in dollars. Calculate inventory turnover ratio for the last two years.
5. List the intangibles and the types and amounts of each intangible for one year.
6. List plant, property & equipment including the type of depreciation used and depreciation expense and accumulated depreciation. Also, calculate the return on assets ratio for the last two years. Rate of return on total assets (ROA)
7. List the current liabilities & contingencies for the last year. Calculate current ratio for the last two years.
8. List the long-term liabilities and contingencies for the last year. Calculate the long-term debt ratio for the last two years.
9. Create (copy/paste) the stockholder’s equity report. Include the investments and list the amounts in each category: trading, available for sale, long term and amounts for the last year. In addition, the types of Equity and the number of shares outstanding should be included.
10. Create the cash flow report for the last year. Include the amounts in the three sections and tell if the amounts are good or bad. Calculate the cash flow to equity ratio for the last two years.
11. Analyze the company. Talk through the ratios and explain if each is good, bad or ugly.Would you invest or not and why? (This can be written in a page or 2.)
