D Question 7 1 pts You want to save deposit) $5.232 per year, starting next year,...

Question

Question

D Question 7 1 pts You want to save deposit) $5.232 per year, starting next year, to make a down payment of $75,752 on a Vaca

Answer 1

Answer #1

Nper = payment = 5232

I/Y =Rate = 3.03%

FV = Future value =$75,752

PV = present value =0

NPER = Number of years = ?

Excel function=Nper(3.03%,-5232,0,75752)

Number of years = 12.1856 years.

Add a comment

Answer 2

Similar Homework Help Questions

Question 7 1 pts You want to save (deposit) $7,397 per year, starting next year, to...

Question 7 1 pts You want to save (deposit) $7,397 per year, starting next year, to make a down payment of $78,702 on a vacation home. If you can earn 3.97 percent on your investment, for how many years will you have to make deposits? Answer to 4 decimals.
PLEASE ANSWER EVERYTHING ASAP THANK YOU!!! Investment X offers to pay you $3,728 per year for...

PLEASE ANSWER EVERYTHING ASAP THANK YOU!!! Investment X offers to pay you $3,728 per year for 9 years, whereas Investment Y offers to pay you $4,690 per year for 5 years. What is the dollar difference (higher minus lower) in the present values of these two cash flow streams if the discount rate is 5.26 percent? Answer to two decimals. What are the annual cash flows (in $) of an annuity for 14 years, which costs $33,721 today, if the...
D Question 1 1 pts You will save $1,000 per year You can earn 8% on...

D Question 1 1 pts You will save $1,000 per year You can earn 8% on your deposits. How much will you have 15 years from now At Round your answer to 2 decimals places, for example 100.21 Question 2 1 pts You will save some amount of money for 3 years. You can earn 2% on your savings. What is the FV factor for an annuity in this problem? Round your answer to 4 decimals, for example 10.1234. DI...

To fund your dream around-the-world vacation, you plan to save $1,250 per year for the next...

To fund your dream around-the-world vacation, you plan to save $1,250 per year for the next 12 years starting one year from now. If you can earn an interest rate of 5.71 percent, how much will you have saved for your vacation? Multiple Choice o $18,431.38 o $20,018.86 o $19,832.35 o О $20,73382 $20,733.82 o $19,582.60 The value of the following cash flows four years from today is $8,487.54. The interest rate is 5.6 percent. What is the value of...
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...
You can save $2,000 per year for the next four years in an account earning 7...

You can save $2,000 per year for the next four years in an account earning 7 percent per year. How much will you have at the end of the fourth year if you make the first deposit today? (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16))

Question 13 1 pts Tom plans to save $107 a month, starting today, for 16 years....

Question 13 1 pts Tom plans to save $107 a month, starting today, for 16 years. Dick plans to save $107 a month for 16 years, starting one month from today. Both Tom and Dick expect to earn an average return of 5.7 percent APR on their savings and both will make the same number of deposits. At the end of the 16 years, how much more (in $) will Tom have than Dick? Answer to two decimals. Question 12...
Check my work You can save $2,000 per year for the next four years in an...

Check my work You can save $2,000 per year for the next four years in an account earning 7 percent per year. How much will you have at the end of the fourth year if you make the first deposit today? (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16) Future value
Question 9 5 pts You will deposit $150 each of the next five years (the first...

Question 9 5 pts You will deposit $150 each of the next five years (the first deposit will occur one year from today, and there will be a total of 5 equal deposits) into an account that pays a 7.3% effective annual rate. Six years from today, you wish to have exactly $1000 in the account. You would need to deposit an additional $_ _into the account six years from today to meet that goal. [Hints: Make a timeline! There...

Suppose you want to save $50,000 as a down payment to purchase a house in 7...

Suppose you want to save $50,000 as a down payment to purchase a house in 7 years. You plan on saving money at the beginning of each month starting today. If you can earn 3.60% APR on your investment over the time frame, how much must you save each month to reach your goal?