BUILDING A FINANCIAL MODEL FOR COGNIZANT Goals of the Homework: The goal of the homework is to:·...

Question

BUILDING A FINANCIAL MODEL FOR COGNIZANT
Goals of the Homework: The goal of the homework is to:
· Understand how accounting and finance knowledge can be combined to build a integrated model for a company which includes assumptions, historical and projected income statement, balance sheet, cash flow statement
· Understand how an investment banker, equity analyst, hedge fund or a company analyst builds a detailed financial model for a company
· Enable you to write an initiating equity research report on a company by using the model to do discounted cash flow analysis. For homework purposes we are writing a mini report given time constraints
· Understand discounted cash flow analysis valuation methodologies used for valuing a stock
· Read research reports of companies and familiarize yourself with databases such as Thomson One and Bloomberg
Checklist for Submission 1: The submission should include and please put a Check mark against each item before you submit the homework. Pls make sure you read the detailed submission at the back of the document
Group Submission: Historical income statement, balance sheet and cash flow statement and the historical assumptions in Excel Sheet and the Historical Debt Schedule below Cash Flow Statement (You will have to read the Notes to the Financial Statements to get some of the balances)
Individual Submission: Historical income statement, balance sheet and cash flow statement and the historical assumptions in Excel Sheet and the Historical Debt Schedule below Cash Flow Statement (You will have to read the Notes to the Financial Statements to get some of the balances)
Group Submission: A word document in bullets with explanation showing 5 Points what you learned from first submission and 5 Points what the Challenges were of the first submission. Please be prepared to talk about these in class
Group Review: Please confirm you have reviewed the Public Information Book for Cognizant in the Assignment Folder (just reviewed is required)
Format Used: You have used the format sent to you and filled all the numbers in the sheet
Homework Details for Submission 1:
Historical Income Statement – For the Year Ended December 31, 2013, 2014 and 2015
Balance Sheet – For the Year Ended December 31, 2014 and 2015
Cash Flow Statement – For the Year Ended December 31, 2015
Historical Assumptions for the last 2-3 years – for growth rates you will have for two years only i.e. 2013 to 2014 and 2014 to 2015 since you are not inputing 2012 numbers
1

Table of Contents (Formal design)

COGNIZANT (CTSH)
Public Information Book (PIB)
1
TABLE OF CONTENTS FOR COGNIZANT PIB
10-K FOR THE FISCAL YEAR ENDED DECEMBER 31, 2015 ............ XXXXXXXXXX3
10-Q FOR THE NINE MONTHS ENDED SEPTEMBER 30, 2016 ..... XXXXXXXXXX111
EARNINGS CALL TRANSCRIPT FOR Q3, 2016 ................................ XXXXXXXXXX285
PRESS RELEASES FOR Q1-Q3, 2016 ................................................... XXXXXXXXXX302
NEWS FOR THE LAST 12 MONTHS ENDED NOVEMBER 28, 20 XXXXXXXXXX325
EQUITY RESEARCH REPORTS ........................................................... XXXXXXXXXX327
WEDBUSH SECURITIES AS OF SEPTEMBRE 8, 2016 ........................................ XXXXXXXXXX328
SOCIETE GENERALE AS OF SEPTEMBER 23, 2016 .......................................... XXXXXXXXXX341
HSBC AS OF SEPTEMBER 30, 2016 .............................................................. XXXXXXXXXX367
BMO AS OF NOVEMBER 7, 2016 .................................................................. XXXXXXXXXX404
WELLS FARGO AS OF NOVEMBER 7, 2016 .................................................... XXXXXXXXXX413
DEUTSCHE BANK AS OF NOVEMBER 7, 2016 ................................................. XXXXXXXXXX428
UBS AS OF NOVEMBER 7, 2016 .................................................................... XXXXXXXXXX443
COWEN GROUP AS OF NOVEMBER 8, 2016 .................................................... XXXXXXXXXX449
BARCLAYS AS OF NOVEMBER 8, 2016 ........................................................... XXXXXXXXXX458
MORGAN STANLEY AS OF NOVEMBER 8, 2016 .............................................. XXXXXXXXXX471
J.P. MORGAN AS OF NOVEMBER 8, 2016 ....................................................... XXXXXXXXXX483
AMBIT AS OF DECEMBER 9, 2016 ................................................................ XXXXXXXXXX494
SUMMARY OF VALUATION FROM EQUITY RESEARCH REPORTS XXXXXXXXXX
ELLIOTT LETTER TO COGNIZANT DATED NOVEMBER 28, XXXXXXXXXX535

2
10-K FOR THE FISCAL YEAR ENDED
DECEMBER 31, 2015
3
Morningstar® Document Research℠

FORM 10-K
COGNIZANT TECHNOLOGY SOLUTIONS CORP - CTSH
Filed: Fe
uary 25, 2016 (period: December 31, 2015)
Annual report with a comprehensive overview of the company
The information contained herein may not be copied, adapted or distributed and is not wa
anted to be accurate, complete or timely. The use
assumes all risks for any damages or losses arising

cognizant-model-template-to-be-used-for-deliverable-1-september-19-2020-3-vtfptq4y.xlsx deliverable-1-building-a-financial-model-for-cognizant-sep-19-2020-1-lhlcebbf.docx cognizant-pib-2015-as-of-september-19-5uvcw1e3.pdf

Yash · Accepted Answer

Model
	Cognizant financial model
	($ in millions, except per share data)		 
			HISTORICAL FINANCIAL STATEMENTS					PROJECTED FINANCIAL STATEMENTS
			Fiscal Year Ending December 31,					Fiscal Year Ending December 31,
			2011A	2012A	2013A	2014A	2015A	2016P	2017P	2018P	2019P	2020P
	Income Statement
	Revenues
John Basilici: John Basilici:
Segment revenues as per " Segment Information" in the notes to respective 10-Ks
	 Financial Services				$3,717.6	$4,285.6	$5,002.9
	 Healthcare				$2,264.8	$2,689.4	$3,667.5
	 Manufacturing/Retail/Logistics				$1,868.3	$2,093.6	$2,343.9
	 Other				$992.5	$1,194.1	$1,401.7
	Total revenues				$8,843.2	$10,262.7	$12,416.0
	    % Growth					16.1%	21.0%
	Cost of revenues (1)				$5,265.5	$6,141.1	$7,440.2
	     Cost of revenues as % of Revenues				59.5%	59.8%	59.9%
	Gross profit				$3,577.7	$4,121.6	$4,975.8
	    Gross profit margin %				40.5%	40.2%	40.1%
	Selling, general and administrative expenses				$1,727.6	$2,037.0	$2,508.6
	     SG&A as % of Revenue				19.5%	19.8%	20.2%
	 Depreciation and amortization expense related to P&E				$155.7	$172.1	$233.1
Basilici, John P. (TDBB): John Basilici:
Note 4 — Property and Equipment, net
"Depreciation and amortization expense related to property and equipment"
	 Amortization of intangible assets				$24.2	$36.0	$96.9
Basilici, John P. (TDBB): John Basilici:
Note 5 — Goodwill and Intangible Assets, net
"Amortization of
intangible assets"
	 Amortization recorded as a reduction of revenues				($7.7)	($8.4)	($4.8)
Basilici, John P. (TDBB): John Basilici:
Note 5 — Goodwill and Intangible Assets, net
"Amortization...relating to customer relationship intangible assets was recorded as a reduction of revenues."
	Total depreciation and amortization expense				$172.2	$199.7	$325.2
	Income from operations / EBIT
John Basilici: John Basilici:
Segment Operating Profit as per " Segment Information" in the notes to respective 10-Ks
	 Financial Services				$1,212.1	$1,320.1	$1,641.9
	 Healthcare				$829.9	$851.0	$1,200.0
	 Manufacturing/Retail/Logistics				$630.3	$685.7	$802.7
	 Other				$318.3	$391.9	$453.7
	 Unallocated costs				($1,312.7)	($1,363.8)	($1,956.3)
	Total income from operations				1,677.9	1,884.9	2,142.0
	    EBIT margin %				19.0%	18.4%	17.3%
	EBITDA				$1,850.1	$2,084.6	$2,467.2
	     EBITDA margin %				20.9%	20.3%	19.9%
	     EBITDA growth					12.7%	18.4%
	Other income / (expense), net
	 Interest income				$48.9	$62.4	$83.7
	 Interest expense				$0.0	($2.5)	($17.7)
	 Foreign currency exchange gains (losses), net				($41.1)	($20.4)	($42.6)
	 Other, net				$2.2	($0.4)	($1.8)
	Total other income				$10.0	$39.1	$21.6
	Pretax income				$1,687.9	$1,924.0	$2,163.6
	Taxes				$459.3	$484.7	$540.0
	     Tax Rate				27.2%	25.2%	25.0%
	Net income				$1,228.6	$1,439.3	$1,623.6
	     Net Margin %				13.9%	14.0%	13.1%
	     Net Income Growth					17.1%	12.8%
	Earnings per share
	Weighted average number of common shares outstanding—Basic				604.0	608.1	609.1
	 Dilutive effect of stock-based compensation plans				5.7	4.4	4.2
	Weighted average number of common shares outstanding—Diluted				609.7	612.5	613.3
	Basic earnings per share				$2.03	$2.37	$2.67
	Diluted earnings per share				$2.02	$2.35	$2.65
	Reconciliation of Non-GAAP Financial measures
	GAAP income from operations / EBIT				1,677.9	1,884.9	2,142.0
	 Add: Stock-based compensation expense				$118.8	$134.8	$192.0
	 Add: Acquisition-related charges
Basilici, John P. (TDBB): John Basilici:
2015 10-K, PDF pg. 46:
Acquisition-related charges include, when applicable, amortization of purchased intangible assets included in the depreciation and amortization expense line on our consolidated statements of operations, external deal costs, acquisition-related retention bonuses, integration costs, changes in the fair value of contingent consideration liabilities, charges for impairment of acquired intangible assets and other acquisition-related costs.				$24.0	$48.4	$115.8
	Non-GAAP income from operations / EBIT				$1,820.7	$2,068.1	$2,449.8
	    Non-GAAP EBIT margin %
Basilici, John P. (TDBB): John Basilici: 
Non-GAAP operating margin target range of 19-20% (confirmed in the 3Q16 press release)				20.6%	20.2%	19.7%
	GAAP diluted earnings per share				2.02	2.35	2.65
	 Effect of above operating adjustments, net of tax				$0.17	$0.23	$0.35
	 Effect of non-operating FX gains and losses, net of tax
Basilici, John P. (TDBB): John Basilici:
2015 10-K, PDF pg. 46: 
Non-operating foreign currency exchange gains and losses are inclusive of gains and losses on related foreign exchange forward contracts not
designated as hedging instruments for accounting purposes.
				$0.08	$0.02	$0.07
	Non-GAAP diluted earnings per share				$2.27	$2.60	$3.07
	(1) Excludes depreciation and amortization
	Balance Sheet
	Assets
	Cash and cash equivalents					2010.1	$2,125.2
	Short-term investments					$1,764.6	$2,824.3
	Trade accounts receivable, gross					$2,005.6	$2,291.6
	 Allowance for doubtful accounts					$36.9	$39.

BUILDING A FINANCIAL MODEL FOR COGNIZANT Goals of the Homework: The goal of the homework is to: · Understand how accounting and finance knowledge can be combined to build a integrated model for a...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment