1 Which formula property calculates the future value of monthly deposits of $800 left on2 deposit for 10 years at an annual return of 8%? Assume an initial deposit of $20,000.Your formula must return a positive value.4 Number of years5 Payments per year6 Monthly deposit7 Annual return8 Initial deposit1012$8008%$20,000Multiple Choice=FV(B7/B5,B4 B5,B6,B8)=-FV(B7/85,84-85,B6,B8)-FV(B7.85,84-85,B6)=-FVB7.84-85.B6.B8)

Future value shows the value of the investment after a certain period at a specified rate. The…

Which formula property calculates the future value of monthly deposits of $800 lent deposit for 10 years at an annual return of 8%? Assume an initial deposit of $20,000. Your formula must return a positive value. Number of years 5 Payments per year Monthly deposit Annual return Initial deposit 10 12 $800 8% $20,000 Multiple Choice =FV(B7/B5,B4 B5,B6,B8) =-FV(B7/B5,B4 B5, B6,B8) =-FV(B7/B5,B4-B5.B6)

Which formula property calculates the future value of monthly deposits of $800 lent deposit for 10 years at an annual return of 8%? Assume an initial deposit of $20,000. Your formula must return a positive value. Number of years 5 Payments per year Monthly deposit Annual return Initial deposit 10 12 $800 8% $20,000 Multiple Choice =FV(B7/B5,B4 B5,B6,B8) =-FV(B7/B5,B4 B5, B6,B8) =-FV(B7/B5,B4-B5.B6)

Personal Finance

13th Edition

ISBN:9781337669214

Author:GARMAN

Publisher:GARMAN

Chapter1: Understanding Personal Finance

Section1.4: Perform Time Value Of Money Calculations

Problem 3CC

See similar textbooks

Similar questions

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%
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%
Jullo Company is considering the purchase of a new bubble packaging machine. If the machine will provide $20,000 annual savings for 10 years and can be sold for $50,000 at the end of the period, what is the present value of the machine investment at a 9% interest rate with savings realized at year end?
Present Values Krista Kellman has an opportunity to purchase a government security that will pay $200,000 in 5 years. Required: Note: Round answers to two decimal places. 1. Calculate what Krista would pay for the security if the appropriate interest (discount) rate is 6% compounded annually. 2. Calculate what Krista would pay for the security if the appropriate interest (discount) rate is 10% compounded annually. 3. Calculate what Krista would pay for the security if the appropriate interest (discount) rate is 6% compounded semiannually.