Finc 351 and 440 Week 4

profilebarkersbaseball
homework_9.8.14_finc_440_project_directions.docm

FINC440 Instructions & Recommendations for Preparing the Course Assignments

(Due End of Weeks 1, 4, 5, 6, & 8) -

The purpose of this note is to carefully explain the general expectations and requirements for the five Assignments that are to be prepared for FINC440. The information and materials presented here are intended to make sure that you clearly understand the general expectations and that there are no misunderstandings about what is to be done and what is expected.

Please review this material so that you are familiar with the specific requirements that are be followed in the preparation and submission of the Assignments.

The Assignments comprise 72% of the final course grade. It will take some time and effort to produce high quality analyses.

Required Outline & Other Information about the Assignments –

1. Work Hard to Avoid Personal Pronouns – The excessive use of personal pronouns is discouraged in business and analytical writing. It is recommended that personal pronouns are avoided altogether, if possible. Please make sure that personal pronouns (e.g., I, we, my, our, etc.) are avoided in paper. It will take some work, but it can be done easily by rearranging the wording of sentences.

2. Companies Are Not “They,” “Their,” or “Them” – This is a reminder that a company is not a “they,” “their,” or “them.” A company is very much an “it.” So, to reference a company, use “it,” the name of the company, or “the company,” or “the organization,” or “the firm,” etc.

3. Outline for Paper –Students must use the required outline for this assignment. The closer that the paper conforms to the required outline, the better! The outline is presented in the next section.

4. Evaluation Rubric – An evaluation rubric is available for the Assignments. It will be used to evaluate the Assignments. The rubric shows the important components that must be included in the papers. It is a good idea to take a look at the rubric and make sure that each Assignment addresses the requirements. A copy is posted with each Assignment in the online classroom.

5. Financial Ratio Analysis – The first Assignment calls for a financial ratio analysis of the company that you selected. You should acquire data from the Mergent Online database available through the UMUC Library. The ratio analysis model (Excel) provided by the instructor is also a useful tool for this Assignment.

6. Subheadings – Each section of the paper must begin with a sub-heading. Please use the sub-headings included in the required outline (presented in the next section).

Here is the Required Outline (It must be used for each Assignment) -

The five class Assignments are intended to be constructive learning experiences. They are designed to show students how to prepare analytical reports in finance using critical thinking, research, and writing skills. The following outline is to be used for each Assignment:

1. Cover Page - Include a cover page containing the title of the Assignment, the student’s name, the professor’s name, the course title, and the date.

2. Introduction – The Introduction must include:

(a) A review of the Assignment purpose, research methods and the principal information sources, and other information related to the completion of the analysis.

(b) The introduction should also include an overview of the sections of the paper that follow. (1/2 to 1 page)

3. Analysis Section – The body of the report is to address the assigned topics and questions. It is essential that students include appropriate in-text reference citations in APA format:

4. Summary / Conclusion – The summary or conclusion should review the major observations, conclusions and recommendations developed in the analysis. No new material should be introduced in this section. (1/2 to 1 page)

6. References – Provide list of references in APA format.

Source of Useful Information - Please remember that financial statements and other useful information are available from the Mergent Online database that is available to you through the UMUC Library (“Resources” tab in the online classroom). Please notice that financial ratios are grouped into appropriate categories (Profitability Ratios, Liquidity Ratios, Debt Management Ratios, and Asset Management Ratios), which makes it easy to set up the ratios and use them in the analysis.

The following information is intended to help you with using the Mergent Online Database available in the Strayer Learning Resource Center:

Financial Statements for companies, financial ratios, and Form 10K annual reports can be obtained from the UMUC Library, which is accessible from the Online Classroom (see “Resources” tab at the top of the screen).

Once in the Mergent database, in the block titled “Company Search, Enter Symbol or Company Name” enter the company’s name or its Stock Ticker Symbol (e.g., for Deere & Company, enter DE). Next, select the company from the drop-down menu.

For Financial Statements – Select “Company Financials” tab

For Financial Ratios – Select “Company Financials” tab and “Ratios” sub-tab

For Form 10K Annual Reports – Select “Filings” tab (and then select the most recent Annual Form 10K report)

Writing Assignment – Comments About Financial Analysis (Ratio Analysis)

The financial ratio analysis is the subject of the first Assignment (due at the end of Week 1).

It may be helpful for you to have some additional information about how to prepare such an analysis, to receive some recommendations, and have a chance to see a sample analysis.

Writing Assignment - Example of Financial Ratio Analysis - An analysis of the company’s financial ratios is the objective of the first Assignment. Included below is the presentation of a simple financial ratio analysis. This is only an example. This one can be improved in many ways. It is presented just to give you an idea about what is expected to be prepared and used in the financial analysis section of the first Assignment.

The analysis that you prepare can include different ratios, it could include figures (graphs) that present the information, or other methods of presentation and analysis.

Some additions and other comments that may improve this analysis are:

1. Include industry average ratios or competitors’ ratios. This is known as “cross-sectional” analysis.

2. It would be useful to include figures “graphs” of the historical ratio data. In addition to the table, this would facilitate the presentation of the “historical” or “trend” ratio analysis.

3. Include a statement or sentence that summarizes the evaluation of each group of ratios – is the company’s performance good, not so good, needing improvement, strong, etc.?

4. As is done with this example, always include the actual ratio data (the actual ratio numbers) in the written analysis in addition to the presentation in the table.

5. Good points about this analysis: (1) It uses the Mergent financial ratio data that are available from the Library database; (2) The ratios are presented in a table, which is numbered and titled; (3) Several years of ratio data are presented; (4) Actual ratio numbers are used in the written analysis; (5) An effort is made to evaluate the ratio data; and, (6) The ratio analysis is divided into appropriate sub-sections.

Financial Ratio Analysis

The available financial ratios for MKC, shown in Table 1 below, were used to analyze the company’s profitability, liquidity, debt management and asset management. These ratios were also compared the industry averages available on www.msn.com . (Note: These industry data need to be included.)

Table 1 MKC Financial Ratios

 

 

 

 

 

 

 

 

 

 

 

 

 

Ratio

2011

 

2010

 

2009

 

2008

 

2007

 

 

Profitability

ROA % (Net)

9.97

10.88

9.07

8.49

8.59

 

 

ROE % (Net)

24.49

26.55

25.09

23.84

22.8

 

 

Solvency

 

 

Quick Ratio

0.48

0.51

0.49

0.43

0.57

 

 

Current Ratio

1.23

1.22

1.19

0.94

1.14

 

 

 

 

Debt

Total Debt to Equity

0.78

0.61

0.74

1.17

0.67

 

 

Interest Coverage

10.55

10.34

8.84

6.64

5.84

 

 

 

 

Asset Mgmt.

Inventory Turnover

3.99

4.16

4.21

4.35

4.13

 

 

Total Asset Turnover

0.99

0.98

0.97

1.05

1.09

 

 

Include Market Value Ratios

 

 

 

 

 

 

 

 

 

 

Source: Mergent Online financial ratios for MKC

Note: Need to include Industry or Competitors’ ratios with the data.

Profitability Ratios

As of November 30, 2011, MKC’s return on assets (ROA) increased 16% from 2007. However, ROA decreased by 8.4% from 2010 to 2011 to 9.97%, which may be due to increased assets. In the 2011 annual report, McCormick stated that inventory levels were higher in 2011 because of acquisitions and large increases in material costs. The ROA industry average is 8.7%, which suggests that McCormick is efficiently using its assets to generate profits. MKC’s return on equity (ROE) increased by 7.4% from November 30, 2007 to November 30, 2011, but decreased by 7.8% from 2010 to 2011. The company’s ROE was 24.49%, as of November 30, 2011, compared to the industry average of 25.01%. This indicates that other companies in the industry may have been slightly more successful at generating profits with shareholders’ ‘investments. It seems that MKC is still very profitable, but factors such as materials costs, increased interest expenses from 2011 acquisitions, and inventory levels affected the profitability in 2011.

Solvency Ratios

The quick ratio and current ratio were used to measure McCormick’s liquidity. The quick ratio decreased 15.8% from 2007 to 2011 and 5.9% from 2010 to 2011. The industry average quick ratio is 0.7, so MKC’s quick ratio of 0.48 for 2011 suggests that MKC may have had a difficult time turning its inventory into cash in 2011. The current ratio increased 7.9% from 2007 to 2011 and 0.8% from 2010 to 2011. The industry average current ratio is 1.2, so MKC’s 2011 current ratio of 1.23 indicates that the company is on par with the rest of the industry in its ability to pay short-term obligations.

Capitalization / Debt Ratios

McCormick’s total debt to equity has increased 16.4% from 2007 to 2011 and 27.9% from 2010 to 2011. The acquisitions in 2011 were partially financed with debt (McCormick Form 10K Report, 2011). In 2011, MKC’s total debt to equity ratio was 0.78 but the industry seems to be more highly leveraged with an average total debt to equity ratio of 1.01. Although McCormick has taken on more debt, the company’s ability to make interest payments on the debt has increased. MKC’s interest coverage has increased 80% from 2007 to 2011 and increased 2% from 2010 to 2011. The industry average interest coverage ratio is 19.3, which is much higher than MKC’s interest coverage ratio of 10.55 in 2011. While the industry average may be higher, McCormick is very capable of making interest payments on outstanding debt.

Management / Activity Ratios

McCormick’s inventory turnover ratio decreased by 3.4% from 2007 to 2011 and by 4% from 2010 to 2011. As previously stated, McCormick’s inventory levels have increased which led to the decrease in inventory turnover. The industry average inventory turnover ratio is 6.7 which indicates that McCormick possibly has higher inventory levels than other companies in the industry. MKC’s asset turnover ratio also decreased from 2007 to 2011 by 9.2%, however, the ratio increased by 1% from 2010 to 2011. The industry average is 1 and MKC’s asset turnover ratio was 0.99 in 2011, showing that MKC is almost as efficient as the rest of the industry at using assets to produce profits.

Summary of Financial Ratio Analysis

(Include a summary of the ratio analysis along with important conclusions.)

Evaluation Rubric for the Assignments –

The evaluation Rubric for the Assignments is available in the online classroom.