LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How do I calculate interest?

I want to create a spreadsheet that shows my kids the power of
compounded interest. I want to show them what regular deposits
against a specific monthly interest rate results in, at the end of the
year. I want to have the interest rate in cell A1 and starting in row
5, in column A I have the date of deposit and in column B I have the
deposited amount. Then I want to have a total that calculates the
updated balance including the compounded interest rate each month.

Any suggestions? TIA!
Robert
 
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
how to calculate interest on payments Bob L Excel Discussion (Misc queries) 2 December 5th 09 02:53 AM
How do you calculate an interest only loan Richard[_10_] Excel Discussion (Misc queries) 2 April 26th 09 07:40 AM
Calculate Daily Interest SWBookkeeper Excel Discussion (Misc queries) 1 April 9th 08 08:16 PM
How to calculate Compound Interest Nikhil Excel Worksheet Functions 3 September 19th 07 03:52 PM
calculate interest between two dates Arvind Khanna via OfficeKB.com Excel Worksheet Functions 1 June 1st 05 01:18 PM


All times are GMT +1. The time now is 11:57 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"