Price of bier in CR	18.9	Infltion in CR	"1,2% pa."
Price of bier in USA	0.92	"Inflation in USA 4,5% pa."	
ER	20.54347826		
..after one year			
E(ER)	19.89473684		
			
			
Yen/usd	80.12		
EUR/usd	0.991		
..thus Yen/eur			
Yen/eur	80.84762866		
##### Sheet/List 2 #####
T	8											
c	0.07											
ytm	0.04										110.3812891	
N	10000											
ytm_n	1%											
ytm_n	0.05										re	0.103812891
												
	years	1	2	3	4	5	6	7	8			0.09877045
	CF	700	700	700	700	700	700	700	10700			
		673.0769231	647.1893491	622.2974511	598.3629337	575.3489747	553.220168	531.9424692	7818.385194			110.3812891
	P	12019.82346										
												
	Macalay Duration	673.0769231	1294.378698	1866.892353	2393.451735	2876.744874	3319.321008	3723.597285	62547.08155			
	MD	78694.54442										
	MD	6.547063247										
	ModDuration	6.295253122	%									
	$Duration	756.6783118										
												
	Estimat of New Price	11263.14515										
												
	years	1	2	3	4	5	6	7	8			
	CF	700	700	700	700	700	700	700	10700			
		666.6666667	634.9206349	604.686319	575.8917324	548.4683165	522.3507776	497.4769311	7242.181174			
	P	11292.64255										
##### Sheet/List 3 #####
	0	1	2	3	4	5	6	7	8	9	10		
r1=10%	-2000	-3000	-4000	-1000	2000	3000	4000	5000	6000	7000	8000		25000
DCF	-2000	-2727.272727	-3305.785124	-751.3148009	1366.026911	1862.763969	2257.89572	2565.790591	2799.044281	2968.683329	3084.346315		
NPV1	8120.178464												
													
NPV2	-2000	-2400	-2560	-512	819.2	983.04	1048.576	1048.576	1006.63296	939.524096	858.9934592		
r2=25%	-767.4574848												
													
	0.237047329	0.23											
Proof	-2000	-2439.02439	-2643.928878	-537.3839184	873.7949892	1065.603645	1155.125903	1173.908438	1145.276525	1086.305647	1009.343226		
	-110.9788144												
											Final point		
				7	6	5	4	3	2	1	0		
wacc=14%	0	1	2	3									
_-CF	-2000	-3000	-4000	-1000									
	-2000	-2631.578947	-3077.870114	-674.9715162									
sum_-DCF	-8384.420577												
_+CF					2000	3000	4000	5000	6000	7000	8000		
					4389.945248	5776.243747	6755.84064	7407.72	7797.6	7980	8000		
sum_FV(+CF)	48107.34964												
													
	0.190896003