I need help with my assignment 1 or my Financial Management

JWI530_Assignment1DataandAnalyticsTemplateBlackberryvCitrixPartATemplate7.xlsx

Home >Business & Finance homework help >Management homework help >I need help with my assignment 1 or my Financial Management

Sheet1

Assignment 1							Student Name:
Data and Analytics Submission Template
Due: Sunday Midnight Week 5
		Blackberry					Citrix
	UNITS (eg Billions, Millions, Thousands - Please input)	Millions					Millions
		FY 2021	FY 2020	FY 2019	FY 2018	Comments	FY 2020	FY 2019	FY 2018	FY 2017	Comments
	Total Revenue (or Sales)			904	932				2,974	2,825
	Cost of Goods Sold/Cost of Sales			206	262				434	440
	Total Selling, General & Administrative (SG&A)			409	467				1,389	1,309
	Research and development			219	239				440	416
	Impairment and amortization expenses			136	164	Imp. + Amort. Exp			16	17	Imp. + Amort. Exp
	Gross Profit (Gross Income)			698	670	Rev - COS			2,540	2,385	Rev - COS
	Gross Margin			77%	72%	GP/Rev			85%	84%	GP/Rev
	Net Profit (Net Income)			93	405				576	(21)
	Net Margin			10%	43%	NP/Rev			19%	-1%	NP/Rev
	SG&A as % of Sales			45%	50%	SG&A/Rev			47%	46%	SG&A/Rev
	R&D Expense as % of Sales			24%	26%	Int Exp/Rev			15%	15%	Int Exp/Rev
	Impairments and Amortization as a % of Sales			15%	18%				1%	1%
	Return on Sales (ROS)			10%	43%	NP/Rev			19%	-1%	NP/Rev
	Return on Total Assets (ROA)			2%	11%	NP/Total Assets			11%	-0%	NP/Total Assets
	Return on Equity (ROE)			4%	16%	NP/Total Equity			105%	-2%	NP/Total Equity
	Cash			548	816				619	1,115
	Accounts Receivable			194	151				688	712
	Inventory			- 0	- 0				22	13
	Total Current Assets			1,194	2,545				2,087	2,621
	Total Assets			3,929	3,780				5,136	5,820
	Total Current Liabilities			471	411				2,911	1,687
	Long Term Debt (including LT Cap Lease)			665	782				742	2,127	LTD + LT Lease (if provided)
	Total Debt			1,293	1,275				4,585	4,828
	Retained Earnings			(32)	(45)				4,169	3,509
	Total Equity			2,636	2,505				551	992
	Current Ratio			2.54	6.19	CA/CL			0.72	1.55	CA/CL
	Quick Ratio			1.58	2.35	(Cash + Ar)/CL			0.45	1.08	(Cash + Ar)/CL
	Long Term Debt to Equity			0.25	0.31	LTD/Total Equity			1.35	2.14	LTD/Total Equity
	Total Debt to Equity			0.49	0.51	Tot Debt/Tot Equity			8.32	4.87	Tot Debt/Tot Equity
	AR Turnover (times per year)			5.2		Revenue/Avg AR			4.2		Revenue/Avg AR
	Days Sales Outstanding (in days)			70		365/AR Turnover			86		365/AR Turnover
	Cash Flow From Operations			100	704				1,035	908
	Cash Flow from Investing			(375)	(630)				132	(64)
	Cash Flow from Financing			5	(10)				(1,658)	(694)
	Capital Expenditures			(17)	(15)				(69)	(81)	Purch of P&E
	Dividends			- 0	- 0				(47)	- 0
	Purchase of Treasury Stock			- 0	(18)				(1,261)	(1,175)
	Cash used in Acquisitions			(1,402)	- 0				(249)	(60)
	Free Cash Flow			83	689	CFFO - CapEx			966	827	CFFO - CapEx
	Free Cash Flow as % of Net Income			89%	170%	FCF/NI			168%	-3938%	FCF/NI
			Indicates Financial Ratio (calculations required)
	MEMO
	2020 and 2019 data from 2020 Annual Report
	2018 and 2017 from 2018 Annual Report