Company analysis

 

choose a company and write about the company selected.

should be about 2,000 words in length. References should be cited throughout the paper and in the reference section.

 

Title Page
Table of Contents
Introduction
Provide background information on the company selected for the project, including the website link, financial information (annual sales and profits for the last three years), stock exchange information (if applicable), etc.
Describe the company’s industry, products/services sold, customer base, and competitors.
Body
Company’s Organization and Management of Information Systems
Identify the types of information systems the company uses. If information systems can’t be identified, search to identify systems used by competitors or that can be purchased for use by the company.
Describe how information systems enhance the company’s business processes.
Suggest how the company has used information system(s) or any technology to achieve a competitive advantage.
Identify any ethical and/or social issues in the company’s use of information systems to manage its business.
Company’s Information Technology Environment
Describe how the company may upgrade its information technology(IT) infrastructure from time to time.
Based on what you have learned about the company, what is your assessment of its ability to effectively secure and protect customer information and privacy?
Application of Information Systems to Managing the Company’s Business
Based on your research and knowledge of the company’s products, services, customers, and markets, briefly describe the company’s supply chain.
Describe some of the company’s ecommerce activities as you see them.

 

Company analysis

 

choose a company and write about the company selected.

should be about 2,000 words in length. References should be cited throughout the paper and in the reference section.

 

Title Page
Table of Contents
Introduction
Provide background information on the company selected for the project, including the website link, financial information (annual sales and profits for the last three years), stock exchange information (if applicable), etc.
Describe the company’s industry, products/services sold, customer base, and competitors.
Body
Company’s Organization and Management of Information Systems
Identify the types of information systems the company uses. If information systems can’t be identified, search to identify systems used by competitors or that can be purchased for use by the company.
Describe how information systems enhance the company’s business processes.
Suggest how the company has used information system(s) or any technology to achieve a competitive advantage.
Identify any ethical and/or social issues in the company’s use of information systems to manage its business.
Company’s Information Technology Environment
Describe how the company may upgrade its information technology(IT) infrastructure from time to time.
Based on what you have learned about the company, what is your assessment of its ability to effectively secure and protect customer information and privacy?
Application of Information Systems to Managing the Company’s Business
Based on your research and knowledge of the company’s products, services, customers, and markets, briefly describe the company’s supply chain.
Describe some of the company’s ecommerce activities as you see them.

 

Company analysis

 

 

 

Research 2 companies of your choice. Explain how they have focused on uncertainty in the supply chain over the last two years with special emphasis on the following levers:

1. Capacity,

2. Inventory

3. Time

4. Information

5. Price

Discuss their successes and failures in these areas.

Company Analysis

Use the Company Dossier through the Internet, to research one publicly traded company in which you are interested. Locate the company website and financial statements. Review the stockholders’ equity section of the company’s balance sheet. Be prepared to discuss.
Imagine that you are advising an investor who is considering purchasing stock in the company. Discuss how stockholders’ equity is reported and analyzed. Make a recommendation whether the investor should purchase stock in the company. Provide support for the recommendation.

 

Company Analysis

 

Windy plc (Windy) manufactures and erects wind turbines. The company is listed in the UK and its financial year-end is 31 December. To date the company has increased in size and value by organic growth. Windy’s board is now investigating the acquisition of 100% of the share capital of Wavey Ltd (Wavey), a manufacturer of wave energy converters.

You are a member of Windy’s finance team and the company’s finance director has sent an email to you, extracts from which are shown below:

 

Were Windy to buy Wavey it would cost in the region of £35 million, which we would need to borrow. Our bankers are willing to lend us that sum, but at an interest rate of 11% pa. I want to explain to the board the implications of the investment, based primarily on its estimated NPV. Can you calculate an up to date WACC figure for me?

 

 

Company Analysis

 

There is an uploaded draft of the companies under my draft. The data collected in it are for the years 2016, 2017 and 2018 data and that is by going through the financial reports. However, I have only completed 50 companies for each county. The aim of this exercise is to test if there is misstatement/restatements in the financial statements.
This exercise is for Oman, KSA and Kuwait for the years 2016, 2017 and 2018. There is an excel sheet uploaded under my draft which has only 50 companies. You have to complete all listed companies in each country. For example, KSA has around 183 companies.
Create a new excel sheet or continue on my draft in the same way. The objective of this exercise is to test the financial reports of each country.

Notes:
AM = Firm j in time period t is scored one (1) if there is an occurrence of an accounting misstatement in the firm’s financial reports where at least one misstated item exists; otherwise firm j is scored zero (0).
Big4 = Firm j in time period t is scored one (1) if the external auditor is a noted member of BIG4 audit firms (i.e., EY, DT, PWC, KPMG); otherwise firm j is scored zero (0).
Specialization = Firm j in time period t is scored one (1) if the external auditor is a defined as an industry specialist to the industry k that firm j is classified; otherwise firm j is scored zero (0).
Delay = Number of days between the end of the financial year of firm j to the date the independent auditor’s report is signed.
AUDCHG = Firm j is scored one (1) if during time period t the external auditor was changed; otherwise firm j is scored zero (0).
Own = Proportion of common outstanding shares held by the substantial shareholders of firm j in time period t.
FAM = Firm j in time period t is scored one (1) if the major shareholder in time period t is the original founding family; otherwise firm j is scored zero (0).
CROSS = Firm j in time period t is scored one (1) if the ownership structure of the entity is arranged in the form of pyramids (or cross-holdings); otherwise firm j is scored zero (0).
LEV = Ratio of total debt of firm j at the end of time period t divided by the total assets at the end of time period t.
ISSUE = Firm j is scored one (1) if during time period t the entity issued new securities; otherwise firm j is scored zero (0).
NFCF = Firm j is scored one (1) if the free cash flow for time period t is negative; otherwise firm j is scored zero (0).
MB = Ratio of the market value of firm j at the end of time period t to the book value of equity.
REHAB = Firm j is scored one (1) if during time period t the entity is subject to a financial rehabilitation plan due to financial distress and/or regulatory profitability action; otherwise firm j is scored zero.
DUAL = Firm j is scored one (1) if at the chief executive officer (or most senior executive manager) is also the chairman of the board of directors; otherwise firm j is scored zero.
LNSIZE = Natural logarithm of the total assets of firm j at the end of time period t.
PERFORMANCE = The ratio of net earnings for time period t of firm j divided by the total revenue of firm j in time period t.
AGE = Number of years since firm j was established to end of time period t.

 

Company Analysis

 

 

There is an uploaded draft of the companies under my draft. The data collected in it are for the years 2016, 2017 and 2018 data and that is by going through the financial reports. However, I have only completed 50 companies for each county. The aim of this exercise is to test if there is misstatement/restatements in the financial statements.
This exercise is for Oman, KSA and Kuwait for the years 2016, 2017 and 2018. There is an excel sheet uploaded under my draft which has only 50 companies. You have to complete all listed companies in each country. For example, KSA has around 183 companies.
Create a new excel sheet or continue on my draft in the same way. The objective of this exercise is to test the financial reports of each country.

Notes:
AM = Firm j in time period t is scored one (1) if there is an occurrence of an accounting misstatement in the firm’s financial reports where at least one misstated item exists; otherwise firm j is scored zero (0).
Big4 = Firm j in time period t is scored one (1) if the external auditor is a noted member of BIG4 audit firms (i.e., EY, DT, PWC, KPMG); otherwise firm j is scored zero (0).
Specialization = Firm j in time period t is scored one (1) if the external auditor is a defined as an industry specialist to the industry k that firm j is classified; otherwise firm j is scored zero (0).
Delay = Number of days between the end of the financial year of firm j to the date the independent auditor’s report is signed.
AUDCHG = Firm j is scored one (1) if during time period t the external auditor was changed; otherwise firm j is scored zero (0).
Own = Proportion of common outstanding shares held by the substantial shareholders of firm j in time period t.
FAM = Firm j in time period t is scored one (1) if the major shareholder in time period t is the original founding family; otherwise firm j is scored zero (0).
CROSS = Firm j in time period t is scored one (1) if the ownership structure of the entity is arranged in the form of pyramids (or cross-holdings); otherwise firm j is scored zero (0).
LEV = Ratio of total debt of firm j at the end of time period t divided by the total assets at the end of time period t.
ISSUE = Firm j is scored one (1) if during time period t the entity issued new securities; otherwise firm j is scored zero (0).
NFCF = Firm j is scored one (1) if the free cash flow for time period t is negative; otherwise firm j is scored zero (0).
MB = Ratio of the market value of firm j at the end of time period t to the book value of equity.
REHAB = Firm j is scored one (1) if during time period t the entity is subject to a financial rehabilitation plan due to financial distress and/or regulatory profitability action; otherwise firm j is scored zero.
DUAL = Firm j is scored one (1) if at the chief executive officer (or most senior executive manager) is also the chairman of the board of directors; otherwise firm j is scored zero.
LNSIZE = Natural logarithm of the total assets of firm j at the end of time period t.
PERFORMANCE = The ratio of net earnings for time period t of firm j divided by the total revenue of firm j in time period t.
AGE = Number of years since firm j was established to end of time period t.

 

 

Company Analysis

 

 

There is an uploaded draft of the companies under my draft. The data collected in it are for the years 2016, 2017 and 2018 data and that is by going through the financial reports. However, I have only completed 50 companies for each county. The aim of this exercise is to test if there is misstatement/restatements in the financial statements.
This exercise is for Oman, KSA and Kuwait for the years 2016, 2017 and 2018. There is an excel sheet uploaded under my draft which has only 50 companies. You have to complete all listed companies in each country. For example, KSA has around 183 companies.
Create a new excel sheet or continue on my draft in the same way. The objective of this exercise is to test the financial reports of each country.

Notes:
AM = Firm j in time period t is scored one (1) if there is an occurrence of an accounting misstatement in the firm’s financial reports where at least one misstated item exists; otherwise firm j is scored zero (0).
Big4 = Firm j in time period t is scored one (1) if the external auditor is a noted member of BIG4 audit firms (i.e., EY, DT, PWC, KPMG); otherwise firm j is scored zero (0).
Specialization = Firm j in time period t is scored one (1) if the external auditor is a defined as an industry specialist to the industry k that firm j is classified; otherwise firm j is scored zero (0).
Delay = Number of days between the end of the financial year of firm j to the date the independent auditor’s report is signed.
AUDCHG = Firm j is scored one (1) if during time period t the external auditor was changed; otherwise firm j is scored zero (0).
Own = Proportion of common outstanding shares held by the substantial shareholders of firm j in time period t.
FAM = Firm j in time period t is scored one (1) if the major shareholder in time period t is the original founding family; otherwise firm j is scored zero (0).
CROSS = Firm j in time period t is scored one (1) if the ownership structure of the entity is arranged in the form of pyramids (or cross-holdings); otherwise firm j is scored zero (0).
LEV = Ratio of total debt of firm j at the end of time period t divided by the total assets at the end of time period t.
ISSUE = Firm j is scored one (1) if during time period t the entity issued new securities; otherwise firm j is scored zero (0).
NFCF = Firm j is scored one (1) if the free cash flow for time period t is negative; otherwise firm j is scored zero (0).
MB = Ratio of the market value of firm j at the end of time period t to the book value of equity.
REHAB = Firm j is scored one (1) if during time period t the entity is subject to a financial rehabilitation plan due to financial distress and/or regulatory profitability action; otherwise firm j is scored zero.
DUAL = Firm j is scored one (1) if at the chief executive officer (or most senior executive manager) is also the chairman of the board of directors; otherwise firm j is scored zero.
LNSIZE = Natural logarithm of the total assets of firm j at the end of time period t.
PERFORMANCE = The ratio of net earnings for time period t of firm j divided by the total revenue of firm j in time period t.
AGE = Number of years since firm j was established to end of time period t.

 

 

Company Analysis

 

 

 

 

 

1. Using the stocks in your initial portfolio, prepare a valuation of each stock and the initial portfolio using zero, constant or variable growth models with a market return at 8% and at 12%. [Note that the growth rate must be less than the required rate of return.] Make sure you list the date of the valuation and the closing share price of your firm’s stock. Each firm’s required rate of return will depend on its beta.

2. Is the stock of each of these companies over or undervalued?

3. What is the expected return using the CAPM model?

4. Prepare a time series ratio analysis (liquidity, activity, debt, and profitability). Identify any events during the period that may have caused the stocks’ prices to increase or decrease, explaining how these events affect the stocks’ prices.

Company Analysis

 

Company description
 Create your own company, a service , retail or manufacturing
 Give a suitable name to your company,
 Describe the nature of the business
(80 marks)
Group students, through using the Microsoft Access, have to 1. Create tables with the following instructions
 Crate at least 5 tables
 Each table consists at least 5 attributes (fields).
 Each table consists at least 5 records.
 Should identify the PK and FK (if any) in each table.