Chapter 6, Problem 57QP

Summary Introduction

To calculate: The monthly savings of Person BB.

Introduction:

The series of payments that are made at equal intervals is an annuity payment. The amount of annuity payments is mainly calculated based on the particular situation.

Answer to Problem 57QP

The monthly savings of Person BB is $3,710.16418.

Explanation of Solution

Given information:

Person BB wishes to save money to fulfill his three objectives. They are as follows:

• The first objective of Person BB is to retire at thirty years from present with a retirement amount of $24,000 for a month for every 25 years, the first payment will be expected at thirty years and a month from present.
• The second objective of Person BB is to buy a cabin in the Place R within ten years at a projected cost of $340,000.
• The third objective of Person BB is to leave an inheritance of $1,500,000 to Person F after he passes on and at the last of the 25 years of withdrawal.

Person BB can afford to save $2,500 for a month for the next ten years if he can earn the effective annual cost of 7% after his retirement and 10% before his retirement.

Note: The cash flows from the given information takes place on a monthly basis, the given interest rate is an effective annual rate. As the cash flows take place on a monthly basis, it is essential to compute the effective monthly rate by finding the annual percentage rate through monthly compounding, and then dividing it by 12. The preretirement annual percentage rate is calculated as follows:

Formula to calculate the effective annual rate:

$\text{Effective annual rate}=\left(1+{\left(\frac{\text{APR}}{12}\right)}^{12}-1\right)$

Compute the effective annual rate:

$\begin{array}{c}\text{Effective annual rate}=\left(1+{\left(\frac{\text{APR}}{12}\right)}^{12}-1\right)\\ 0.10=\left(1+{\left(\frac{\text{APR}}{12}\right)}^{12}-1\right)\end{array}$

Compute the annual percentage rate with the effective annual rate:

$\begin{array}{c}\text{Annual percentage rate}=12\left({\left(1+\text{EAR}\right)}^{\frac{1}{12}}-1\right)\\ =12\left({\left(1+0.10\right)}^{0.083333333}-1\right)\\ =12\left(1.00797414-1\right)\\ =0.095689685\end{array}$

Hence, the annual percentage rate is 0.0957 or 9.57%.

The annual percentage rate for the post-retirement is calculated as follows:

Formula to calculate the effective annual rate:

$\text{Effective annual rate}=\left(1+{\left(\frac{\text{APR}}{12}\right)}^{12}-1\right)$

Compute the effective annual rate:

$\begin{array}{c}\text{Effective annual rate}=\left(1+{\left(\frac{\text{APR}}{12}\right)}^{12}-1\right)\\ 0.07=\left(1+{\left(\frac{\text{APR}}{12}\right)}^{12}-1\right)\end{array}$

Compute the annual percentage rate with the effective annual rate:

$\begin{array}{c}\text{Annual percentage rate}=12\left({\left(1+\text{EAR}\right)}^{\frac{1}{12}}-1\right)\\ =12\left({\left(1+0.07\right)}^{0.083333333}-1\right)\\ =12\left(1.005654145-1\right)\\ =0.067849744\end{array}$

Hence, the annual percentage rate is 0.067 or 6.78%.

First, it is essential to compute the retirement needs of Person BB. The amount that is essential for retirement is the present value of the monthly spending plus the inheritance’s present value. The present value of the two cash flows is as follows:

Formula to calculate the present value annuity:

$\text{Present value annuity}=C\left\{\frac{\left[1-\left(\frac{1}{1+r^t}\right)\right]}{r}\right\}$

Note: C denotes the payments, r denotes the rate of exchange, and t denotes the period.

Compute the present value annuity for without fee:

$\begin{array}{c}\text{Present value annuity}=C\left\{\frac{\left[1-\left(\frac{1}{{\left(1+r\right)}^t}\right)\right]}{r}\right\}\\ =\$24,000\left\{\frac{\left[1-\left(\frac{1}{{\left(1+\frac{0.067849744}{12}\right)}^{12\left(25\right)}}\right)\right]}{\frac{0.067849744}{12}}\right\}\\ =\$24,000\left\{\frac{\left[1-\left(\frac{1}{{\left(1.005654145\right)}^{300}}\right)\right]}{\frac{0.067849744}{12}}\right\}\\ =\$24,000\left\{\frac{\left[1-0.18424918\right]}{0.005654145333}\right\}\end{array}$

$=\$3,462,595.764$

Formula to calculate the present value:

$\text{Present value}=\frac{\text{Cash flow}}{{\left(1+\text{r}\right)}^{\text{t}}}$

Compute the present value:

$\begin{array}{c}\text{Present value}=\frac{\text{Cash flow}}{{\left(1+\text{r}\right)}^{\text{t}}}\\ =\frac{\$1,500,000}{{\left(1+\frac{0.067849744}{12}\right)}^{12\left(25\right)}}\\ =\frac{\$1,500,000}{{\left(1.005654145\right)}^{300}}\\ =\$276,373.7982\end{array}$

Hence, the present value is $276,373.7982.

Person BB will be saving $2,500 for a month for the upcoming ten years until he buys the cabin. The value of his savings after ten years is calculated as follows:

Formula to calculate the future value annuity:

$\text{Future value annuity}=C\left\{\frac{\left[{\left(1+r\right)}^t-1\right]}{r}\right\}$

Note: C denotes the annual cash flow or the annuity payment, r denotes the rate of interest, and t denotes the number of payments.

Compute the future value annuity of Person BB:

$\begin{array}{c}\text{Future value annuity}=C\left\{\frac{\left[{\left(1+r\right)}^t-1\right]}{r}\right\}\\ =\$2,500\left\{\frac{\left[{\left(1+\frac{0.095689685}{12}\right)}^{12\left(10\right)}-1\right]}{\frac{0.095689685}{12}}\right\}\\ =\$2,500\left\{\frac{\left[{\left(1+0.007974140417\right)}^{120}-1\right]}{0.007974140417}\right\}\\ =\$2,500\left\{\frac{\left[2.593742328-1\right]}{0.007974140417}\right\}\end{array}$

$\begin{array}{c}=\$2,500\left\{199.8638404\right\}\\ =\$499,659.64\end{array}$

Hence, the future value of the annuity is $499,659.64.

The amount that remains in the hands of Person BB after the purchase of the cabin is as follows:

$\$499,659.64-\$340,000=\$159,659.64$

Note: The amount that remains in the hands of Person BB is calculated by subtracting the cost of the cabin from the calculated future value of the annuity.

Hence, the amount that Person BB has in his hands is $159,659.64.

Person BB still has twenty years until retirement and at the time when he is ready to retire, the amount he would receive is as follows:

Formula to compute the future value:

$\text{Future value}=\text{PV}{\left(1+\text{r}\right)}^{\text{t}}$

Note: C denotes the annual cash flow or the annuity payment, r denotes the rate of interest, and t denotes the number of payments.

Compute the future value:

$\begin{array}{c}\text{Future value}=\text{PV}{\left(1+\text{r}\right)}^{\text{t}}\\ =\$159,659.64{\left(1+\frac{0.957}{12}\right)}^{12\left(20\right)}\\ =\$159,659.64{\left(1+0.007974140417\right)}^{240}\\ =\$159,659.64\left(6.727499935\right)\end{array}$

$=\$1,074,110.218$

Hence, the future value is $1,074,110.218.

Thus, when Person BB is ready for the retirement based on his present savings, he will be short of the below amount:

$\$3,738,969.5622-\$1,074,110.218=\$2,664,859.34$

Thus, the above calculated amount is the future value of the monthly savings that Person BB has to make between ten to thirty years.

Hence, the future value of an annuity of Person BB is $2,664,859.344.

Compute the monthly savings of Person BB using the formulae of the future value of an annuity:

$\begin{array}{c}\text{Future value annuity}=C\left\{\frac{\left[{\left(1+r\right)}^t-1\right]}{r}\right\}\\ \$2,664,859.344=C\left\{\frac{\left[{\left(1+\frac{0.095689685}{12}\right)}^{12\left(20\right)}-1\right]}{\frac{0.095689685}{12}}\right\}\\ \$2,664,859.344=C\left\{\frac{\left[{\left(1+0.007974140417\right)}^{240}-1\right]}{0.007974140417}\right\}\\ \$2,664,859.344=C\left\{\frac{5.727499262}{0.007974140417}\right\}\end{array}$

$\begin{array}{c}C=\frac{\$2,664,859.344}{718.259143}\\ =\$3,710.16418\end{array}$

Hence, the monthly savings of Person BB is $3,710.16418.