Question

2. Tom sets up auto-payment for his monthly mortgage payments so that at the end of every month $2100 will be automatically withdraw from one of his savings accounts and sent to the mortgage company. This savings account pays a generous 1.75% monthly interest. He expects that he will need to make exactly 300 payments and his mortgage will be paid off. He wishes to move enough money from his other accounts into this one so that he won't need to worry about it running out of money. In addition, he also wishes to have $10,000 remaining balance in the account after the 300th mortgage payment. How much money will he need to put into the account right now so that it has enough for 300 monthly withdrawals and has $10,000 leftover as expected? 3. Ken hopes to be able to retire in 35 years. Suppose he plan to start depositing $180 into his 401(k) account every month with the first deposit to be made right away. Suppose his 401(k) account pays 0.55% per month. If he indeed retires after 35 years, how much will he have in his 401(k) account to support his retirement life? 4. Suppose you have savings of $8,000 in a bank account that pays monthly compound interest of 0.85%. You expect to withdraw $200 per month for 50 months from your account, with the first withdrawal starting a month from now. If there are no other deposits or withdrawals, is there any money left in your account after your 50m withdrawal? If so, how much is there? If not, how much have you overdrawn your account?

Answer 1

2. Amount to be put in initially is $119,395.96 as follows:

Clipboard Allghment C6 f =PV(C1,C2,C3,C4,C5)*-1 A в 1 Interest rate Rate 1.75% 2 Number of payments Nper 300 3 Amount of monthly payments Pmt 2,100 4 Future value Fv $ 10,000 5 Timing of payments Type 6 Initial deposit PV $119,395.96 7

3. Amount available at the end of 35 years will be $296,522.89 as follows:

Cubour C6 fx=FV(C1,C2,C3,C4,C5)*-1 А в c D 1 Interest rate Rate 0.55% 2 Number of payments Nper 420 5 yea 420 (35 years* 12) 3 Amount of monthly payments Pmt $ 180 4. Present Value Pv 0 5 Timing of payments Type 6 Future value Fv $296,522.89

4. There will be no amount left over after 50th withdrawal. The account will be overdrawn by $181.60 as follows:

FONT C6 Rate Clipboard Allghmel fc =FV(C1,C2,C3,C4,C5)*-1 A в 1 Interest rate 0.85% 2 Number of payments Nper 50 3 Amount of monthly payments Pmt $ (200) 4. Present Value Pv $ 8,000.00 5 Timing of payments Type 6 Future value Fv ($181.60)! 7