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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
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,214
Messages
6,170,771
Members
452,353
Latest member
strainu

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