Solved by verified expert:Analyst report assignmentCalvin Klein (PVH), and Gap (GPS)I want someone to complete this files because I did as much as I can.I did 2 Excel files that every file has 6 to 7 sheets you can see it at the bottom of each file.
presentation1.pptx
gps_financial_statements_analysis.xlsx
pvh_financial_statements_analysis__1_.xlsx
Unformatted Attachment Preview
.
Analyst report assignment
Calvin Klein (PVH), and Gap (GPS)
Overview
• You will working as financial analysts preparing reports for clients interested
in potential investments
• Analyze the business and financial statements of 2 publicly-traded
companies within the same industry -Calvin Klein (PVH), and Gap
(GPS)• Provide an opinion as to whether or not each company is a good
investment based on your analysis of the company’s liquidity,
solvency and profitability analyses as well as your overall
interpretation of the horizontal and vertical analyses
Overview
• Prepare a written analyst report of 4-5 pages based on your analysis.
• With your group, present your findings to the class. Presentations
should be between 8-10 minute
Overview
• Use proper business writing
• Professional
• avoid clichés and colloquialisms
• Concise
• Free of errors
• All writing should be in your own words not those of your sources
• Format: follow the template on Blackboard
• Submission: Upload your Word and Excel documents in Blackboard
• Present your findings to the class (8-10 minutes per group)
Outline
• Brief discussion of each company and its business
• Brief discussion of significant recent developments that have affected any of your specific
companies or the entire industry
• Analysis of Excel-based financial statements including:
• 3-year horizontal analysis
• Vertical analysis for each of the 3 years
• Ratio calculations for each of the 3 years divided into 3 components: liquidity, solvency and
profitability
• Interpretation of each item above (main focus of the assignment)
• Overall conclusion as to whether the company is a good investment
Discussion of the companies and their
businesses and industry
• Sources:
• Companies’ websites
• “Business” section of annual report (10-k)
• What should your client know about the businesses and
their environment?
Significant recent developments
• How/why have the companies been in the news recently?
• Use reputable sources (WSJ instead of Wikipedia)
• Summarize what your client should know about the
company’s recent developments
Source:
http://writing.wisc.edu/Handbook/QPA_paraphrase2.html
• Use proper business writing
• Professional
• avoid clichés and colloquialisms
• Concise
• Free of errors
Analysis of Excel-based financial statements
• 3-year horizontal analysis
• Vertical analysis for each of the 3 years
• Ratio calculations
• Find the most recent fiscal year-end that all companies have filed and
use that year as the most recent year
• Download Excel-based financial statements
Accessing and downloading Excel-based financial
statements
Access the most recent 10-K (and the 10-k from two years earlier) using
the following link and entering the company name or ticker
https://www.sec.gov/edgar/searchedgar/companysearch.html
Search filing type 10-K
Click on the link for
Interactive Data
Accessing and downloading Excel-based financial
statements
Choose: View Excel Document
Downloading Excel-based financial
statements
Once opened, you will need the following worksheets:
• Income Statements (also called Statement of Operations)
• Do not use the Statements of Comprehensive Income, which is
different from the Income Statement
• Balance Sheets (also called Statements of Financial Position)
• Statements of Cash Flows
Downloading Excel-based financial
statements
• Copy the 3 financial statement worksheets from Edgar into the ratio
analysis template
• The income statements and statements of cash flows report 3 years
of data.
• Rename the worksheets and present in the following order:
• Balance sheets
• Income statements
• Statements of cash flows
Downloading Excel-based financial
statements
• You will need to add two years of balance sheet data from an older10k in order to report 4 years of balance sheet data necessary to
calculate ratios for the most recent 3 years.
• May need to add accounts (lines) to the balance sheet if an
account was used three and/or four years ago but not in the two
most recent balance sheets
Analyzing financial statements
• Horizontal Analysis
• Copy the balance sheets into a new worksheet, title the worksheet
Horizontal Analysis and keep the most recent 3 years of data
• Calculate (using formulas in Excel) and report dollar and
percentage increases or decreases over the 3-year period so that
the most recent balance sheet accounts are reported as a % of the
base year balances
Horizontal Analysis – Balance Sheet
Horizontal Analysis – Income Statement
Analyzing financial statements
• Vertical Analysis
• Copy the balance sheets into a new worksheet, title the worksheet
Vertical Analysis and keep the most recent 3 years of data
• Calculate (using formulas in Excel) and report each balance sheet
account as a percentage of total assets
Vertical Analysis – Balance Sheets
Vertical Analysis – Income Statements
Ratio Analysis
• Although analysts may use different variations of some of
the ratios we are analyzing, use the ratio definitions given on
the template
• Use average balances by year where indicated (not ending
balances)
Analyzing financial statements
• Link the underlying data needed as inputs for calculating each ratio
• Do not hard-code the numbers on the spreadsheet
• For example, when determining the current ratio:
• Link the value of current assets in cell E10 to the current assets
field in the company’s Excel balance sheet
• Link the value of current liabilities in cell E11 to the current
liabilities field in the company’s Excel balance sheet
Analyzing financial statements
• Use Excel for all calculations
• Do not hard-code the numbers on the spreadsheet
• For example, when determining the current ratio:
Analyzing financial statements
• If a required value is not directly reported in the balance sheet, show
your calculation using Excel
• For example, suppose the balance sheet does not show a subtotal for
current liabilities. In the ratio template field requesting current
liabilities, use Excel to calculate it by adding (and linking to) each
current liability field on the balance sheet
Analyzing financial statements
• If a value is not required and not reported, enter 0.
• For example, Walmart does not separately report “Short-term
investments”. For simplicity, instead of looking in the footnotes for
this data, report a value of zero.
• Be sure to delete the formula when a field is missing or has a value
of zero so your spreadsheet does not report #DIV/0!, #VALUE!, or an
inappropriate change of 100%
Analyzing financial statements
Non-controlling Interests
• The company has an investment in one or more subsidiaries
• Accounting rules require consolidation of financial information if the parent
company owns more than 50% of the subsidiary.
• Consolidation of 100% of the assets, liabilities, equity and income
• Ownership of 51-99% of the assets, liabilities, equity and income
• “Non-controlling interest” represents the portion that is consolidated by the
(parent) company but owned by others
Non-controlling Interests
Source: http://macabacus.com/accounting/noncontrolling-interest
Non-controlling Interests
Source: http://macabacus.com/accounting/noncontrolling-interest
Analyzing financial statements
Non-controlling Interests
• In ratio analysis, use stockholders’ equity and net income amounts that are attributable to
the (parent) company only
• Ratios that use equity and net income:
•
•
•
•
•
•
ROE
ROA
Profit margin
Times interest earned
EPS
Payout ratio
Earnings per share
• Use basic earnings per share
• Diluted EPS accounts for the conversion of options
(employee stock options, convertible debt, etc) to redeem
common stock
Earnings per share
• Although EPS is reported on the face of the income
statement, show the calculation by linking to earnings
attributable to the company and basic weighted
average common shares outstanding
Market Price per Share
Find the closing price on the dates of all three fiscal year-ends being
analyzed.
• Use any source to find stock prices. Two common sources are Yahoo
Finance and Google Finance. Use the “historical data” section.
• Stocks do not trade on weekends or certain holidays. If the company’s
fiscal year end is on a non-trading day, use the last closing price prior
to the fiscal year end.
Source:
https://www.google.com/finance/historical?cid=38230&startdate=Jan+20%2C+2016&enddate=Feb+4%2C+2016&num=30&ei=338FWMGaDMfEeqqUnMgG
Use (and defend) your judgment
• If a ratio calculation requires your judgement, explain your
decision.
• For example, Wal-Mart reports revenues as “net sales”
and “membership and other income”. Either can be used
as the “net sales” number in ratio calculations, I
should/would explain why I chose to include both types of
revenue in my calculation of net sales.
Analysis is an art, not a science
• You may find different ratios telling different stories (for example,
ROA is increasing but ROE is decreasing)
• Instead of telling a conflicting story (profitability is both increasing
and decreasing), describe the big picture (income was relatively
unchanged over the 3-year period but the company sold PP&E,
reducing its assets, while at the same time the company issued new
shares of common stock, increasing equity).
The analysis
• You don’t need to write about each number you calculated
• Tell an interesting story
• Discuss only the most significant changes and why they matter
• Focus on overall liquidity, solvency and profitability but be able to
support your rationale with specific ratios where necessary
• Understand what the changes mean for the company and whether
the changes are good or bad for the company
• Discuss the “story” told by the data for each company, one company
at a time.
The report
• General guideline: Written portion should be 4-5 pages doublespaced
• Upload the written portion, without tables, in Blackboard using the
link called Analyst Report Word Document
• Check your Safe Assign score; scores above 25% indicate that too
much text matches underlying sources. Make sure your writing is in
your own words
• Upload each Excel file (one for each company analyzed) using the link
called Analyst Report Excel Files
CONSOLIDATED BALANCE SHEETS – USD ($) $ in Millions Jan. 28, 2017 Jan. 30, 2016 Jan. 31, 2015
Current assets:
Cash and cash equivalents
Merchandise inventory
Other current assets
Total current assets
$
$
$
$
1.783,0 $
1.830,0 $
702,0 $
4.315,0 $
1.370,0 $
1.873,0 $
742,0 $
3.985,0 $
1.515,0
1.889,0
913,0
4.317,0
Property and equipment, net
Other long-term assets
Total assets
$
$
$
2.616,0 $
679,0 $
7.610,0 $
2.850,0 $
638,0 $
7.473,0 $
2.773,0
600,0
7.690,0
Current liabilities:
Current maturities of debt
Accounts payable
Accrued expenses and other current liabilities
Income taxes payable
Total current liabilities
$
$
$
$
$
65,0 $
1.243,0 $
1.113,0 $
32,0 $
2.453,0 $
421,0
1.112,0
979,0
23,0
2.535,0
$
$
$
$
$
21,0
1.173,0
1.020,0
20,0
2.234,0
Long-term liabilities:
Long-term debt
Lease incentives and other long-term liabilities
Total long-term liabilities
$
$
$
1.248,0
1.005,0
2.253,0
$
$
$
1.310,0
1.083,0
2.393,0
$
$
$
1.332,0
1.141,0
2.473,0
$
$
$
$
$
$
$
20,0
81,0
2.749,0
54,0
2.904,0
7.610,0
$
$
$
$
$
$
$
20,0 $
$
2.440,0 $
85,0 $
$
2.545,0 $
7.473,0 $
21,0
2.797,0
165,0
2.983,0
7.690,0
Stockholders’ equity:
Common stock $0.05 par value, Authorized 2,300 shares for all
periods presented; Issued and Outstanding 399 and 397 shares
Additional Paid in Capital
Retained earnings
Accumulated other comprehensive income
Treasury stock at cost (660 and 643 shares)
Total stockholders’ equity
Total liabilities and stockholders’ equity
Feb. 01, 2014
$
$
$
$
1.510,0
1.928,0
992,0
4.430,0
$
$
$
2.758,0
661,0
7.849,0
$
$
$
$
$
25,0
1.242,0
1.142,0
36,0
2.445,0
$
$
$
1.369,0
973,0
2.342,0
$
$
$
$
$
$
$
55,0
2.899,0
14.218,0
135,0
(14.245,0)
3.062,0
7.849,0
CONSOLIDATED STATEMENTS OF INCOME – USD ($) shares in Millions, $ in Millions
Net sales
Cost of goods sold and occupancy expenses
Gross profit
Operating expenses
Operating income
Interest expense
Interest income
Income before income taxes
Income taxes
Net income
Weighted-average number of shares—basic (in shares)
Weighted-average number of shares – diluted (in shares)
Earnings per share – basic (in dollars per share)
Earnings per share – diluted (in dollars per share)
12 Months Ended
Jan. 28, 2017
$ 15.516,0
$
9.876,0
$
5.640,0
$
4.449,0
$ 1.191,0
$
75,0
$
(8,0)
$
1.124,0
$
448,0
$
676,0
$
$
399
400
1,69
1,69
12 Months Ended
Jan. 30, 2016 Jan. 31, 2015
$ 15.797,0 $ 16.435,0
$ 10.077,0 $ 10.146,0
$
5.720,0 $
6.289,0
$
4.196,0 $
4.206,0
$ 1.524,0 $ 2.083,0
$
59,0 $
75,0
$
(6,0) $
(5,0)
$
1.471,0 $
2.013,0
$
551,0 $
751,0
$
920,0 $ 1.262,0
$
$
411
413
2,24
2,23
$
$
435
440
2,90
2,87
CONSOLIDATED STATEMENTS OF CASH FLOWS – USD ($) $ in Millions
12 Months Ended
Jan. 28, 2017 Jan. 30, 2016
Cash flows from operating activities:
Net income
$
676,0
$
920,0
Adjustments to reconcile net income to net cash provided by operating
activities:
Depreciation and amortization
Amortization Lease Incentives
Share-based compensation
Tax benefit from exercise of stock options and vesting of stock units
$
$
$
$
593,0
(62,0)
76,0
(4,0)
$
$
$
$
592,0
(65,0)
76,0
26,0
Excess tax benefit from exercise of stock options and vesting of stock units
$
(1,0) $
(28,0)
Other Asset Impairment Charges
Goodwill, Impairment Loss
Non-cash and other items
Deferred income taxes
$
$
$
$
107,0
71,0
(4,0)
(54,0)
$
$
$
$
54,0
(126,0)
101,0
Changes in operating assets and liabilities:
Merchandise inventory
Other current assets and other long-term assets
Accounts payable
Accrued expenses and other current liabilities
Income taxes payable, net of prepaid and other tax-related items
Lease incentives and other long-term liabilities
Net cash provided by operating activities
$
$
$
$
$
$
$
46,0
54,0
146,0
76,0
19,0
(20,0)
1.719,0
$
$
$
$
$
$
$
(6,0)
133,0
(47,0)
(41,0)
(24,0)
29,0
1.594,0
Cash flows from investing activities:
Purchases of property and equipment
Proceeds from Sale of Property, Plant, and Equipment
Other
Net cash used for investing activities
$
$
$
$
(524,0)
(5,0)
(529,0)
$
$
$
$
(726,0)
(4,0)
(730,0)
Cash flows from financing activities:
Proceeds from issuance of short-term debt
Payments of short-term debt
Payments of long-term debt
Proceeds from issuances under share-based compensation plans
Withholding tax payments related to vesting of stock units
Repurchases of common stock
Excess tax benefit from exercise of stock options and vesting of stock units
$
$
$
$
$
$
$
(400,0)
(21,0)
29,0
(19,0)
1,0
$
$
$
$
$
$
$
400,0
(21,0)
65,0
(69,0)
(1.015,0)
28,0
Cash dividends paid
Other
Net cash used for financing activities
$
$
$
(367,0) $
$
(777,0) $
(377,0)
(1,0)
(990,0)
Effect of foreign exchange rate fluctuations on cash and cash equivalents
$
Net increase (decrease) in cash and cash equivalents
Cash and cash equivalents at beginning of period
Cash and cash equivalents at end of period
–
$
(19,0)
$
$
$
413,0 $
1.370,0 $
1.783,0 $
(145,0)
1.515,0
1.370,0
Non-cash investing activities:
Purchases of property and equipment not yet paid at end of period
$
56,0
$
81,0
Supplemental disclosure of cash flow information:
Cash paid for interest during the period
Cash paid for income taxes during the period, net of refunds
$
$
82,0
488,0
$
$
78,0
452,0
Months Ended
Jan. 31, 2015
$
1.262,0
$
$
$
$
564,0
(64,0)
100,0
37,0
$
(38,0)
$
$
$
$
10,0
(66,0)
75,0
$
$
$
$
$
$
$
(9,0)
240,0
(41,0)
(33,0)
(87,0)
179,0
2.129,0
$
$
$
$
(714,0)
121,0
(3,0)
(596,0)
$
$
$
$
$
$
$
(21,0)
90,0
(52,0)
(1.179,0)
38,0
$
$
$
(383,0)
(1.507,0)
$
(21,0)
$
$
$
5,0
1.510,0
1.515,0
$
73,0
$
$
77,0
714,0
CONSOLIDATED BALANCE SHEETS – USD ($) $ in Millions Jan. 28, 2017 Jan. 30, 2016 Jan. 31, 2015
Current assets:
Cash and cash equivalents
Merchandise inventory
Other current assets
Total current assets
Property and equipment, net
Other long-term assets
Total assets
$
$
$
$
$
$
$
1.783,0 $
1.830,0 $
702,0 $
4.315,0 $
2.616,0 $
679,0 $
7.610,0 $
1.370,0 $
1.873,0 $
742,0 $
3.985,0 $
2.850,0 $
638,0 $
7.473,0 $
1.515,0
1.889,0
913,0
4.317,0
2.773,0
600,0
7.690,0
Current liabilities:
Current maturities of debt
Accounts payable
Accrued expenses and other current liabilities
Income taxes payable
Total current liabilities
$
$
$
$
$
65,0 $
1.243,0 $
1.113,0 $
32,0 $
2.453,0 $
421,0
1.112,0
979,0
23,0
2.535,0
$
$
$
$
$
21,0
1.173,0
1.020,0
20,0
2.234,0
Long-term liabilities:
Long-term debt
Lease incentives and other long-term liabilities
Total long-term liabilities
$
$
$
1.248,0
1.005,0
2.253,0
$
$
$
1.310,0
1.083,0
2.393,0
$
$
$
1.332,0
1.141,0
2.473,0
$
$
$
$
$
$
$
20,0
81,0
2.749,0
54,0
2.904,0
7.610,0
$
$
$
$
$
$
$
20,0 $
$
2.440,0 $
85,0 $
$
2.545,0 $
7.473,0 $
21,0
2.797,0
165,0
2.983,0
7.690,0
Stockholders’ equity:
Common stock $0.05 par value, Authorized 2,300 shares for all
periods presented; Issued and Outstanding 399 and 397 shares
Additional Paid in Capital
Retained earnings
Accumulated other comprehensive income
Treasury stock at cost (660 and 643 shares)
Total stockholders’ equity
Total liabilities and stockholders’ equity
Feb. 01, 2014
Change over 3-year period
Amount
Percent
$
$
$
$
$
$
$
1.510,0
1.928,0
992,0
4.430,0
2.758,0
661,0
7.849,0
$
$
$
$
$
$
$
273,00
(98,00)
(290,00)
(115,00)
(142,00)
18,00
(239,00)
18,1%
-5,1%
-29,2%
-2,6%
-5,1%
2,7%
-3,0%
$
$
$
$
$
25,0
1.242,0
1.142,0
36,0
2.445,0
$
$
$
$
$
40,00
1,00
(29,00)
(4,00)
8,00
160,0%
0,1%
-2,5%
-11,1%
0,3%
$
$
$
1.369,0
973,0
2.342,0
$
$
$
(121,00)
32,00
(89,00)
-8,8%
3,3%
-3,8%
$
$
$
$
$
$
$
55,0
2.899,0
14.218,0
135,0
(14.245,0)
3.062,0
7.849,0
$
(35,00)
$ (2.818,00)
$ (11.469,00)
$
(81,00)
$ 14.245,00
$
(158,00)
$
(239,00)
-63,6%
-97,2%
-80,7%
-60,0%
-100,0%
-5,2%
-3,0%
$
$
$
$
$
$
–
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
$
$
–
#DIV/0!
#DIV/0!
CONSOLIDATED STATEMENTS OF INCOME – USD ($) shares in Millions, $ in Millions
Net sales
Cost of goods sold and occupancy expenses
Gross profit
Operating expenses
Operating income
Interest expense
Interest income
Income before income taxes
Income taxes
Net income
Weighted-average number of shares—basic (in shares)
Weighted-average number of shares – diluted (in shares)
Earnings per share – basic (in dollars per share)
Earnings per share – diluted (in dollars per share)
12 Months Ended
Jan. 28, 2017
$ 15.516,0
$
9.876,0
$
5.640,0
$
4.449,0
$ 1.191,0
$
75,0
$
(8,0)
$
1.124,0
$
448,0
$
676,0
$
$
399
400
1,69
1,69
12 Months Ended
Jan. 30, 2016 Jan. 31, 2015
$ 15.797,0 $ 16.435,0
$ 10.077,0 $ 10.146,0
$
5.720,0 $
6.289,0
$
4.196,0 $
4.206,0
$ 1.524,0 $ 2.083,0
$
59,0 $
75,0
$
(6,0) $
(5,0)
$
1.471,0 $
2.013,0
$
551,0 $
751,0
$
920,0 $ 1.262,0
$
$
411
413
2,24
2,23
$
$
Change over 3-year period
Amount
Percent
$
$
$
$
$
$
$
$
$
$
(919,00)
(270,00)
(649,00)
243,00
(892,00)
(3,00)
(889,00)
(303,00)
(586,00)
-5,6%
-2,7%
-10,3%
5,8%
-42,8%
0,0%
60,0%
-44,2%
-40,3%
-46,4%
$
$
$
$
$
$
$
$
–
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
435
440
2,90
2,87
CONSOLIDATED BALANCE SHEETS – USD ($) $ in Millions Jan. 28, 2017
Percent
Jan. 30, 2016
Current assets:
Cash and cash equivalents
Merchandise inventory
Other current assets
Total current assets
Property and equipment, net
Other long-term assets
Total assets
$
$
$
$
$
$
$
1.783,0
1.830,0
702,0
4.315,0
2.616,0
679,0
7.610,0
23,4%
24,0%
9,2%
56,7%
34,4%
8,9%
100,0%
$
$
$
$
$
$
$
1.370,0
1.873,0
742,0
3.985,0
2.850,0
638,0
7.473,0
Current liabilities:
Current maturities of debt
Accounts payable
Accrued expenses and other …
Purchase answer to see full
attachment
You will get a plagiarism-free paper and you can get an originality report upon request.
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more