Question 621973
  <pre><font face = "Tohoma" size = 3 color = "indigo"><b> 
Hi,
Excel columns A thru H, based on A = P(1 + r)^t	  or A/(1+r)^t = P			
		B*12	C*A		                E^B	  D/F	        G/.9
4369.66	30	360	$1,573,077.60	1.10	17.4494	$90,150.80	$100,167.56
1626.83	15	180	$292,829.40	1.10	4.1772	$70,101.03	$77,890.03
3724.21	30	360	$1,340,715.60	1.08	10.0627	$133,236.74	$148,040.82
4469.19	15	180	$804,454.20	1.14	7.1379	$112,701.20	$125,223.56