Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Jamie Lee and Ross, now 57 and still very active, have plenty of time on their hands now that the triplets are away at college.

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Jamie Lee and Ross, now 57 and still very active, have plenty of time on their hands now that the triplets are away at college. They both realized that time has just flown by; over twenty-four years have passed since they married! Looking back over the past years, they realized that they have worked hard in their careers, Jamie Lee as the proprietor of a cupcake caf and Ross, self-employed as a web-page designer. They have enjoyed raising their family and strived to be financially sound as they are looking to retirement that is just around the corner. They saved regularly and invested wisely over the years. They rebounded nicely from the economic crisis over the past few years, as they watched their investments closely and adjusted their strategies when they felt it necessary. They purchase vehicles with cash and do not carry credit card balances, choosing instead to use them for convenience only. The triplets are pursuing their master's degrees and have tuition covered through work/study programs at the university. Jamie Lee and Ross are just a few short years from realizing their goals of retiring at 65 and purchasing a home at the beach! They are reviewing their financial situation to ensure they will be ready for retirement. They anticipate being able to live comfortably with 80% of their current expenses. The rate of return on their investments until they retire is 5%. They expect this percentage to drop to 4% after retirement. Use this information, along with Exhibit 1-A. Exhibit 1-B, and the information provided below to determine the annual deposit amount Jamle Lee and Ross will need to make until they retire in order to make up the shortfall between their " 0 " for any unused and income needed during retirement. Each answer must have a value for the assignment to be complete. Enter " 0 " for any unused categories. Current Expense Amounts (Jamie Lee and Ross Combined) Fixed expenses: $4,500 per month Variable expenses: $2,400 per month Estimated Income Amounts (Jamie Lee and Ross Combined) Estimated Annual Retirement Living Expenses Estimated annual living expenses if retiring today Number of years until retirement Expected annual rate of return before retirement Future value (use Exhibit 1-A) Projected annual retirement living expenses, adjusted for inflation Estimated Annual Income at Retirement (A) Social Security income Company pension, personal retirement account income Investment and other income Total retirement income (B) Annual shortfall of income after retirement (A - B) (C) Expected years in retirement Expected annual rate of retum before retirement Expected annual rate of return on invested funds after retirement Future value factor for a series of deposits (use Exhibit 1-B) (D) Annual deposit required to accumulate the amount needed Prev 1 of 1 Next Exhibit 1-A Future Value (Compounded Sum) of $1 after a Given Number of Time Periods \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Period & 128 & 135 & 145 & 15s & 16s & 17v & 185 & 195 & 20s & 251 & 3ev \\ \hline 1 & 1.120 & 1.130 & 1.140 & 1.150 & 1.160 & 1.170 & 1.180 & 1.190 & 1.260 & 1.250 & 1.380 \\ \hline 2 & 1.254 & 1.277 & 1.368 & 1.323 & 1.346 & 1.369 & 1.392 & 1.416 & 1.440 & 1.563 & 1.690 \\ \hline 3 & 1.405 & 1.443 & 1.482 & 1.521 & 1.561 & 1.602 & 1.643 & 1.685 & 1.728 & 1.953 & 2.197 \\ \hline 4 & 1.574 & 1.630 & 1.689 & 1.749 & 1.811 & 1.874 & 1.939 & 2.005 & 2.074 & 2.441 & 2.856 \\ \hline 5 & 1.762 & 1.842 & 1.925 & 2.011 & 2.100 & 2.192 & 2.288 & 2.386 & 2.488 & 3.052 & 3.713 \\ \hline 6 & 1.974 & 2.082 & 2.195 & 2.313 & 2.436 & 2.565 & 2.700 & 2.840 & 2.986 & 3.815 & 4.827 \\ \hline 7 & 2.211 & 2.353 & 2.502 & 2.660 & 2.826 & 3.001 & 3.185 & 3.379 & 3.583 & 4.768 & 6.275 \\ \hline 8 & 2.476 & 2.658 & 2.853 & 3.059 & 3.278 & 3.511 & 3.759 & 4.021 & 4.360 & 5.960 & 8.157 \\ \hline 9 & 2.773 & 3.004 & 3.252 & 3.518 & 3.863 & 4.108 & 4.435 & 4.785 & 5.160 & 7.451 & 10.604 \\ \hline 10 & 3.106 & 3.395 & 3.707 & 4.046 & 4.411 & 4.807 & 5.234 & 5.695 & 6.192 & 9.313 & 13.786 \\ \hline 11 & 3.479 & 3.836 & 4.226 & 4.652 & 5.117 & 5.624 & 6.176 & 6.777 & 7,430 & 11.642 & 17.922 \\ \hline 12 & 3.896 & 4.335 & 4.818 & 5.350 & 5.936 & 6.580 & 7.288 & 8.664 & 8.916 & 14.552 & 23.298 \\ \hline 13 & 4.363 & 4.898 & 5.492 & 6.153 & 6.886 & 7.699 & 8.599 & 9.596 & 10.699 & 18.190 & 30.288 \\ \hline 14 & 4.887 & 5.535 & 6.261 & 7.076 & 7.988 & 9.007 & 10.147 & 11.420 & 12.839 & 22.737 & 39.374 \\ \hline 15 & 5.474 & 6.254 & 7.138 & 8.137 & 9.266 & 10.539 & 11.974 & 13.590 & 15.407 & 28.422 & 51.186 \\ \hline 16 & 6.130 & 7.067 & 8.137 & 9.358 & 10.748 & 12.330 & 14.129 & 16.172 & 18.488 & 35.527 & 66.542 \\ \hline 17 & 6.866 & 7.986 & 9.276 & 10.761 & 12.468 & 14.426 & 16.672 & 19.244 & 22.186 & 44.409 & 86.504 \\ \hline 18 & 7.698 & 9.624 & 10.575 & 12.375 & 14.463 & 16.879 & 19.673 & 22.901 & 26.623 & 55.511 & 112.455 \\ \hline 19 & 8.613 & 10.197 & 12.056 & 14.232 & 16.777 & 19.748 & 23.214 & 27.252 & 31.948 & 69.389 & 146.192 \\ \hline 20 & 9.646 & 11.523 & 13.743 & 16.367 & 19,461 & 23.106 & 27,393 & 32.429 & 38.338 & 86.736 & 190.05 \\ \hline 25 & 17.800 & 21.231 & 26.462 & 32.919 & 40.874 & 50.658 & 62.669 & 77.388 & 95.396 & 264.698 & 705.641 \\ \hline 30 & 29.960 & 39.116 & 50.950 & 66.212 & 85.850 & 111.065 & 143.371 & 184.675 & 237.376 & 807.794 & 2,619,996 \\ \hline 40 & 93.051 & 132.782 & 188.884 & 267.864 & 378.721 & 533.869 & 750.378 & 1,051.668 & 1,469.772 & 7,523,164 & 36,118.865 \\ \hline 50 & 289.002 & 450.736 & 700.233 & 1,283.657 & 1,670.704 & 2,566.215 & 3,927,357 & 5,988.914 & 9,100,438 & 70,064.923 & 497,929.223 \\ \hline \end{tabular} Exhibit 1-B Future Value (Compounded Sum) of \$1 Paid In at the End of Each Period for a Given Number of Time Periods (an Annuity) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Period & 15 & 24 & 31 & 45 & 54 & 65 & 75 & 83 & 91 & 101 & 115 \\ \hline 1 & 1. e & 1.603 & 1,008 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 & 1.000 \\ \hline 2 & 2.010 & 2.020 & 2.030 & 2.040 & 2.050 & 2.060 & 2.070 & 2.080 & 2.098 & 2.100 & 2.110 \\ \hline 3 & 3.030 & 3.060 & 3.091 & 3.122 & 3,153 & 3.184 & 3.215 & 3.246 & 3.278 & 3.310 & 3.342 \\ \hline 4 & 4.060 & 4,122 & 4.184 & 4.246 & 4.310 & 4,375 & 4.440 & 4.506 & 4.573 & 4.641 & 4.710 \\ \hline 5 & 5.101 & 5.204 & 5.309 & 5.416 & 5.526 & 5.637 & 5,751 & 5.867 & 5.985 & 6.105 & 6.228 \\ \hline 6 & 6.152 & 6.38B & 6,468 & 6.633 & 6.802 & 6.975 & 7.153 & 7.336 & 7.523 & 7,716 & 7.913 \\ \hline 7 & 7.214 & 7,434 & 7.662 & 7.898 & 8.142 & 8.394 & 8.654 & 8.923 & 9.200 & 9.487 & 9.783 \\ \hline 8 & 8.286 & 8.583 & 8.892 & 9.214 & 9.549 & 9.897 & 10.260 & 10.637 & 11.028 & 11.436 & 11.859 \\ \hline 9 & 9.369 & 9.755 & 10.159 & 10.583 & 11.027 & 11.491 & 11.978 & 12,488 & 13.021 & 13.579 & 14.164 \\ \hline 10 & 10.462 & 10.958 & 12,464 & 12.006 & 12.578 & 13.181 & 13.816 & 14.487 & 15.193 & 15.937 & 16.722 \\ \hline 11 & 11.567 & 12.169 & 12.808 & 13.486 & 14,207 & 14.972 & 15.784 & 16.645 & 17.568 & 18.531 & 19.561 \\ \hline 12 & 12.683 & 13.412 & 14+192 & 15.026 & 15.917 & 16.870 & 17.888 & 18.977 & 20.141 & 21.384 & 22.713 \\ \hline 13 & 13.869 & 14.680 & 15.618 & 16.627 & 17.713 & 18.882 & 20.141 & 21.495 & 22.953 & 24.523 & 26.212 \\ \hline 14 & 14,947 & 15.974 & 17+086 & 18.292 & 19.599 & 21.015 & 22.550 & 24.215 & 26.019 & 27.975 & 30.095 \\ \hline 15 & 16.897 & 17.293 & 18.599 & 20.024 & 22.579 & 23.276 & 25.129 & 27.152 & 29.361 & 31.772 & 34.405 \\ \hline 16 & 17.258 & 18.639 & 20.157 & 21.825 & 23.657 & 25.673 & 27.888 & 36.324 & 33.003 & 35.95e & 39.190 \\ \hline 17 & 18.430 & 20.012 & 21.762 & 23.698 & 25.846 & 28,213 & 30.840 & 33,756 & 36.974 & 40.545 & 44.591 \\ \hline 18 & 19.615 & 21.412 & 23.414 & 25.645 & 28.132 & 30.906 & 33,999 & 37.450 & 41.301 & 45.599 & 50.396 \\ \hline 19 & 20.811 & 22,841 & 25.117 & 27.672 & 30.539 & 33.760 & 37.379 & 41,446 & 46.018 & 51.159 & 56.939 \\ \hline 20 & 22.019 & 24.297 & 26.870 & 29.778 & 33.066 & 36.786 & 40.995 & 45.762 & 51.168 & 57.275 & 64.203 \\ \hline 25 & 28.243 & 32.030 & 36.459 & 41.646 & 47.727 & 54.865 & 63.249 & 73.186 & 84.701 & 98.347 & 114.413 \\ \hline 3 e & 34.785 & 40.568 & 47.575 & 56.085 & 66.439 & 79.058 & 94,461 & 113.283 & \( 1 3 \longdiv { 6 . 3 6 8 } \) & 164,494 & 199+821 \\ \hline 40 & 48.886 & 60.462 & 75.401 & 95.026 & 120.806 & 154.762 & \begin{tabular}{l} 199.635 \\ \end{tabular} & 259.057 & 337.882 & 442.593 & 581.826 \\ \hline 50 & 64,463 & 84.579 & 112.797 & 152.667 & 209.348 & 290.336 & 486.529 & 573.770 & 815.084 & 1,163,909 & 1,668,771 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Period & 120 & 13V & 141 & 151 & 165 & 17 & 183 & 191 & 201 & 250 & 30x \\ \hline21 & 1.000 & 1. eee & 1.000 & 1.000 & 1.000 & 1, evo & 1.000 & 1.000 & 1.00e & 1.000 & 1.000 \\ \hline 2 & 3.3742.170 & 3.4072.138 & 3.4402.140 & 3.4732.150 & 2.160 & 2.170 & 2.180 & 2.190 & 2.200 & 2.250 & 2.300 \\ \hline 3 & 4.7793.374 & 4.8503.407 & 4.9213.440 & 4.9933.473 & 5.0663.506 & 3.539 & 3.572 & 3.696 & 3.640 & 3.813 & 3.990 \\ \hline54 & 6.3534.739 & 6.4804.850 & 6.6104.921 & 6.7424.993 & 6.8775.066 & 7.0145.141 & 7.1545.215 & 7.2015.291 & 5.368 & 5.766 & 6.287 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations In Personal Finance

Authors: Dave Ramsey

1st Edition

0981683967, 978-0981683966

More Books

Students also viewed these Finance questions

Question

Explain global human resource management.

Answered: 1 week ago

Question

Describe the grievance procedure in a union environment.

Answered: 1 week ago

Question

Discuss whistleblower protection under OSHA.

Answered: 1 week ago