Question: The company I picked was Spotify. Also a excel sheet is required. Attached is the Project outline
You are to act as a financial advisor to a client interested in investing in a particular industry. You will research a company and provide a recommendation to your client whether he/she should invest. Some possible industries include:
PART A: Obtain Financial Statements
Pick recent ones
Obtain 3 years of financial statements (just the Balance Sheet and Income Statement) for your company from SEC.GOV. 3 BALANCE SHEETS AND 3 INCOME STATEMENTS will be submitted. One set per company.
PART B: Enter data into FSAP (Financial Statement Analysis Package)
(Google - "Financial Statement Template.xls, click on "Excel Template for Income Statement - Accounting Simplified").
Enter the Balance Sheet and Income Statement amounts for 3 years into the Financial Statement Analysis Package Excel file (just the Balance Sheet and Income Statement information, not the Statement of Cash Flows). Make sure your balance sheet BALANCES!!!! Make sure your Net Income matches your Net Income on the Income Statement. Submit one FSAP per company.
PART C: Company Analysis
Focus more on their position within the industry, recent developments, fluctuation in stock prices relative to the market/industry, and other items of significance that would impact your investment decision. Legal issues facing the company. New markets and new products. DO NOT WRITE ABOUT THE HISTORY OF THE COMPANY (1 page - single spaced). Submit 1 paper per company.
PART D: Industry Analysis
Summarize the economic outlook for your industry. Look at recent market activity, recent indicators impacting your industry. Address recent change in stock prices. Obtain industry averages for your ratio and common size analysis. Identify laws/regulations impacting your industry. Identify market trends and geo/political events impacting your industry. Identify Micro/Macro economic conditions impacting your industry. DO NOTE WRITE ABOUT YOUR INDIVIDUAL COMPANIES. (1 page - single spaced). Submit 1 paper per industry.
Data sources: Standard and Poor's Stock Reports or other Industry Surveys, Mergent's Industry Review. Finance.yahoo.com, moneycentral, msn.com, hoovers.com, and other financial websites. Examine recommendations of other investment websites (buy/sell/hold).
PART E: FINAL PAPER
A. Include Company Analysis (address prior comments)
B. Include Industry Analysis (address prior comments)
C. Include FSAP summary - Create tables summarizing the analysis tab of your FSAP. Make it look professional.
D. Write a summary of the significant findings from the financial statement analysis. (1 single spaced page). Address significant (Focus on the 2-4 items under each) Ratios, Horizontal Analysis, and Common Sized Analysis from the FSAP (look under the Analysis Tab). Do not address all the ratios and every line of vertical and horizontal analysis, just what you feel is important.
E. Based on your findings would you invest? Include specific support for your decision based on your findings in the analysis. Also include support (for or against) investing in the industry you chose.
Information related to above question is enclosed below:
Attachment:- excelTemplate.rar