You need to have $34,500 in 14 years. You can earn an annual interest rate of 5 percent for the first 4 years, 5.6 percent for the next 3 years, and 6.3 percent for the final 7 years. How much do you have to deposit today?

You need to have $34,500 in 14 years. You can earn an annual interest rate of 5 percent for the first 4 years, 5.6 percent for the next 3 years, and 6.3 percent for the final 7 years. How much do you have to deposit today?

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 3PB: Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate...

See similar textbooks

Related questions

Q: year, to make a down payment of $75,752 on a vacation home If you can earn 3.03 percent on your…

A: The future value idea is a useful tool for investors to compare various investment prospects.…

Q: How much should you deposit at the end of each month into an investment account that pays 8.5%…

A: Retirement income is the money one receives after they stop working, either through savings,…

Q: You have a chance to buy an annuity that pays $50,000 at the beginning of each year for 15 years.…

A: Present value means today’s value of money you expect to receive or pay in future. PV = PMT…

Q: (Comprehensive problem) You would like to have $52,000 in 15 years. To accumulate this amount, you…

A: An ordinary annuity can be seen as a certain set of regular payments or deposits made to either…

Q: (Comprehensive problem) You would like to have $52,000 in 12 years. To accumulate this amount, you…

A: Future value = $52,000Period = 12 yearsInterest rate = 10% compounded annually

Q: Assume you graduate from college with $26,000 in student loans. If your interest rate is fixed at…

A: Loan amount (X) = $26000 r = 5% per annum = 5%/12 = 0.4167% per month n = 10 years = 120 months Let…

Q: If you deposit the money in the bank, how much will you have in one year?

A: The time value of money implies that the cash in hand at present has a higher value than the cash…

Q: You are considering taking out a loan of $17,000.00 that will be paid back over 5 years with monthly…

A: Here,ParticularsValuesLoan amount (PV) $ 17,000.00Term of loan 5.00Number of months in a…

Q: Suppose that you borrow $200,000 in the form of a 12-year loan with an annual interest rate of 6%…

A: Loan value: $200,000Time period: 12 years , which is 144 monthsInterest rate: 6% p.a, which is 0.5%…

Q: Suppose you deposit $10 every week into an account that earns 4% interest compounded weekly. How…

A: The future value is the amount that will be received at the end of a certain period. In simple…

Q: You just opened a brokerage account, depositing $4,500. You expect the account to earn an interest…

Q: u want to buy a car, and a local bank will lend you $33,000. The loan would be fully amortized over…

A: The loan is an agreement between two parties where an amount is forwarded on a promise of repayment…

Q: 13) You take out a loan for $75,000 for 12 years at 6% monthly. What is the payment? a) how much…

A: A study that proves that the future worth of the money is lower than its current value due to…

Q: One year from now you will need a $1,000 deposit to rent a new apartment. You now have $927.…

A: Future Value Future value refers to the value of the investment at a certain point in time in future…

Q: You need to have $30,000 for a down payment on a house in 6 years. If you can earn an annual…

A: STEP 1 Present Value The value of a sum of money today is known as its present value.

Q: You are depositing $10,000 in a 5 year CD that pays 4.5% interest each year. How much interest will…

A: Interest Accrued = [ P (1+r)n ]- P where P= Principal Amount Deposited n=Term of Deposit r= Interest…

Q: Suppose that you're planning a vacation and borrow $2,000 from a bank for one year at a stated…

A: The real interest that an investor earns on the investment and a borrower pays on loan after…

Question

MUST USE EXCEL FORMULA, NOT ALGEBRAICALLY!

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

DID YOU NOT SEE MY WORDS? MUST USE EXCEL FORMULA! NOT ALGEBRAICALLY!

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
You need to heave $34,500 in 14 years. You can earn an annual interest rate of 5 percent for the first 4 years, 5.6 percent for the next 3 years, and 6.3 percent for the final 7 years. How much do you have to deposit today?MUST USE EXCEL FORMULAS!! NOT ALGEBRAICALLY!
You need to have $30,000 for a down payment on a house in 6 years. If you can earn an annual interest rate of 3.3 percent, how much will you have to deposit today? USE EXCEL FORMULAS ONLY! NO ALGEBRAICALLY!
You would like to have $53,000 in 13 years. To accumulate this amount, you plan to deposit an equal sum in the bank each year that will earn 6 percent interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate this amount? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? (Assume you can earn 6 percent on this deposit.) c. At the end of five years, you will receive $20,000 and deposit this in the bank toward your goal of $53,000 at the end of year 13. In addition to the lump-sum deposit, how much must you deposit in equal annual amounts, beginning in year 1 to reach your goal? (Again, assume you can earn 6 percent on your deposits.)
You need to have $31,000 in 11 years. You can earn an annual interest rate of 3 percent for the first 3 years, 3.6 percent for the next 2 years, and 4.3 percent for the final 6 years. How much do you have to deposit today?
you need to have $33,750 in 5 years. you can earn an annual interest rate of 6 percent for the first 3 years, and 6.6percent for the next 2 years. how much would you have to deposit today
You would like to have $78,000 in 12 years. To accumulate this amount, you plan to deposit an equal sum in the bank each year that will earn 9% interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate this amount? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should the lump-sum deposit be? (Assume you can earn 9% on this deposit) c. At the end of year 5, you will receive $10,000 and deposit it in the bank in an effort to reach your goal of $78,000 at the end of year 12. In addition to the lump-sum deposit, how much must you invest in 12 equal annual deposits to reach your goal? (Again, assume you can earn 9% on this deposit)
You would like to have $ 59,000 in 15 years. To accumulate this amount, you plan to deposit an equal sum in the bank each year that will earn 9 percent interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate this amount? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? (Assume you can earn 9 percent on this deposit.) c. At the end of five years, you will receive $ 10,000 and deposit this in the bank toward your goal of $ 59,000 at the end of year 15. In addition to the lump-sum deposit, how much must you deposit in equal annual amounts, beginning in year 1 to reach your goal? (Again, assume you can earn 9 percent on your deposits.) Question content area bottom Part 1 a. How much must you deposit annually to accumulate this amount? $ enter your response here…
(Comprehensive problem) You would like to have $54,000 in 16 years. To accumulate this amount, you plan to deposit an equal sum in the bank each year that will earn 6 percent interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate this amount? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? (Assume you can earn 6 percent on this deposit.) c. At the end of five years, you will receive $20,000 and deposit this in the bank toward your goal of $54,000 at the end of year 16. In addition to the lump-sum deposit, how much must you deposit in equal annual amounts, beginning in year 1 to reach your goal? (Again, assume you can earn 6 percent on your deposits.) a. How much must you deposit annually to accumulate this amount? (Round to the nearest cent.)
How much do you have to deposit today so that beginning 11 years from now you can withdraw $15,000 a year for the next 5 years (periods 11 through 15) plus an additional amount of $30,000 in the last year (period 15)? Assume an interest rate of 9 percent. The amount of money you have to deposit today is
(Comprehensive problem) You would like to have $52,000 in 15 years. To accumulate this amount, you plan to deposit an equal sum in the bank each year that will earn 8 percent interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate this amount? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? (Assume you can earn 8 percent on this deposit.) c. At the end of five years, you will receive $15,000 and deposit this in the bank toward your goal of $52,000 at the end of year 15. In addition to the lump-sum deposit, how much must you deposit in equal annual amounts, beginning in year 1 to reach your goal? (Again, assume you can earn 8 percent on your deposits.) * a. How much must you deposit annually to accumulate this amount? $(Round to the nearest cent.) b. If you decide to make a large lump-sum deposit today instead of the annual…
(Comprehensive problem) You would like to have $59,000 in 15 years. To accumulate this amount, you plan to deposit an equal sum in the bank each year that will earn 9 percent interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate this amount? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? (Assume you can earn percent on this deposit.) c. At the end of five years, you will receive $20,000 and deposit this in the bank toward your goal of $59,000 at the end of year 15. In addition to the lump-sum deposit, how much must you deposit in equal annual amounts, beginning in year 1 to reach your goal? (Again, assume you can earn 9 percent on your deposits.) a. How much must you deposit annually to accumulate this amount? C