Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brett
 
Posts: n/a
Default How to create compounded int table?

I a table that shows interest compounding for a savings account. A
variable amount of money will be taken out each month and that should
be taken into consideration. As well as a variable amount possibly
being deposited.

The table needs these initial values:
- Current balance (say $10,000)
- Interest rate
- Number of months to calculate

Then I need a way to enter variations in monthly withdrawals. Similar
to amortizing except I need to enter the payments manually and have the
table recalculate once I tab out of that month's payment box. Or, I
could enter the payments initially as well. Deposits should be handled
the same way. Payments or deposits could be $0.00 for any month.

Thanks,
Brett

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brett
 
Posts: n/a
Default How to create compounded int table?

I actually just created a table that contains each month. Not the most
dynamic way but does what I need it to.

Reply
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
Create pivot table from 2 worksheets MichaelKoh Excel Discussion (Misc queries) 1 November 1st 05 06:00 PM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
How do I create a one variable data table? prelll91 Excel Discussion (Misc queries) 0 February 27th 05 07:47 PM
Is it possible to create a table inside of a cell? Jose Excel Discussion (Misc queries) 1 January 21st 05 06:47 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM


All times are GMT +1. The time now is 07:19 AM.

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"