Question

In: Accounting

You have invested money in a savings account that pays a fixed monthly interest on the...

You have invested money in a savings account that pays a fixed monthly interest on the account balance. The following table shows the account balance over the first 5 months.

Time
in months
Savings balance
0 $1500.00
1 $1521.00
2 $1542.29
3 $1563.88
4 $1585.77
5 $1607.97

(a) How much money was originally invested?
$  

(b) Show that the data are exponential. (Round your answer to three decimal places.)

Each successive ratio of new/old is   , which shows that the data is exponential.


Find an exponential model for the account balance. (Let t be the time in months and B the savings balance in dollars. Round your parameters to three decimal places.)
B(t) =


(c) What is the monthly interest rate? (Round your answer to one decimal place.)
  %

(d) What is the yearly interest rate? (Round your answer to one decimal place.)
%

(e) Suppose that you made this investment on the occasion of the birth of your daughter. Your plan is to leave the money in the account until she starts college at age 19. How large a college fund will she have? (Round your answer to the nearest cent.)
$

(f) How long does it take your money to double in value? (Round your answer to two decimal places.)
months

How much longer does it take it to double in value again? (Round your answer to two decimal places.)
months

Solutions

Expert Solution

A) Money originally inveeted is $1,500.

B) Exponential data is data which follows some patterns. I.e. variable moves upward or downward by common ratio or amount or function.

Each successive ratio of new/old is 1.014, which shows that the data is exponential.

Trend Ratio = (Amount ⁿ / Amount ⁿ-¹) * 100

1. ($1,521.00/$1,500.00) = 1.014

2. ($1,542.29/$1,521.00) = 1.014

3. ($1,563.88/$1,542.29) = 1.014

4. ($1,585.77/$1,563.88) = 1.014

5. ($1,607.97/$1,585.77) = 1.014

Exponential Model For Account Balance B(t) = A(1.014)t

(t= months)

C) MONTHLY INTEREST RATE

Monthly Interest Rate will be 1.4%

(1.014-1)*100 = 1.4% per month

D) ANNUITY INTEREST RATE

Nominal rate: 1.4% per month * 12 months

= 16.8% per annum coumpounded monthly

Effective rate: {(1.014)¹² -1}*100

= 18.16% per annum compounded annually

E) Balance after 19 years:

effective annual rate = 18.16% ( calculated in D)

Duration = 19 years

Balance after 19 years

= $1,500(1.1816)19 = $35,729.79

= $35,700.

F) Duration to double the money

Monthly rate is 1.4 i.e. r=0.014

3000 = 1500(1.014)t

2 = 1.014 t

Solving this equation using log table

t = Log(2)/Log(1.014)

t = 0.3010/0.0060 = 50.16 i.e 50 months approx.

Dear student, please refer the above solution and provide feedback as well as query if any are invited by comment.


Related Solutions

You invested money in a savings account paying 10% interest seven years ago.
You invested money in a savings account paying 10% interest seven years ago.  The account is now worth $5,527.50.  How much did you invest?
Suppose you are invested in an (excellent) account that pays 50% interest per year, paid monthly....
Suppose you are invested in an (excellent) account that pays 50% interest per year, paid monthly. The account is closed to new investment, so you cannot reinvest the interest. Do you prefer this account to one that pays a single payment of 50% at the end of the year, rather than monthly? Why or why not? Explain your reasoning (you may wish to reference ideas like compounding, NPV, IRR, etc.)
if you invest $20 in a savings account tha pays 5% interest how much money will...
if you invest $20 in a savings account tha pays 5% interest how much money will you have in 4 years if you make no additional deposits
Suppose you have a certain amount of money in a savings account that earns compound monthly...
Suppose you have a certain amount of money in a savings account that earns compound monthly interest, and you want to calculate the amount that you will have after a specific number of months. The formula is as follows: f = p * (1 + i)^t • f is the future value of the account after the specified time period. • p is the present value of the account. • i is the monthly interest rate. • t is the...
Kori is making monthly contributions of of $260 to her savings account which pays interest at...
Kori is making monthly contributions of of $260 to her savings account which pays interest at the APR of 6.9%, compounded monthly. Right after Kori makes her 35th contribution, the bank changes the APR to 7.2% and Kori makes 57 more $260 contributions. What is Kori's balance right after her last contribution?
If a savings account pays 6% p.a. interest rate, how much money do you need to...
If a savings account pays 6% p.a. interest rate, how much money do you need to deposit to accumulate $72,566 in 9 years? Note that the bank will compound interest monthly.
Josh deposited $800 in a savings account at 4.0% interest, compounded monthly. A) how much money...
Josh deposited $800 in a savings account at 4.0% interest, compounded monthly. A) how much money will josh have in his account after 4 years? B) After how many years will josh have $2000 in his account(if he does not withdraw any money)?
Bank A pays 15% interest, compounded monthly, on its money market account. What is the effective...
Bank A pays 15% interest, compounded monthly, on its money market account. What is the effective annual rate?
You invest $7,000 into a savings account that pays an annual interest rate of 12.00%.
You invest $7,000 into a savings account that pays an annual interest rate of 12.00%. How much would you have in your account after 12 years?A.$20,549B.$24,010C.$27,272D.$30,343E.$33,231F.$35,942G.$38,483H.$40,861
You put $1,000 into a savings account that pays 4% in annualinterest. How much money...
You put $1,000 into a savings account that pays 4% in annual interest. How much money will you have after 2 years if the account pays only simple interest?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT