entering different estimates. The closer you can estimate the answer, the more likely that the Solver will find a solution.
Case 4: The calculator displays:
The Solver is unable to find a solution. Check your equation to make sure you have made no errors in entering it. Also check the value of each known variable. If your equation and variables are correct, you might be able to find a solution by entering very good guesses.
Equations Used by
Actuarial Functions
n＝number of compounding periods.
i%＝periodic interest rate, expressed as a percentage.
Single Payment Present Value Function
(Present value of a single $1.00 payment made after n periods.)
|
| i% －n | |
SPPV (i% : n) ＝ 1 | ＋ |
| |
| |||
|
| 100 | |
Single Payment Future Value Function
(Future value after n periods of a single $1.00 payment.)
|
| i% n | |
SPFV (i% : n) ＝ 1 | ＋ |
| |
| |||
|
| 100 | |
Uniform Series Present Value Function
(Present value of a $1.00 payment that occurs n times.)
|
| |
| i% －n | ||
1 － | 1 ＋ |
|
| | ||
|
| |||||
USPV (i% : n) ＝ |
| | 100 | |||
|
| i% |
|
|
| |
|
|
|
|
|
| |
|
|
| 100 |
|
|
|
Uniform Series Future Value Function
(Future value of a $1.00 payment that occurs n times.)
246 B: More About Calculations
File name :