Ilustrative example													
													
	0	1	2	3	4								
	-12000	3000	5000	4000	2000			0	1	2	3	4	
0.06	-12000	2830.188679	4449.9822	3358.477132	1584.187326		0.07	-12000	3000	5000	4000	2000	
	222.8353379							-12000	2803.738318	4367.193641	3265.191508	1525.790424	
								-38.08610922					
cumCF	-12000	-9169.811321	-4719.829121	-1361.351989	222.8353379								
													
						0.14066224	50.6384064						
													
								0	1	2	3	4	
							0.068515	-12000	3000	5000	4000	2000	
							0.068540323	-12000	2807.634895	4379.340947	3278.824123	1534.29017	
								0.090135266					
													0.064887046
													
							3	2	1	0			
							3573.048	5618	4240	2000	15431.048		
##### Sheet/List 2 #####
Example from slides																
																
Project A		0	1	2	3	4	5				Project B	0	1	2	3	
		-90000				-30000					(-CF)	-10000	-2000	-2000	-2000	
			10000	17000	34000	41000	38000					-10000	-1890.00189	-1786.053572	-1687.822313	
		-90000	10000	17000	34000	11000	38000				(+CF)					
	DCF	-90000	9450.00945	15181.45536	28692.97933	8772.465247	28638.14018				0.3	2000	3000	7000		
	NPV	735.0495728										600	900	2100		
WACC	0.0582										0.5	4000	6000	9000		
												2000	3000	4500		
Paypack Period		-90000	-80549.99055	-65368.53519	-36675.55586	-27903.09061	735.0495728				0.2	5000	7000	10000		
4years+10days								0.025666805	9.240049965			1000	1400	2000		
																
												3600	5300	8600		
IRR												3402.003402	4733.041966	7257.635948		
	r_2	0.065														
	DCF	-90000	9389.671362	14988.20781	28146.86912	8550.554	27735.47179									
	NPV_2	-1189.225922										-10000	1512.001512	2946.988394	5569.813634	
											NPV	28.8035404				
irr	0.060797516															
		0	1	2	3	4	5				PB	-10000	-8487.998488	-5541.010094	28.8035404	0.005171365
MIRR			4	3	2	1	0				2years+ 2days					1.861691472
		-90000				-30000										
			10000	17000	34000	41000	38000									
											IRR					
use WACC	D(-CF)	-90000	0	0	0	-23924.90522	0									
		-113924.9052									r_2	0.059				
												-10000	1427.763467	2627.764888	4689.783384	
	FV(+CF)		12539.23463	20144.30058	38072.76616	43386.2	38000				NPV_2	-1254.68826				
		152142.5014														
											IRR	0.058217953				
																
MIRR	0.059562002												2	1	0	
											MIRR	0	1	2	3	
											(-CF)	-10000	-2000	-2000	-2000	
												-10000	-1890.00189	-1786.053572	-1687.822313	
												-15363.87778				
											(+CF)		3600	5300	8600	
													4031.234064	5608.46	8600	
												18239.69406				
																
											MIRR	0.058860877