Question

Please show your steps for each part of the problem, and if a calculator was used,...

Please show your steps for each part of the problem, and if a calculator was used, list the button combination pressed in order to arrive at your answer!

a. Jack and Jill are twins and at 20 years of age they both opened separate investment accounts with an on online broker. Jack started investing $50 a month starting from today. Jill will save $55 a month starting at the end of the month. if this investment account gives them 8% annual return on investment, how much money will each have accumulated when they both retire at age 65?

b. 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?

c. 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.

d. 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?

Homework Answers

Answer #1

a)

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
Please show all your work step by step all the formula that is used A. How...
Please show all your work step by step all the formula that is used A. How much will you have saved after 6 years by contributing $1200 at eh end of each year if you expected to earn 11% on the investment? B. A business owner plans to deposit his annual profits in an investment account earing a 9% annual return. If the owner starts with their first deposit today for $22000. And expects to make the same profit for...
Please show what to enter on financial calculator to find the answer. Currently, I have $2,500...
Please show what to enter on financial calculator to find the answer. Currently, I have $2,500 in my bank account that pays 6% APR with monthly compounding. In order to have $12,000 in this account in 5 years, how much money should I add to this account each month starting from next month?
PLEASE SHOW HOW TO SOLVE USING FINANCIAL CALCULATOR. 20) Suppose Oppenheimer Bank is offering a 30-year...
PLEASE SHOW HOW TO SOLVE USING FINANCIAL CALCULATOR. 20) Suppose Oppenheimer Bank is offering a 30-year mortgage with an EAR of 6.80%. If you plan to borrow $150,000, what will your monthly payment be? 24) What is the present value (PV) of an investment today that pays $10,000 every year for four years, starting one year from today? Assume the interest rate is 7% APR, compounded quarterly. 25) You just deposited $2,500 in a bank account that pays a 12%...
Please answer all parts of problem :) a) You borrowed $3,000 with "Add-on Interest" at 9%...
Please answer all parts of problem :) a) You borrowed $3,000 with "Add-on Interest" at 9% with 12 equal monthly payments to payoff the loan. What is the actual interest rate the lender is charging you in this deal. Choose the correct answer: 9% 13.51% 12.48% 10.15% 16.22% b) XYZ Inc entered in a 4 year contract with a client. XYZ will receive following cash flows at the end of each year. If they can earn 6% annual interest, what...
Q1: Jill wants to buy a car but needs to calculate how much she can afford...
Q1: Jill wants to buy a car but needs to calculate how much she can afford to borrow. The maximum she can repay each month-end is $560 per month and the bank has indicated it will charge a fixed 8.0% p.a compounding monthly. If she takes a loan for 5 years how much can she afford to borrow? (Do not use the $ sign or commas; include cents e.g 24500.09) Q2: Payments of $200 per month are deposited into a...
Assume that today is the first day of the month and that it is also your...
Assume that today is the first day of the month and that it is also your first day of retirement. You have saved for retirement over the years and have accumulated $499,000 in an investment account from which you plan to make monthly withdrawals during your retirement starting at the end of this month. Assuming you can earn annual returns of 7.5% in your investment account during your retirement years, how much money can you withdraw every month to make...
Excel retirement problem:  You just got your first job and plan to start saving for...
Excel retirement problem:  You just got your first job and plan to start saving for retirement by investing with each monthly paycheck.  You plan to retire in 45 years.  In 50 years, you want to give your daughter a gift of $1,000,000.  You will receive an inheritance from a rich great-uncle of $250,000 in 20 years.  You think you will want $150,000 every year when you retire, starting the day you retire. You plan to...
Question 2. You have approached Commonwealth Bank for a loan to buy a house. The bank...
Question 2. You have approached Commonwealth Bank for a loan to buy a house. The bank offers you a $500 000 loan, repayable in equal monthly instalments at the end of each month for the next 30 years. Required: a. If the interest rate on the loan is 4.5% per annum, compounded monthly, what is your monthly repayment (to the nearest dollar)? b. What is your weekly payment if you wish to pay weekly instalments and the interest rate is...
PART 2 - HOMEWORK 3 - Time Value of Money (30 pts) Please use Excel to...
PART 2 - HOMEWORK 3 - Time Value of Money (30 pts) Please use Excel to answer the following questions. Print an Excel spreadsheet that presents your answers to these TVM questions and also print the formula sheet that shows how you calculated your answers.   1 Calculate the present value of 120 monthly payments of $300 at an annual rate of 8%. The payments are made at the end of each month. 2 You are financing a new car with...
Please show the below problem in Excel: John and Peggy would like to buy a house....
Please show the below problem in Excel: John and Peggy would like to buy a house. They have looked at their budget and determined that they can afford a maximum monthly mortgage payment of $1,100. Interest rates on 30-year, fixed-rate mortgages currently have a nominal annual interest rate of 7 percent with monthly compounding (payments due at the end of each month). Given these loan terms, what is the maximum amount John and Peggy borrow today to purchase a house...