Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Inge Company considered the following alternatives for establishing a fund for college expenses, to be provided as a benefit for the children of their
The Inge Company considered the following alternatives for establishing a fund for college expenses, to be provided as a benefit for the children of their employees. The funds assets are to be available on December 31, 2028. 1. An amount of $100,000 to be deposited on January 2, 2018, at an expected annual rate of return of 8%. 2. An amount of $15,000 to be deposited every January 2nd, beginning on January 2, 2018, at an expected annual rate of return of 6%. 3. Beginning on December 31, 2018, an amount of $14,890 to be deposited on every December 31s through December 31, 2028, at an expected annual rate of return of 7%. Using the accompanying future and present value tables, prepare the schedule that The Inge Company would prepare relating to these financing alternatives. Present Value of $1 6 270496 6.0% 7.0% 8.09 9.0% 10.0% 11.0% 12.0% 20.0% 1 0.94340 0.93458 0.92393 0.91743 0.90909 0.90090 0.89286 0.83333 2 0.89000 0.87344 0.85734 0.84168 0.82645 0.81162 0.79719 0.69444 3 0.83962 0.81630 0.79383 0.77218 0.75131 0.73119 0.71178 0.57870 4 0.79209 0.76290 0.73503 0.70843 0.68301 0.65873 0.63552 0.48225 5 0.74726 0.71299 0.68058 0.64993 0.62092 0.59345 0.56743 0.40188 0.66634 0.63017 0.59627 0.56447 0.53454 0.50663 0.33490 7 0.66506 0.62275 0.58349 0.54703 0.51316 0.48166 0.45225 0.27908 8 0.62741 0.58201 0.54027 0.50187 0.46651 0.43393 0.40388 0.23257 9 0.59190 0.54393 0.50025 0.46063 0.42410 0.39092 0.36061 -0.19381 10 0.55839 0.50835 0.46319 0.42241 0.38554 0.35218 0.32197 0.16151 1 0.52679 0.47509 0.42888 0.38753 0.35049 0.31728 0.25748 0.13459 12 0.49697 0.44401 0.39711 0.35553 0.31863 0.28584 0.25668 0.11216 0.46884 0.41496 0.36770 0.32618 0.28966 0.25751 0.22917 14 0.44230 0.38782 0.34045 0.29925 0.25333 0.23199 0.20462 0.07789 $ 0.41727 0.36245 0.31524 0.27454 0.23939 0.20900 0.18270) 0.06491 0.09346 Future Value of $1 M 6.0% 7.0% 8.0% 9.0% 10.0% 11.0% 12.0% 1 1.06000 1.07000 1.08000 1.090C0 1.10000 1.11000 1.12000 2 1.12360 1.14490 1.16640 1.18810 1.21000 1.23210 1.25440 3 1.191021.22504 1.25971 1.29503 1.33100 1.36763 1.40493 4 1.25249, 1.31080 1.36049 1.41158 1.45410 1.51807 1.57352 5 1.33823 1.40255 1.46933 1.53862 1.61051 1.68506 1.76234 20.0% 1.20000 1.44000 1.72800 2.07360 248832 2.98998 3.58318 4.29982 5.15978 6.19174 6 1.41852 1.50073 1.58687. 1.67710 1.77156 1.87041 1.97382 7 1.50363 1.60578 1.71382 1.82804 1.94872 2.07616 221068 8 1.59385 1.71819 1.85093 1.99256 2.14359 2.30454 2.47596 9 1.68948 1.83846 1.99900 2.17189 2.35795 2.55804 277308 TO 1.79085 1.96715 2.15892 2.36736 2.59374 2.83942 3.1058S 11 1.89830 210485 2.33164 258043 205312 3.15176 3.47855 12 201220 2.25219 2.51817 2.81266 3.13843 3.49845 3.89598 13 2.13293 240985 2.71962 3.06580 3.45227 3.88328 4.36349 14 2.26090 2.57853 2.93719 3.34173 3.79750 4.31044 4.88711 h5 239656 2.75903 3.17217 3.64248 4.17725 4.78459 5.47357 743008 8.91610 10.89932 12.33915 15.40702 Present Value of an Ordinary Annuity n 6.0% 7.0% 8.0% 9.0% 10.0% 11.0% 12.0% 20.0% 1 0.94340 0.93458 0.92593 0.91743 0.90909 0.90090 0.89286 0.83333 2 1.83339 1.BOBC2 1.78326 1.75911 1.73554 1.71252 1.69005 1.52778 3 267301 2.62432 257710 253129 248685 2.44371 240183 2.10648 4 3.46511 3.38721 3.31213 3.38721 3.31213 3.23972 3.16987 3.10245 3.03735 2.58873 5 421236 4.10020 3.99271 3.88965 3.79079 3.69590 3.60478 2.99061 64.91722 4.76654 4.62288 4.48592 4.35525 4.230532.11:41/3.325 7 5.58238 5.38929 5.205275.03295 4.36842 4.71220 4.56376 3.60459 8 6.20979 5.97130 5.74564 5.53482 5.33493 5.74612 4.96764 3.83716 9 6.80169 6.51523 6.24689 5.99525 5.75902 5.53705 5.32825 4.03097 10 7-36009 7.02353 6.71008 6,41766 6.14457 5.88923 5.65022 4.1920 11 7.58687749867 7.13896 6.80519 6.49506 6.20452 5.93770 4.32705 12 8.303847.94260 7.53608 7.16073 6.81369 6.49236 6.19437 4.43922 13 8.85268 8.35765 7.90378 7.48690 7.10336 6.74987 642355 4.53268 14 9.29498 8.74547 8.24424 7.78615 7.36609 6.981876.62817 4.61057 15 9.71225 9.10791 8.55948 8.06069 7.60608 7.190876.81086 4.67547 Future Value of an Ordinary Annuity ni 6.0% 7.0% 8.0% 11.0% 20.0% 1 2 1.0000 20600 3.1836 4.3746 5.6371 1.0000 2.9700 3.2149 4.4399 5.7507 1.0000 2.0800 3.2464 4.5061 5.8666 9.0% 10.0% 1.0000 1.0000 20900 - 21000 3.2781 3.3100 4.5731" 4.6410 5.9847 6.1051 1.0000 2.1100 3.3421 4.7097 6.2278 12.0% 1.0000 21200 3.3744 4.7793 6.3528 1.0000 2.2000 3.6400 5.3680 7.4416 4 5 6 7 6.9753 8.3938 9.8975 11.4913 13.1809 7.1533 7.3359 75233 7.7156 7.9129 8.1152 8.6540 8.9228 9.2004 9.4872 9.7833 10.0690 10.2598 10.6366 11.0285 11.4359 11.8594 122997 11.9780 12.4876 13.0210 13.5795. 14.1640 14.7757 13.8764 14.4866 15.1929 15.9374 16.7220 17.5487 9.9299 12.9159 16.4971 20.7989 25.9587 9 10 11 14.9716 15.7836 16.6455 17.5603 18.5312 19.5614 20.6546 12 16.8899 17.8889 18.9771 20.1407 21.3843 22.7132 24.1331 13 18.8821 20.1406 21.4953 22.9534 24.5227 26.2116 28.0291 114 21.0151 22.5505 24.2149 26.0192 27.975030.0949 32.3926 15 23.2760 25.1290 27.1521 29.3609 31.7725 34.4054 37.2797 32.1504 39.5805 48.4956 59.1959 720351 Present Value of an Annuity Due 16.0% 7.0% B.0% 9.0% 10.0% 11.0% 12.0% 20.0% 1 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 2 1.94340 1.93458 1.92593 1.91743 1.90909 1.90090 1.89286 1.8.3333 3 2.83339 2.80802 2.78326 275911 2.73554 271252 269005 2.52778 4 3.67301 3.62432 3.57710 3.53129 3.48685 3.44371 3.40183 3.10548 5 4.46511 4.32721 4.31213 4.23972 4.16987 4.10245 4.03735 3.58873 6 5.21236 5.10020 4.99271 4.68965 4.79079 4.69590.4.60478 3.99661 7 5.91732 5.7600+ 5.62233 5.48592 5.35526 5.23054 5.11141 4.32551 86.58238 6.32929 6.20637 6.03295 5.86862 5.71220 5.56376 4.60459 97.20979 6.97130 6.74654 6.53482 6:33493 6.14612 5.96764 4.83716 107.80169 7.51523 7.24689 6.99525 6.75902 6.53705 6.32825 5.03097 11 8.360098.02358 7.71000 7.41766 7.14457 6.88923 6.65022 5.19247 12 8.886878.49867 8.13896 7.80519 7.49506 7.20652 6.93770 5.32706 13 9.38384 8.94269 8.53608 8.16073 7.81389 7.49236 7.19437 5.43922 14 9.85268 9.35765 8.90378 8.48690 8.10336 7.74987 7.42355 5.53268 15 10.29498 9.74547 9.24424 8.76615 8.35659 7.98187 7.62817 5.61057 Future Value of an Annuity Due 1 2 3 4 5 6.0% 7.0% 8.0% 9.0% 10.0% 11.0% 12.0% 20.0% 1.0600 1.0700 1.0800 1.0900 1.1000 1.1100 1.1200 1.2000 2.1836 2.2149 2.2454 2.2761 23100 2.3421 2.3744 2.6400 3.3746 3.4399 3.5061 3.5731 3.6410 3.7097 3.7793 4.3680 4.6371 4.7507 4.8666 4.9847 5.1051 5.2278 5.3528 6.4416 5.9753 6.1533 6.3359 6.5233 6.7156 6.9129 7.1152 8.9299 6 7.3938 76540 7.9228 8.2004 8.4872 8.7833 9.6890 11.9159 7 8.8975 9.2599 9.6366 10.0225 10.4359 10.8594 11.2997 15.4991 8' 10.4913 10.9780 11.4876 12.0210 12.5795 13.1640 13.7757 19.7989 9 12.1808 12.8164 13.4866 14.1929 14.9374 15.7220 16.5487 24.9587 10 13.9716 14.7836 15.645 16.5603 17.5312 18.5614 19.6546 31.1504 11 15.8699 16.5885 17.9771 19.140720.3843 21.7132 2.1331 33.5305 12 17.8821 19.1406 20.4953 21.9534 23.5227 25.2116 27.0291 47.4966 13 20.0151 21.5505 23.2149 25.0192 26.9750 29.0949 31.3926 58.1959 14 22.2760 24.1290 26.1521 28.3609 30.7725 33.4054 36.2797 71.0351 15 24.6725 26.8881 29.3243 . 32.0034 34.9497 38.1899 41.7533 86.4421
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started