Term Project

AlmightyFluff
Termprojectdescriptions.pdf

Term Project Description

1

Term Project – Financial Statement Analysis 1. Choose one public company in the U.S. that you are interested in and find the industry

peer that closely resembles the target company's line of business.

2. Find the latest five years' annual reports of the firm. You should go to the SEC website

to search for 10-k filings instead of gathering financial information from some third-

party site.

3. Compile comparative financial statements in the latest five years. Apply year-to-year

change analysis on essential items of the financial statements. Construct the vertical

common-size income statement and common-size balance sheet by expressing each

item in the financial statements as a percentage of a relevant total within the same year.

Explain the change of trend in your analysis.

4. Calculate financial ratios for the target firm and the peer using the comparative

financial statements. The ratios should be grouped into five categories: Liquidity,

Profitability, Efficiency, Long-term solvency, and Investor-oriented ratios. These ratios

will provide the basis for analyzing the financial performance of the company. Based

on the financial performance, identify the issues related to the target company's

business operation, and make investment recommendations from long-term investors'

perspective.

5. Each student needs to write a report to summarize your findings. Key discussion items

could include but not limited to the following points:

a. Summary of the company. Write a brief description of the company that you

are analyzing. Identify the company's strengths, threats, and risk factors.

Term Project Description

2

b. Use the year-to-year change analysis to identify the trend and kinks over time.

c. Refer to the vertical common-size income statement and common-size

balance sheet and compare each item change over time. Read the relevant

footnotes and find out the economic reasons that lead to the change.

d. Financial ratio analysis. Explain the trend of the ratio change by referring to

the corporate decisions in the footnotes. Comment on the business issues

implied by the change and make suggestions to managers. (Don't just state the

calculation formula; tell the story behind the ratios). Compute the same ratios

on an industry peer and use the industry peer as the benchmark for

comparison.

e. Explain the change of ROE in the DuPont analysis format. The improvement

or deterioration of ROE may be caused by financial leverage, sales efficiency,

and/or profitability. Which one is the main reason for the change? You can

use your analysis as a reason for the buy/not buy decision.

f. (bonus points) Apply Altman's multivariate model on the targeted company

and benchmark to predict bankruptcy.

g. Recent news. The news could be economic, industry, or company-specific.

Illustrate how the news might affect your decision to invest in the company.

Examples of company-specific news include recent acquisitions, management

change, earnings reports, lawsuits, or significant changes in operations, etc.

h. Recommendation to Buy or Not to Buy. Form an investment recommendation

based on the above analysis.

i. In the conclusion of your report, please list the operational issues identified by

referring to your analysis results. Please state your recommendation clearly

with relevant reasons. The reason should be consistent with your analysis

results. Be sure to check the grammar and spelling in your report, be sure to

write your name and student ID on the header.

Term Project Description

3

6. What should be included in your submission? I will create a submission link on the

course website. You need to include the following in your submission:

a. Term project report in word or pdf format.

b. Excel spreadsheet that includes the original financial statements, horizontal

and vertical analysis, common-size income statement and balance sheet,

financial ratios calculated in five categories, Dupont Analysis results,

Bankruptcy analysis results using Altman's model (bonus). Spreadsheet

results are what you used in the report.

c. Presentation video link you created using the instruction given in a separate

file.

d. Powerpoint file if used in your presentation.

Finally, have fun in doing your term project!

  • Term Project – Financial Statement Analysis