The Retirement Analysis Kit Help File

Lump Sum Required

Lump Sum Required

Previous topic Next topic  

Lump Sum Required

Previous topic Next topic  

Example #1

What is the lump sum deposit required today for an account to grow to $1,000,000 in 25 years, growing at 7% with no additional deposits.

Data Entry

Use the following values for the prompts:


Prompt

Value


Type of Fund

Future Value


Current Account Value

Do not enter value


Type of Deposits

Level Deposits


# of Deposits/Year

1


Amount of Each Deposit

0


Deposits Made at

End of Period


Interest Rate

7


# of Years

25


Future Value

1000000

Place the cursor on the Current Account Value prompt and click on the 'Calculate Cursor Line' button.

Result

The current account balance is 184,249.18

Example #2

If the interest rate was 8%, how much would the lump sum deposit be?

Data Entry

Enter '8' for the rate of return and press tab.

Result

The present value re-calculates to $146,017.88

Example #3

What is the lump sum deposit required today if the client were to deposit $250 per month, increasing by 3% per year?

Data Entry

Change the following prompts to the values shown:


Prompt

Type of Deposits

Value

Annual Increase by a %


# of Deposits/Year

12


Amount of Each Deposit

250


Annual Increase in Deposit

3

Results

The lump sum deposit recalculates to $102,577.01