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?
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?