This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: Question 3 Solution Rate 7.50% Tabulation Year Deposit Interest Balance OR Amount Years FV $5,000 $5,000 ($5,000) $10,305 =FV(7.5%,10I8,,H8) 1 $1,000 $375.0 $6,375 ($1,000) 1 $1,917 =FV(7.5%,10I9,,H9) 2 $1,000 $478.1 $7,853 ($1,000) 2 $1,783 =FV(7.5%,10I10,,H10) 3 $0 $589.0 $8,442 FW $14,006 =SUM(J8:J10) 4 $0 $633.2 $9,075 5 $0 $680.6 $9,756 OR Amount Years PV 6 $0 $731.7 $10,488 ($5,000) $5,000 7 $0 $786.6 $11,274 ($1,000) 1 $930 8 $0 $845.6 $12,120 ($1,000) 2 $865 9 $0 $909.0 $13,029 PW $6,796 =SUM(J8:J10) 10 $0 $977.2 $14,006 FW $14,006 OR Present value of years12 $1,796 =PV(C5,2,1000,0) Year 0 $5,000 sum to get PW $6,796 FW $14,006 =FV(C5,10,0,J22) Ben deposits $5,000 now into an account that earns 7.5 percent interest compounded annually. He then deposits $1,000 per year at the end of the first and second years and no more. How much will the account contain 10 years after the initial deposits? Question 4 Solution Rate 7% Compounded Annually A tabulation shows this well. Deposit Withdrawal Interest Balance $2,000.00 $0.00 $0.00 $2,000.00 1 $0.00 $0.00 $140.00 $2,140.00 2 $0.00 $0.00 $149.80 $2,289.80 3 $0.00$1,000.00 $160.29 $1,450.09 4 $0.00 $0.00 $101.51 $1,551.59 5 $3,000.00 $0.00 $108.61 $4,660.20 6 $0.00 $0.00 $326.21 $4,986.42 7 $0.00 $0.00 $349.05 $5,335.47 8 $1,500.00 $0.00 $373.48 $7,208.95 9 $0.00 $0.00 $504.63 $7,713.58 10 $0.00 $0.00 $539.95 $8,253.53 11 $0.00 $0.00 $577.75 $8,831.27 NPV $5,011.97 ($816.30) $4,195.67 FW= $8,831.27 Deposit Withdrawal Net $2,000.00 $0.00 $2,000.00 1 $0.00 $0.00 $0.00 2 $0.00 $0.00 $0.00 3 $0.00$1,000.00 ($1,000.00) 4 $0.00 $0.00 $0.00 5 $3,000.00 $0.00 $3,000.00 6 $0.00 $0.00 $0.00 7 $0.00 $0.00 $0.00 8 $1,500.00 $0.00 $1,500.00 9 $0.00 $0.00 $0.00 10 $0.00 $0.00 $0.00 11 $0.00 $0.00 $0.00 NPV= $4,195.67 FW= $8,831.27 Determine PV of each transaction, sum and determine future value. Year Amount PV Transaction ($2,000.00) $2,000.00 3 $1,000.00 ($816.30) 5 ($3,000.00) $2,138.96 8 ($1,500.00) $873.01 PW = Sum $4,195.67 11 FW $8,831.27 Determine the FV in period 11 of each transaction, and sum. Year Amount FV Transaction ($2,000.00) $4,209.70 3 $1,000.00 ($1,718.19) 5 ($3,000.00) $4,502.19 8 ($1,500.00) $1,837.56 11 Sum = FW $8,831.27 If you invest $2,000 today, withdraw $1,000 in 3 years, deposit $3,000 in 5 years, deposit $1,500 in 8 years, and withdraw the entire sum 3 years after the final deposit, how much will you withdraw? Interest is 7% compounded annually. End of year An alternative is as follows. Determine the PV of each deposit and each withdrawal, sum these, and then find the future value in year 11 of this sum. Using negative signs that reflect the movement of money from your pocket (deposits) and positive signs for what comes into your pocket (withdrawals), makes the future value be positive, which it should be....
View
Full
Document
This note was uploaded on 02/15/2012 for the course MBA 101 taught by Professor X during the Spring '11 term at Shawnee.
 Spring '11
 X
 Interest

Click to edit the document details