How calculate return of investment if i deposit every month

[Akatecho]

Dear All,

I have some question about financial, i would to find the return from deposit every month.

If I deposit or investment every month start Jan to Dec at initial of month equal 25,000.

and Annual interest rate = 9.5%

and number of month that i deposit is 12 months.

then how can i calculate return that i will get at the end of year.

Best regards,

Compound Interest.xlsx

[MarvinP]

Hi Akatecho,

It seems to me the 9.5 annual is really 9.5/12 monthly. You simply do each month separately and see what happens at the end. I may be one month off as the interest might not be paid until the end of the month instead of the first. See the attached.

[MrShorty]

I'm not familiar with the financial functions, but you might also look at the FV() and related functions: https://support.office.com/en-us/art...rs=en-US&ad=US

[kvsrinivasamurthy]

Pl see file
Use
=-FV(B2/12,B3,B1,0,1)