LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calulate interest for a loan as payments are received Laurie-Earl'sGirl Excel Discussion (Misc queries) 2 May 9th 07 04:28 AM
Template to calculate Compound Interest on Savings Graham Excel Discussion (Misc queries) 1 October 18th 06 01:26 PM
loan payments - Interest only? Steach91 Excel Discussion (Misc queries) 3 July 2nd 06 01:55 AM
Interest Only Loans & Payments James Excel Discussion (Misc queries) 2 October 17th 05 06:24 PM
Formula for calculating interest payments? Jack Shearer Excel Worksheet Functions 3 March 15th 05 06:17 AM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"