Zor (1998) Hindi | S Take Test: hw1-20 Chegg Study I Class of 2019 Senio... hind
ID: 2809543 • Letter: Z
Question
Zor (1998) Hindi | S Take Test: hw1-20 Chegg Study I Class of 2019 Senio... hindi movies sunny... estion Completion Status: to save annually for the next 10 years? Assume that the first deposit to her pension fund will be today, followed by nine more annual deposits, and that the annual withdrawals from age 65 will occur at the beginning of each year. Use the following spreadsheet (the numbers are not correct) and Goal Seek to find an answer SAVING FOR THE FUTURE Annual desired pension payout Annual payment 10,000 4 Interest rate Account Deposit or balance,withdrawal Interest Total in account Your age beginning of beginning of during year end of year 10,000 10,000 10,000 10,000 535,500D7 C7 B7 572,775D8+C8+B8 611,914 500,000 25,500 27.275 139 500 57 572,775 611,914 653,009 696,160 31,096653,009 35.308 741-46810,000 37,573 42450 741468 789,041 10,000 13 39,952 952838,993 789,041 838,993 891 443 9465151(100,000) 888,841 828,283 764,697 891443 946,515 888,841 10,000 0,000450 64 65 (100,000) 39.44 414 97.9 100,000) 7.932 (100,000)29 897 554,220 476,931 395 778 310,566 221.095 70 627 (100,000) 476,931 395.778 (100.000) 18.847 14,789 26 74Explanation / Answer
1.
37411.4284197298
2.
100000
3.
0
Age Account Beginning Deposit/Withdrawal Interest Account ending 55 500000 37411.42842 26870.57142 564281.9998 56 564281.9998 37411.42842 30084.67141 631778.0997 57 631778.0997 37411.42842 33459.4764 702649.0045 58 702649.0045 37411.42842 37003.02165 777063.4546 59 777063.4546 37411.42842 40723.74415 855198.6271 60 855198.6271 37411.42842 44630.50278 937240.5583 61 937240.5583 37411.42842 48732.59934 1023384.586 62 1023384.586 37411.42842 53039.80073 1113835.815 63 1113835.815 37411.42842 57562.36218 1208809.606 64 1208809.606 37411.42842 62311.05171 1308532.086 65 1308532.086 -100000 60426.6043 1268958.69 66 1268958.69 -100000 58447.93451 1227406.625 67 1227406.625 -100000 56370.33124 1183776.956 68 1183776.956 -100000 54188.8478 1137965.804 69 1137965.804 -100000 51898.29019 1089864.094 70 1089864.094 -100000 49493.2047 1039357.299 71 1039357.299 -100000 46967.86494 986325.1636 72 986325.1636 -100000 44316.25818 930641.4218 73 930641.4218 -100000 41532.07109 872173.4929 74 872173.4929 -100000 38608.67465 810782.1676 75 810782.1676 -100000 35539.10838 746321.2759 76 746321.2759 -100000 32316.0638 678637.3397 77 678637.3397 -100000 28931.86699 607569.2067 78 607569.2067 -100000 25378.46034 532947.6671 79 532947.6671 -100000 21647.38335 454595.0504 80 454595.0504 -100000 17729.75252 372324.8029 81 372324.8029 -100000 13616.24015 285941.0431 82 285941.0431 -100000 9297.052154 195238.0952 83 195238.0952 -100000 4761.904762 100000 84 100000 -100000 0 0Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.