Question

The user wants to save money to buy a new car 10 years from today. Have...

  1. The user wants to save money to buy a new car 10 years from today. Have the user input the amount that they can invest at the start of each year and the price of the car that they want to buy. What annual interest rate will they need to earn in order to be able to buy the car 10 years from today?

Note: This question is from excel for accounting, so the calculation should be made in an excel format.

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

$10,000 and $55,000 are taken as an example, any figure can be entered and the Annual interest rate will change accordingly.

1 is added at the end of the formula to signify the type of annuity, as the payment is made at the start of each year, hence it is an annuity due, if payments were made at the end then 0 would have been taken.

Cal:

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 to buy a new house in 13 years you want to save money for...
you plan to buy a new house in 13 years you want to save money for a downnpayment on the new house you are able to place $394 every month at the end of the month into a savings account at an annual tate of 13.46percent compounded monthly how much money will be in the account after you made the last payment
Abdullah wants to buy a car in 6 years. His dream car costs AED 300,000 today...
Abdullah wants to buy a car in 6 years. His dream car costs AED 300,000 today and car prices are expected to increase at a rate of 15% per year for the next 6 years. Calculate the amount that he needs to save on a monthly basis to buy his dream car in 5 years, if he can earn a 12% interest compounded monthly on his savings account.
Suppose you want to buy a car of $ 140,000 after 10 years. To buy it,...
Suppose you want to buy a car of $ 140,000 after 10 years. To buy it, you will save equal amount of money from the end of this year. How much do you have to save per year? The annual interest rate is 5% I. $ 9,854.45 II. $ 111,30.64 III. $ 12,696.61 IV. $ 233,743.5
You plan to buy a house in 11 years. You want to save money for a...
You plan to buy a house in 11 years. You want to save money for a down payment on the new house. You are able to place $286 every month at the end of the month into a savings account at an annual rate of 6.54 percent, compounded monthly. How much money will be in the account after you made the last payment?
You plan to buy a house in 6 years. You want to save money for a...
You plan to buy a house in 6 years. You want to save money for a down payment on the new house. You are able to place $401 every month at the end of the month into a savings account at an annual rate of 14.64 percent, compounded monthly. How much money will be in the amount after you made the last payment?
A couple just had a baby and wants to save enough money for a new car...
A couple just had a baby and wants to save enough money for a new car when the baby turns 18. Earning interest at 3.5% compounded quarterly how much does the couple need to invest every three months to have 97,000 in the investment by the time the baby is 18?
You plan to buy a house in 7 years. You want to save money for a...
You plan to buy a house in 7 years. You want to save money for a down payment on the new house. You are able to place $353 every month at the end of the month into a savings account at an annual rate of 10.73 percent, compounded monthly. How much will be in the account after you made the last payment? Round the answer to the two decimal places.
Your company wants to save $165,000 to buy new equipment 42 months from now. The plan...
Your company wants to save $165,000 to buy new equipment 42 months from now. The plan is to set aside an equal amount of money on the first day of each quarter starting today. The company can earn 6.25% annually. How much does the company have to save each quarter to achieve the goal?
Suppose James wants to buy a car in 3 years’ time and estimates that he will...
Suppose James wants to buy a car in 3 years’ time and estimates that he will need $25,000. The interest rate that he can earn from a savings account is 6% per annum. If James can put in $7,000 today, $6,000 in one year’s time and $5,000 in 2 years’ time, how much will he have to come up with at the end of the third year to buy his car? A. He does not require more money as the...
Suppose James wants to buy a car in 3 years’ time and estimates that he will...
Suppose James wants to buy a car in 3 years’ time and estimates that he will need $25,000. The interest rate that he can earn from a savings account is 6% per annum. If James can put in $7,000 today, $6,000 in one year’s time and $5,000 in 2 years’ time, how much will he have to come up with at the end of the third year to buy his car? A. He does not require more money as the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT