Using Excel to calculate1. What is the present value of the following cash flow at a 12% discount rate?Year 1Year 2Year 3$200,000Year 4-$50,000$100,000$150,0002. You decide to save $8000 per year from now on. You plan to retire in 30 years' time.(a) How much will you have accumulated by then? The annual interest rate is 8%. Note: the first saving will start one yearfrom today.(b) If you live 20 years after retirement, what annual level of expenditure will those savings support?

Name: Using Excel to calculate1. What is the present value of the following
Uploaded: 2024-03-20T06:50:59.000Z
Channel: Bartleby
Description: Using Excel to calculate1. What is the present value of the following cash flow at a 12% discount rate?Year 1Year 2Year 3$200,000Year 4-$50,000$100,000$150,0002. You decide to save $8000 per year from now on. You plan to retire in 30 years' time.(a)

Answered: Using Excel to calculate 1. What is the…

Business

Finance

Using Excel to calculate 1. What is the present value of the following cash flow at a 12% discount rate? Year 1 Year 2 Year 3 Year 4 $100,000 $150,000 $200,000 -$50,000

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

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

See similar textbooks

Similar questions

Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
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?
Calculating interest earned and future value of savings account. If you put 6,000 in a savings account that pays interest at the rate of 3 percent, compounded annually, how much will you have in five years? (Hint: Use the future value formula.) How much interest will you earn during the five years? If you put 6,000 each year into a savings account that pays interest at the rate of 4 percent a year, how much would you have after five years?
You put $250 in the bank for S years at 12%. A. If interest is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the fifth year. B. Use the future value of $1 table in Appendix B and verity that your answer is correct.
If you invest $15,000 today, how much will you have in (for further instructions on future value in Excel, see Appendix C): A. 20 years at 22% B. 12 years at 10% C. 5 years at 14% D. 2 years at 7%
You put $600 in the bank for 3 years at 15%. A. If Interest Is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the third year. B. Use the future value of $1 table In Appendix B and verify that your answer is correct.
How much would you invest today in order to receive $30,000 in each of the following (for further instructions on present value in Excel, see Appendix C): A. 20 years at 22% B. 12 years at 10% C. 5 years at 14% D. 2 years at 7%
How much would you invest today in order to receive $30,000 in each of the following (for further Instructions on present value In Excel, see Appendix C): A. 10 years at 9% B. 8 years at 12% C. 14 years at 15% D. 19 years at 18%
If you invest $12,000 today, how much will you have in (for further Instructions on future value in Excel, see Appendix C): A. 10 years at 9% B. 8 years at 12% C. 14 years at l5% D. 19 years at 18%
Use the present value and future value tables 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? $fill in the blank 1 B. If you place $6,100 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? $fill in the blank 2 C. You invest $7,000 per year for 9 years at 12% interest, how much will you have at the end of 9 years? $fill in the blank 3 D. You win the lottery and can either receive $760,000 as a lump sum or $40,000 per year for 19 years. Assuming you can earn 8% interest, which do you recommend and why?
Suppose you want to withdraw $20,000 at the end of year 3 and another $20,000 at the end of year 5. The account's interest rate is 5% compounded annually. A How much should you deposit now? B) Suppose you realize you can only deposit $10,000 today, but you expect to have more funds available in 1 year. How much must you deposit into the account at the end of year 1 so that you can still make the necessary withdrawals at the end of years 3 and 5?
Use the present value and future value tables to answer the following questions. A. If you would like to accumulate $2,600 over the next 5 years when the interest rate is 15%, how much do you need to deposit in the account? $fill in the blank 1 B. If you place $6,300 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? $fill in the blank 2 C. You invest $7,000 per year for 11 years at 12% interest, how much will you have at the end of 11 years? $fill in the blank 3 D. You win the lottery and can either receive $740,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? Take the lump sum $740,000 because it is more money.