To complete a companies finance analysis

profilesda1212

Financial Report Project

 
USE: Apple Inc. as the company of choice
USE: 10-k report (https://www.sec.gov/Archives/edgar/data/320193/000119312515356351/d17062d10k.htm) , https://www.sec.gov/cgi-bin/browse-edgar?CIK=AAPL&action=getcompany&owner=exclude,
          google market, yahoo market
 
Project out line:
 
chapter 1 - executive summary
*company strength - describe the sources of the company strength that your financial ratios and risk return analysis disclosed.
*company weakness - describe the sources of the company strength that your financial ratios and risk return analysis disclosed.
*company opportunities- describe what opportunities there are for the company making profits in the future.
*company threats - what competitive risks threaten the company’s profitability?
*recommendations - as a consultant to the chief financial officer and president of the company what are your recommendations for improving the financial performances of the company.
 
chapter 2 - background information on the company.  Business and strategies (use 10-k report and describe)
  1. business and risk
1.1 - the main focus of the business of the company (2 paragraphs)(use 10-k report and describe) (yahoo finance & google and describe the marketing strategy)
1.2 - the 3 principal risks. (3 paragraphs) (use 10-k report and describe)
  1. market strategy
2.1 - what are the main products (2 paragraphs) (use 10-k report and describe)
2.2 - what are the main distribution channels (2 paragraphs) (use 10-k report and describe)
2.3 - what are their principal promotion activities (2paragraphs) (use 10-k report and describe)
2.4 - how their prices compare to competition (2 paragraphs) (use 10-k report and describe)
2.5 - who are their target customers (2 paragraphs) (use 10-k report and describe)
  1. financial strategy
3.1 - prepare a table that shows the assets, liabilities, total common stock and additional paid in capital and retained earnings. (use 10-k report and describe)
3.2 - explain how asset increases were financed by increases in liabilities and equity. (2paragraphs) (use 10-k report and describe)
3.3 - briefly discuss company mergers (1 paragraph) (use 10-k report and describe)
  1. organizational capabilities and human resources 
4.1 - obtain the company organization chart. explain what it shows (1 paragraph) (use google)
4.2 - discuss number of units and employees. (1 paragraph) (use google)
  1. industry and competition
5.1 - the total size of the industry and major competitors. 
5.2 - explain what makes the company different from competittors.
 
chapter 3 - description of financial statements
Note: have to understand each asset, liability, stockholders equity, revenue and expenses account mean. explain what a balance sheet and income statements are and how the 2 are related.
  1. balance sheet accounts: description and detail (use 10-k report)
1.1 - make a list of all balance sheet accounts. define each account.
1.2 - read the notes to financial statements and summarize the explanation and detail numbers that add up to the account.
  1. income statement accounts: description and details (use 10-k report)
2.1 - make a list of all income statement accounts. 1_define each account.
2.2 - read the notes to financial statements and summarize the explanation and detail numbers that add up to the account.
 
chapter 4 - analysis of agency issues (summary and evaluation)
  1. statement of sources and uses of funds
1.1 - obtain the balance sheets for the past 2 years. construct a statement of sources and uses of funds
1.2 - describe what are the major sources and uses of funds. (1 paragraph)
  1. statement of cash flows
2.1 - obtain the balance sheets for the past 2 years. construct a statement of cash flows
2.2 - describe the company’s cash flows from operations, financing and investing; 3. compare your cash flows numbers to those of the company’s formal statement of cash flows and explain the differences. (1 paragraph)
 
 chapter 5 - analysis of sources an uses of funds and cash flows
  1. formally presented statements.
1.1 - type the balance sheets, income statements, cash flows and stockholders equity statement of the company for the past 2 years as well as 5 years in excel spreadsheet.
1.2 - make sure in your spreadsheet all the numbers, subtotals and totals are complete and accurate.
  1. vertical and horizontal analysis of balance sheets.    
 2.1 - compute the ratios for 5 years. 
 2.2 - describe the major assets and liabilities 
 2.3 - describe the major changes
 2.4 - compare the company’s ratio to the industry’s ratio
  1. vertical and horizontal analysis of income statements
3.1 - compute the ratios for 5 years.
3.2 - describe the major revenues and expenses.
3.3 - describe the major changes.
3.4 - compare the company’s ratios to the industry’s ratios.
 
chapter 6 - vertical and horizontal analysis of the company.
  1. compute the company’s ratios
1.1 - liquidity ratios
1.2 - asset management ratios
1.3 - debt management ratios
1.4 - profitability ratios
1.5 - market value ratios
1.6 - solving ratios 
  1. make industry comparison
2.1 - look up the industry ratios for 5 years
2.2 - graph the ratios for the company and the industry
2.3 - write your analysis
  1. make a table of company ratios and industry average ratios
3.1 - develop a chart of the table of ratios
3.2 - briefly define and explain the purpose of each ratio
3.3 - explain if each ratio shows strength or weakness compared to the industry average.
3.4 - discuss any trends in the ratios
3.5 - summarize your findings regarding group of ratios
  1. liquidity management
4.1 define, explain purpose, present the company and industry average ratios, charts and explain trends, improvements or deteriorations and strength or weakness
4.2 - relate to other ratios of the company
  1. asset management
5.1 - define, explain purpose, present the company and industry average ratios, charts and explain trends, improvements or deteriorations and strength or weakness
5.2 - relate to other ratios of the company
  1. debt management
6.1 - define, explain purpose, present the company and industry average ratios, charts and explain trends, improvements or deteriorations and strength or weakness
6.2 - relate to other ratios of the company
  1. profitability management
7.1 - define, explain purpose, present the company and industry average ratios, charts and explain trends, improvements or deteriorations and strength or weakness
7.2 - relate to other ratios of the company
  1. market valuation
8.1 - define, explain purpose, present the company and industry average ratios, charts and explain trends, improvements or deteriorations and strength or weakness
8.2 - relate to other ratios of the company
  1. management’s discussion and analysis
9.1 - read the companies management discussion and analysis presented in the 10k report and summarize it. (2 paragraphs)
 
chapter 7 - financial ratio analysis: integrating financial financial analysis, modified dupont chart
  1. modified dupont charts
1.1 - prepare modified dupont charts.
1.2 - explain how the company’s return on equity was affected by the equity multiplier, profit margin on sales and total assets turn over.
  1. company strategies and modified dupont charts
2.1 - prepare a forecasted balance sheet and income statements for the company for the next year. use the textbook examples as a guide.
 
chapter 8 - financial forecasting and opportunities and threats
  1. sales forecast
1.1 - apply simple regression analysis to quarterly data from the past 5 years to forecast the sales of the company for the next 5 years. obtain the sales revenues from the company 10Q’s. The fourth quarter data for each year is the annual figures from 10-k less the 3 quarterly figures from the 10Q’s. Make comments on your sales forecasts.  (2) explain if the sales forecast is reliable.
  1. subtitle 2: pro forma balance sheet, income statement and cash flows
2.1 - prepare a forecasted balance sheet and income statement for the company for the next year. 
 
chapter 9 - financial planning
  1. break even analysis
1.1 - compute and present total, operating, cash and financial break-even amounts
1.2 - prepare a break-even chart
  1. degree of leverage analysis
2.1 - measure the degrees of operating, financial, and total leverage
2.2 - discuss the impact of fixed operating and financial costs on the profitability of the company
 
chapter 10 - risk and return
  1. realized rates of return and volatility - (1) measure the realized weekly rates of returns on common stock of the company and S&P 500 index (Symbol ^GSPC). obtain information from the following website: http://finance.yahoo.com. (2) calculate the mean, variance, and standard deviation of the realized returns.
  2. market risk beta. -(1) run a simple regression between the excess (deficiency) of realized returns of the company over (under) the return to the US 10 year treasury note (http://finance.yahoo.com) (Symbol ^TNX) and excess (deficiency) of realized returns of the S&P 500 index. measure the alpha, beta, market risk and company specific risk for the company. (2) compare your beta those available from other sources such as value line investment survey. explain the possible reasons for any differences.
  3. cost of equity - measure the cost of retained earnings and common stock using: capital assets pricing model, gordon model, and cost of bonds plus premium.
  4. cost of bonds and preferred stock -measure the costs of bonds and preferred stock by examining new issues by the company or bond and preferred stock of comparable firms.
  5. capital structure and weighted average cost of capital - review the historical capital structure of the company and make judgement regarding optimal capital structure and measure the weighted average cost of capital.
    • 10 years ago
    • 50
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      final_work.docx