ANNUITY				GROWING ANNUITY	
Interest rate	0.02			Interest rate	0.02
				Growth rate	0.01
					
Period	Cash flow			Period	Cash flow
1	1000			1	1000
2	1000			2	1010
3	1000			3	1020.1
4	1000			4	1030.301
5	1000			5	1040.60401
					
PV CLASSICAL FORMULA	4713.459509			PV CLASSICAL FORMULA	4806.781618
PV ANNUITY FORMULA	4713.459509			PV ANNUITY FORMULA	4806.781618
					
					
					
					
PERPETUITY					
Interest rate	0.2				
					
					
Period	Cash flow	PV	PV perpetuity		
1	1000	833.3333333	5000		
2	1000	1527.777778	5000		
3	1000	2106.481481	5000		
4	1000	2588.734568	5000		
5	1000	2990.61214	5000		
6	1000	3325.510117	5000		
7	1000	3604.591764	5000		
8	1000	3837.159803	5000		
9	1000	4030.966503	5000		
10	1000	4192.472086	5000		
11	1000	4327.060071	5000		
12	1000	4439.216726	5000		
13	1000	4532.680605	5000		
14	1000	4610.567171	5000		
15	1000	4675.472642	5000		
					
					
					
					
GROWING PERPETUITY					
Interest rate	0.2				
Growth rate	0.01				
					
Period	Cash flow	PV	PV grow. perpetuity		
1	1000	833.3333333	5263.157895		
2	1010	1534.722222	5263.157895		
3	1020.1	2125.05787	5263.157895		
4	1030.301	2621.923708	5263.157895		
5	1040.60401	3040.119121	5263.157895		
6	1051.01005	3392.10026	5263.157895		
7	1061.520151	3688.351052	5263.157895		
8	1072.135352	3937.695469	5263.157895		
9	1082.856706	4147.560353	5263.157895		
10	1093.685273	4324.19663	5263.157895		
11	1104.622125	4472.865497	5263.157895		
12	1115.668347	4597.995127	5263.157895		
13	1126.82503	4703.312565	5263.157895		
14	1138.09328	4791.954742	5263.157895		
15	1149.474213	4866.561908	5263.157895		
##### Sheet/List 2 #####
Period	Cash flows			Discount rates for NPV profile	NPV		
0	-10000			0			
1	3500			0.01			
2	4000			0.02			
3	4500			0.03			
				0.04			
Interest rate	0.05			0.05			
				0.06			
NPV				0.07			
				0.08			
				0.09			
				0.1			
				0.11			
				0.12			
							
							
							
							
							
							
							
							
							
							
							
##### Sheet/List 3 #####
Loan	Interest rate	N. of Periods		Payment	Total payment	Total interests	
10000	0.05	1					
		2					
		3					
		4					
		5					
		6					
		7					
		8					
		9					
		10