Financial Spreadsheet 33740 | Qr2021 Q1 D Ex En

Partial file snippet.

Sheet 1: Table of Contents

	
	
	
	
	
		

		

		

		

	
	
		Table of Contents
		
	
		

		

		

		

	
	
		I.  Financial Results
		

		

		

	
	
		

		1
		Revenue by Region
		

	
	
		

		

		1-1
		Year To Date
	
	
		

		

		1-2
		Quarterly
	
	
		

		2
		Product Sales Analysis (vs PY Reported Actual)
		

	
	
		

		

		2-1
		Year To Date
	
	
		

		3
		Product Sales Analysis (Reported & Underlying Growth)
		

	
	
		

		4
		Product Forecasts
		

	
	
		

		5
		Exchange Rate
		

	
	
		

		6
		CAPEX, Depreciation, Amortization and Impairment Losses 
		

	



Sheet 2: 1-1

	
	
	
	
	
	
	
	
		1. Revenue by Region
		

		

		

		

		

		

		Table of Contents
	
	
		■ Year To Date
		

		

		

		

		

		

		

	
	
		

		Reported *1
		

		Underlying *1
		

	
	
		(Bn JPY)
		FY20Q1
		FY21Q1
		YOY
		

		YOY
		

	
	
		 Total revenue
		801.9
		949.6
		147.8
		18.4%
		

		3.8%
		

	
	
		Japan *2
		144.0
		259.0
		114.9
		79.8%
		

		1.0%
		

	
	
		% of revenue
		18.0%
		27.3%
		9.3pt
		

		

		

		

	
	
		United States
		402.6
		412.2
		9.6
		2.4%
		

		0.5%
		

	
	
		% of revenue
		50.2%
		43.4%
		-6.8pt
		

		

		

		

	
	
		Europe and Canada
		157.6
		178.7
		21.2
		13.4%
		

		11.1%
		

	
	
		% of revenue
		19.6%
		18.8%
		-0.8pt
		

		

		

		

	
	
		Growth and Emerging Markets *3
		97.6
		99.7
		2.0
		2.1%
		

		10.8%
		

	
	
		% of revenue
		12.2%
		10.5%
		-1.7pt
		

		

		

		

	
	
		Asia (excluding Japan)
		36.9
		40.3
		3.4
		9.3%
		

		13.6%
		

	
	
		% of revenue
		4.6%
		4.2%
		-0.4pt
		

		

		

		

	
	
		Latin America
		30.8
		30.1
		-0.7
		-2.3%
		

		24.4%
		

	
	
		% of revenue
		3.8%
		3.2%
		-0.7pt
		

		

		

		

	
	
		Russia/CIS
		13.0
		12.3
		-0.7
		-5.4%
		

		-14.9%
		

	
	
		% of revenue
		1.6%
		1.3%
		-0.3pt
		

		

		

		

	
	
		Other *4
		16.9
		17.0
		0.0
		0.3%
		

		7.3%
		

	
	
		% of revenue
		2.1%
		1.8%
		-0.3pt
		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Of which royalty / service income *2
		18.1
		157.7
		139.6
		773.2%
		

		

		

	
	
		*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.
		

	



Sheet 3: 1-2

	
	
	
	
		1. Revenue by Region (continued)
		

		

		

		

		

		

		

		

		

		

		

		

		Table of Contents
	
	
		■ Quarterly
		Reported *1
		

	
	
		

		FY20
		FY21
		

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

	
	
		Total revenue
		801.9
		788.9
		836.8
		770.3
		949.6
		18.4%
		

		

		

		

		

		

		

	
	
		Japan *2
		144.0
		138.3
		152.7
		124.6
		259.0
		79.8%
		

		

		

		

		

		

		

	
	
		% of revenue
		18.0%
		17.5%
		18.3%
		16.2%
		27.3%
		

		

		

		

		

		

		

		

	
	
		United States
		402.6
		383.5
		402.8
		379.0
		412.2
		2.4%
		

		

		

		

		

		

		

	
	
		% of revenue
		50.2%
		48.6%
		48.1%
		49.2%
		43.4%
		

		

		

		

		

		

		

		

	
	
		Europe and Canada
		157.6
		169.6
		172.8
		166.2
		178.7
		13.4%
		

		

		

		

		

		

		

	
	
		% of revenue
		19.6%
		21.5%
		20.7%
		21.6%
		18.8%
		

		

		

		

		

		

		

		

	
	
		Growth and Emerging Markets *3
		97.6
		97.5
		108.4
		100.5
		99.7
		2.1%
		

		

		

		

		

		

		

	
	
		% of revenue
		12.2%
		12.4%
		13.0%
		13.0%
		10.5%
		

		

		

		

		

		

		

		

	
	
		Asia (excluding Japan)
		36.9
		41.4
		40.9
		37.1
		40.3
		9.3%
		

		

		

		

		

		

		

	
	
		% of revenue
		4.6%
		5.2%
		4.9%
		4.8%
		4.2%
		

		

		

		

		

		

		

		

	
	
		Latin America
		30.8
		28.2
		36.4
		26.2
		30.1
		-2.3%
		

		

		

		

		

		

		

	
	
		% of revenue
		3.8%
		3.6%
		4.4%
		3.4%
		3.2%
		

		

		

		

		

		

		

		

	
	
		Russia/CIS
		13.0
		8.6
		17.1
		18.8
		12.3
		-5.4%
		

		

		

		

		

		

		

	
	
		% of revenue
		1.6%
		1.1%
		2.0%
		2.4%
		1.3%
		

		

		

		

		

		

		

		

	
	
		Other *4
		16.9
		19.3
		14.0
		18.3
		17.0
		0.3%
		

		

		

		

		

		

		

	
	
		% of revenue
		2.1%
		2.4%
		1.7%
		2.4%
		1.8%
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Of which royalty / service income *2
		18.1
		28.2
		22.8
		23.4
		157.7
		773.2%
		

		

		

		

		

		

		

	
	
		*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 table of contents i financial results revenue by region year to date quarterly product sales analysis vs py reported actual amp underlying growth forecasts exchange rate capex depreciation amortization and impairment losses bn jpy fyq 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 the customer location billion selling price sale diabetes portfolio in included gem include middle east oceania africa includes continued fy q...

Related files

Share

Help


Table of Contents

I. Financial Results
	1	Revenue by Region
		1-1	Year To Date
		1-2	Quarterly
	2	Product Sales Analysis (vs PY Reported Actual)
		2-1	Year To Date
	3	Product Sales Analysis (Reported & Underlying Growth)
	4	Product Forecasts
	5	Exchange Rate
	6	CAPEX, Depreciation, Amortization and Impairment Losses

1. Revenue by Region						Table of Contents
■ Year To Date
	Reported *1				Underlying *1
(Bn JPY)	FY20Q1	FY21Q1	YOY		YOY
Total revenue	801.9	949.6	147.8	18.4%	3.8%
Japan *2	144.0	259.0	114.9	79.8%	1.0%
% of revenue	18.0%	27.3%	9.3pt
United States	402.6	412.2	9.6	2.4%	0.5%
% of revenue	50.2%	43.4%	-6.8pt
Europe and Canada	157.6	178.7	21.2	13.4%	11.1%
% of revenue	19.6%	18.8%	-0.8pt
Growth and Emerging Markets *3	97.6	99.7	2.0	2.1%	10.8%
% of revenue	12.2%	10.5%	-1.7pt
Asia (excluding Japan)	36.9	40.3	3.4	9.3%	13.6%
% of revenue	4.6%	4.2%	-0.4pt
Latin America	30.8	30.1	-0.7	-2.3%	24.4%
% of revenue	3.8%	3.2%	-0.7pt
Russia/CIS	13.0	12.3	-0.7	-5.4%	-14.9%
% of revenue	1.6%	1.3%	-0.3pt
Other *4	16.9	17.0	0.0	0.3%	7.3%
% of revenue	2.1%	1.8%	-0.3pt

Of which royalty / service income *2	18.1	157.7	139.6	773.2%
*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.

1. Revenue by Region (continued)													Table of Contents
■ Quarterly	Reported *1
	FY20				FY21
(Bn JPY)	Q1	Q2	Q3	Q4	Q1	YOY	Q2	YOY	Q3	YOY	Q4	YOY
Total revenue	801.9	788.9	836.8	770.3	949.6	18.4%
Japan *2	144.0	138.3	152.7	124.6	259.0	79.8%
% of revenue	18.0%	17.5%	18.3%	16.2%	27.3%
United States	402.6	383.5	402.8	379.0	412.2	2.4%
% of revenue	50.2%	48.6%	48.1%	49.2%	43.4%
Europe and Canada	157.6	169.6	172.8	166.2	178.7	13.4%
% of revenue	19.6%	21.5%	20.7%	21.6%	18.8%
Growth and Emerging Markets *3	97.6	97.5	108.4	100.5	99.7	2.1%
% of revenue	12.2%	12.4%	13.0%	13.0%	10.5%
Asia (excluding Japan)	36.9	41.4	40.9	37.1	40.3	9.3%
% of revenue	4.6%	5.2%	4.9%	4.8%	4.2%
Latin America	30.8	28.2	36.4	26.2	30.1	-2.3%
% of revenue	3.8%	3.6%	4.4%	3.4%	3.2%
Russia/CIS	13.0	8.6	17.1	18.8	12.3	-5.4%
% of revenue	1.6%	1.1%	2.0%	2.4%	1.3%
Other *4	16.9	19.3	14.0	18.3	17.0	0.3%
% of revenue	2.1%	2.4%	1.7%	2.4%	1.8%

Of which royalty / service income *2	18.1	28.2	22.8	23.4	157.7	773.2%
*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