(I have already down with Step1 and Step 2’s part a, I only need help for the part b and part c of Step2, as well as the stock return for Stag Industrial)
Step 1: Pick a company
- – Talk to your teammates and pick a company.
- – Complete PART 1 by Saturday, March 6, 11:59pm EST.Post your file(s) (Excel and write-up) to Canvas/Assignments/Group Project. Only one group member needs to post. No late submissions accepted.
Identify a firm that is publicly traded (on one of US exchanges) and operates in an industry in which you would like to work or to open up your own business. The firm must have positive Net Income for the past 3 years. (You can look this up in Yahoo Finance/ our firm s name/financials)
Step 2: Download and compute accounting/financial data
Download financial data into a (neatly arranged and labeled) spreadsheet, following the guidelines provided in the FSIT lab session with Prof. Ionici. Download three years of data, ending with the last fiscal year for which the firm has data available. Make sure you download all appropriate data in order to complete the following tasks:
a. Calculate the following variables for three consecutive years: Current ratio, total debt ratio, debt to equity ratio, asset turnover ratio, profit margin, ROA, ROE, price to earnings, market to book, annual stock return, and amount of dividends. Refer to your notes from your FSIT class for information on how to get that data. You may add additional ratios to your analysis if you would like to, but it is not mandatory.
b. For each of the ratios and variables referenced above, find the average value for the industry of our compan . If ou can t find it, use as a benchmark a firm that is most similar to the one you picked.
c. If you use any additional data sources, be sure to document them (e.g., Yahoo finance; the company website; etc.)
0 comments