Problem Set 3 - Compound Interest You deposit 2000 TL in a bank account paying 8
ID: 3697820 • Letter: P
Question
Problem Set 3 - Compound Interest
You deposit 2000 TL in a bank account paying 8% interest per year. Determine how much interest your investment will earn in 5 years in this account if (i) the interest is “simple” and (i) if the interest is “compound”.
You borrow 20,000 TL at 10% yearly interest (compounded annually). You will not make any payment in the first year. In Years 2, 3 and 4 you will make equal end-of-year payments of A TL to pay off the loan at the end of Year 4. You can assume that all of a year’s interest is paid off at the end of that year (except, of course, on Year 1 when there is no payment). Based on this information, frst calculate the value of A that will make this payment arrangement valid and complete the table below that will show the year-by-year status of the loan balance.
Year
Beginning of Year Balance
Interest
Accrued
for the Year
Total Balance
Payment
Towards
Year’s Interest
Payment
Towards
Remaining
Balance
Total
Payment
End of Year
Balance
1
2
3
4
Total
You deposit 3,000 TL today in a bank account that pays 0.75% monthly interest. How many months will it take for the money to grow to double? Calculate your answer analytically and by using a relevant Excel function.
Your late grandfather bought a farmland 30 years ago for 1,000 TL, which he recently sold for 160,000 TL. What yearly interest did he earn on this investment? Calculate your answer analytically and by using a relevant Excel function.
You want to save 1,000,000 TL by making uniform monthly deposits in a bank account paying 0.8% interest per month. If you want to achieve you goal in 20 years, how much should you deposit each month? Calculate your answer analytically and by using a relevant Excel function.
Your father just retired with 555,000 TL savings in his private retirement account that pays 0.92% monthly interest. If he wants to withdraw a salary of 6,000TL per month, how long will it take for him to deplete the savings? As a graduate student with excellent knowledge engineering economics, you advice him to be more conservative and withdraw 5,100 TL per month (15% less than his original intention of 6,000 TL). How long will the retirement savings last then? Show your calculations both using analytical formulas and a relevant Excel function. Interpret your findings.
In reference to part (f) above, your farther agrees with you that he can be more conservative with cashing into his retirement savings. As a person with years of Engineering Economics experience in his career, he is well capable of making his own calculations. He immediately understands that your real motivation could as well be maximizing your inheritance of the amount of money left in the account upon his death (at which he takes no offense). But he explains that the real reason he wants to withdraw 6000 TL a month is because he wants to put part of that money into a different retirement account that he can lock in a monthly rate of 1% (if he commits to making no withdrawals for the first 15 years). The current account allows him to withdraw at most 6000 TL a month, and he claims that at that withdrawal rate his calculations show that he will deplete the money in roughly 208 months. For all these months, his plan is to put 810 TL into the new retirement account (thus leaving him with 5190 TL to spend), which he claims will grow to be a larger amount of money than would be in the current account if he implemented your suggestion of withdrawing only 5100 a month. Verify your father’s calculations.
Year
Beginning of Year Balance
Interest
Accrued
for the Year
Total Balance
Payment
Towards
Year’s Interest
Payment
Towards
Remaining
Balance
Total
Payment
End of Year
Balance
1
2
3
4
Total
Explanation / Answer
1. P = 8000
r = 8%
t= 5 years
a) For simple interest:
Interest = P*r*t/100 = 8000*8*5/100 = 3200
b) For compound interest:
Amount = P*(1+r/100)n = 8000*(1+8/100)^5 = 11754.62
Interest = Amount - P = 11754.62 - 8000 = 3754.62
2. Borrowed money = P = 20000
Rate = r = 10% per year
Time = 4 years
Total amount to be repaid = M = P*(1+r/100)n = 20000*(1+10/100)^4 = 29282
Interest to be paid = M - P = 29282 - 20000 = 9282
Equated Yearly Installments (EYI) starting from 2nd year>
Principal component in EYI = 20000/3 = 6666.67
Interest component in EYI = 9282/3 = 3094
3. P = 3000
r = 0.75 per month
n = ?
M = 2*P= 2*3000 = 6000
M = P*(1+r/100)n
6000 = 3000* (1+0.75/100)^n
6000/3000 = 1.0075^n
2 = 1.0075^n
Or
1.0075^n = 2
On taking log of both sides base 10
log10(1.0075)^n = log10(2)
n*log10(1.0075) = log10(2)
n = log10(2) / log10(1.0075) = 0.3010 / 0.003245 = 92.75 month = 93 month approx.
Function in excel: PDURATION(rate%,principal,maturity) = PDURATION(0.75%,3000,6000) = 92.76577
4. M = 160000, P = 1000, n = 30, r =?
M = P*(1+r/100)n
160000 = 1000*(1+r/100)^30
160 = (1+r/100)^30
Taking log of both sides base 10
log(160) = 30*log(1+r/100)
log(1+r/100) = 2.2041/30
log(1+r/100) = 0.734
Taking antilog on both sides:
1+r/100 = 5.42
r= (5.42-1)*100 = 4.42*100 = 442%
Year Beginning of year balance Interest accrued for the year Total Balance Payment towards Year’s interest Payments towards remaining balance Total Payment End of year balance 1 20000 2000 22000 0 0 0 20000 2 20000 2000 22000 3094 6666.67 9760.67 13333.33 3 13333.33 1333.33 14666.66 3094 6666.67 9760.67 6666.66 4 6666.66 666.67 7333.33 3094 6666.67 9760.67 -0.01 Total 9282 20000.01 29282.01
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.