The Retirement Analysis Kit Help File

Account Distributions and Loans

Account Distributions and Loans

Previous topic Next topic  

Account Distributions and Loans

Previous topic Next topic  

Account Distributions can calculate any of the following items for an account:

1.Current Account Value

2.Amount of each Distribution

3.Number of Years

4.Rate of Return

5.Final Account Value

Simply enter the known values, place the cursor on the editor listed above to be calculated, and click on the 'Calculate Cursor Line' button found below the data input(Interst Calculator Cursor Line, or press Control-F10) .

Notes: After calculating a prompt, it will be highlighted with a red background. While a prompt is highlighted, changing the value in any other prompt (except the Calculation Type) will update the calculated prompt.

 If the value in the calculated prompt (highlighted) is modified, it will no longer be calculated.

The Loan calculator uses the same calculations as the Account Distribution calculator but uses different terminology in prompts and reports. For example, for distributions the first prompt is 'Current Account Value', for loans it is 'Loan Value'.

Prompts in the Interest Calculator's Future Value Calculator

Note:Prompts shown below with an asterisk beside them may be calculated.

Type of Fund

For future value calculations, select either Account Distributions or Loan.

Current Account Value/Loan Value*

Enter the current account balance (or loan value).

Type of Distribution/Type of Payment

If the distributions or payments increase annually, select the method that they change by.

# of Distributions per Year/# of Payments per Year*

Enter the number of distributions or payments per year.

Amount of Each Deposit*

Enter the initial value of the deposit. If a Type of Distribution/Type of Payment method was selected other than 'Level...' then the deposits will increase after the first year.

Distributions Made at/Payments Made at

Select whether deposits are made at the beginning or end of a period. For example, on a 12 pay, select whether the distributions/payments are made at the beginning or end of the month.

Interest Rate*

Enter the effective annual interest rate.

Note:Interest rates may be changed in future years after a calculation is made by editing the values displayed in the grid.

 The interest rate can not exceed 12.0000%.

Final Account Value/Balloon Payment*

Enter the hypothetical account value at the end of the term.

Calculating the Unknown Value

After entering values for each of the known prompts, place the cursor on the prompt to be calculated and click on the Interst Calculator Cursor Line button.