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:

		6%	11%		6%	11%
18	0	10000	10000		10000	10000
28	10	17908	28394		17908.48	28394.21
38	20	32071	80623		32071.35	80623.12
48	30	57435	228923		57434.91	228923
58	40	102857	650009		102857.2	650008.7

<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody>
</tbody>

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.