Building a Financial Model for CognizantBUILDING A FINANCIAL MODEL FOR COGNIZANT Goals of the...

Question

Building a Financial Model for Cognizant

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 ............................... 3 10-Q FOR THE NINE MONTHS ENDED SEPTEMBER 30, 2016 ........................ 111 EARNINGS CALL TRANSCRIPT FOR Q3, 2016 ................................................... 285 PRESS RELEASES FOR Q1-Q3, 2016 ...................................................................... 302 NEWS FOR THE LAST 12 MONTHS ENDED NOVEMBER 28, 2016 ................ 325 EQUITY RESEARCH REPORTS .............................................................................. 327 WEDBUSH SECURITIES AS OF SEPTEMBRE 8, 2016 ........................................................... 328 SOCIETE GENERALE AS OF SEPTEMBER 23, 2016 ............................................................. 341 HSBC AS OF SEPTEMBER 30, 2016 ................................................................................. 367 BMO AS OF NOVEMBER 7, 2016 ..................................................................................... 404 WELLS FARGO AS OF NOVEMBER 7, 2016 ....................................................................... 413 DEUTSCHE BANK AS OF NOVEMBER 7, 2016 .................................................................... 428 UBS AS OF NOVEMBER 7, 2016 ....................................................................................... 443 COWEN GROUP AS OF NOVEMBER 8, 2016 ....................................................................... 449 BARCLAYS AS OF NOVEMBER 8, 2016 .............................................................................. 458 MORGAN STANLEY AS OF NOVEMBER 8, 2016 ................................................................. 471 J.P. MORGAN AS OF NOVEMBER 8, 2016 .......................................................................... 483 AMBIT AS OF DECEMBER 9, 2016 ................................................................................... 494 SUMMARY OF VALUATION FROM EQUITY RESEARCH REPORTS .......... 525 ELLIOTT LETTER TO COGNIZANT DATED NOVEMBER 28, 2016 .............. 535 2 10-K FOR THE FISCAL YEAR ENDED DECEMBER 31, 2015 3 Morningstar® Document Research℠ FORM 10-K COGNIZANT TECHNOLOGY SOLUTIONS CORP - CTSH Filed: February 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 warranted to be accurate, complete or timely. The user 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...

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

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment

Sun	Mon	Tue	Wed	Thu	Fri	Sat
30	31	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	1	2	3