In: Finance
sami is planning on buying a car after five years. the current price of the car is 50,000 dollars and inflation rate is 3 percent. sami currently has 11,000 dollars in a bank account that pays an annual interest rate of 8 percent, compounded semi-annually. he wants to save for the balance by making semi annual payments in the account, at the end of each period. 1.compute the amount of the payments
End of year two, sami withdrew 3200 dollars, and he deposited 2100 dollars end of year three. compute the last two payments.
1)$2801.265
Current Value of Car | 50000.00 | ||||||||||||
Inflation | 3% | ||||||||||||
Money In Hand | 11000 | ||||||||||||
Bank Interest | 8% | 4.00% | |||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||||||
Car Value | 50000.00 | 51500.00 | 53045.00 | 54636.35 | 56275.44 | 57963.70 | 59702.61 | ||||||
Periods | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
CF | 11000.00 | 14241.27 | 17612.18 | 21117.93 | 24763.92 | 28555.74 | 32499.23 | 36600.47 | 40865.75 | 45301.64 | 49914.97 | 54712.84 | 59702.62 |
Interest Earned | 0.00 | 440 | 569.65 | 704.49 | 844.72 | 990.56 | 1142.23 | 1299.97 | 1464.02 | 1634.63 | 1812.07 | 1996.60 | 2188.51 |
Semiannual Payments | 0 | 2801.265 | 2801.265 | 2801.265 | 2801.265 | 2801.265 | 2801.265 | 2801.265 | 2801.265 | 2801.265 | 2801.265 | 2801.265 | 2801.265 |
Annual Payments | 2801.265 |
2) $2915.88
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
CF | 11000.00 | 14355.89 | 17846.01 | 21475.73 | 22050.64 | 25848.56 | 31898.38 | 36090.20 | 40449.70 | 44983.57 | 49698.80 | 54602.63 | 59702.62 |
Interest Earned | 0.00 | 440 | 574.24 | 713.84 | 859.03 | 882.03 | 1033.94 | 1275.94 | 1443.61 | 1617.99 | 1799.34 | 1987.95 | 2184.11 |
Semiannual Payments | 0 | 2915.885 | 2915.885 | 2915.885 | 2915.885 | 2915.885 | 2915.885 | 2915.885 | 2915.885 | 2915.885 | 2915.885 | 2915.885 | 2915.885 |
Annual Payments | 2915.885 |