FINANCIAL RATIO ANALYSIS
Financial Ratio Analysis
William F. Slater, III
ACC 529 Accounting for Managerial Decision Making
University of Phoenix
Week 5 Assignment for ePortfolio
Michael Greenen, C.P.A, C.F.P. - Instructor
July 1, 2003
Table of Contents
Table of Contents3
Profitability of Sample Company5
Sample Company ROI for 20005
Sample Company ROI for 20015
Activity of Sample Company7
Leverage of Sample Company7
Liquidity of Sample Company7
What Is Necessary to Assess the Company?8
What Ratios Have the Most Value?10
What Other Factors, Beyond Ratios, Need To Be Considered?10 How Would Your Assessment Criteria Change If The Company In a Different Industry12 Changes in Assessment Method12
Appendix A Sample Company's Financial Statements from 1999 200115 Appendix B Financial Ratio Analysis of Sample Company19
This research paper will evaluate Sample Company using review standard financial ratio analysis techniques and assess its potential as a good investment. This is written in the form of a memo to the CEO of an Alabama-based firm, looking for sound financial advice with regards to whether of not buying stock in Sample Company is a sound investment.
This research paper will reveal the financial analysis techniques used to evaluate the financial performance of the Sample Company, and evaluate the company's worthiness as an investment. The paper is divided into three sections. The first section is the memo, which is the main body of the paper. The second section, Appendix A, includes as a reference contains each of the sets of the four financial statements that show Sample Company's performance from 1999 to 2001. The third section, Appendix B, contains the actual financial ratio analysis techniques, showing the company's performance in 2000 and 2001, the percent change in performance between these years, a short description of the meaning of each ratio, as well as a short assessment of the company's change in performance between 2000 and 2001. Using these appendices to support the financial analysis ideas expressed in the memo, the reader should feel that they have a complete set of facts to substantiate these ideas and provide a reference for them.
Date:July 1, 2003
To:Randall K. Black, CEO
Absolutely Alabama Investments
From:William F. Slater, III, Consultant
Subject:Financial Analysis Using Ratio Analysis and Recommendation Dear Randall:
Thank you for the opportunity to review Sample Company's financial statements and make this ratio analysis, as well as some recommendations about possible investment in this company.
Using financial statements from 1999, 2000, and 2001, along with standard financial ratio analysis, I have been able to develop what I believe is a clear picture of this company's financial performance. Note that the financial analysis was done using the financial report data from publicly available financial statements for the years 2000 and 2001. I have included these statements for your review in Appendix A
Appendix B contains other measures of Sample Company's financial performance, as expressed in standard financial ratio analysis techniques using figures from the financial reports in Appendix A.
Profitability of Sample Company
First, let's look at the Return on Investment (ROI) for 2000 and 2001, using the Dupont Model, which is margin times turnover. Margin is net income divided by the sales, and turnover is sales / average total assets (Marshall, 2002).
Sample Company ROI for 2000
ROI = MARGIN x TURNOVER
OPERATING INCOME =Operating IncomexSales
AVERAGE TOTAL ASSETSSalesAverage Total Assets
Input: 498 =498...