Question 10 (1 point) You estimate you will need $5,000 for you vacation next year. How...

Question

Question

Answer 1

Answer #1

Font Number Style fx =PMT(9%,1.5,,5000) А B C D E F F H Save 1 amount of vecation interest rate years 5000 9% 2 1.5 Function

The amount which is to be deposited today is $ 3261.02

Here the pmt function is used to solve the present value payment.

Answer 2

Similar Homework Help Questions

Question 21 (1 point) You would like to save $2000 for a trip at the end...

Question 21 (1 point) You would like to save $2000 for a trip at the end of your degree in three years. You deposit $1,000 today and will make a another deposit in 18 months. How much should you deposit so that you will have 2000 in three years if you will earn 9% simple. Use three years as your focal date. Your Answer: Answer
Question 2 pts You want to take a cruise vacation 4 years from now when you...

Question 2 pts You want to take a cruise vacation 4 years from now when you complete graduate school. You estimate that you will need $5,000 when you complete graduate school to pay for the cruise. If you can earn 9.8% interest on your deposits, how much would you have to deposit today to be able to pay for the cruise when you graduate? Round your answer to 2 decimals. For example, $100.12. D Question 2 2 pts You will...
REQUIRED LUMP SUM PAYMENT Starting next year, you will need $5,000 annually for 4 years to...

REQUIRED LUMP SUM PAYMENT Starting next year, you will need $5,000 annually for 4 years to complete your education. (One year from today you will withdraw the first $5,000.) Your uncle deposits an amount today in a bank paying 5% annual interest, which will provide the needed $5,000 payments. How large must the deposit be? Round your answer to the nearest cent. $ How much will be in the account immediately after you make the first withdrawal? Round your answer...

You want to have $12,000 in 10 years for a dream vacation. If you can earn...

You want to have $12,000 in 10 years for a dream vacation. If you can earn an interest rate of .9 percent per month, how much will you have to deposit today?
You want to take a cruise vacation 5 years from now when you complete graduate school....

You want to take a cruise vacation 5 years from now when you complete graduate school. You estimate that you will need $5,000 when you complete graduate school to pay for the cruise. If you can earn 5.9% interest on your deposits, how much would you have to deposit today to be able to pay for the cruise when you graduate? Round your answer to 2 decimals. For example, $100.12.
Answer Question 5 (1 point) You decide to begin saving for your retirement. Each month you...

Answer Question 5 (1 point) You decide to begin saving for your retirement. Each month you will deposit $400 in to an account that earns J12 = 10%. How much money will you have in 6 years if your first payment in one month? Your Answer: Answer Question 6 (1 point) You decide to begin saving for a vacation. Each month you will deposit $250 in to a account that earns J12 = 10%. How much interest will you earn...

How much should you deposit today in order to withdraw $5,000 each year for 7 years?...

How much should you deposit today in order to withdraw $5,000 each year for 7 years? Your first withdraw will start 5 years from now and your deposit will earn 4% interest.
If you invest $5,000 annually for the next 20 years and earn 9% per year (20...

If you invest $5,000 annually for the next 20 years and earn 9% per year (20 deposits, annuity, AER rate) . . A. How much will you have at the end of the 20th year (T20), if the first deposit is 1 year from now (at T1) ? B. How much will you have at the end of the 20th year, if the first deposit is made immediately (at T0) ?
give you $1,000 per year for the next 10 1. Your grandmother has offered to give...

give you $1,000 per year for the next 10 1. Your grandmother has offered to give you $1,000 per year to what is the present value of this 10-year. $1.000 annuity discounted back to the present at 5 percent? What will be the present value if you received the $1,000 payment at the beginning of each year? 2. You are graduating from college at the end of this semester, and you have decided to invest $5000 a year for the...

please answer Question 5 20 pts You would like to purchase a vacation home in 10...

please answer Question 5 20 pts You would like to purchase a vacation home in 10 years. The current price of such a home is $500,000 but the price of these types of homes is rising at a rate of 3% per year. How much would you have to invest today in nominal terms to exactly pay for the vacation home if your investments earn 5% APR (compounded annually) in nominal terms? o $412,524 o $427,375 O $671,958 O $306,957