ericashweather
New Member
- Joined
- Jul 21, 2022
- Messages
- 1
- Office Version
- 365
- 2016
- Platform
- Windows
Hello ALL!!
Is there a way to use the data of an amount ($1, $100, $1000), a timeframe (1 year up to 40 years), and interest rate (1% to 10%). My intent is to create a table that shows the power of investing $1 with years on one axis and interest rate on another. My question is if this can be placed as a PivotTable. OR would anybody have a recommendation as to how to best display how one dollar (or 10 or 100) can grow by showing the ending balance if you invest one dollar for 1 year and up to 40 years, but spread over with the ending balances for each interest rate?
THANK YOU!!!
I tried studying hard the actual financial formula for this and could not get it functioning in a way to get what I am trying to get. What I did do so far is create a simple spreadsheet of the ten interest rates (mentioned above) at the top and the amount of years (1 year each over 40 years). Within each cell of this matrix/table/spreadsheet displayed is the ending balance of that interest rate per that length of years. I created the formulas for each year per interest rate of one dollar and display the compound interest accrued for that year and then underneath that the ending balance for that year. I have a second sheet with the rows of each compound interest earned for that year hidden. I will revisit this post and upload what I actually made.
My intent is to use the amount, duration, and interest rate, and turn that into a PivotTable. THANK YOU SO MUCH!!
Is there a way to use the data of an amount ($1, $100, $1000), a timeframe (1 year up to 40 years), and interest rate (1% to 10%). My intent is to create a table that shows the power of investing $1 with years on one axis and interest rate on another. My question is if this can be placed as a PivotTable. OR would anybody have a recommendation as to how to best display how one dollar (or 10 or 100) can grow by showing the ending balance if you invest one dollar for 1 year and up to 40 years, but spread over with the ending balances for each interest rate?
THANK YOU!!!
I tried studying hard the actual financial formula for this and could not get it functioning in a way to get what I am trying to get. What I did do so far is create a simple spreadsheet of the ten interest rates (mentioned above) at the top and the amount of years (1 year each over 40 years). Within each cell of this matrix/table/spreadsheet displayed is the ending balance of that interest rate per that length of years. I created the formulas for each year per interest rate of one dollar and display the compound interest accrued for that year and then underneath that the ending balance for that year. I have a second sheet with the rows of each compound interest earned for that year hidden. I will revisit this post and upload what I actually made.
My intent is to use the amount, duration, and interest rate, and turn that into a PivotTable. THANK YOU SO MUCH!!
