You just deposited $9,500 in an investment account and will deposit $5000 more four years from now. What is the built-in functions on a spreadsheet to determine how much will be in the account 11 years from now if the rate of return is 10% per year? The built-in function is =FV (10%,11,9500) + FV ( 10 %,7.,5000) and it displays $

You just deposited $9,500 in an investment account and will deposit $5000 more four years from now. What is the built-in functions on a spreadsheet to determine how much will be in the account 11 years from now if the rate of return is 10% per year? The built-in function is =FV (10%,11,9500) + FV ( 10 %,7.,5000) and it displays $

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

You need to accumulate $10,000. To do so, you plan to make deposits of $1,400 per year with the first payment being made year from today - into a bank account that pays 9% annual interest. Your last deposit will be less than $1,400 if less is needed to round out to $10,000. How many years will it take you to reach your $10,000 goal? Do not round intermediate calculations. Round your answer up to the nearest whole number. year(s) How large will the last deposit be? Do not round intermediate calculations. Round your answer to the nearest cent. $
Lily Enterprise wants to accumulate a total sum of $824,000 in a few years. They want to deposit $145,800 today and make additional $29,150 deposits at the end of every six months thereafter. How many additional deposits and how long will it take to accumulate the $824,000 if interest rate is 5.99% compounded monthly? Enter the future value as a positive value in the FV box below. Enter PV and PMT as positive or negative values based on FV being positive. Report N (number of additional deposits) as a whole number. P/Y = C/Y = N = I/Y = PV = $ PMT = $ FV = $ Report your answer in years and months as whole numbers below. If years is an exact integer as 7 years, then enter 7 for years and 0 for months. You must enter a value in each box. It will take years and months.
If you put $200,000 into your investment account now for 10 year at 5% annual interest, what is the difference in interest income between simple interest calculation and compound interest calculation? use Excel for calculation.
You invest $ 500 today and receive $ 750 at the end of 5 years. a. DETERMINE the internal rate of return, using hand interpolation. Write answer to 2 decimal places. b. SUBMIT the procedures via the spreadsheet icon. Show all your computations. -
You are saving for a new house. You place $40,000 into an investment account each year for five years. How much will you have after five years if the account earns (a) 3%, (b) 6%, or (c) 9% compounded annually? Note: Use tables, Excel, or a financial calculator. Round your answers to 2 decimal places. (FV of $1, PV of $1, FVA of $1, and PVA of $1)
Please use excel and explain how you solved it step by step thank you How much income should an investment of 100,000 $ made today, in order to make a profit with 7% interest, bring in per year for 10 years?
When an initial amount of P dollars is invested at r% annual interest compounded n times per year, the value of the account (4) after years is given by the equation nt A=P(1 + =)** n Write an equation that represents the value in an account that starts out with an initial investment of $5000 and pays 10% interest compound monthly. Then use that equation to fill the table and use the table to graph the equation. Years (1) Value (4) 0 5 10 15 20 oo → KI
One can solve for payments (PMT), periods (N), and interest rates (1) for annuities. The easiest way to solve for these variables is with a financial calculator or a spreadsheet. Quantitative Problem 1: You plan to deposit $2,100 per year for 4 years into a money market account with an annual return of 3%. You plan to make your first deposit one year from today. a. What amount will be in your account at the end of 4 years? Do not round intermediate calculations. Round your answer to the nearest cent. $ b. Assume that your deposits will begin today. What amount will be in your account after 4 years? Do not round intermediate calculations. Round your answer to the nearest cent. $ Quantitative Problem 2: You and your wife are making plans for retirement. You plan on living 25 years after you retire and would like to have $95,000 annually on which to live. Your first withdrawal will be made one year after you retire and you anticipate that your retirement account will earn 12% annually. a.…
This exercise is designed to be solved using technology such as calculators or computer spreadshoets You borrow $11,000 with a term of four years at an APR of 7%. Make an amortization table. How much equity hve you bult up halfway through the term? (Round your amwer to two decimal places.) s 6321 84 elook
Suppose you save $2,800 ayear for 43 years into an investment account that earns 8.5% return, how much will you have at the end of the periods? Formula? Excel Function?
Ten annual returns are listed in the following table: (Click on the following icon in order to copy its contents into a spreadsheet.) - 19.6% 16.2% 18.3% - 49.8% 43.7% 1.1% - 16.4% a. What is the arithmetic average return over the 10-year period? b. What is the geometric average return over the 10-year period? c. If you invested $100 at the beginning, how much would you have at the end? 46.4% a. What is the arithmetic average return over the 10-year period? The arithmetic average return over the 10-year period is %. (Round to two decimal places.) 45.3% - 3.9%
Use the formula for computing future value using compound interest to determine the value of an account at the end of 8 years if a principal amount of $13,000 is deposited in an account at an annual interest rate of 5% and the interest is compounded quarterly. The amount after 8 years will be $ (Round to the nearest cent as needed.) Enter your answer in the answer box and then click Check Answer. All narts showing javascript:doExercise(9); Clear All Check Answer sy Po a 99+

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS