Excel Help Please

[ACB312]

I'm looking for a formula/function in Excel where I can enter a cash value, an interest rate and a time period and the formula will return what the total value of the cash is now. Say �10 per month over 18 months at 4.6%. I've tried Excel help but am getting confused with the American terms used. I'm just trying to compare my rate of return on Premium Bonds against a deposit account to see if I'm up or down on the deal. Thanks in advance for any help.

[Buenchico]

If your requirements really are as simple as you state, I suggest that you forget about spending time with Excel and simply use an online calculator, like the one here:
http://www.moneymatterstome.co.uk/Interactive- Tools/GeneralInterestCalculator.htm
(Don't bother with the sliders, just amend the specimen figures as you would when word processing. Your answer appears instantly, without even having to click a button).

Chris

[ACB312]

Fits the bill exactly. Thank you Chris.

[Gandy]

It's pretty straightforward in Excel too. Click to open a new workbook and then click use template. Under "spreadsheet solutions" click " Loan Amoritization". This will open a workbook - simply fill in the blanks