Question

You have decided to begin saving for a vacation to Hawaii. You believe that the full...

You have decided to begin saving for a vacation to Hawaii. You believe that the full cost of the vacation, with airfare, accommodations, and dining will be $5,000. You are going to begin saving $150 per month, beginning one month from today. If your account pays interest at a rate of 7.2% APR compounded monthly, how many months will it take to save $5,000? Round your answer UP to the nearest whole month.

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Number of months to save $5,000 is calculated using NPER function in Excel :

rate = 7.2%/12 (converting annual rate into monthly rate)

pmt = -150 (Monthly saving. This is entered with a negative sign because it is a cash outflow)

pv = 0 (amount currently saved is zero)

fv = 5000 (required ending value of account)

NPER is calculated to be 30.48

This is rounded up to 31

It will take 31 months to save $5,000

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You plan on going on a 11 month vacation 9 months from now. You can pay...
You plan on going on a 11 month vacation 9 months from now. You can pay $4,118 per month during the vacation, or you can pay $33,934 today. If you pay today, how much does it save (or cost) you in present value term if your investments earn 4.85% APR (compounded monthly)? If it costs you more to pay today, state your answer with a negative sign (eg., -2000).
You want to open a savings account and you have 3 choices: 1) a saving account...
You want to open a savings account and you have 3 choices: 1) a saving account that pays interest of 7.2% compounded quarterly (In other words, it offers an APR=7.2%, compounded quarterly), 2) a saving account that pays interest of 6.8% compounded monthly, and 3) a saving account that pays interest of 7% continuously compounded? Which one do you prefer?
You begin saving for retirement at age 25, and you plan to retire at age 70....
You begin saving for retirement at age 25, and you plan to retire at age 70. You want to deposit a certain amount each month into an account that pays an APR of 3% compounded monthly. Make a table that shows the amount you must deposit each month in terms of the nest egg you desire to have when you retire. (Round your answers to the nearest cent.)
You just decided to begin saving for retirement. You will make deposits of $1,000 per month...
You just decided to begin saving for retirement. You will make deposits of $1,000 per month into a retirement account that earns 8.00% p.a. The first deposit is made today and the last deposit will be made when you retire exactly 30 years from today. (Note: you make 361 total monthly deposits into your retirement account.) You will begin to make withdrawals from the account the first month after you retire. If you plan to live an addition 25 years...
a. You plan on going on a 8 month vacation 8 months from now. You can...
a. You plan on going on a 8 month vacation 8 months from now. You can pay $3,904 per month during the vacation, or you can pay $24,441 today. If you pay today, how much does it save (or cost) you in present value term if your investments earn 4.39% APR (compounded monthly)? If it costs you more to pay today, state your answer with a negative sign (eg., -2000). b. You've just been hired at a new job. You...
You just decided to begin saving for retirement. You will make deposits of $1,000 per month...
You just decided to begin saving for retirement. You will make deposits of $1,000 per month into a retirement account that earns 8.00% p.a. The first deposit is made today and the last deposit will be made when you retire exactly 30 years from today. The day you retire you will buy an RV for $240,000. You will begin to make withdrawals from the account the first month after you retire. If you plan to live an addition 25 years,...
You have been saving money to buy a home and today, you decided to buy a...
You have been saving money to buy a home and today, you decided to buy a home and take out $350,000 mortgage loan from a bank. This loan requires you to make a monthly payment for 30 years and the interest rate on your loan is 4% APR compounded monthly. What is your monthly mortgage payment for this loan? Please show your excel formula in your answer and explain step-by-step calculation to arrive to your answer.
a. You plan to take a vacation in 10 months that will cost $8,167 How much...
a. You plan to take a vacation in 10 months that will cost $8,167 How much do you have to invest today to just fund your vacation if your investments earn 4.7% APR (compounded monthly)? b. You will have a property tax payment due in 10 months that will cost $8,292. How much do you have to invest today to have just enough to pay your property tax bill if your investments earn 4.9% APR (compounded monthly)?
You begin saving for retirement at age 25, and you plan to retire at age 60....
You begin saving for retirement at age 25, and you plan to retire at age 60. You want to deposit a certain amount each month into an account that pays an APR of 6% compounded monthly. Make a table that shows the amount you must deposit each month in terms of the nest egg you desire to have when you retire. (Round your answers to the nearest cent.) Nest egg size Needed deposit $100,000 $ $200,000 $ $300,000 $ $400,000...
You decided to save money for a travel to Barcelona in two years. You decided to...
You decided to save money for a travel to Barcelona in two years. You decided to open a savings account and make equal monthly deposits for the next two years. You think that you need to save $5,000. You checked a few banks to find out the best savings account and identified one, the APR of which is 3.6%. You will receive interests every month and you are going to keep those received interests in your savings account. How much...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT