某上市药企集团自由现金流（FCFF）模板下载

作者：金贝财税更新时间：2022-03-03

某上市药企集团自由现金流（FCFF）模板，详细内容请点击下载完整版，表格内附有计算公式

	自由现金流（FCFF）
	2010A	2011A	2012A	2013A	2014E	2015E	2016E	2017E
净利润	926,343,505.56	1,210,907,807.69	1,582,515,843.41	2,321,453,787.17	2,121,117,127.62	2,591,077,628.80	3,164,712,680.15	3,525,779,778.18
有效税率	0.11	0.14	0.14	0.14	0.13	0.13	0.13	0.13
云南白药利息收入	28,290,592.42	23,453,426.96	16,915,215.30	19,774,485.25	34,908,949.30	42,702,492.91	52,235,972.07	57,981,929.00
云南白药利息支出	11,345,156.52	2,201,654.35	15,932,079.40	21,355,380.42	23,679,608.18	28,809,784.59	35,085,290.61	38,867,623.03
净利息支出	-16,945,435.90	-21,251,772.61	-983,135.90	1,580,895.17	-11,229,341.11	-13,892,708.32	-17,150,681.46	-19,114,305.96
税后净利息支出	-15,097,363.44	-18,290,353.63	-850,250.77	1,358,590.35	-9,745,087.62	-12,056,420.62	-14,883,766.71	-16,587,846.47
无杠杆净利润	911,246,142.12	1,192,617,454.06	1,581,665,592.64	2,322,812,377.52	2,111,372,040.01	2,579,021,208.18	3,149,828,913.44	3,509,191,931.71
递延税款	-15,413,425.62	-75,011.11	10,655,820.71	51,760,414.77	8,726,811.63	30,814,597.61	37,612,380.70	23,674,622.25
NOPAT	895,832,716.50	1,192,542,442.95	1,592,321,413.35	2,374,572,792.29	2,120,098,851.64	2,609,835,805.79	3,187,441,294.13	3,532,866,553.96
折旧	283,139,145.03	258,065,292.13	310,191,187.54	412,932,697.87	1,076,638,721.59	1,317,002,038.08	1,611,027,295.91	1,788,240,298.47
净运营资本	538,692,660.70	699,032,478.90	1,325,894,385.10	1,877,245,866.67	2,194,454,278.66	2,109,057,470.88	2,579,911,842.19	1,554,947,786.60
资本支出	3,307,388.45	1,186,852,717.66	518,930,483.40	461,441,361.59	1,525,271,195.00	1,718,688,277.95	2,102,391,377.45	2,090,486,525.63
自由现金流（FCFF）	636,971,812.38	-435,277,461.48	57,687,732.39	448,818,261.90	-522,987,900.43	99,092,095.04	116,165,370.41	1,675,672,540.19

			FCFF各项数据计算过程
递延所得税资产	68,010,398.48	67,935,387.37	78,591,208.08	130,351,622.85	139,078,434.48	169,893,032.09	207,505,412.79	231,180,035.03
递延税款（增量）	-15,413,425.62	-75,011.11	10,655,820.71	51,760,414.77	8,726,811.63	30,814,597.61	37,612,380.70	23,674,622.25

流动负债合计	3,030,573,331.77	3,341,670,658.74	3,455,488,327.43	3,659,357,880.12	5,347,167,625.92	6,536,621,151.62	7,991,624,288.84	8,868,574,373.23
流动资产合计	6,361,515,184.06	7,371,644,989.93	8,811,357,043.72	10,892,472,463.08	14,774,736,487.54	18,073,247,484.12	22,108,162,463.53	24,540,060,334.52
流动资产变动	1,379,111,181.98	1,010,129,805.87	1,439,712,053.79	2,081,115,419.36	3,882,264,024.46	3,298,510,996.59	4,034,914,979.41	2,431,897,870.99
流动负债变动	840,418,521.28	311,097,326.97	113,817,668.69	203,869,552.69	1,687,809,745.80	1,189,453,525.71	1,455,003,137.22	876,950,084.39
净运营资本	538,692,660.70	699,032,478.90	1,325,894,385.10	1,877,245,866.67	2,194,454,278.66	2,109,057,470.88	2,579,911,842.19	1,554,947,786.60

固定资产	236,586,837.99	1,033,185,052.11	1,251,589,383.64	1,269,767,136.49	1,696,389,847.32	2,075,114,745.10	2,538,391,285.54	2,817,614,326.95
累计折旧	283,139,145.03	258,065,292.13	310,191,187.54	412,932,697.87	1,076,638,721.59	1,317,002,038.08	1,611,027,295.91	1,788,240,298.47
折旧率	1.20	0.25	0.25	0.33	0.63
折旧增量	-14,061,110.84	-25,073,852.90	52,125,895.41	102,741,510.33	663,706,023.72	240,363,316.50	294,025,257.83	177,213,002.55

资本支出	3,307,388.45	1,186,852,717.66	518,930,483.40	461,441,361.59	1,525,271,195.00	1,718,688,277.95	2,102,391,377.45	2,090,486,525.63
固定资产增量	-21,010,551.87	796,598,214.12	218,404,331.53	18,177,752.85	426,622,710.83	378,724,897.77	463,276,540.44	279,223,041.41
折旧	283,139,145.03	258,065,292.13	310,191,187.54	412,932,697.87	1,076,638,721.59	1,317,002,038.08	1,611,027,295.91	1,788,240,298.47
长期资产	167,617,531.89	287,336,433.73	271,815,613.76	296,432,609.41	310,413,621.66	323,553,767.15	339,627,495.55	349,315,349.22
商誉	12,843,661.62	12,843,661.62	12,843,661.62	12,843,661.62	12,843,661.62	12,843,661.62	12,843,661.62	12,843,661.62
无形资产	119,594,963.51	244,338,401.04	228,971,952.14	223,165,380.31	238,712,436.97	238,712,436.97	238,712,436.97	238,712,436.97
长期股权投资	35,178,906.76	30,154,371.07	30,000,000.00	60,423,567.48	58,857,523.07	71,997,668.56	88,071,396.97	97,759,250.63
长期资产增量	-258,782,424.48	119,718,901.84	-15,520,819.97	24,616,995.65	13,981,012.25	13,140,145.49	16,073,728.40	9,687,853.67
长期待摊费用	4,906,052.20	17,415,142.00	10,670,616.73	10,528,747.65	16,833,744.95	20,591,936.71	25,189,157.76	27,959,965.12
长期无息负债
长期应付款	4,944,832.43	4,944,832.43	4,814,832.43	4,814,832.43	8,804,994.62	10,770,740.11	13,175,345.07	14,624,633.03

债务利息率	0.06	0.01	0.09	0.11	0.07
利息支出（利息费用）	11,345,156.52	2,201,654.35	15,932,079.40	21,355,380.42	23,679,608.18	28,809,784.59	35,085,290.61	38,867,623.03
总负债-无息负债	192,969,068.83	199,020,995.29	186,369,308.81	197,952,794.37	338,062,582.87	411,303,688.59	500,896,124.36	554,894,698.04
短期借款	10,000,000.00	10,000,000.00	10,000,000.00	10,000,000.00	10,000,000.00	10,000,000.00	10,000,000.00	10,000,000.00
一年内到期的非流动负债
长期借款	6,684,882.14	6,684,882.14	6,684,882.14	6,684,882.14	11,985,097.67	14,660,812.16	17,933,889.15	19,906,616.96
其他非流动负债	176,284,186.69	182,336,113.15	169,684,426.67	181,267,912.23	316,077,485.20	386,642,876.44	472,962,235.21	524,988,081.08

利息收入/（货币资金+交易性金融资产）	0.01	0.02	0.01	0.01	0.02
货币资金	1,994,960,614.35	1,142,709,549.94	1,728,332,161.40	2,082,951,549.60	2,315,015,977.41	2,831,851,297.29	3,464,071,889.02	3,845,119,796.81
交易性金融资产	0.00	519,683.25	0.00	149,758.72	0.00	0.00	0.00	0.00
利息收入	28,290,592.42	23,453,426.96	16,915,215.30	19,774,485.25	34,908,949.30	42,702,492.91	52,235,972.07	57,981,929.00