Question

Chuck needs to purchase a piece of machinery in 10 years. The item costs $1,800 today...

Chuck needs to purchase a piece of machinery in 10 years. The item costs $1,800 today but its price inflates 4% per year. He will also have to pay sales tax of 7% on the purchase. To finance the purchase, Chuck deposits $50 into an account at the beginning of each quarter for the next 10 years. The effective annual interest rate is 6.5%. a) Will the balance of the fund be sufficient to purchase the piece of machinery in 10 years? (b) How much extra money will Chuck have to pay or how much extra will he have saved?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

First we will calculate the future value of Machinery;-

Future Value = Present Value (1+infiliation rate)time period

= 1800(1+0.04)10

= $ 2664.44

Since, the purchase of machine attracts sales Tax of 7%.

Final Cost of Machinery = 2664.44(1+0.07)

= $ 2850.95

So, the final price of machinery will be $ 2850.95 in 10 years.

Now, we will calculate future value of quarterly investment made by Chuck using the Future Value of Annuity Due formula:-

FV = P* [(1+r) – 1] *(1+r)

where, P= periodic payment ;= $50

FV= future Value

r = Periodic Interest rate ;= (.065/12)*3 ;= 0.01625

n = No of period ;= 10 years*4 quarters ;= 40

FV = 50* 1 [(1 + 0.01625) 40 - 11 0.01625 *(1 + 0.01625)

FV = $2831.61

a). So, the balance of the fund is $ 2831.61

Since, Machinery will cost $ 2850.95 in 10 years. Hence, the balance fund is insufficient to purchase machinery in 10 years.

b). Since, the balance fund is less, Chuck has to pay Extra money which is = $2850.95-$2831.61

= $19.34

If you need any clarification regarding this solution, then you can ask in comments

If you like my answer then please Up-vote as it will be motivating.

Add a comment
Know the answer?
Add Answer to:
Chuck needs to purchase a piece of machinery in 10 years. The item costs $1,800 today...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A Firm needs to replace most of its machinery in five years at a cost of...

    A Firm needs to replace most of its machinery in five years at a cost of $500,000. The company wishes to create a sinking fund to have this money available in five years. How much should the quarterly deposits be if the fund earns 8%? Use MS-Excel to illustrate the accumulation of funds over the five year period.

  • Today is Derek's 25th birthday. Derek has been advised that he needs to have $2,081,021.00 in...

    Today is Derek's 25th birthday. Derek has been advised that he needs to have $2,081,021.00 in his retirement account the day he turns 65. He estimates his retirement account will pay 9.00% interest. Assume he chooses not to deposit anything today. Rather he chooses to make annual deposits into the retirement account starting on his 29.00th birthday and ending on his 65th birthday. How much must those deposits be? Suppose you deposit $2,961.00 into an account today. In 6.00 years...

  • Today is Derek’s 25th birthday. Derek has been advised that he needs to have $2,907,389.00 in...

    Today is Derek’s 25th birthday. Derek has been advised that he needs to have $2,907,389.00 in his retirement account the day he turns 65. He estimates his retirement account will pay 5.00% interest. Assume he chooses not to deposit anything today. Rather he chooses to make annual deposits into the retirement account starting on his 30.00th birthday and ending on his 65th birthday. How much must those deposits be? Suppose you deposit $2,199.00 into an account today. In 7.00 years...

  • [ALL OF THESE MUST BE DONE IN EXCEL] 1. Future value: Chuck Tomkovick is planning to invest $3,000 today in a mutual fu...

    [ALL OF THESE MUST BE DONE IN EXCEL] 1. Future value: Chuck Tomkovick is planning to invest $3,000 today in a mutual fund that will provide a return of 8 percent each year. What will be the value of the investment in 10 years? 2. Future value: Ted Rogers is investing $7,00 in a bank CD that pays a 6 percent annual interest. How much will the CD be worth at the end of five years? 3. Future value: Your...

  • Today is Derek’s 25th birthday. Derek has been advised that he needs to have $2,847,524.00 in...

    Today is Derek’s 25th birthday. Derek has been advised that he needs to have $2,847,524.00 in his retirement account the day he turns 65. He estimates his retirement account will pay 7.00% interest. Assume he chooses not to deposit anything today. Rather he chooses to make annual deposits into the retirement account starting on his 26.00th birthday and ending on his 65th birthday. How much must those deposits be?

  • Today is Derek’s 25th birthday. Derek has been advised that he needs to have $2,362,525.00 in...

    Today is Derek’s 25th birthday. Derek has been advised that he needs to have $2,362,525.00 in his retirement account the day he turns 65. He estimates his retirement account will pay 7.00% interest. Assume he chooses not to deposit anything today. Rather he chooses to make annual deposits into the retirement account starting on his 29.00th birthday and ending on his 65th birthday. How much must those deposits be?

  • Today is Derek’s 25th birthday. Derek has been advised that he needs to have $2,427,268.00 in...

    Today is Derek’s 25th birthday. Derek has been advised that he needs to have $2,427,268.00 in his retirement account the day he turns 65. He estimates his retirement account will pay 8.00% interest. Assume he chooses not to deposit anything today. Rather he chooses to make annual deposits into the retirement account starting on his 30.00th birthday and ending on his 65th birthday. How much must those deposits be?

  • 4. John is 25 years old right now. He needs $650,000 at age of 65 to...

    4. John is 25 years old right now. He needs $650,000 at age of 65 to retire comfortably. If his mutual fund account can generate an average annual rate of return of 7%, how much money he needs to put in right now? 5. Bank Certificate of Deposit (CD) gives you 3% interests, how much money will you have in 20 years when you deposit $7500 today? 6. John deposits $1000 into company Raw IRA each month (another type of...

  • BE6-3 (L02) Candice Willis will invest $30,000 today. She needs $150,000 in 21 years. What annual...

    BE6-3 (L02) Candice Willis will invest $30,000 today. She needs $150,000 in 21 years. What annual interest rate must she earn? BE6-6 (L03) Steve Madison needs $250,000 in 10 years. How much must he invest at the end of each year, at 5% interest, to meet his needs? BE6-7 (L02) John Fillmore’s lifelong dream is to own his own fishing boat to use in his retirement. John has recently come into an inheritance of $400,000. He estimates that the boat...

  • Problem. A company borrowed $4,250,000 at an effective rate of 4.25% for 5 years. To make...

    Problem. A company borrowed $4,250,000 at an effective rate of 4.25% for 5 years. To make sure it has the money needed to repay the loan when it comes due, the company is making deposits into a sinking fund at the beginning of each quarter. The sinking fund pays the company 3.21%. (a) How much will the company need to have at maturity to pay off this loan? (b) How much should each sinking fund payment be? You must show...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT