a. Andrea wants to know how much money she will have in 6 years if she deposits her $900tax refund now and then deposits an additional $60 per month in her account that pays anAPR of 1.5% compounded monthly. Use Excel to determine how much money will Andreahave in the account in 6 years?$b. If Andrea changes her mind and decides that instead of setting aside $60 per month shewants to know how much she will have to deposit each month to save up a total of $7500, wecan use goal seek to find the value for PMT which yields $7500 at the end of 6 years. Howmuch money will Andrea need to deposit per month?

b. Determining the monthly deposit required to reach a total of $7,500 in 6 years:In Excel:Set up…

Answered: a. Andrea wants to know how much money…

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 14PROB

See similar textbooks

Similar questions

Refer to the present value table information on the previous page. What amount should Brett have in his bank account today, before withdrawal, if he needs 2,000 each year for 4 years, with the first withdrawal to be made today and each subsequent withdrawal at 1-year intervals? (Brett is to have exactly a zero balance in his bank account after the fourth withdrawal.) a. 2,000 + (2,000 0.926) + (2,000 0. 857) + (2,000 0.794) b. 2,0000.7354 c. (2,000 0.926) + (2,000 0.857) + (2,000 0.794) + (2,000 0.735) d. 2,0000.9264
Please help me answer the following time value of money question. Tanya wants to be able to withdraw $7000 at the end of 7 years and $9000 at the end of 8 years. If she can earn 5.5%, how much does she need to deposit in order to do that? (*there are 2 different future values.)
Jill wants to make a few deposits so that she can withdraw $5000 per year at the end of each year for the next 15 years. A deposit of X is made a year from now, a second deposit of 2X is made at the end of year 4, and a deposit of (X/2) is made at the end of year 8. What is the amount of X if the goal is to empty the account? Use 6% interest.
a. Andrea wants to know how much money she will have in 8 years if she deposits her $700 tax refund now and then deposits an additional $70 per month in her account that pays an APR of 1.6% compounded monthly. Use Excel to determine how much money will Andrea have in the account in 8 years? $ b. If Andrea changes her mind and decides that instead of setting aside $70 per month she wants to know how much she will have to deposit each month to save up a total of $5500, we can use goal seek to find the value for PMT which yields $5500 at the end of 8 years. How much money will Andrea need to deposit per month? $
2. Remi deposits $2,000 into a savings account at her bank. If the interest rate is 3.25 percent, how much money will she have in her account after 5 years? 7. You are Co introductory rate months and the rate be entered into a drawin commercial. You pay $50 a you switch? Use the smart dec mathematically and include an em
I need Question 4,5 and 6 Joanna has $1,500 to put into one of two savings accounts. The first pays 5.6% simple interest each year. The second pays 4.8% annual interest compounded monthly. Use a TVM Solver is necessary. Write an equation to model the balance of the first account after any number of years (t). 2. How much money will she have after 15 years in the first account? 3.How many years until Joanna would have $3,500 in the first account? 4. Write an equation to model the balance of the second account after any number of years (t). 5.How much money will she have after 15 years in the second account? 6.How many years until Joanna would have $3,500 in the second account? 7.Which account would you recommend for Joanna? Explain your answer.
You want to be able to withdraw $40,000 from your account each year for 25 years after you retire. If you expect to retire in 15 years and your account earns 6.6% interest while saving for retirement and 6.2% interest while retired:Round your answers to the nearest cent as needed.a) How much will you need to have when you retire?$b) How much will you need to deposit each month until retirement to achieve your retirement goals?$c) How much did you deposit into you retirement account?$d) How much did you receive in payments during retirement?$e) How much of the money you received was interest?$
What will be the deposit amount for Jane if she wants to buy a car within 7 years with a price of BDT2500000 and the Bank interest rate is 9%? Remember that Jane wants to make those payments in advance of each Quarter.
Sara wants to make a deposit now into an account that earns 3% annually so that she will be able to withdraw an amount of $125 at the end of each of the next 5 years. How much should she deposit today?
Katy has decided she wants to put money aside for a $8000 downpayment on a house. She figures she will be ready to buy in 10 years. How much does she need to deposit today into an account that earns 6.75% interest compounded monthly for her to reach her goal?
She wants to know the amount of money she will be receiving after 6 months What I Can Do Read and analyze the situation below then answers the question gve. Your mom asked your opinion if she will be joining the cooperative in her office. and wanted to buy something in December. The cooperative wants her to contribute P1,000 per month beginning in June 2020 which will earn 3% compounded monthly. How much will be the future value of your mom's contribution at the end of December 2020? Tasks: Tou need to prepare a report showing a cash flow diagram on the total amount Of money your mother will earn at the end of December. Teport, write a conclusion stating your opinion to help your mom to decide. At the end of your Cash Flow Diagram onclusion:
Holly Krech is planning for her retirement, so she is setting up a payout annuity with her bank. She wishes to receive a payout of $1,900 per month for twenty years. (a) How much money must she deposit if her money earns 7.8% interest compounded monthly? (Round your answer to the nearest cent.)___________ $ (b) Find the total amount that Holly will receive from her payout annuity. Thank you!

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

SEE MORE TEXTBOOKS