How do I recreate a spreadsheet using a given formula?

[EmilyBenson98]

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?

 

[BrianJN1]

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.

 

[BrianJN1]

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.