Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Comprehensive Analysis Project (CAP) As shown in the syllabus, you have a project to do for this course. Other instructors have students work in groups, have milestones where specific work has to be...

1 answer below »
Comprehensive Analysis Project (CAP)
As shown in the syllabus, you have a project to do for this course. Other instructors
have students work in groups, have 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. I feel that
this project will
ing you to an understanding of the Learning Objectives of the project
and 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 this 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
einforce 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 - Li
y 8th
edition Textbook or Chapter 23, pages XXXXXXXXXXin the Acct 159/Acct 6 - Price 13th editionTextbook. You will want to
efer 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
atios/. 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
iz_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
esources/financial-ratio-analysis. This site has some great information
ut not a lot of detail. It tells you the facts but not as knowledge friendly as other sites.
http:
www.investopedia.com/university
atios
https:
www.zionsbank.com/pdfs
iz_resources_book-6.pdf
http:
educ.jmu.edu/~drakepp/principles/module2/fin_rat.pdf
http:
www.demonstratingvalue.org
esources/financial-ratio-analysis
Annual Reports
Here are two links to annual reports (pdf files), one for American Eagle Outfitters, the other for The Buckle.
1. http:
te
ytube.net/AnnualReport/AmericanEagleOutfitters.pdf
2. http:
te
ytube.net/AnnualReport/TheBuckle.pdf
Requirements Section One
Conduct a comprehensive ratio analysis of each company, using the income statement and balance sheet of each
company and any other 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 ratio 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. 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
equirement #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) cu
ent 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) interest 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 would you 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
Answered Same Day Aug 05, 2021

Solution

Tanmoy answered on Aug 08 2021
140 Votes
Comparative Analysis of the Financial Statements
The Buckle Inc. & American Eagle Outfitters Inc.
Part A
Ratio Analysis of the Buckle Inc. & American Eagle Outfitters Inc. for 2015 and 2014
    Operating Asset Management Analysis
     
    The Buckle - 2015
    The Buckle - 2014
    American Eagle Outfitters -2015
    American Eagle Outfitters - 2014
    Cu
ent Ratio
    2.65
    2.77
    1.94
    2.23
    Quick Ratio
    1.59
    1.77
    1.33
    1.53
    Receivables Turnove
    134.60
    261.23
    48.35
    44.74
    Day's Sales Uncollected
    2.71
    1.40
    7.55
    8.16
    Inventory Turnove
    4.97
    5.07
    7.63
    7.52
    Day's Inventory on Hand
    73.43
    72.05
    47.85
    50.00
    Payables Turnove
    18.08
    16.93
    12.59
    12.18
    Day's Payable
    20.18
    20.99
    32.78
    33.95
    Financing Period
    1st Fe
uary to 31st January
    1st Fe
uary to 31st January
    -
    -
     
     
     
     
     
    Profitability and Total Asset Management Analysis
     
    The Buckle - 2015
    The Buckle - 2014
    American Eagle Outfitters -2015
    American Eagle Outfitters - 2014
    Profit Margin
    44.0%
    44.3%
    35.2%
    33.7%
    Asset Turnove
    2.12
    2.06
    1.93
    1.95
    Return on Assets
    30%
    30%
    5%
    5%
     
     
     
     
     
    Financial Risk Analysis
     
    The Buckle - 2015
    The Buckle - 2014
    American Eagle Outfitters -2015
    American Eagle Outfitters - 2014
    Debt Equity Ratio
    -
    -
    -
    -
    Return on Equity
    0.46
    0.45
    0.07
    0.07
    Interest Coverage Ratio
    -
    -
    -
    -
     
     
     
     
     
    Liquidity Ratio
     
    The Buckle - 2015
    The Buckle - 2014
    American Eagle Outfitters -2015
    American Eagle Outfitters - 2014
    Cash flows to Sales
    0.17
    0.15
    0.10
    0.07
    Cash flows to Assets
    0.36
    0.32
    0.20
    0.14
    Free Cash Flows
    150314
    145215
    93424
    -48643
     
     
     
     
     
    Analysis of Market Strength
     
    The Buckle - 2015
    The Buckle - 2014
    American Eagle Outfitters -2015
    American Eagle Outfitters - 2014
    Price Earnings Ratio
    15.03
    13.07
    33.43
    31.47
    Dividend Yield
    1.80%
    1.90%
    3.48%
    3.06%
The cu
ent ratio states the company’s ability to pay the short term obligation within a year. The more it is the ratio; the better is the firm’s position. The cu
ent ratio of both the companies Buckles Inc. and American Eagle Inc. have declined in 2015 compared to the previous year 2014. This is not a positive indicator.
The quick ratio is similar to cu
ent ratio, but it is a measurement of the company’s ability to use near cash. It does not take into consideration inventories as it takes time to generate quick money from sales of goods. Here, too we can find for both the companies the quick ratio have declined in 2015 compared to 2014.
Receivables turnover specifies the firm’s effectiveness to collect the debt from its debtors. For Buckle Inc. we can observe that the ratio have declined in 2015 compared to 2014 which means company is taking more time to collect debts from its debtors. For American Eagles it is observed that the receivable turnover has increased in 2015 compared to 2015. This signifies the company’s ability to collect cash from its debtors has increase and also the company has become slightly conservative when it comes to extending credit towards its debtors.
Days sales uncollected is similar to receivables where it signifies the number of days it is required for the company to collect the debt. For Buckles Inc. we can observe that it takes more days in 2015 compared to 2014. Whereas for American Eagles Inc. it takes much lesser days in 2015 compared to 2014.
Inventory Turnover signifies the number of times the inventory or goods of the company are sold. The more times it is sold the better is the turnover. For Buckles Inc. the ratio decreases in 2015 compared to 2014. Whereas for American Eagles the ratio increases slightly in 2015 compared to 2014.
Days’ inventory on hand specifies the numbers of day’s inventory are held for sales after its production. For Buckles Inc. it’s not positive in 2015 whereas for American Eagles the numbers in 2015 is much better compared to 2014.
Payable turnover signifies the short term ability of the firm to pay-off its suppliers. It can be observed that Buckles Inc. pays more times in 2015 than 2014. Compared to this, American Eagles pays lower number of times than Buckles Inc. This states that Buckles Inc. is much more creditor friendly than American Eagles.
Days’ Payable measure the number of days required to pay-off the creditors or suppliers of a firm. In 2015, for both the companies it takes lesser number of days in comparison to 2014 to pay-off the suppliers. Hence, both of them are in a better position in this regard.
Profit Margin is the percentage of company’s profit over its revenue or sales and signifies the ability of the firm to handle its overall profits efficiently. For Buckle Inc. the profit margins have slightly declined in 2015 compared to 2014 but for American Eagles Inc. it has increased.
Asset Turnover states the how efficiently the firm uses its assets to generate sales. For Buckles Inc. it is slightly better in 2015 than American Eagles Inc. compared to the previous year.
Return on Assets signifies how economically the company management is using the assets to generate its earnings. It is displayed in percentage. It can be observed that for Buckles Inc. this ratio is far better for both the years than American Eagles Inc.
Debt Equity ratio signifies the proportion of debt and equity the company uses to finance its assets and also signifies the ability of the equity to fulfil the obligation of the suppliers during business debacle. Both the companies do not have any debt with which it finances its assets.
Return on equity signifies the profitability of the business in relation to its employment of equity. This ratio has increased slightly of Buckles Inc. in 2015 compared to 2014, whereas it is same for American Eagles Inc. for both the years.
Interest coverage ratio is the ability of the firm to cover the present interest payment or servicing with its available earnings or profits. Since there is no debt for both the companies, hence there is no need of interest payment.
Cash flow to Sales signifies the ability of the firm to generate cash inflow for the business in proportion to the sales. It can be observed that for both Buckles Inc. and American Eagles this ratio has increased significantly in 2015 compared to 2014.
Cash flow to assets is actually an efficiency ratio which rates the ability of cash inflow to the assets of the firm without being impacted by income measurement or recognition concept. It can be observed that for both the companies the ratio is prudent in 2015 compared to 2014.
Free Cash flow is the cash flow from operations less capital expenditures of the company. The more it is, the better it is for the company and its investors. It is the fund available to be distributed among the security holders. The free cash flow for both the companies has increased...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers