Financial Spreadsheet 41826

Partial file snippet.

Sheet 1: Contents

	
	
	
	
	
		

		Excel version of selected tables from the Quarterly Financial Report
		

		

	
	
		

		

		

		

	
	
		Supplementary Revenue Information
		

		

		

	
	
		

		

		Revenue by Region (Year To Date)
		R-1-1
	
	
		

		

		Revenue by Region (Quarterly)
		R-1-2
	
	
		

		

		Product Sales Analysis (Year To Date)
		R-2-1
	
	
		

		

		Product Sales Analysis (Reported & Core CER Change)
		R-3
	
	
		

		

		Product Forecast
		R-4
	
	
		

		

		

		

	
	
		Financial Appendix
		

		

		

	
	
		

		

		FY2022 Q1 Reported Results with Actual and CER % Change
		A-3
	
	
		

		

		FY2022 Q1 Core Results with Actual and CER % Change
		A-4
	
	
		

		

		FY2022 Q1 Reconciliation from Reported to Core
		A-5
	
	
		

		

		FY2021 Q1 Reconciliation from Reported to Core
		A-6
	
	
		

		

		FY2022 Full Year FX Rates Assumptions and Currency Sensitivity
		A-12
	
	
		

		

		CAPEX, Depreciation and Amortization and Impairment losses 
		A-13
	



Sheet 2: R-1-1

	
	
	
	
	
	
	
	
		1. Revenue by Region
		

		

		

		

		

		

		Table of Contents
	
	
		■ Year To Date
		

		

		

		

		

		

		

	
	
		

		Reported *1
		

		Core Growth at CER *1*5
		

	
	
		(Bn JPY)
		FY21Q1 YTD
		FY22Q1 YTD
		YOY
		

		YOY
		

	
	
		 Total revenue
		949.6
		972.5
		22.9
		2.4%
		

		8.3%
		

	
	
		Japan *2
		259.0
		140.5
		-118.4
		-45.7%
		

		11.3%
		

	
	
		% of revenue
		27.3%
		14.5%
		-12.8pt
		

		

		

		

	
	
		United States
		412.2
		501.1
		88.8
		21.6%
		

		5.4%
		

	
	
		% of revenue
		43.4%
		51.5%
		8.1pt
		

		

		

		

	
	
		Europe and Canada
		178.7
		205.6
		26.8
		15.0%
		

		9.3%
		

	
	
		% of revenue
		18.8%
		21.1%
		2.3pt
		

		

		

		

	
	
		Growth and Emerging Markets *3
		99.7
		125.3
		25.6
		25.7%
		

		15.1%
		

	
	
		% of revenue
		10.5%
		12.9%
		2.4pt
		

		

		

		

	
	
		Asia (excluding Japan)
		40.3
		46.1
		5.8
		14.4%
		

		2.9%
		

	
	
		% of revenue
		4.2%
		4.7%
		0.5pt
		

		

		

		

	
	
		Latin America
		30.1
		40.3
		10.2
		34.0%
		

		16.7%
		

	
	
		% of revenue
		3.2%
		4.1%
		1.0pt
		

		

		

		

	
	
		Russia/CIS
		12.3
		17.4
		5.0
		40.8%
		

		24.7%
		

	
	
		% of revenue
		1.3%
		1.8%
		0.5pt
		

		

		

		

	
	
		Other *4
		17.0
		21.6
		4.6
		26.8%
		

		34.2%
		

	
	
		% of revenue
		1.8%
		2.2%
		0.4pt
		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Of which royalty / service income *2
		157.7
		33.6
		-124.1
		-78.7%
		

		30.9 %
		

	
	
		*1 Revenue amount is classified into countries or regions based on the customer location.
		

	
	
		*2 The 133.0 billion JPY selling price of the sale of diabetes portfolio in Japan is included in FY21Q1YTD.
		

	
	
		*3 GEM: Growth and Emerging Markets, which include Asia (excluding Japan), Latin America, Russia/CIS, Middle East, Oceania and Africa.
		

	
	
		*4 Other region includes Middle East, Oceania and Africa.
		

	
	
		*5 Refer to "Appendix" for the definition and reconciliations of core financial measures and CER (Constant Exchange Rate).
		

	



Sheet 3: R-1-2

	
	
	
	
		1. Revenue by Region (continued)
		

		

		

		

		

		

		

		

		

		

		

		

		Table of Contents
	
	
		■ Quarterly
		Reported *1
		

	
	
		

		FY21
		FY22
		

	
	
		(Bn JPY)
		Q1
		Q2
		Q3
		Q4
		Q1
		YOY
		Q2
		YOY
		Q3
		YOY
		Q4
		YOY
		

	
	
		Total revenue
		949.6
		844.8
		901.3
		873.3
		972.5
		2.4%
		

		

		

		

		

		

		

	
	
		Japan *2
		259.0
		131.9
		139.4
		128.7
		140.5
		-45.7%
		

		

		

		

		

		

		

	
	
		% of revenue
		27.3%
		15.6%
		15.5%
		14.7%
		14.5%
		

		

		

		

		

		

		

		

	
	
		United States
		412.2
		426.2
		458.6
		417.4
		501.1
		21.6%
		

		

		

		

		

		

		

	
	
		% of revenue
		43.4%
		50.4%
		50.9%
		47.8%
		51.5%
		

		

		

		

		

		

		

		

	
	
		Europe and Canada
		178.7
		175.2
		187.0
		198.2
		205.6
		15.0%
		

		

		

		

		

		

		

	
	
		% of revenue
		18.8%
		20.7%
		20.7%
		22.7%
		21.1%
		

		

		

		

		

		

		

		

	
	
		Growth and Emerging Markets *3
		99.7
		111.5
		116.3
		129.0
		125.3
		25.7%
		

		

		

		

		

		

		

	
	
		% of revenue
		10.5%
		13.2%
		12.9%
		14.8%
		12.9%
		

		

		

		

		

		

		

		

	
	
		Asia (excluding Japan)
		40.3
		49.4
		50.1
		57.2
		46.1
		14.4%
		

		

		

		

		

		

		

	
	
		% of revenue
		4.2%
		5.8%
		5.6%
		6.5%
		4.7%
		

		

		

		

		

		

		

		

	
	
		Latin America
		30.1
		31.3
		32.2
		34.9
		40.3
		34.0%
		

		

		

		

		

		

		

	
	
		% of revenue
		3.2%
		3.7%
		3.6%
		4.0%
		4.1%
		

		

		

		

		

		

		

		

	
	
		Russia/CIS
		12.3
		12.8
		18.5
		18.5
		17.4
		40.8%
		

		

		

		

		

		

		

	
	
		% of revenue
		1.3%
		1.5%
		2.1%
		2.1%
		1.8%
		

		

		

		

		

		

		

		

	
	
		Other *4
		17.0
		18.0
		15.5
		18.4
		21.6
		26.8%
		

		

		

		

		

		

		

	
	
		% of revenue
		1.8%
		2.1%
		1.7%
		2.1%
		2.2%
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Of which royalty / service income *2
		157.7
		25.4
		27.4
		62.7
		33.6
		-78.7%
		

		

		

		

		

		

		

	
	
		*1 Revenue amount is classified into countries or regions based on the customer location.
		

	
	
		*2 The 133.0 billion JPY selling price of the sale of diabetes portfolio in Japan is included in FY21Q1.
		

	
	
		*3 GEM: Growth and Emerging Markets, which include Asia (excluding Japan), Latin America, Russia/CIS, Middle East, Oceania and Africa.
		

	
	
		*4 Other region includes Middle East, Oceania and Africa.

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet contents excel version of selected tables from the quarterly financial report supplementary revenue information by region year to date r product sales analysis reported amp core cer change forecast appendix fy q results with actual and a reconciliation full fx rates assumptions currency sensitivity capex depreciation amortization impairment losses table growth at bn jpy fyq ytd yoy total japan pt united states europe canada emerging markets asia excluding latin america russiacis other which royalty service income amount is classified into countries or regions based on customer location billion selling price sale diabetes portfolio in included fyqytd gem include middle east oceania africa includes refer quot for definition reconciliations measures constant exchange rate continued...

Related files

Share

Help

	Excel version of selected tables from the Quarterly Financial Report

Supplementary Revenue Information
		Revenue by Region (Year To Date)	R-1-1
		Revenue by Region (Quarterly)	R-1-2
		Product Sales Analysis (Year To Date)	R-2-1
		Product Sales Analysis (Reported & Core CER Change)	R-3
		Product Forecast	R-4

Financial Appendix
		FY2022 Q1 Reported Results with Actual and CER % Change	A-3
		FY2022 Q1 Core Results with Actual and CER % Change	A-4
		FY2022 Q1 Reconciliation from Reported to Core	A-5
		FY2021 Q1 Reconciliation from Reported to Core	A-6
		FY2022 Full Year FX Rates Assumptions and Currency Sensitivity	A-12
		CAPEX, Depreciation and Amortization and Impairment losses	A-13

1. Revenue by Region						Table of Contents
■ Year To Date
	Reported *1				Core Growth at CER 15
(Bn JPY)	FY21Q1 YTD	FY22Q1 YTD	YOY		YOY
Total revenue	949.6	972.5	22.9	2.4%	8.3%
Japan *2	259.0	140.5	-118.4	-45.7%	11.3%
% of revenue	27.3%	14.5%	-12.8pt
United States	412.2	501.1	88.8	21.6%	5.4%
% of revenue	43.4%	51.5%	8.1pt
Europe and Canada	178.7	205.6	26.8	15.0%	9.3%
% of revenue	18.8%	21.1%	2.3pt
Growth and Emerging Markets *3	99.7	125.3	25.6	25.7%	15.1%
% of revenue	10.5%	12.9%	2.4pt
Asia (excluding Japan)	40.3	46.1	5.8	14.4%	2.9%
% of revenue	4.2%	4.7%	0.5pt
Latin America	30.1	40.3	10.2	34.0%	16.7%
% of revenue	3.2%	4.1%	1.0pt
Russia/CIS	12.3	17.4	5.0	40.8%	24.7%
% of revenue	1.3%	1.8%	0.5pt
Other *4	17.0	21.6	4.6	26.8%	34.2%
% of revenue	1.8%	2.2%	0.4pt

Of which royalty / service income *2	157.7	33.6	-124.1	-78.7%	30.9 %
*1 Revenue amount is classified into countries or regions based on the customer location.
*2 The 133.0 billion JPY selling price of the sale of diabetes portfolio in Japan is included in FY21Q1YTD.
*3 GEM: Growth and Emerging Markets, which include Asia (excluding Japan), Latin America, Russia/CIS, Middle East, Oceania and Africa.
*4 Other region includes Middle East, Oceania and Africa.
*5 Refer to "Appendix" for the definition and reconciliations of core financial measures and CER (Constant Exchange Rate).

1. Revenue by Region (continued)													Table of Contents
■ Quarterly	Reported *1
	FY21				FY22
(Bn JPY)	Q1	Q2	Q3	Q4	Q1	YOY	Q2	YOY	Q3	YOY	Q4	YOY
Total revenue	949.6	844.8	901.3	873.3	972.5	2.4%
Japan *2	259.0	131.9	139.4	128.7	140.5	-45.7%
% of revenue	27.3%	15.6%	15.5%	14.7%	14.5%
United States	412.2	426.2	458.6	417.4	501.1	21.6%
% of revenue	43.4%	50.4%	50.9%	47.8%	51.5%
Europe and Canada	178.7	175.2	187.0	198.2	205.6	15.0%
% of revenue	18.8%	20.7%	20.7%	22.7%	21.1%
Growth and Emerging Markets *3	99.7	111.5	116.3	129.0	125.3	25.7%
% of revenue	10.5%	13.2%	12.9%	14.8%	12.9%
Asia (excluding Japan)	40.3	49.4	50.1	57.2	46.1	14.4%
% of revenue	4.2%	5.8%	5.6%	6.5%	4.7%
Latin America	30.1	31.3	32.2	34.9	40.3	34.0%
% of revenue	3.2%	3.7%	3.6%	4.0%	4.1%
Russia/CIS	12.3	12.8	18.5	18.5	17.4	40.8%
% of revenue	1.3%	1.5%	2.1%	2.1%	1.8%
Other *4	17.0	18.0	15.5	18.4	21.6	26.8%
% of revenue	1.8%	2.1%	1.7%	2.1%	2.2%

Of which royalty / service income *2	157.7	25.4	27.4	62.7	33.6	-78.7%
*1 Revenue amount is classified into countries or regions based on the customer location.
*2 The 133.0 billion JPY selling price of the sale of diabetes portfolio in Japan is included in FY21Q1.
*3 GEM: Growth and Emerging Markets, which include Asia (excluding Japan), Latin America, Russia/CIS, Middle East, Oceania and Africa.
*4 Other region includes Middle East, Oceania and Africa.

Related files

Share

Share to social media

Help

Login Area