How do I recreate a spreadsheet using a given formula?

EmilyBenson98

New Member
Joined
Aug 30, 2017
Messages
2
Accumulated Capital
Age 6% Growth 11% Growth
18 $10,000.00 $10,000.00
28 $17,908.00 $28,394.00
38 $32,071.00 $80,623.00
48 $57,435.00 $228,923.00
58 $102,857.00 $650,009.00

The Growth amount for an investment is found using the equation: F=P(1+i)^N where F is the future value, P is the initial investment amount, i is the annual interest rate and N is the number of years that the funds remain invested.

Question: how do I recreate this spreadsheet using the given formula and what numbers represent the given variables F, P, i and N?
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Emily,
My spreadsheet looks like this:
[TABLE="width: 448"]
<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="class: xl63, width: 64, align: right"]6%[/TD]
[TD="class: xl63, width: 64, align: right"]11%[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]6%
[/TD]
[TD="width: 64"] 11%
[/TD]
[/TR]
[TR]
[TD="align: right"]18
[/TD]
[TD="align: right"]0
[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]10000[/TD]
[TD][/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]10000[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]17908[/TD]
[TD="align: right"]28394[/TD]
[TD][/TD]
[TD="align: right"]17908.48[/TD]
[TD="align: right"]28394.21[/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]32071[/TD]
[TD="align: right"]80623[/TD]
[TD][/TD]
[TD="align: right"]32071.35[/TD]
[TD="align: right"]80623.12[/TD]
[/TR]
[TR]
[TD="align: right"]48[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]57435[/TD]
[TD="align: right"]228923[/TD]
[TD][/TD]
[TD="align: right"]57434.91[/TD]
[TD="align: right"]228923[/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]102857[/TD]
[TD="align: right"]650009[/TD]
[TD][/TD]
[TD="align: right"]102857.2[/TD]
[TD="align: right"]650008.7[/TD]
[/TR]
</tbody>[/TABLE]

I've inserted a column into your data the cell B2 holds the formula = A2 - $A2 and this is copied down so that I have increments of 10.

In cell F2 I have this which is then dragged down:
=C$2*POWER((1+C$1),B2)
In G2 I have:
=D$2*POWER((1+D$1),B2)

I could eliminate Column B and use this formula:=C$2*POWER((1+C$1),A2-$A$2) and then =D$2*POWER((1+D$1),A2-$A$2) for the 11%.

Note that my results are note Integers so you should employ INT if you must go there.
 
Upvote 0
I missed the some of your question. P is the initial Principal ($10000), i is the interest rate being either 6 or 11%, and N is the Number of years for the length of the investment.
If the period is 0, then wwe start with age 18 -18. At Age 28 the investment would be 28 -18 and so 10 (the value of N). F is the value generated as you proceed down the columns.
 
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,314
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top