Question

In: Finance

1. A regular deposit of $100 is made at the beginning of each year for 20...

1. A regular deposit of $100 is made at the beginning of each year for 20 years. Simple interest is calculated at i%per year for the 20 years. At the end of the 20-year period, the total interest in the account is $840. Suppose that interest of i% compounded annually had been paid instead. How much interest would have been in the account at the end of the 20 years?

2. Herman has agreed to repay a debt by using the following repayment schedule. Starting today, he will make $100 payments at the beginning of each month for the next two-and-a-half years. He will then pay nothing for the next two years. Finally, after four-and-a-half years, he will make $200 payments at the beginning of each month for one year, which will pay off his debt completely. For the first four-and-a-half years, the interest on the debt is 9% compounded monthly. For the final year, the interest is lowered to 8.5% compounded monthly. Find the size of Herman’s debt. Round your answer to the nearest dollar.

Solutions

Expert Solution

Assume annual interest =r

r=i/100

Simple Interest on first deposit =20*r*100

Simple Interest on Year 2 beginning deposit=19*r*100

Total Simple interest =20*r*100+19*r*100+18*r*100+……………………..+r*100

Total Simple Interest =100*r*(20+19+18+17+………..+1)

Total Simple Interest =100*r*(20*(20+1)/2)=100*r*210=21000*r

Total Simple Interest =$840

21000*r=840

r=840/21000=0.04

i=0.04*100%=4%

IF COMPOUNDED ANNUALLY:

Future Value of deposit at end of 20 years =FV=(Deposit)*((1+r)^(20-N))

r=0.04,N=year of Cash Flow

N

D

FV=D*(1.04^(20-N)

End of Year

Deposit

Future Value

0

$100

$219.11

1

$100

$210.68

2

$100

$202.58

3

$100

$194.79

4

$100

$187.30

5

$100

$180.09

6

$100

$173.17

7

$100

$166.51

8

$100

$160.10

9

$100

$153.95

10

$100

$148.02

11

$100

$142.33

12

$100

$136.86

13

$100

$131.59

14

$100

$126.53

15

$100

$121.67

16

$100

$116.99

17

$100

$112.49

18

$100

$108.16

19

$100

$104.00

SUM

$3,096.92

Total Amount Deposited=100*20=$2,000

Total Future Value of deposit with 4% interest compounded annually=$3,096.92

Amount of Interest in the account=3096.92-2000=$1,096.92


Related Solutions

If you deposit $15,000 per year for 9 years (each deposit is made at the end...
If you deposit $15,000 per year for 9 years (each deposit is made at the end of each year) in an account that pays an annual interest rate of 9%, what will your account be worth at the end of 9 years? Please show details and related formulas, I will give thumbs up ASAP once I check the answer.
1.Deposits of $1000 are made at the beginning of each year for three years. The balance...
1.Deposits of $1000 are made at the beginning of each year for three years. The balance at the end of each year (before the deposit for the next year) was $1100, $2000, and $3400, respectively. Find the time-weighted yield rate. 2. A 10,000 par value 10-year bond with 8% annual coupons is bought at a premium to yield an annual effective rate of 6%. Calculate the interest portion of the 7th coupon.
the cpompany has customers make a 20% deposit on items made. This deposit is credited to...
the cpompany has customers make a 20% deposit on items made. This deposit is credited to the Unearned Sales Account when received. Customers pay the remaining balance (80% of the selling price) once the product is done and delivered. On june 1, 2016, the Unearned Sales account had a credit balance of $180,000. During June and July 2016, total customer deposits made for products to be delivered in the future amounted to $400,000 and $480,000. Questions: (please explain answers, not...
What is the future value of 20 periodic payments of $4,000 each made at the beginning...
What is the future value of 20 periodic payments of $4,000 each made at the beginning of each period and compounded at 8%? Build an Excel worksheet to verify your calculation of #1. Show the calculation year by year (periodic amount, payment, balances etc.) Given the information of #1 above, how much you would have to save every year (period) if you want to have 2 million dollars of cash after 20 years (periods)
$100 is received at the beginning of year 1, $200 is receivedat the beginning of...
$100 is received at the beginning of year 1, $200 is received at the beginning of year 2, and $300 is received at the beginning of year 3. If these cash flows are invested at 12 percent, what will their future value be at the end of year 3?What is the present value of a $25,000 perpetuity be if the discount rate (required rate of return) is 14 percent? (HINT: Excel does not have a built-in formula for perpetuity. You...
Payments of $6,000.00 are made into a fund at the beginning of each year for ten...
Payments of $6,000.00 are made into a fund at the beginning of each year for ten years. The fund is invested at an annual effective rate of i. The interest generated is reinvested at 10%. The total accumulated value at the end of the ten years is $98,180.00. Find I round to 3 decimal places
A man is planning to retire in 20 years. He wishes to deposit a regular amount...
A man is planning to retire in 20 years. He wishes to deposit a regular amount every three months until he retires, so that, beginning one year following his retirement, he will receive annual payments of $60,000 for the next 15 years. How much must he deposits if the annual interest rate is 6% compounded quarterly? (Note that the last deposit is made on the date of the end of 20th year, and first withdrawal is at the end of...
Q.3. A man is planning to retire in 20 years. He wishes to deposit a regular...
Q.3. A man is planning to retire in 20 years. He wishes to deposit a regular amount every two months until he retires so that, beginning one year following his retirement, he will receive annual payments of $30,000 for the next 10 years. How much must he deposit if the interest rate is 10% compounded monthly?
$2,000 are deposited into a fund at the beginning of each year for 20 years. Starting...
$2,000 are deposited into a fund at the beginning of each year for 20 years. Starting from the beginning of the 26th year, the balance can support annual payment D lasting forever. Find D if the nominal interest rate compounded continuously is 8%.
Victor invests 300 into a bank account at the beginning of each year for 20 years....
Victor invests 300 into a bank account at the beginning of each year for 20 years. The account pays out interest at the end of every year at an annual effective interest rate of i% . The interest is reinvested at an annual effective rate of i / 2 %. The yield rate on the entire investment over the 20 year period, if he would only make deposits of 300 due is 8% annual effective. Determine i.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT