Question

In: Accounting

This assignment highlights the importance of using the "effective annual rate" and how to obtain a...

This assignment highlights the importance of using the "effective annual rate" and how to obtain a periodic rate that will provide us with the desired effective annual rate.

Assume that you inherited $100,000 from your grandparents, today. You have exactly 20 years to retire and you decided to put the entire amount into 20 years, 4% annual interest annuity.

A) Assuming you did not deposit any additional amount into this account, compute your account balance by the time you retire, using the annuity calculator. Then, compute the same using a scientific calculator (not a financial one) using the appropriate formulas from the textbook and show your calculations. (Make sure the amounts are the same!)

B) 1) Now assume that in addition to this initial $100,000, you also contributed $500 at the end of each month until you retire. Compute your retirement account balance using the annuity calculator. Highlight the end balance, total principal, and total interest.

2) Now, using the relevant formulas from the textbook and a scientific calculator, reproduce the results (End Balance, Total Principal, Total Interest) showing your calculations. Highlight any issue one has to pay attention to calculating those values.

3) Finally, assume that the contributions were made at the beginning of each month. What are the above three values now? Show your computations to reproduce those values with a scientific calculator and highlight the formulas used.

C) Now, look at the first row of the “Annual Schedule” table provided by the calculator (just under the graph): Copy the values of the last three columns (Interest, End Balance, End Principal). (The values as of the end of the first year.)

Solutions

Expert Solution

ANSWER:

Requirement A:

Principal (P)= $100,000

Annual Interest Annuity (r) = 4%

Time (t) = 20 years

Calculating the account balance after 20 years, using Annuity Calculator:

Principal $100,000
Interest $119,112.31
Ending Balance $219,112.31

Calculating the account balance after 20 years, using textbook formulas:

FV = A [(1 + r)t - 1] / r

= 100,000 [(1 + 4%)20 - 1] / 4%

= 100,000 [(1.04)20 - 1] / 0.04

= 100,000 (29.75) = $2,975,000

Requirement B:

Starting Principal = $100,000

$500 deposited at the end of each month until retirement

The account balance after 20 years, using Annuity Calculator:

Principal $220,000
Interest $181,033.18
Ending Balance $401,033.18

Starting Principal = $100,000

$500 deposited at the end of each month until retirement

So, total amount deposited in 20 years = $500 * 12 * 20 = $120,000

Therefore, Principal = 100,000 + 120,000 = $220,000

Calculating the account balance after 20 years, using textbook formulas:

FV = A [(1 + r)t - 1] / r

= 220,000 [(1 + 4%)20 - 1] / 4%

= 220,000 [(1.04)20 - 1] / 0.04

= 220,000 (29.75) = $6,545,000‬


Related Solutions

1.a The annual interest rate is 8% with annual compounding. Please calculate effective annual rate, effective...
1.a The annual interest rate is 8% with annual compounding. Please calculate effective annual rate, effective semi-annual rate, effective quarterly rate, effective monthly rate, effective weekly rate (1 year = 52 weeks), effective daily rate (1 year = 365 days). 1.b The annual interest rate is 8% with monthly compounding. Please calculate effective monthly rate, effective annual rate, effective semi-annual rate, effective quarterly rate.
effective annual interest rate
You have received a loan from a bank with a quoted rate of 18 percent compounded monthly. What is the Effective annual interest rate of the loan?
The annual nominal rate is jm = 0.15pa. What is the effective annual rate as a...
The annual nominal rate is jm = 0.15pa. What is the effective annual rate as a percentage to two decimal places? The number of compounding periods is 8. Enter your answer as a decimal eg 17.42% = .1742 to four decimal places. Accuracy of one basis point. Tip: use excel to get the required accuracy.
Convert a 10% continuously compounded annual rate (rcc annual)into an effective annual rate (reff annual)....
Convert a 10% continuously compounded annual rate (rcc annual) into an effective annual rate (reff annual). The equivalent effective annual rate is: (a) 230.258509% pa (b) 10.536052% pa (c) 10.517092% pa (d) 10.468982% pa (e) 9.531018% pa
What is the difference between the effective annual rate and the annual percentage rate, and when...
What is the difference between the effective annual rate and the annual percentage rate, and when should you use which?
How spot rate and forward rate affects the annual cash flow? Also the importance of hedging...
How spot rate and forward rate affects the annual cash flow? Also the importance of hedging too?
What is the difference between the annual percentage rate (APR) and the effective annual rate (EAR)?...
What is the difference between the annual percentage rate (APR) and the effective annual rate (EAR)? Which rate do you believe is more relevant for financial decisions and why?
The effective semi-annual interest rate is 5%. The equivalent effective monthly rate is ___________ (Carry out...
The effective semi-annual interest rate is 5%. The equivalent effective monthly rate is ___________ (Carry out 4 places after the decimal point, and write the answer as a decimal)
Using the constant annual effective rate 2.3443% , determine the accumulated amount in your account from...
Using the constant annual effective rate 2.3443% , determine the accumulated amount in your account from 1st january 2011 to 31 December 2020 (ten years in total) according to the following deposit patterns. i) Deposit $1,000 at the start of every month. ii) Deposit $1,000 at the start of the first month and keeps increasing by $100 in the subsequent months until the monthly deposit achieves $3,000, then remains at $3,000 in all the following months. iii) Deposit $3,000 at...
Is this statement true or false? The effective annual rate is > than the annual percentage...
Is this statement true or false? The effective annual rate is > than the annual percentage rate. Explain your answer.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT