Date Principal Interest Formula Formula Formula Formula
1/4/1996 1000.00 .0725 =2*(3/4) =2^3 =2*(3+5) =B2*C2
1/4/1996 1000 0.0725 1.5 816 72.5
FV PV annual i n in years Factor
=B2*E2 5000 0.12 3 =(1+(C2/12))^(D2*12)
7,153.84$ 5,000.00$ 12% 31.430769
PV FV annual i n in years Factor
=B2*E2 50000 0.05 10 =(1+(C2/12))^(D2*12)
30,695.66$ 50,000.00$ 5% 10 0.613913
FV A annual i n in years Factor
=B2*E2 2000 0.08 20 =((1+C2)^(D2)-1)/C2
91,523.93$ 2,000.00$ 8% 20 45.76196
FV A annual i n in years Factor
=B2*E2 2000 0.08 20 =((((1+C2)^(D2+1))-1)/(C2))-1
PV A annual i n in years Factor
=B2*E2 60000 0.08 30 =(((1+C2)^(D2))-1)/((C2*(1+C2)^(D2)))
PV A annual i n in years Factor
=B2*E2 60000 0.08 30 =((((1+C2)^(D2-1))-1)/((C2*(1+C2)^(D2-1)))+1)