I have tried many times with functions pv(), fv(), etc to solve the following
problems but unable to get required result. I think that I am unable to
understand the financial functions properly. Could any one help me by giving
solution, please.

Problem 1:
Investment: Rs. 1000
Rate of Interest: 8.41% compounded yearly. Deposit doubles in 8 years 7
months.
Amount Payable, on a certificate of Rs. 1000
Term of Encashment Amount Payable
After 030 months 1170.51
After 036 months 1207.95
After 042 months 1267.19
After 048 months 1310.80
After 054 months 1355.90
After 060 months 1435.63
After 066 months 1488.49
After 072 months 1543.30
After 078 months 1649.13
After 084 months 1713.82
After 090 months 1781.06
After 096 months 1850.93
After 102 months 2000.00


Problem 2:
Investment: Rs. 10000
Rate of Interest: Interest 8% is compounded half-yearly and paid after the
maturity period of 6 years alongwith the principal. Rs. 1000 shall become Rs.
1601 on maturity.

Interest accrued each year on a certificate of Rs. 10,000 are as follows:

Financial year Amount Payable
2005-06 -
2006-07 816
2007-08 883
2008-09 955
2009-10 1033
2010-11 1117
2011-12 1208


I need a function which automatically show the maturity value of an
Investment:
a) Rs. 1000 pm for 20 years
b) Rs. 1000 pa for 20 years


In both cases I need a function/formula which automatically show the
maturity value of an Investment:
a) Rs. 1000 for 20 years
b) Rs. 1000 pm for 20 years
c) Rs. 1000 pa for 20 years

Regards