Question

Suppose a person has contributed $2,000 per year for 30 years at 6% interest rate and...

Suppose a person has contributed $2,000 per year for 30 years at 6% interest rate and then retired. The balance in the account is then used to purchase an annuity which will make a payment at the end of each month for the following 20 years, completely exhausting the account. The annuity pays 7.29% compounded monthly. What will the amount of the monthly payment be?

PLEASE SHOW WORK

Homework Answers

Answer #1

Firstly, the balance in the account at the end of 30 years is calculated.

The balance in the account at the end of 30 years is calculated by computing the future value

Yearly payment= $2,000

Interest rate= 6%

Time= 30 years

The future value of the annuity is calculated by entering the below:

PMT= 2,000; I/Y= 6; N= 30

Press CPT and FV to calculate the future value.

The balance in the account at the end of 30 years is $158,116.37.

Secondly, the monthly payment of the annuity purchased should be calculated.

Present value= $158,116.37

Interet rate= 7.29%/12= 0.6075%

Time= 20 years*12= 240 months

The monthly payment is calculated by entering the below:

PV= -158,116.37; N= 240; I/Y= 0.6075

Press CPT and PMT to calculate the monthly payment.

The monthly payment is $1,253.55.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Suppose you have a nest egg (retirement account balance) of $1,000,000 with an APR of 6%....
Suppose you have a nest egg (retirement account balance) of $1,000,000 with an APR of 6%. Find the monthly payment for a 25 year annuity. In other words, you start with a million dollars and receive an equal payment every month for 25 years. At the end of that time, the account is empty. Find the monthly payment for a 30 year annuity. Find the monthly payment for a 35 year annuity.
Please show work A person borrows $11,000 from the bank at a yearly interest rate of...
Please show work A person borrows $11,000 from the bank at a yearly interest rate of 10% which is compounded monthly. The loan will be paid off in 2 years 1. What are the monthly payments? 2. If he decides to pay off the entire loan balance at the end of 17th month, what would be the total amount at that time?
Catherine received a 30 year loan of $240,000 to purchase a house. The interest rate on...
Catherine received a 30 year loan of $240,000 to purchase a house. The interest rate on the loan was 5.90% compounded monthly. a. What is the size of the monthly loan payment? $ Round to the nearest cent b. What is the principal balance of the loan at the end of 3 years?$ Round to the nearest cent c. By how much will the amortization period shorten if Catherine made an extra payment of $54,000 at the end of the...
A $10000 loan has an interest rate of 12% per year, compounded monthly, and 30 equal...
A $10000 loan has an interest rate of 12% per year, compounded monthly, and 30 equal monthly payments are required. a) If payments begin at the end of the first month, what is the value of each payment? b) How much interest is in the 10th payment? c) What would you enter into Excel to solve part b? d) What is the unpaid balance immediately after the 10th payment? e) If the 30 loan payments are deferred and begin at...
Suppose an investor plans to make monthly deposits into an account that pays 9% interest, compounded...
Suppose an investor plans to make monthly deposits into an account that pays 9% interest, compounded monthly, so that $100,000 will be in the account immediately after the payment at the end of Year 10. The first payment will occur at the end of Month 1 (one month from the present). How much must be deposited monthly
a) Suppose the interest rate is 6.6% per year compounded monthly. Compute the amount Sarah must...
a) Suppose the interest rate is 6.6% per year compounded monthly. Compute the amount Sarah must deposit in an account today so that she can pay herself $350 per month for the next eleven years. b) How much must Sarah deposit today if she wants to pay herself at the beginning of each month? Please show your work :)
Suppose that you drive 30, 000 miles per year and gas averages ​$4 per gallon. Complete...
Suppose that you drive 30, 000 miles per year and gas averages ​$4 per gallon. Complete parts a. and b. below. a. What will you save in annual fuel expenses by owning a hybrid car averaging 30 miles per gallon rather than an SUV averaging 9 miles per​ gallon? b. If you deposit your monthly fuel savings at the end of each month into an annuity that pays 4.8​% compounded​ monthly, how much will have saved at the end of...
A man aged 30 deposits $600 at the end of each month for 35 years into...
A man aged 30 deposits $600 at the end of each month for 35 years into a registered retirement savings account fund paying interest at 3% compounded annually. Starting on his 65th birthday, he makes 120 equal monthly withdrawals from the fund at the beginning of each month. During this period, the fund pays interest at 6% compounded annually. Calculate the amount of each withdrawal (annuity payment). A timeline may assist you in solving this calculation.
Suppose Cindy borrows $200,000 today using a 30-year fixed-rate mortgage with a 3.6% quoted interest rate...
Suppose Cindy borrows $200,000 today using a 30-year fixed-rate mortgage with a 3.6% quoted interest rate to buy a coop. She will make the first monthly payment one month from today. Her loan balance is $200,000 today. 1) What is her monthly mortgage payment? 2) What will be her loan balance after making the first monthly payment one month from today? You should show all steps to find the answer to earn full credit.
A man aged 30 deposits $500 at the end of each month for 35 years into...
A man aged 30 deposits $500 at the end of each month for 35 years into a registered retirement savings account fund paying interest at 4% compounded annually. Starting on his 65th birthday, he makes 120 equal monthly withdrawals from the fund at the beginning of each month. During this period, the fund pays interest at 7% compounded annually. Calculate the amount of each withdrawal (annuity payment). A timeline may assist you in solving this calculation. (10 points)