Hi,
Please find below Project Sample as a guide ;
Company Name: Intel Corp
Stock Symb:INTC
Finance 5103 – Financial Management
Project
Name: _________________________
Grading Rubric:
- Company Profile? (10 points)
- Financial Analysis (25 points)
- Stock valuation (25 points)
- Corporate Governance? (10 points)
- Corporate Policy (25 points)
- Writing and organization of the paper (5 points)
Total:_______________
Finance 5103 – Financial Management
Project
Company: Microsoft Corporation
James Mark
December 2013
Introduction
This report presents the financial analysis of Microsoft Corporation. The firm’s financial status is evaluated using ratio analysis and suggestions on improvement are provided. The risk and return of Microsoft common stocks are studied and the fundamental value of stock is estimated……
Company Profile
Microsoft is a high tech company providing computer software products worldwide. The firm is founded in 1975 by …….
Financial Analysis
Comparing to previous year, Microsoft’s assets have higher liquidity and also high returns (See table 1)……
Stock Analysis
Microsoft now has about 9 billion outstanding common shares. Table 2 shows that the average monthly return from Jan 2009 to Dec 2013 is 0.32% with a standard deviation of 7.21%…….
Corporate Governance
Microsoft’s ISS Governance QuickScore as of Jan 1, 2014 is 3. The pillar scores are Audit: 1; Board: 8; Shareholder Rights: 5; Compensation: 3.……
Corporate Policies – Payout Policy
Microsoft as a growth firm didn’t pay dividend until 2003. Before that, the firm split stocks several times (see Table 3)…….
Conclusion
Based on the analysis presented above, Microsoft appears to have a good financial standing…….
Appendix:
Table 1: Financial Ratios
|
Ratio Analysis |
2013 |
2012 |
|
|
Liquidity Ratios |
|
|
|
|
Current Ratio |
x |
x |
|
|
Quick Ratio |
x |
x |
|
|
Asset Management Ratios |
|
|
|
|
Inventory Turnover |
x |
x |
|
|
Days Sales Outstanding |
x |
x |
|
|
Fixed Assets Turnover |
x |
x |
|
|
Total Assets Turnover |
x |
x |
|
|
Debt Management Ratios |
|
|
|
|
Debt Ratio |
|
x |
x |
|
Times-interest-earned ratio |
x |
x |
|
|
EBITDA coverage ratio |
x |
x |
|
|
Profitability Ratios |
|
|
|
|
Profit Margin |
x |
x |
|
|
Basic Earning Power |
x |
x |
|
|
Return on Assets |
x |
x |
|
|
Return on Equity |
x |
x |
|
|
Market Value Ratios |
|
|
|
|
Price-to-earnings ratio |
x |
x |
|
|
Price-to-cash flow ratio |
x |
x |
|
|
Market-to-book ratio |
x |
x |
|
Table 2: Stock Returns
|
Month |
Market Level (S&P 500 Index) |
Market Monthly Return |
MSFT Adjusted Stock Price |
MSFT Monthly Return |
|
Dec 2013 |
xx |
xx |
24.74 |
-0.32% |
|
Nov 2013 |
xx |
xx |
24.82 |
6.84% |
|
Oct 2013 |
xx |
xx |
23.23 |
1.13% |
|
Sep 2013 |
xx |
xx |
22.97 |
1.28% |
|
Aug 2013 |
xx |
xx |
22.68 |
-3.90% |
|
… |
|
|
… |
… |
|
…. |
|
|
… |
… |
|
… |
|
|
… |
… |
|
…. |
|
|
… |
… |
|
Mar2009 |
xx |
xx |
18.15 |
13.72% |
|
Feb 2009 |
xx |
xx |
15.96 |
-4.89% |
|
Jan 2009 |
xx |
xx |
16.78 |
-12.05% |
|
Dec 2008 |
xx |
xx |
23.6 |
|
|
Average Return: |
xx |
xx |
|
0.32% |
|
Standard Deviation: |
xx |
xx |
|
7.21% |
|
Beta: |
|
|
|
xx |
Table 3: Payout History
|
Date |
Dividends |
|
18-Feb-03 |
2 : 1 Stock Split |
|
11/19/2013 |
0.28 |
|
29-Mar-99 |
2 : 1 Stock Split |
|
8/13/2013 |
0.23 |
|
23-Feb-98 |
2 : 1 Stock Split |
|
5/14/2013 |
0.23 |
|
9-Dec-96 |
2 : 1 Stock Split |
|
2/19/2013 |
0.23 |
|
23-May-94 |
2 : 1 Stock Split |
|
11/13/2012 |
0.23 |
|
15-Jun-92 |
3 : 2 Stock Split |
|
8/14/2012 |
0.2 |
|
27-Jun-91 |
3 : 2 Stock Split |
|
5/15/2012 |
0.2 |
|
16-Apr-90 |
2 : 1 Stock Split |
|
2/14/2012 |
0.2 |
|
21-Sep-87 |
2 : 1 Stock Split |
|
11/15/2011 |
0.2 |
|
|
|
|
8/16/2011 |
0.16 |
|
|
|
|
5/17/2011 |
0.16 |
|
|
|
|
2/15/2011 |
0.16 |
|
|
|
|
11/16/2010 |
0.16 |
|
|
|
|
8/17/2010 |
0.13 |
|
|
|
|
5/18/2010 |
0.13 |
|
|
|
|
2/16/2010 |
0.13 |
|
|
|
|
11/17/2009 |
0.13 |
|
|
|
|
8/18/2009 |
0.13 |
|
|
|
|
….. |
xx |
|
|
|
Kind regards….Daniel


0 comments