Question

In: Finance

You're trying to save to buy a new $80,000 speedboat to take to the lake. You...

You're trying to save to buy a new $80,000 speedboat to take to the lake. You have $65,000 today that can be invested at your bank. The bank pays 6% annual interest on its accounts. How long will it be before you have enough to buy the speedboat?

Solutions

Expert Solution

Future value = 80000

Present value = 65000

Interest rate per year = 6%

The number of years required can be solved by using NPER function of excel

=NPER(0.06,0,-65000,80000,0)

= 3.56 years

Hence after 3.56 years the speedboat can be bought

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

You're trying to save to buy a new $170,000 Ferrari. You have $40,000 today that can...
You're trying to save to buy a new $170,000 Ferrari. You have $40,000 today that can be invested at your bank. The bank pays 5.5 percent annual interest on its accounts. How long will it be before you have enough to buy the car? Multiple Choice 27.02 years 25.02 years 27.52 years 26.77 years 27.27 years
You're trying to save to buy a new $180,000 Ferrari. You have $44,000 today that can be invested at your bank.
You're trying to save to buy a new $180,000 Ferrari. You have $44,000 today that can be invested at your bank. The bank pays 4.0 percent annual interest on its accounts. How long will it be before you have enough to buy the car?
You’re trying to save to buy a new $195,000 Ferrari. You have $32,000 today that can...
You’re trying to save to buy a new $195,000 Ferrari. You have $32,000 today that can be invested at your bank. The bank pays 3.9 percent annual interest on its accounts. How long will it be before you have enough to buy the car? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) length of time _____ years
You’re trying to save to buy a new $180,000 Ferrari. You have $29,000 today that can...
You’re trying to save to buy a new $180,000 Ferrari. You have $29,000 today that can be invested at your bank. The bank pays 3.6 percent annual interest on its accounts. How long will it be before you have enough to buy the car? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Length of Time in years?
You need to save a total of $7,500 in order to buy a new motorcycle. You...
You need to save a total of $7,500 in order to buy a new motorcycle. You are starting with savings of $4,000 but will make no additional contributions. The annual interest rate is 5%. In excel compute how long you would need to wait in order to reach your goal for interest that is compounded annually, semi-annually, quarterly, monthly, weekly, and daily. Which of the following accurately depicts this calculation?
You're saving to buy a new truck that costs $35,000. You have $28,000 today that can...
You're saving to buy a new truck that costs $35,000. You have $28,000 today that can be invested at your bank. The bank pays 4.5 percent annual interest on its accounts. It will be ______ years before you have enough to buy the truck. (Round your answer to 2 decimal places. (e.g., 32.16))
You are trying to decide how much to save for retirement. Assume you plan to save...
You are trying to decide how much to save for retirement. Assume you plan to save $8,000 per year with the first investment made one year from now. You think you can earn 5.5​% per year on your investments and you plan to retire in 32 ​years, immediately after making your last $8,000 investment. a. How much will you have in your retirement account on the day you​ retire? b.​ If, instead of investing $8,000 per​ year, you wanted to...
You are trying to decide how much to save for retirement. Assume you plan to save...
You are trying to decide how much to save for retirement. Assume you plan to save $ 6,500 per year with the first investment made one year from now. You think you can earn 5.0​% per year on your investments and you plan to retire in 36 ​years, immediately after making your last $ 6,500 investment. a. How much will you have in your retirement account on the day you​ retire? b.​ If, instead of investing $ 6,500 per​ year,...
You are trying to decide how much to save for retirement. Assume you plan to save...
You are trying to decide how much to save for retirement. Assume you plan to save $5,000 per year with the first investment made one year from now. You think you can earn 10.0​% per year on your investments and you plan to retire in   43 ​years, immediately after making your last $5,000 investment. a. How much will you have in your retirement account on the day you​ retire? b.​ If, instead of investing $5,000 per​ year, you wanted to...
You are trying to decide how much to save for retirement. Assume you plan to save...
You are trying to decide how much to save for retirement. Assume you plan to save $6,000 per year with the first investment made one year from now. You think you can earn ​10.0% per year on your investments and you plan to retire in 34 ​years, immediately after making your last $6,000 investment. a. How much will you have in your retirement account on the day you​ retire? b.​ If, instead of investing $6,000 per​ year, you wanted to...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT