Financial Accounting Analysis
kevcnypngh7315
comprehensive_analysis_project.pdf
Comprehensive Analysis Project (CAP)
As shown in the syllabus, you have a project to do for this course. My
colleague Mike Booth in his financial accounting courses expertly uses
this project as a tool for teaching the entire semester. He has
students work in groups, has milestones where specific work has to be
done, etc.
Although this is an outstanding way to do a project for this course, I
choose to do it on an individual basis where the students have the
option to work with each other. I elected to use textbook examples
and the Internet for supplementing the learning process replacing the use
of Annual Reports of publically traded companies. Ultimately, I feel that this project will bring you to an equivalent
understanding of the Learning Objectives of the project and in both cases, I would argue that a student seriously
interested in his/her future is not limited as to what he/she could learn about financial statement analysis from either
format.
I want to start out by giving you some directions on what you should accomplish and why then later itemize the analysis
questions in the Requirements area.
Overview of the Project a.k.a. CAP
The final project asks you to:
1) Answer general "theory" questions regarding these two companies.
2) Utilize the Internet as resources to understand how to generate useful indicators in the areas of Profitability,
Asset Management, Financial Risk, Liquidity, and Market Strength.
3) Perform calculations and analyses on the financial statement data given.
4) Evaluate the results from your calculations and analyses and
form conclusions regarding your understanding of the
companies compared.
5) Discuss this project with others in the class or work in self-
created groups (for both online and traditional classes) to
discuss the project where you can learn from each other but
ultimately prepare you own individual analysis. (The level of
interaction between students is up to the individual student
and while highly recommended, is not required.)
Learning Objectives
This case analysis has many important learning objectives which are:
1) to provide a review of important concepts covered in this course as well as integrating the knowledge you
have gained during the semester so that you can see the "big picture".
2) to expose you to alternative formats for financial statements as well as terminology that may not be "just
like" the textbook.
3) to practice your communication skills (i.e., effective reading, listening, writing, speaking).
4) to improve/reinforce your interpersonal skills by providing experience in working with other students as a
cooperative learning team (see #5 above).
5) to provide a foundation in understanding and using corporate financial statements that will be useful in your
future college courses and professional career, as well as from a potential investor standpoint.
(Adapted from Michael Booth’s Acct 1 Project).
Parts to the Project
The project is divided into two major sections. The first section is ratio analysis also called performance measurement.
In this section, I give you a couple pages I scanned from a textbook of some of the underlying concepts of performance
measurement. To provide you with details on what the ratios are and what they mean, I then included four hyperlinks
to resources on the web. My suggestion is to give each link a quick overview to see which one fits your learning style.
Some are “down and dirty” without much frills and others are more sophisticated and detailed. Remember that you
have your own textbook chapters that you will have completed by the time you put the finishing touches on this project
so you should have no shortage of resources.
Following these resources, I give you the actual textbook problem (problem 14.4) with the Income Statement and
Balance Sheet. I decided to provide all of this information so that you have it all at your disposal and do not have to go
“find” the information yourself. My thinking is that if I provide the information, you can spend your time on the learning
aspect of this assignment. At the end of this first section is the requirements section itemizing what you need to do.
The second section which follows all of the above is a very short section where I want you to write up an analysis of a
horizontal and vertical analysis problem where I give you the problem and the solution. I am looking for a write up of
what the data means. My thinking on this one is that the computer will spit out the numbers and the calculation but
you need to be able to interpret the results.
SECTION ONE
Here are 2 pages that I scanned from the Needles textbook that will give you a little background information. I hope the
quality is good enough for you to read. See if they helps you understand the overall concepts of Financial Performance
Measurement.
Ratios Defined – Course textbooks:
Just as a reminder: To see a list of the ratios and their formulae, see Chapter 14, page 654 in the Acct 1A - Libby 8th
edition Textbook or Chapter 23, pages 825-826 in the Acct 159/Acct 6 - Price 13th editionTextbook. You will want to
refer to these pages or from the Internet sites below to find the formulae needed in the requirements section below.
Financial Ratios from the Web
Here are a couple of websites that define the ratios and give you some background. Use this information to paraphrase
your ratios as instructed in the requirements section below. I am looking for you being able to read the explanations
from one of these websites, combine it with what you have read from your textbook and learned from doing your
homework and then tell me in your own words (no direct quotes) what each ratio represents and why it is important. As
you read from these websites, don’t try to understand everything that they are saying as the detail varies site by site.
Focus in on 1) what the ratio is and how it is calculated; 2) what it means (needed for the paraphrase), and 3) why it is
important (needed for the analysis write up). The calculations and the paraphrase is what is required for each of the
first 5 requirements of section one. Your summary for section one will be the “why” part (which is requirement number
6 and is your analysis, also discussed more in the requirements section below). Here are the web links.
1. http://www.investopedia.com/university/ratios/. This one is great but when you first enter the site, it runs
some advertisement. Just look to the top-right of the page to click the link that will skip the ads and go directly
to the content. I thought this one would be the best for this project and most students so I put it first.
2. https://www.zionsbank.com/pdfs/biz_resources_book-6.pdf. This site is a pdf document that was created by
Zion Bank, a financial institution operating in Idaho and Utah. It is my second choice of great ones to use but it is
a bit long (23 pages).
3. http://educ.jmu.edu/~drakepp/principles/module2/fin_rat.pdf. This site is a handout from a professor at James
Madison University in Virginia and contains 14 well written pages but is more like a textbook, which is good if
you want the detail, but involves a bit more time and effort to get thru it.
4. http://www.demonstratingvalue.org/resources/financial-ratio-analysis. This site has some great information
but not a lot of detail. It tells you the facts but not as knowledge friendly as other sites.
Problem 14.4 (from the Needles textbook)
FYI: I took this case study from a completely different textbook so that there is limited chance that anyone here would
have the answer key to the questions asked. Here is the data you need, Problem 14.4.
P4 JD Campbell and Associates is considering an investment in the common stock of a chain of retail department stores.
He has narrowed his choice to two retail companies, Heckle Corporation and Jeckle Corporation, whose income
statements and balance sheets follow.
Heckle Jeckle
Net Sales 12,560,000$ 25,210,000$
Costs and Expenses:
Cost of Goods Sold 6,142,000 14,834,000
Selling Expenses 4,822,600 7,108,200
Administrative Expenses 986,000 2,434,000
Total Costs and Expenses 11,950,600 24,376,200
Income from Operations 609,400 833,800
Interest Expense 194,000 228,000
Income before Income Taxes 415,400 605,800
Income Taxes Expense 200,000 300,000
Net Income 215,400$ 305,800$
Earnings Per Share ? ?
Income Statement
For the Period Ending December 31, 2013
Heckle Jeckle
Cash 80,000$ 192,400$
Marketable Securities at Cost 203,400 84,600
Accounts Receivable, Net 552,800 985,400
Inventory 629,800 1,253,400
Prepaid Expenses 54,400 114,000
Property, Plant & Equipment, Net 2,913,600 6,552,000
Intagibles and Other Assets 553,200 144,800
Total Assets 4,987,200$ 9,326,600$
Accounts Payable 344,000$ 572,600$
Notes Payable 150,000 400,000
Income Taxes Payable 50,200 73,400
Bonds Payable 2,000,000 2,000,000
Common Stock, $20 par 1,000,000 600,000
Paid In Capital 609,800 3,568,600
Retained Earnings 833,200 2,112,000
Total Liabilites and Stockholder's equity 4,987,200$ 9,326,600$
Assets
Liabilities and Stockholder's Equity
Balance Sheet
December 31, 2013
During the year, Heckle paid a total of $50,000 in dividends. The market price per
share of its stock is currently $60. In comparison, Jeckle paid a total of $114,000 in
dividends, and the current market price of its stock is $76 per share. Heckle had net
cash flows from operations of $271,500 and net capital expenditures of $625,000.
Jeckle had net cash flows from operations of $492,500 and net capital expenditures of
$1,050,000. Information for prior years is not readily available. Assume that all notes
payable are current liabilities and all bonds payable are long term liabilities and that
there is no change in inventory.
Requirements Section One
Conduct a comprehensive ratio analysis of each company, using all available information. Compare the results. Round
to one decimal place and consider changes of 0.1 or less to be indeterminate. For this section, you need to use the data
given above. Show me the formula (you are welcome to copy and paste the formulae text from any source so that you
can reduce the amount of typing), then show the calculation (the numbers from Problem 14.4). Next, paraphrase what
the ratio means. Do this process for each of Requirements 1-5. I am looking for your understanding of the ratio and not
what you can copy and paste. This format is how I will judge your understanding of the material. Expected length of the
paraphrase is 2 paragraphs, not 2 sentences. If you treat this part of the project like a recipe, you should be able to
efficiently complete this part of the project. The analysis in requirement #6 is the “Why” discussed above. Be sure to
properly quote your paraphrase and anything that you may quote in your analysis (see the note about proper citation at
the bottom of this document).
1) Prepare an Operating Asset Management Analysis by calculating for each company the :
a) current ratio b) quick ratio c) receivables turnover
d) day’s sales uncollected e) inventory turnover f) days’ inventory on hand
g) payables turnover h) days’ payable i) financing period
2) Prepare a Profitability And Total Asset Management Analysis by calculating for each company the:
a) profit margin b) asset turnover c) return on assets
3) Prepare a Financial Risk Analysis by calculating for each company the:
a) debt to equity ratio b) return on equity c) investing coverage ratio
4) Prepare a Liquidity Analysis by calculating for each company the cash flow yield
a) Cash flows to sales b) Cash flows to assets c) Free cash flows
5) Prepare An Analysis Of Market Strength by calculating for each company the:
a) price/earnings ratio b) dividend yield
6) Once you have completed the first 5 steps, write a 1-2 page analysis of the Heckle and
Jeckle corporations. Which one is better off and why? What are their similarities, differences,
strengths, weaknesses, etc.? Which one should JD Campbell and Associates invest in and why?
Note: This section is another opportunity where you can demonstrate your understanding of
what you learned this semester so write as much as you can as long as it pertains to the project.
Some Additional Information
Suggestion: Go thru the chapters and add information that is relevant to this project. A quick scan of the chapters should
create ideas that demonstrate what you have learned in this course.
When you find a formula from the Internet that is an image or difficult to copy and retain the proper format and if you have the Snipping Tool software on your computer, use it to get just the formula. I have demonstrated how to do this in the TerryTubeVideos discussed in the next section. I would suggest using Excel for all your numbers crunching, use the Paste Special (called OLE or object linking and embedding) to link your spreadsheets into Word with your analysis along with your Snipping Tool images. Again, how to do this can be found at TerryTubeVideos.
Citing your Paraphrases Use this website to paraphrase all the ratios that you have calculated. In your analysis, be sure to properly cite your work.
You can use the video I created to demonstrate how to cite in Word if you are unsure. The address for the videos is: http://www.cabrillo.edu/homepages/temullin/TerryTubeVideos.htm. I will make the screen capture videos over Spring Break ’14 so check back if you have read this before I have TerryTubeVideos completed.
SECTION TWO To demonstrate your knowledge of Horizontal Analysis and Vertical Analysis, I am giving you a problem from the Price
textbook, Problem 23-1B but not to worry, I am also giving you the solutions. My focus here is for you to do just the
analysis. My thinking on this one is that the computer will spit out the calculation but you need to be able to interpret the
results. Here is Price textbook Problem 23-1B (scanned) and the corresponding solution. Please realize that I am not
asking you to do all the work shown below; it is already done for you thereby significantly reducing the amount of work
you need to do for this section.
PROBLEM 23.1B
1.
2013 2012 PERCENT*
Revenue
Sales 5 7 3 5 0 0 4 2 5 5 0 0 100.6% 100.6% 1 4 8 0 0 0 34.8%
Less Sales Returns and Allowances 3 5 0 0 2 5 0 0 0.6% 0.6% 1 0 0 0 40.0%
Net Sales 5 7 0 0 0 0 4 2 3 0 0 0 100.0% 100.0% 1 4 7 0 0 0 34.8%
Cost of Goods Sold
Merchandise Inventory, January 1 3 6 0 0 0 3 4 0 0 0 6.3% 8.0% 2 0 0 0 5.9%
Net Purchases 2 7 5 0 0 0 1 6 2 0 0 0 48.2% 38.3% 1 1 3 0 0 0 69.8%
Total Merchandise Available for Sale 3 1 1 0 0 0 1 9 6 0 0 0 54.6% 46.3% 1 1 5 0 0 0 58.7%
Less Merchandise Inventory, December 31 3 6 0 0 0 3 6 0 0 0 6.3% 8.5% 0 0.0%
Cost of Goods Sold 2 7 5 0 0 0 1 6 0 0 0 0 48.2% 37.8% 1 1 5 0 0 0 71.9%
Gross Profit on Sales 2 9 5 0 0 0 2 6 3 0 0 0 51.8% 62.2% 3 2 0 0 0 12.2%
Operating Expenses
Selling Expenses
Sales Salaries Expense 8 7 0 0 0 8 0 0 0 0 15.3% 18.9% 7 0 0 0 8.8%
Payroll Tax Expense—Selling 8 7 0 0 8 0 0 0 1.5% 1.9% 7 0 0 8.8%
Other Selling Expenses 2 4 0 0 0 1 8 0 0 0 4.2% 4.3% 6 0 0 0 33.3%
Total Selling Expenses 1 1 9 7 0 0 1 0 6 0 0 0 21.0% 25.1% 1 3 7 0 0 12.9%
General and Administrative Expenses
Officers Salaries Expense 7 5 0 0 0 5 0 0 0 0 13.2% 11.8% 2 5 0 0 0 50.0%
Payroll Tax Expense—Administrative 7 5 0 0 5 0 0 0 1.3% 1.2% 2 5 0 0 50.0%
Depreciation Expense 7 0 0 0 7 0 0 0 1.2% 1.7% − 0 − 0.0%
Other General and Administrative Expenses 3 5 0 0 2 0 0 0 0.6% 0.5% 1 5 0 0 75.0%
Total General and Administrative Expenses 9 3 0 0 0 6 4 0 0 0 16.3% 15.1% 2 9 0 0 0 45.3%
Total Operating Expenses 2 1 2 7 0 0 1 7 0 0 0 0 37.3% 40.2% 4 2 7 0 0 25.1%
Net Income Before Income Taxes 8 2 3 0 0 9 3 0 0 0 14.4% 22.0% (1 0 7 0 0) -11.5%
Income Tax Expense 2 0 5 7 5 2 3 2 5 0 3.6% 5.5% (2 6 7 5) -11.5%Net Income After Income Taxes 6 1 7 2 5 6 9 7 5 0 10.8% 16.5% (8 0 2 5) -11.5%
Best Sales, Inc.
Comparative Income Statement
For Years Ended December 31, 2013 and 2012
AMOUNTS
PERCENT OF
NET SALES* INCREASE OR (DECREASE)
2013 2012 AMOUNT
PROBLEM 23.1B (continued)
1.
2013 2012 PERCENT
Current Assets
Cash 8 8 3 7 5 5 6 5 7 9 29.6% 23.1% 3 1 7 9 6 56.2%
Accounts Receivable 6 3 9 2 5 3 5 0 0 0 21.4% 14.3% 2 8 9 2 5 82.6%
Merchandise Inventory 3 6 0 0 0 3 6 0 0 0 12.0% 14.7% 0 0.0%
Prepaid Expenses 1 5 0 0 1 0 0 0 0.5% 0.4% 5 0 0 50.0%
Supplies 5 0 0 4 3 4 0.2% 0.2% 6 6 15.2%
Total Current Assets 1 9 0 3 0 0 1 2 9 0 1 3 63.7% 52.8% 6 1 2 8 7 47.5%
Property, Plant, and Equipment
Land 4 0 0 0 0 4 0 0 0 0 13.4% 16.4% − 0 − 0.0%
Building and Equipment 8 2 5 0 0 8 2 5 0 0 27.6% 33.7% − 0 − 0.0%
Less Accumulated Depreciation (1 4 0 0 0) (7 0 0 0) -4.7% -2.9% (7 0 0 0) 100.0%
Net Book Value—Building and Equipment 6 8 5 0 0 7 5 5 0 0 22.9% 30.9% (7 0 0 0) (9.3)%
Total Property, Plant, and Equipment 1 0 8 5 0 0 1 1 5 5 0 0 36.3% 47.2% (7 0 0 0) (6.1)%
Total Assets 2 9 8 8 0 0 2 4 4 5 1 3 100.0% 100.0% 5 4 2 8 7 22.2%
Current Liabilities
Accounts Payable 3 8 0 0 0 4 5 0 0 0 12.7% 18.4% (7 0 0 0) (15.6)%
Sales Tax Payable 2 0 0 0 2 5 0 0 0.7% 1.0% (5 0 0) (20.0)%
Payroll Taxes Payable 1 2 0 0 1 0 0 0 0.4% 0.4% 2 0 0 20.0%
Income Taxes Payable 2 1 2 5 7 6 3 0.7% 0.3% 1 3 6 2 178.5%
Total Current Liabilities 4 3 3 2 5 4 9 2 6 3 14.5% 20.1% (5 9 3 8) (12.1)%
Long-Term Liabilities
Mortgage Payable 7 4 0 0 0 7 5 0 0 0 24.8% 30.7% (1 0 0 0) (1.3)%
Total Long-Term Liabilities 7 4 0 0 0 7 5 0 0 0 24.8% 30.7% (1 0 0 0) (1.3)%
Total Liabilities 1 1 7 3 2 5 1 2 4 2 6 3 39.3% 50.8% (6 9 3 8) (5.6)%
Stockholders’ Equity
Common Stock ($1 par, 20,000 shares authorized
20,000 shares issued and outstanding) 2 0 0 0 0 2 0 0 0 0 6.7% 8.2% − 0 − 0.0%
Paid-in Capital—Common Stock 5 0 0 0 5 0 0 0 1.7% 2.0% − 0 − 0.0%
Retained Earnings 1 5 6 4 7 5 9 5 2 5 0 52.4% 39.0% 6 1 2 2 5 64.3%
Total Stockholders’ Equity 1 8 1 4 7 5 1 2 0 2 5 0 60.7% 49.2% 6 1 2 2 5 50.9%
Total Liabilities and Stockholders’ Equity 2 9 8 8 0 0 2 4 4 5 1 3 100.0% 100.0% 5 4 2 8 7 22.2%
INCREASE OR (DECREASE)
2013 2012 AMOUNT
Assets
Liabilities and Stockholders’ Equity
Best Sales, Inc.
Comparative Balance Sheet
For Years Ended December 31, 2013 and 2012
AMOUNTS
PERCENT OF
TOTAL ASSETS*
Requirements Section Two
The way I would attack this part of the Comprehensive Analysis Project is to first make sure you know where the
percentages are coming from. Just review in your book the concepts of Horizontal and Vertical Analysis and then look at
the numbers and decide based on your chapter readings and other work this semester what you would investigate if you
were the CEO of the company. I am giving you this project in Word/PDF format so you
can better see the numbers if you zoom in using the zoom tool in the lower right corner.
Although I could give you the original spreadsheet containing these numbers so that you can create graphs and charts to
supplement your analysis, the publisher puts each character in individual columns so you cannot use it as actual numbers
in Excel. You will have to do your own data entry for any graph and
chart making. This project is being used for Accounting 6,
Accounting 1A and Accounting 159. My expectations is that
Accounting 6 will definitely do the graphs and charts and I will
leave it up to the other two classes to decide based on the
student’s level of Excel experience to do what he/she feels is
beneficial to the analysis. I will give extra credit to the latter
groups for any graphs and charts that are included in the analysis.
Expected length of Section Two is a minimum of two exceptionally
well written pages (three if using graphs and charts). Again, use
the “what and why” format as explained in Section One. Tell me
what the numbers say and why it is important. Answer questions
such as what areas do the numbers show are of concern, what changes should the CEO make or look into, etc. As in any
analysis, you can also discuss what is good and is therefore probably not a concern to the CEO. Use your textbook to help
you develop your analysis so that it is meaningful.
Conclusion
This project has a significant amount of information but I tried to write it out in enough detail that the number of
questions you may have should be significantly reduced. Again, this document is long but please realize the amount of
work that I have already done for you. This project should easily be doable in the last 2 weeks of class doing it in bits and
pieces (or in one long day if you choose the marathon approach) which is what it is designed for. Reminder: this project
was not created as a group project of 4-6 students each doing individual sections but as an individual project where each
student is independently responsible for all the content.
Feel free to interpret and go “above and beyond” what is asked but do not forget that if you are in Accounting 1 or 6, this
is a college level transferable class so treat it as such. Accounting 159 students should also aim for quality work, regardless
of the transferability issue. Your learning is what is important here, not just getting a grade. Also notice that in the
syllabus, this project counts 100 points so you should be putting the effort into this project that is equivalent to one exam
that requires 3-4 chapters’ worth of learning and studying to be prepared to take an exam. This project would also be an
excellent document to take with you to job interviews in the future to show the level of your writing skills as well as your
analytical and critical thinking abilities.
Read everything in detail then contact me with any questions you may have. If any revisions become necessary, I will send
you an announcement in Blackboard.
Terry
