View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bonjella bonjella is offline
external usenet poster
 
Posts: 1
Default Savings with interest and regular payments

Hello,

I have searched the internet for help with this, but anything relivent
seems geared towards paying off loans rather than saving so my answers
are coming out negitive, or just wrong.

Hopefully there is an easier way of doing this.

I am trying to save up a deposite for my first home... and I want to
know how long it'll take me.

I have a starting balance, the annual interest rate of my savings
account, and how much I can save each month. I also have a target
ammount in mind.

From this I want to know how many Months I will have to save this

before my Target is met.

On a seporate issue I want to know, if I want to buy a home in 2 years
time, how much I'll have saved by then, but I think this is possible
using NPER, again it's currently coming out 'backwards' and it's still
needs a target ammount.

I hope you can point me in the right direction :-)

many thanks,

Amy