Question

3. (10 pts) Six years from today you need $600,000. You plan to deposit $5000 monthly, with the first payment to be made now.

3,4,5,6. can you explain me how to do it!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

3.

Interest rate per month is (12% / 12) = 1%.

The amount accumulated in six years is calculated below:

Accumulated amount = Cash flow x / (1+i) - 1 (1-(1 + i)-1

Accumulated amount = 5,000 x ((1+0.01 12x6 - 1 1-(1 + 0.01)-1

Accumulated amount = 5,000 x 105.75703

Accumulated amount = 528,785.15

Thus, the amount of $5,000 is not enough to have $600,000 in six years.

Add a comment
Know the answer?
Add Answer to:
3,4,5,6. can you explain me how to do it! 3. (10 pts) Six years from today...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2. (10 pts) You borrow $40,000 from the local bank at 5% APR, compounded monthly on...

    2. (10 pts) You borrow $40,000 from the local bank at 5% APR, compounded monthly on a 6-year loan but you want to pay for the loan with payments every four months. (a) What is your effective interest on your 4-month payment? (b) What is your payment made every four months? (c) What is the APY for your loan with your payments??

  • Question 5 10 pts You borrow $400,000 at a rate of 5% per year compounded monthly...

    Question 5 10 pts You borrow $400,000 at a rate of 5% per year compounded monthly and make monthly payments for 2 years to repay the loan. What Excel function can be used to calculate the loan payment amount? =PMT((5/12)%, 240, -400000) =PMT(5%, 20, -400000) =PMT((5/12)%, 24,-400000) =PMT(5%, 240, 400000)

  • You would like to save annually for buying a car 6 years from today. Suppose the...

    You would like to save annually for buying a car 6 years from today. Suppose the first deposit is made today and the last deposit will be made 5 years from now. Assume the car will cost you $30,000 and your deposits earn you interest at 6% p.a. compounded annually. a. What is your annual deposit amount? b. Instead of making annual deposits, you would like to make your deposit monthly and the bank is happy to pay your interest...

  • You are looking at buying a car. You negotiate the price of the car down to...

    You are looking at buying a car. You negotiate the price of the car down to $16,000. You have $6,000 in cash, so you’ll borrow $10,000 to purchase the car. The dealer offers you a loan that has an APR of 4%, compounded monthly, with monthly payments starting next month and lasting 5 years. What would be the monthly payment?

  • Can anyone help me solve these without excel? 1) If Serena invests $10,000 today in a...

    Can anyone help me solve these without excel? 1) If Serena invests $10,000 today in a project and receives $7,000 one year from today and $5,000 two years from today in return, what is her annual internal rate of return? You can assume that her effective annual discount rate is 20%. 2) Jamie will buy a $2,000,000 house today. She will make a 20% deposit, and borrow the remaining amount in the form of a mortgage. She will repay the...

  • 1- Your rich aunt wants to finance four years of college for you. Assuming an annual...

    1- Your rich aunt wants to finance four years of college for you. Assuming an annual cost of $19,000, how much money must she put in your college fund now to cover the entire cost of your college education if the fund earns 6% per year. 2- You just bought a used car for $7,000 with no down payment using dealer financing at 5% APR compounded monthly. If you make monthly payments of $500, how many months will it take...

  • 1, you are offered to receive $200, $250, $300,$350 and $400 at the end of each...

    1, you are offered to receive $200, $250, $300,$350 and $400 at the end of each year the first payment of $200 is giving to you two years from now. if your money can earn 5% annual rate. how much you should pay for this deal? 2, your father will retire in 10 years. if he needs $25,000 per years for 10 years after retirement. how much he have to save at the end of each year in the next...

  • (3 pts) Bob would ike to have $20,000 in 4 years to use as a down...

    (3 pts) Bob would ike to have $20,000 in 4 years to use as a down payment on a future house purchase. He has no money saved up now, but plans on depositine 5375 per month at the end of every month to save for this goal. What is the periodic interest rate Bob must earn to reach his goal? What is the Annual Percentage rate? 1) Periodic Nominal APR) (3 pts) Sue has $30,000 to use as a down...

  • QUESTION 5 Suppose you want to buy a house that costs $750,000. You are required to...

    QUESTION 5 Suppose you want to buy a house that costs $750,000. You are required to put 10% down, which means the amount to be borrowed is 90% of the price of the house. If you want a 30 year mortgage, and the borrowing rate is 5.6% APR compounded monthly, what would be your monthly payment? (Answer to the nearest penny) 5 points    QUESTION 6 Suppose you want to buy a car that costs $17,000. If the dealer is...

  • 1) (3 pts) Bob would like to have a total savings of $30,000 in 6 years...

    1) (3 pts) Bob would like to have a total savings of $30,000 in 6 years to use as a down payment on a future house purchase. He has no money saved up now, but plans on depositing $350 per month at the end of every month to save for this goal. What is the periodic interest rate Bob must earn to reach his goal? What is the Annual Percentage rate? 1 Periodic *.ㅡ I Nominal (APR)- % 2) (3...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT