The fundamental equation of finance:
ROW/COL	B	C	D	E	F	G	H	I
5
6
7		The compound amount equation is:
8		V = P *(1+ i)^t
9
10
11
12
13	This equation can also be stated as follows.
14		ln(V )= ln(P)+t*ln(1+ i)
15
16
17
18
19
20		I =	10.00%
21		P =	$100.00
22		t =	10
23
24		ln(v)=	5.558272	<=LN(D21)+D22*(LN(1+D20))
25
26		V =	$259.37	<=EXP(D24)
27
28		Using the FV function	$259.37	<=FV(D20,D22,0,D21)*-1
29
30		An alternative would be:
31
32
33		ln($1.00 )=t*ln(1+ i)
34
35
36
37
38
39		I =	10.00%
40		P =	$1.00
41		t =	10
42
43		ln(1)=	0.9531018	<=D41*(LN(1+D39))
44		FV Factor	2.5937425	<=EXP(D43)
45
46		For	$100
47		V=	$259.37	<=+D44*100
48
49
50		Another alternative for annual compounding would be:
51
52
53		V=P*exp(t*ln(1+ i))
54
55
56
57
58		I =	10.00%
59		P =	$100.00
60		t =	10
61
62		V=	$259.37	<=+D59*EXP(D60*(LN(1+D58)))
63
64		For continuous compounding the formula would be:
65
66		V=P*exp(t*i)
67
68
69
70
71		I  (continuously) =	10.00%
72		P =	$100.00
73		t =	10
74
75		V=	$271.83	<=+D72*EXP(D73*D71)
76
77
78		Note the difference of	$12.45	<=+D75-D62
79		is caused by the frequency of compounding
80
81
82
83
84