Question

In: Finance

a. You have saved up for retirement in an annuity account. This account earns a return of 7% on annual basis but compounded monthly.

 

a. You have saved up for retirement in an annuity account. This account earns a return of 7% on annual basis but compounded monthly. You are due to retire in 6 years from now. You will receive monthly payments of $2,400 at the end of each month after retiring, for 15 years. How much have you saved up in this account today?

b. Two banks are competing to give a loan to you for $150,000 with 30-year term to maturity, bank a is offering 6% with quarterly compounding while bank b is offering 5.98% with daily compounding. Which bank should you take the loan from? Support your answer with calculations.

c. A contract requires you to make a payment of $2,500 immediately upfront and additional three payments of $500 each at the end of next three years. If interest rate on this investment is 8.5%, calculate the present value of the contract?

Solutions

Expert Solution

a)

number of periods in retirement = 15*12 = 180

Interest rate = 7%/12

[N = 180 ; I/Y = 7%/12 ; PV = ? ; PMT = 2400 ; FV = 0] Compute (CPT button) for PV

Present value = $267,014.30 (at t = 6)

Present value today (at t = 0)

number of periods = 6*6 = 36 periods

[N = 36 ; I/Y = 7%/12 ; PV = ? ; PMT = 0 ; FV = 267014.30]

so balance today = $216,569.68

b)

(we do not need calculator to solve this question)

We must calculate Effective annual rate (EAR) for both banks and compare them. we should choose the bank with Lower EAR

EAR = (1+(r/n))^n - 1

r = Nominal rate

n = number of compounding periods

Bank a:

EAR = (1 + (6%/4))^4 - 1 = 6.136%

Bank b:

EAR = (1 + (5.98%/365))^365 - 1 = 6.162%

Since EAR of Bank a is lower we should select Bank a

c)

Present value of 500 payments

[N = 3 ; I/Y = 8.5% ; PV = ? ; PMT = 500 ; FV = 0]

PV = 1277.01

Present value of contract = 1277.01 + 2500 = $3777.01


Related Solutions

You have $300,000 saved for retirement. Your account earns 7% interest. How much will you be...
You have $300,000 saved for retirement. Your account earns 7% interest. How much will you be able to pull out each month, if you want to be able to take withdrawals for 25 years? $
Lydia saved $1,345,000 for retirement. The money is deposited in an account earning 3.2% compounded monthly....
Lydia saved $1,345,000 for retirement. The money is deposited in an account earning 3.2% compounded monthly. She is going to withdraw $5500 per month for living expenses. Create a table showing how much interest she earns each month and her monthly balance for the first 5 months of her retirement. Do this by hand with just the functions of a scientific calculator.
A bank offers a retirement annuity that earns 4% APR, compounded monthly. Each person wants to...
A bank offers a retirement annuity that earns 4% APR, compounded monthly. Each person wants to have at least $200,000 in the account when they retire. For each retirement plan described, determine: the monthly deposit, the total length of time they spent investing, the amount in their account at the end of the investing time, the total amount of money they invested, and the total amount of interest they earned. Round monthly deposits up to the cents place and other...
You have $400,000 saved for retirement. Your account earns 9%interest. How much will you be...
You have $400,000 saved for retirement. Your account earns 9% interest. How much will you be able to pull out each month, if you want to be able to take withdrawals for 20 years?
You will deposit $9000 into an account with an annual interest rate of 7% compounded monthly,...
You will deposit $9000 into an account with an annual interest rate of 7% compounded monthly, leave the account untouched for 18 years, and then withdraw equal amounts at the end of each month for the following 9 years, ending with a balance of $9000. What will your monthly withdrawals be?
You have $100,000 in an account that earns 2% APR (Compounded monthly) You want to earn...
You have $100,000 in an account that earns 2% APR (Compounded monthly) You want to earn a higher rate of return and therefore are considering two alternative investments. You will put your $100,000 in one of the two new accounts. Investment 1 will pay you $860 per month for starting next month 120 months. Investment 2 will pay you $2,600 per month for starting next month 40 months. Which account should you choose and how much does it increase your...
You have $100,000 in an account that earns 2% APR (Compounded monthly) You want to earn...
You have $100,000 in an account that earns 2% APR (Compounded monthly) You want to earn a higher rate of return and therefore are considering two alternative investments. You will put your $100,000 in one of the two new accounts. Investment 1 will pay you $860 per month for starting next month 120 months. Investment 2 will pay you $2,600 per month for starting next month 40 months. Which account should you choose and how much does it increase your...
Alexander is setting up a retirement account. If the interest rate is 6.15% compounded monthly, then...
Alexander is setting up a retirement account. If the interest rate is 6.15% compounded monthly, then after making 40 years of monthly payment of $1,200 into the account at the end of each month, then he will have $_________ in the account. Using the TVM Solver, the value for PV= _______ and the value for PMT= _______. At the end of the 40 years, the total interest that Alexander will have earned would be $________.
FINANCE: 3. 3A. You have $500,000 saved for retirement. Your account earns 9% interest. How much...
FINANCE: 3. 3A. You have $500,000 saved for retirement. Your account earns 9% interest. How much will you be able to pull out each month, if you want to be able to take withdrawals for 15 years? 3B. You want to be able to withdraw $40,000 each year for 15 years. Your account earns 7% interest. How much do you need in your account at the beginning? $ How much total money will you pull out of the account? $...
You invest $1,190,000 into a retirement account and earn 9.00% per year, compounded monthly. At retirement...
You invest $1,190,000 into a retirement account and earn 9.00% per year, compounded monthly. At retirement your account balance is $5,430,000. Over how many years did you make this investment? PLEASE ANSWER WITH EXCEL
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT